Re: Inserting current date(MySQL)?
| From: | Jeffrey_N_Dyke at Keane dot com | Date: | Wed, 30 Oct 2002 19:02:28 +0000 |
| Subject: | Re: Inserting current date(MySQL)? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22825@lists.php.net to get a copy of this message | ||
it looks like you have defined $ADDDATE and it is not a posted variable.
what happens if you just have:
<?php
$ADDDATE=date("Y-m-d");
mysql_query ("INSERT INTO client (cl_add_date,
cl_first_name,
cl_last_name,
cl_company,
cl_phone,
cl_email,
cl_address,
cl_city,
cl_state,
cl_zip,
cl_web)
VALUES ('$ADDDATE',
'$_POST[cl_first_name]',
'$_POST[cl_last_name]',
'$_POST[cl_company]',
'$_POST[cl_phone]',
'$_POST[cl_email]',
'$_POST[cl_address]',
'$_POST[cl_city]',
'$_POST[cl_state]',
'$_POST[cl_zip]',
'$_POST[cl_web]') ");
?>
</body>
</html>
Jeff
David Jackson
<info@mustardandr To: php-db@lists.php.net
elish.com> cc:
Subject: [PHP-DB] Inserting current date(MySQL)?
10/30/2002 01:31
PM
Howdy --
I'm my trying to insert to current date from a php form? I know that
MySQL has a CURDATE() fucntion and PHP has several date function, but I
cann't seem to get either to work? Here is my existing code:
TIA,
David Jackson
---------- client_add.php --------
</html>
<body>
<?php require('connect.php'); ?>
<?php
$ADDDATE=date("Y-m-d");
mysql_query ("INSERT INTO client (cl_add_date,
cl_first_name,
cl_last_name,
cl_company,
cl_phone,
cl_email,
cl_address,
cl_city,
cl_state,
cl_zip,
cl_web)
VALUES ('$_POST[ADDDATE]',
'$_POST[cl_first_name]',
'$_POST[cl_last_name]',
'$_POST[cl_company]',
'$_POST[cl_phone]',
'$_POST[cl_email]',
'$_POST[cl_address]',
'$_POST[cl_city]',
'$_POST[cl_state]',
'$_POST[cl_zip]',
'$_POST[cl_web]') ");
?>
</body>
</html>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php