Date

[cherrielwy]

Hi,

In my form, i make the date separate to 3 field(day,month&year) but i need to combine the date to 1 columb in my datbase,may i know how to do it?

 

[vbkris]

add the values. in the php page where u collect the values:
$dd=$_POST['date_field'];//or whatever method u use
$mm=$_POST['month_field'];
$yy=$_POST['year_field'];

$date=$yy."/".$mm."/".$dd;
echo $date;

//now use $date in ur sql query...

Known is handfull, Unknown is worldfull

 

[DRJ478]

After assembling the date (like vbkris showed you) you might want to validate the result before sticking it into the database.

Here's a task for you to investigate:
What happens when you send 02/31/2003 to the database?

 

[cherrielwy]

Hi,

I create three combo box for input, "day","month" and "year",the i put the code:
<?php
$dd=$_POST['day'];//or whatever method u use
$mm=$_POST['month'];
$yy=$_POST['year'];

$date=$yy.&quot;/&quot;.$mm.&quot;/&quot;.$dd;
echo $date;
?>

but the date cannot be show,whats wrong? How sticking it into my database?


thank.
Cherrie

 

[DRJ478]

Questions:
1. Is your form posting to the correct scipt?
2. What version of PHP are you using?
3. Try

<?php
print(&quot;<pre>&quot;);
print_r($_POST);
print_r($HTTP_POST_VARS); # older PHP versions
print(&quot;</pre>&quot;;
?>

 

[cherrielwy]

Hi,DRJ478

i use php4,i'm just start learning php,can u help me. After i feild in the date, the value cannot be insert in to my database. How can i validate the result before sticking it into the database?Thank You

 

[vbkris]

what do u mean by validate?
first did the date echo itself?

Known is handfull, Unknown is worldfull

 

[cherrielwy]

the date had acho after i summit,but have not input to the database.How?Thank You



cherrie

 

[vbkris]

to input it u need to perform an insert query. check on php's database connections...

Known is handfull, Unknown is worldfull

 

[DRJ478]

Here's some more info:

1. To validate the date use the checkdate() function:

http://ca2.php.net/manual/en/function.checkdate.php

2. Read faq434-3850 to learn how to connect to the MySQL server.

3. The INSERT syntax for SQL commands is referenced at:

http://www.mysql.com/doc/en/INSERT.html