Using jQuery variable in PHP page

Question

I'm using jQuery Ajax to store some value in MySql DB

So far I'm passing a start_time as a datetime object like

Wed Aug 15 2012 14:00:00 GMT+0530 (IST)

and I'm getting this value on my php page like

1345019400

in my db, I want to store that value like

2012-8-17 20:45

so the $_POST['start_time'] that value is looking like an integer(I'm not sure )

my question is what to do with that integer value so that it could store in my db like

2012-8-17 20:45

see this url:-- stackoverflow.com/questions/2838756/…

Abid Hussain
– Abid Hussain

2012-08-17 10:02:32 +00:00
Commented Aug 17, 2012 at 10:02 — Abid Hussain
– Abid Hussain, Commented Aug 17, 2012 at 10:02
thanks to all of you for answer

Nags
– Nags

2012-08-17 10:07:07 +00:00
Commented Aug 17, 2012 at 10:07 — Nags
– Nags, Commented Aug 17, 2012 at 10:07

Bhuvan Rikka · Accepted Answer · 2012-08-17 10:01:14Z

0

$bla=1345019400;

$date=date('Y-m-d H:i',$bla);
echo $date;

answered Aug 17, 2012 at 10:01

Bhuvan Rikka

2,7031 gold badge19 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

João Dias · Accepted Answer · 2012-08-17 09:59:43Z

0

The "integer" is a timestamp! Format it using the PHP DateTime::format function

answered Aug 17, 2012 at 9:59

João Dias

1,1081 gold badge17 silver badges39 bronze badges

Comments

Mihai Matei · Accepted Answer · 2012-08-17 10:00:03Z

0

You get timestamp so you have to transform it using date function:

<?php
    $date = date('YYYY-mm-dd hh:ii', $_POST['start_time']);
?>

answered Aug 17, 2012 at 10:00

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

Comments

Henrik Karlsson · Accepted Answer · 2012-08-17 10:00:51Z

0

It's a timestamp. Have a look at the PHP date function to format it.

answered Aug 17, 2012 at 10:00

Henrik Karlsson

5,7634 gold badges28 silver badges43 bronze badges

Comments

ddoor · Accepted Answer · 2012-08-17 10:01:25Z

0

your php needs to format it into mysql date format before it inserts (assuming the data type on your column is DATETIME)

Check out the way php works with dates.

Also if you are having trouble with the date converting, convert it all to an Epoch string between javascript and php, then convert it just before insertion.

Let me know if that makes sense.

answered Aug 17, 2012 at 10:01

ddoor

5,9719 gold badges36 silver badges41 bronze badges

2 Comments

ddoor Over a year ago

No worries (+1) me if you want :P

ddoor Over a year ago

P.S the DATETIME format for mysql is: "YYYY-mm-DD hh:MM:ss" so use that in your php functions.

Alex · Accepted Answer · 2012-08-17 10:08:15Z

0

date("M-d-Y g:i", $date);

read documentation for function date()

answered Aug 17, 2012 at 10:08

Alex

1,30411 silver badges20 bronze badges

Collectives™ on Stack Overflow

Using jQuery variable in PHP page

6 Answers 6

Comments

Comments

Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related