K
K
Konstantin2019-06-24 06:04:09
MySQL
Konstantin, 2019-06-24 06:04:09

How to properly organize the database for matching questions?

Hello!
There are online tests, they have so-called compliance questions, for example:
Match the following points:
5d103cab1eef4321739212.jpeg
Tell me how to properly organize the database structure and check the results?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
kafkiansky, 2019-06-24
@mad_maximus

Store in one field the points of the letter part, in the other field of the same table the points of the numeric part. In the results field, store the already collected array of matches. Well, when the user answers, you first compare whether two arrays are equal, his and the array from the base, and if so, count the answer. If not, go ahead and count.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question