Print data by date

perleo · #1 (**permalink**) 08-09-03, 06:07 AM

Can someone tell me where to begin on this problem

I have a html form with 36 input fields that i want stored in a table. Then by a certain date, no more entrys are allowed made and PHP prints the data on a page.

How would i do that
I have attached the html form below

<html>

<head>
<title>New Page 1</title>
</head>

<body>

<form method="POST" action="--WEBBOT-SELF--">

<p>Name:<input type="text" name="Name" size="20"></p>
<p>ID Number: <input type="text" name="IDn" size="20"></p>
<p>Enter Times Below</p>
<p>------- DAY 1 ----------</p>
<p>Stage 1: <input type="text" name="Day1_1" size="20"></p>
<p>Stage 2: <input type="text" name="Day1_2" size="20"></p>
<p>Stage 3: <input type="text" name="Day1_3" size="20"></p>
<p>Stage 4: <input type="text" name="Day1_4" size="20"></p>
<p>Stage 5: <input type="text" name="Day1_5" size="20"></p>
<p>Stage 6: <input type="text" name="Day1_6" size="20"></p>
<p>Stage 7: <input type="text" name="DAY1_7" size="20"></p>
<p>Stage 8: <input type="text" name="DAY1_8" size="20"></p>
<p>Stage 9: <input type="text" name="DAY1_9" size="20"></p>
<p>Stage 10: <input type="text" name="DAY10" size="20"></p>
<p>Overall: <input type="text" name="DAY1_O" size="20"></p>
<p>------- DAY 2 ----------</p>
<p>Stage 1: <input type="text" name="Day2_1" size="20"></p>
<p>Stage 2: <input type="text" name="Day2_2" size="20"></p>
<p>Stage 3: <input type="text" name="Day2_3" size="20"></p>
<p>Stage 4: <input type="text" name="Day2_4" size="20"></p>
<p>Stage 5: <input type="text" name="Day2_5" size="20"></p>
<p>Stage 6: <input type="text" name="Day2_6" size="20"></p>
<p>Stage 7: <input type="text" name="DAY2_7" size="20"></p>
<p>Stage 8: <input type="text" name="DAY2_8" size="20"></p>
<p>Stage 9: <input type="text" name="DAY2_9" size="20"></p>
<p>Stage 10: <input type="text" name="DAY2_10" size="20"></p>
<p>Overall: <input type="text" name="DAY2_O" size="20"></p>
<p>------- DAY 3 ----------</p>
<p>Stage 1: <input type="text" name="Day3_1" size="20"></p>
<p>Stage 2: <input type="text" name="Day3_2" size="20"></p>
<p>Stage 3: <input type="text" name="Day3_3" size="20"></p>
<p>Stage 4: <input type="text" name="Day3_4" size="20"></p>
<p>Stage 5: <input type="text" name="Day3_5" size="20"></p>
<p>Stage 6: <input type="text" name="Day3_6" size="20"></p>
<p>Stage 7: <input type="text" name="DAY3_7" size="20"></p>
<p>Stage 8: <input type="text" name="DAY3_8" size="20"></p>
<p>Stage 9: <input type="text" name="DAY3_9" size="20"></p>
<p>Stage 10: <input type="text" name="DAY3_10" size="20"></p>
<p>Overall: <input type="text" name="DAY3_O" size="20"></p>
<p> </p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

</body>

</html>

How do i make the data inserted into those fields get printed to a table called "coi" and when submit is pressed a page comes up thank you.

But then i need a page names coi.php to print the data, but only to print the data after a certain date.Oh yeah, that data must be in tables to display them properly

Thanks

NeverMind · #2 (**permalink**) 08-09-03, 06:44 AM

from the HTML code I can see that you are using front page ..
also you are asking for a full code script !?
I mean I can see that you don't know anything in php , right ?
but to be honest the script you are asking for is very easy to make ...
I may - I AM SAYING *MAY*- do this for you if I had the time !! but don't depend on me ...
you want to store the data on MySQL database ?

perleo · #3 (**permalink**) 08-09-03, 09:35 AM

yes store data in mysql 'tables' only, i have very little knowlegde on php & mysql. yes i used frontpage to make the html form.can you make me the php script please to print by 11\12\03 the 12 is the month, its not american date