V
V
Vadim Shvetsov2015-09-01 18:39:40
PHP
Vadim Shvetsov, 2015-09-01 18:39:40

How to store data in the database of translators?

Good afternoon!
Can you please tell me how best to implement the storage of data of translators, editors, etc. in the database?
It is assumed that there are many fields, some of them have one value (full name, etc.), and some fields have 2 or more, some have related values ​​(original language - target language - rate - unit of measure).
Now there is a database written under Windows (like in C ++) and stores data in MS SQL Server (I can’t even understand where the data is and how to export it, I see the structure, but it can’t be repeated in MySQL), but I really want to have access on the web and remake the structure for MySQL.
It is not clear how to store multiple fields and display all this in the manager's personal account with help. PHP.
In the future, an application for iOS is planned, I hope it will not be very difficult to work with MySQL through it.
The desired result - in the personal account on the site, the manager starts a search in the database by the language of the original and translation + subject (filtering is also possible, for example, IP status, work in trados, etc.), he gets several lines with suitable performers, then by clicking on the desired line goes on the page to the desired artist, and there is all the info, multiple fields are displayed in the table (via foreach or count + for).
You will also need to implement a questionnaire in html for applicants, it enters the database with the status unverified and requires verification by the manager, making changes, etc. (that is, it will be necessary to somehow process data from POST to the database).
I am considering the option with serialize / un, but it is not so convenient to search with it, you will always have to write LIKE% x% or bother using regular expressions to find a person with the desired language pair.
The second option that I see is to make a bunch of tables for each possible multiple field and in each table FOREIGN key - ID PRIMARY KEY from the main table, but I don’t know how convenient it will be and how to display it later (where to save the ID when searching from the first table to search for the rest with the same ID multiple fields).
No experience in PHP development (A month of tutorials on sites like Intuit.ru I
translate HMTL CSS PHP MySQL with a dictionary, so to speak, but I’m ready to learn.
I really want to learn everything and I’m trying to use the initial skills in my business.
I would be very grateful to everyone for tips, advice, directions.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question