Trouble saving datetime picker value into database

[gggram2000]

Hi, I'm using php 5.2.3 with mysql server 5.1 as backend.
I have a program in which a person enters or chooses two dates from two datetime pickers and other info, I'm not sure if the problem is in the Datatype for the datetime picker declared in the table editor why none of the fields save in the database. I entered the datatype as DATE. and my datetime pickers code look like this:

<script language="javascript" type="text/javascript" src="datetimepicker.js">
 
//Date Time Picker script- by TengYong Ng of http://www.rainforestnet.com
//Script featured on JavaScript Kit (http://www.javascriptkit.com)
//For this script, visit http://www.javascriptkit.com 
 
</script>
 
//DATES-called from scripts
//Function CreateInputField($field_title,$input_type,$input_name,$input_value,$input_size,$td_width)                                    
$f1->createInputField("<b>$lang->reservDate:</b>",'text','reserv_date',"$redate_value",'40','150');
$f1->createInputField("<b>$lang->departDate:</b>",'text','reserv_date2',"$redate2_value",'40','150');
 
echo "Select Arrival Date: <a href=\"javascript:NewCal('reserv_date','ddmmyyyy')\"><img src=\"../images/cal.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"Pick a date\"></a>                             ";
echo "            Select Departure Date: <a href=\"javascript:NewCal('reserv_date2','ddmmyyyy')\"><img src=\"../images/cal.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"Pick a date\"></a>";

Any help will be greatly appreciated...thanks mites

[chaarmann]

Hi, I'm using php 5.2.3 with mysql server 5.1 as backend.
I have a program in which a person enters or chooses two dates from two datetime pickers and other info, I'm not sure if the problem is in the Datatype for the datetime picker declared in the table editor why none of the fields save in the database. I entered the datatype as DATE. and my datetime pickers code look like this:

<script language="javascript" type="text/javascript" src="datetimepicker.js">
 
//Date Time Picker script- by TengYong Ng of http://www.rainforestnet.com
//Script featured on JavaScript Kit (http://www.javascriptkit.com)
//For this script, visit http://www.javascriptkit.com 
 
</script>
 
//DATES-called from scripts
//Function CreateInputField($field_title,$input_type,$input_name,$input_value,$input_size,$td_width)                                    
$f1->createInputField("<b>$lang->reservDate:</b>",'text','reserv_date',"$redate_value",'40','150');
$f1->createInputField("<b>$lang->departDate:</b>",'text','reserv_date2',"$redate2_value",'40','150');
 
echo "Select Arrival Date: <a href=\"javascript:NewCal('reserv_date','ddmmyyyy')\"><img src=\"../images/cal.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"Pick a date\"></a>                             ";
echo "            Select Departure Date: <a href=\"javascript:NewCal('reserv_date2','ddmmyyyy')\"><img src=\"../images/cal.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"Pick a date\"></a>";

Any help will be greatly appreciated...thanks mites

What says TengYong Ng to the fact that his code doesn't run for you? You should write your own code (read posting guidelines).

Anyway,you copied the wrong code. This code runs on the client browser, but it does not run on the server. You have not even a single PHP command in "your" code and not even a single SQL-command to save the entered value into the database.

[gggram2000]

What says TengYong Ng to the fact that his code doesn't run for you? You should write your own code (read posting guidelines).

Anyway,you copied the wrong code. This code runs on the client browser, but it does not run on the server. You have not even a single PHP command in "your" code and not even a single SQL-command to save the entered value into the database.

Yeah thanks, Basically I would like to know whether DATE is a proper Datatype for a datetimepicker?

---GM

[chaarmann]

Yeah thanks, Basically I would like to know whether DATE is a proper Datatype for a datetimepicker?

---GM

That's the type of question with which you make friends here.

You should use TIMESTAMP or DATETIME for storing the date and time. DATE only can store the date, but not the time. This is different from oracle-db where DATE also can store the time.
Use TIMESTAMP if you need high resolution up to the milliseconds and if all dates are after 1970. Else use DATETIME

[gggram2000]

That's the type of question with which you make friends here.

You should use TIMESTAMP or DATETIME for storing the date and time. DATE only can store the date, but not the time. This is different from oracle-db where DATE also can store the time.
Use TIMESTAMP if you need high resolution up to the milliseconds and if all dates are after 1970. Else use DATETIME

Thanks chaarmann...I appreciate ur help