php date variable insert in sql problem ?

[minkoko]

        <?php
        if(isset($_POST['save'])){
            $ar_name = $_POST['ar_name'];
            $ar_dob=$_POST['ar_dob'];
            $ar_city=$_POST['ar_city'];
            $ar_country = $_POST['ar_country'];
            $ar_address = $_POST['ar_address'];
            $ar_teach = $_POST['ar_teach'];
            $ar_profile_photo = $_POST['ar_profile_photo'];
            $ar_prize= $_POST['ar_prize'];
            
            $artist_query= mysql_query("
INSERT INTO  `tw_gallery`.`artists` (
`ar_id` ,
`ar_name` ,
`ar_dob` ,
`ar_city` ,
`ar_country` ,
`ar_address` ,
`ar_teach` ,
`ar_profile_photo` ,
`ar_prize`
)
VALUES (
NULL ,  '$ar_name',  '$ar_dob',  '$ar_city',  '$ar_country',  '$ar_address',  '$ar_teach',  '$ar_profile_photo', '$ar_prize)'
);


                    
");
            
            if($artist_query){
                echo "<meta http-equiv=refresh content=0;url=artists.php>";
            }else{
               echo "<h1><font color='red'>Not Insert</font></h1>";
            }
            
        }
        ?>

i want to add my variable $ar_dob to my sql database .
it work for me but i want to my insert time to sql databse and i pick with date by jquery ui calender

[sunfighter]

You want to insert a time and you want to insert a date?
Or you want to add a time to jquery ui calender date?
Where would you get the time?

[Old Pedant]

What does the date that is coming from the datepicker *LOOK* like?

TO find out, just do

echo "<hr/>date from datepicker::" . $_POST["...name of field..."] . "::<hr/>";

in your PHP code and then show us what that shows you.

Use the actual name of the field in the <form> that is changed by the datepicker there, of course.

[Old Pedant]

The reason I ask: If the value from the datapicker is in the format "mm/dd/yyyy" or "dd/mm/yyyy" then it won't work with MySQL. MySQL requires format "yyyy-mm-dd". So you need to either re-format the date in your PHP code or use a MySQL function that will convert from the wrong format to the right one.

[minkoko]

Originally Posted by Old Pedant

The reason I ask: If the value from the datapicker is in the format "mm/dd/yyyy" or "dd/mm/yyyy" then it won't work with MySQL. MySQL requires format "yyyy-mm-dd". So you need to either re-format the date in your PHP code or use a MySQL function that will convert from the wrong format to the right one.

yes, My Datetimepicker format is mm/dd/yy from jquery ui site
and my mysql date format is yyyy-mm-dd so, i can't insert

So,How to reformat the date or how to change sql format

[sunfighter]

Guess you didn't mean "time". The default for Datepicker is "mm/dd/yy", but you can change that. See How to initialize the datepicker with the dateFormat option specified:

$( ".selector" ).datepicker({ dateFormat: "yy-mm-dd" });

http://api.jqueryui.com/datepicker/ or here with format.Date:

$.datepicker.formatDate( format, date, [settings] )

http://docs.jquery.com/UI/Datepicker...ker.formatDate

[minkoko]

Thanks mate ,now i see how to format the date for your kindness

and i just have one question about the time

can i formate the time like this 9:00 AM to 10:35 PM


Really thanks sunfighter

[Fou-Lu]

Originally Posted by minkoko

Thanks mate ,now i see how to format the date for your kindness

and i just have one question about the time

can i formate the time like this 9:00 AM to 10:35 PM


Really thanks sunfighter

Those are the same format. 9:00 AM = 10:35 PM when it comes to the display format. MySQL uses a 24 hour clock, so display wise you can use PHP to interpret it as you see fit. Since you are using a datetime type in MySQL, php can take that an convert it easily with the datetime class.

PHP Code:

$dt = new DateTime($record['datetime']);
print $dt->format('F j Y g:i A'); // January 5 2013 12:27 PM 


[Old Pedant]

You can also do all the format conversions in MySQL.

For example:

INSERT INTO sometable ( someDateTimeField )
VALUES( STR_TO_DATE( '3/22/2013 3:31pm', '%c/%e/%Y %r') )

to input 'm/d/yyyy hh:mm:ssAM' values or

SELECT DATE_FORMAT( someDateTimeField,  '%c/%e/%Y %r' ) AS prettyDate
FROM sometable

to convert internal format to 'm/d/yyyy hh:mm:ssAM'

[minkoko]

OK , Thanks for explain about the date formate to Old Pedant & Fou-Lu & sunfighter

Now i see how to use that


I like this method

PHP Code:

$dt = new DateTime($record['datetime']); 
print $dt->format('F j Y g:i A'); // January 5 2013 12:27 PM