Creating a table for adding data to MySQL Database
Posted: Thu May 15, 2008 6:39 am
I have a challenge for you. I hope somebody can rise to it as you have with all of my other (often daft) questions.
Those of you who have been following my rocky introduction to PHP and MySQL will know that I am creating a family tree website.
Okay. So at present I have three entries in my database. I have to add at LEAST a thousand more and doing that manually is a pain in the backside.
I downloaded MySQL Administrator 1.2.12 which allows me to edit table data but it's slow and quite fiddly to do.
SO...
What I want to do is create a PHP page with a large form. I populate the fields and press SUBMIT and the form enters the information in to my database.
I have created the following (VERY rough draft) HTML:
Any idea how I can make this work as a PHP file which does what I want it to do?
This is a lot to ask so I'll fully understand if your reply is to buy a book but I have one and it doesn't help!!!!
Thank you.
Kris.
Those of you who have been following my rocky introduction to PHP and MySQL will know that I am creating a family tree website.
Okay. So at present I have three entries in my database. I have to add at LEAST a thousand more and doing that manually is a pain in the backside.
I downloaded MySQL Administrator 1.2.12 which allows me to edit table data but it's slow and quite fiddly to do.
SO...
What I want to do is create a PHP page with a large form. I populate the fields and press SUBMIT and the form enters the information in to my database.
I have created the following (VERY rough draft) HTML:
Code: Select all
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>URN</title>
</head>
<body>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><form>
<tr>
<td><b><font face="Arial" size="1" color="#FF0000">DATABASE PASSWORD:</font></b></td>
<td><font face="Arial" size="1"><input type="text" name="T1" size="20"></font></td>
<td> </td>
<td><font size="1" face="Arial">URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T92" size="20"></font></td>
</tr>
<tr>
<td><font size="1" face="Arial">SURNAME:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T2" size="20"></font></td>
<td> </td>
<td><font size="1" face="Arial">SURNAME:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T91" size="20"></font></td>
</tr>
<tr>
<td><font size="1" face="Arial">FORENAME:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T90" size="20"></font></td>
<td> </td>
<td><font size="1" face="Arial">MIDDLE NAMES:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T35" size="20"></font></td>
</tr>
<tr>
<td><font size="1" face="Arial">DATE OF BIRTH:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T5" size="20"></font></td>
<td> </td>
<td><font size="1" face="Arial">PLACE OF BIRTH:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T6" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">MOTHER:</font></td>
<td><input type="text" name="T7" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">MOTHER URN:</font></td>
<td><input type="text" name="T9" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">FATHER:</font></td>
<td><input type="text" name="T8" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">FATHER URN:</font></td>
<td><input type="text" name="T10" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 1:</font></td>
<td><input type="text" name="T11" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 1 URN:</font></td>
<td><input type="text" name="T12" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 2:</font></td>
<td><input type="text" name="T13" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 2 URN:</font></td>
<td><input type="text" name="T14" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 3:</font></td>
<td><input type="text" name="T15" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 3 URN:</font></td>
<td><input type="text" name="T16" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 4:</font></td>
<td><input type="text" name="T17" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 4 URN:</font></td>
<td><input type="text" name="T18" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 5:</font></td>
<td><input type="text" name="T19" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 5 URN:</font></td>
<td><input type="text" name="T20" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 6:</font></td>
<td><input type="text" name="T21" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 6 URN:</font></td>
<td><input type="text" name="T22" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 7:</font></td>
<td><input type="text" name="T23" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 7 URN:</font></td>
<td><input type="text" name="T24" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 8:</font></td>
<td><input type="text" name="T25" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 8 URN:</font></td>
<td><input type="text" name="T26" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 9:</font></td>
<td><input type="text" name="T27" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 9 URN:</font></td>
<td><input type="text" name="T28" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SIBLING 10:</font></td>
<td><input type="text" name="T29" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SIBLING 10 URN:</font></td>
<td><input type="text" name="T30" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">CHRISTENING DATE:</font></td>
<td><input type="text" name="T31" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">CHRISTENING PLACE:</font></td>
<td><input type="text" name="T32" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1:</font></td>
<td><input type="text" name="T33" size="20"></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 URN:</font></td>
<td><input type="text" name="T34" size="20"></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 MARRIAGE DATE:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T36" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 MARRIAGE PLACE:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T37" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 1:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T38" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 1 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T39" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 2:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T40" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 2 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T41" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 3:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T42" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 3 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T43" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 4:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T44" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 4 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T45" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 5:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T46" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 5 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T47" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 6:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T48" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 6 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T49" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 7:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T50" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 7 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T51" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 8:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T52" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 8 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T53" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 9:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T54" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 9 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T55" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 10:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T56" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 1 CHILD 10 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T57" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T58" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T59" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 MARRIAGE DATE:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T60" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 MARRIAGE PLACE:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T61" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 1:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T62" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 1 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T63" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 2:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T64" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 2 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T65" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 3:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T66" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 3 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T67" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 4:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T68" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 4 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T69" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 5:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T70" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 5 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T71" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 6:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T72" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 6 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T73" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 7:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T74" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 7 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T75" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 8:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T76" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 8 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T77" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 9:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T78" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 9 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T79" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 10:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T80" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SPOUSE 2 CHILD 10 URN:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T81" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">OCCUPATION:</font></td>
<td><font size="1" face="Arial"><input type="text" name="T82" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">DATE OF DEATH:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T83" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">PLACE OF DEATH:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T84" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">CAUSE OF DEATH:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T85" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">NOTES:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T86" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">PHOTOGRAPHS:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T87" size="20"></font></td>
</tr>
<tr>
<td><font face="Arial" size="1">CENSUS:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T88" size="20"></font></td>
<td> </td>
<td><font face="Arial" size="1">SCRAPBOOK:</font></td>
<td><font face="Arial" size="1"><input type="text" name="T89" size="20"></font></td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td><input type="submit" value="Submit" name="B4"></td>
<td><input type="reset" value="Reset" name="B5"></td>
<td> </td>
<td> </td>
<td> </td>
</tr></form>
</table>
</body>
</html>This is a lot to ask so I'll fully understand if your reply is to buy a book but I have one and it doesn't help!!!!
Thank you.
Kris.