Data entry

sdragon

If I have a text file which has a lot questions and answers , and I want to insert them to mysql by php.
example,
1. What is your name?
Peter Pen
2. How old are you?
33
.....

I want to insert all the questions in the "question field" and answers in the "answer field" .

In this case, I need to make the tag for it ?
Example,
1. [Q] What is your name? [\Q]
[A] Peter Pen [\A]
2. [Q] How old are you? [\Q]
[A] 33 [\A]
...
Or any method can I solve this problem?
I have no idea in this problem:queasy:

Thank you for your help and sorry about the English which is not good enough and if you have any difficulty in understanding><

NogDog

Probably the simplest thing to do, if you are not already stuck with the text file having the question and answer on separate lines, would be to create a CSV file:

1,What is your name?,Peter Pan
2,How old are your?,33

If you have no commas or double-quotes (") in any of the fields, then the commas separator is all you need. If you do have any, then the field must be quoted and the double-quotes within the data must be "escaped" with an additional double quote:

3,"""What is your favorite color?"" is a quote from what movie?",Monty Python and the Holy Grail
4,"Is this a comma: ,",yes

Once you have a CSV file, it is a simple enough matter to import it into your database, either via the "import" option in phpMyAdmin if you are using that, or with a fairly simple PHP script using [man]fgetcsv/man.

PS: An easy way to create the CSV file is to enter your data into Excel or a similar spreadsheet program, then use the "Save As..." option and select the CSV (or "Comma-Separated Value") option.