[RESOLVED] Total Nube here QQ I need to post Date now () to SQL Field from a PHP form

The_Stig

Hi All

I have my script working but then i add a new part and just can't get it to work

Title and Disc post fine to the sql db but when I try to make it post the current date and time just can't get it to work

In the file info.inc.php i have the date as $dataadded=date("d.m.Y H:i",$dates[$i]);

and in my input form file i have

include "info.inc.php"; to pull the date in

and the form code as follows

print "<html><form action='test2.php' method='POST'><table border=1 cellpadding=1 cellspacing=0>
<tr><td>Title</td><td><input type=text name=title size=30><br></td></tr>
<tr><td>Discription</td><td><input type=text name=discr size=40><br></td></tr>
<tr><td>Date</td><td><input type=text name=posted value=$dateadded><br></td></tr>
<tr><td> &nbsp </td><td><input type=submit value='submitme' name='submit'></td></tr>
</table></form></html>";
$title = $POST['title'];
echo "$title"."<br>";
$discr = $POST['discr'];
echo "$discr"."<br>";
$posted = $_POST['posted'];
echo "$posted";

this seems to be the line giving me the prob as the title and desc are input manualy but i and tring to add the date posted in to the same table as a auto for date and time ie 23-08-2005 10:04

were am i going wrong in this line
<tr><td>Date</td><td><input type=text name=posted value=$dateadded><br></td></tr>

???

Tks for the help

devinemke

if you simply want to insert the current date into the db then you don't need/want to ask for it in the form. use the NOW() function in your INSERT query.

The_Stig

Tks for the Rep

If you are saying to set that in the SQL table not the form then I can't do that as this is the manual add for and their is a auto section to the script that write to the SQL db also so i just need to get the form to add the date into the table i have tried to do this many ways but i just need the correct line of code for the form to post the correct date and time to the field in the DB record for the title and desc so if you could post the correct line of code please that would be brill Tks

thorpe

no, devinemke was saying instead of getting the user to fill in the date in the form, have mysql insert the date for you. eg;

INSERT INTO tbl SET datecolumn = NOW();

The_Stig

thorpe wrote:
no, devinemke was saying instead of getting the user to fill in the date in the form, have mysql insert the date for you. eg;

INSERT INTO tbl SET datecolumn = NOW();

That worked when i ran it in phpmyadmin it added one row with the date in it but when i run the form to add a new row of information the date still show as 0000-00-00 00:00:00

the form code now looks like this

if ($POST[submit] == "submitme") {
$sql = "INSERT INTO rssitems (title,descr) values ('".$POST['title']."','".$_POST['discr']."')";
$result = mysql_query($sql);
}

print "<html><form action='test22.php' method='POST'><table border=1 cellpadding=1 cellspacing=0>
<tr><td>Title</td><td><input type=text name=title size=30><br></td></tr>
<tr><td>Discription</td><td><input type=text name=discr size=40><br></td></tr>
<tr><td> &nbsp </td><td><input type=submit value='submitme' name='submit'></td></tr>
</table></form></html>";
$title = $POST['title'];
echo "$title"."<br>";
$discr = $POST['discr'];
echo "$discr"."<br>";

are u saying add the code INSERT INTO tbl SET datecolumn = NOW(); into the form and if so were do i add it please?

The_Stig

OK got part of it sorted but the script that coverts the date from the field this is how the date is stored in the field 1124968525 how can i write to the field with a date like that???

Matt_Kindig

OK got part of it sorted but the script that coverts the date from the field this is how the date is stored in the field 1124968525 how can i write to the field with a date like that???

The date is being stored as a timestamp, the number of seconds that have elapsed between the current time and January 1, 1970. Use the PHP function date to express this timestamp in just about any format.

The_Stig

All sorted many Tks to u all