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.