date insert problem

dcjones

Hi all,

I have ben looking at this to long and require a fresh set of eyes from someone.

I have a form with a date field on it which I want to be populated with todays date, what ever todats date is at the time.

This is the code I am using.

$date_array = getdate();

and then

echo .$date_array['mday']."/".$date_array['mon']."/".$date_array['year'].;

Your right, its not working. Can anyone see what I have screwed up here.

devinemke

echo date('j/n/Y');

dcjones

Hi there and thanks for replying so quickly.

I can use

echo date('j/n/Y');

" to display the date on screen, but need to get that dat into the table field at the same time, which of course I did not put in my first post, sorry.

The code which binds the field is

<?php echo $row_ley_visitors_insert['date']; ?>

I have played with this most of the afternoon.

Can you advise. (good advice would be to go down the pub)

Many thanks

devinemke

what database are you using? if mySQL then the native DATE format is YYYY-MM-DD. you can do any formatting you wish using the [man]date[/man] function.

jkurrle

I'm the lazy type, so when I get a current date, I simply use something like this.

$now=time();

This loads the time and date as an integer (number of seconds since Jan 1st, 1970). From there, I throw it into the database in that format.

From there, you can manipulate the number any way you want with the date() function. For example:

$my_date=date("F j, Y",$now);

would set the date equal to the full word month, day of the month, four digit year (eg: March 1, 2006).

Also, this gives you the ability to extract out any specific item, like just the month, or the day of the week, or the time, without needing to do more than just use the date() function.

dcjones

Hi all,

I am still having problems with this code. The first post is now very old, I have been off ill for sometime.

I have the following, I want to display to days date on my form and then store that date in my mySQL table.

$now - time();

$insertSQL = sprintf("INSERT INTO ley_book (id, name, `date`, comment, email) VALUES (%s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['id'], "int"),
                       GetSQLValueString($_POST['name'], "text"),
                       GetSQLValueString($_POST['$now'], "date"),
                       GetSQLValueString($_POST['comment'], "text"),
                       GetSQLValueString($_POST['email'], "text"));

In my form I have

 echo date("F j, Y", $now);

This displays the correct date on the form, but when submitted to the database the feild content is blank. Can anyone advise please.

dcjones

Hi again,

I think the problem is with:

GetSQLValueString($_POST['$now'], "date"),

I have tried all ways with no results.

Thanks in advance

dcjones

Hi again,

I have changed the code and the form now sends a date of 0000-00-00 to the database table.

The change I made was in the form on the date feild.

 
<TD WIDTH="202" CLASS="bodytext">
    <INPUT NAME="date" CLASS="bodytext" TYPE="text" ID="date" 
    VALUE="echo date("F j, Y", $now); ">
</TD>

This displays the date (today) in the feild but I can't work out why it only sent zeros to the table.

Help please

esukf

mysql accept dates in the format YYYY-MM-DD

try

 
$id = $_POST['id'];
$name = $_POST['name'];
$today = date("Y-m-d");
$comment = $_POST['comment'];
$email = $_POST['email'];

$insertSQL = "INSERT INTO ley_book (id, name, date, comment, email) VALUES ($id, '$name', $today, '$comment', '$email')

n_wattam

dcjones wrote:
Hi again,

I have changed the code and the form now sends a date of 0000-00-00 to the database table.

The change I made was in the form on the date feild.
 
<TD WIDTH="202" CLASS="bodytext">
    <INPUT NAME="date" CLASS="bodytext" TYPE="text" ID="date" 
    VALUE="echo date("F j, Y", $now); ">
</TD>
This displays the date (today) in the feild but I can't work out why it only sent zeros to the table.

Help please

Correct me if i am wrong but you dont have that value statement right.

 
<TD WIDTH="202" CLASS="bodytext">
    <INPUT NAME="date" CLASS="bodytext" TYPE="text" ID="date" 
    VALUE="<? echo date("F j, Y", $now); ?>">
</TD>

that might now work

loanskey

why donot you try mysql date function

simply type" date()" against the column.