php wrong date format

Question

i have this shopping cart in which it sends the orders to mysql database along with the date on when it was ordered: the code for the date is as follows:

<?
    include("includes/db.php");
    include("includes/functions.php");  

    $max=count($_SESSION['cart']);
        for($i=0;$i<$max;$i++){
            $pid=$_SESSION['cart'][$i]['productid'];
            $q=$_SESSION['cart'][$i]['qty'];
            $price=get_price($pid);
            $date=date('Y/m/d');
            $user=$_SESSION['username'];
            $pname=get_product_name($pid);
            mysql_query("insert into `order` values ('','$pname','$q','$price','$date','$user')")

                or die(mysql_error());

it outputs the date as 2011/11,14. How do i get it to output it like the following: 14/11/2011??

im not focusing on the security aspects yet, im trying to get the queries to work 1st — Jahed
– Jahed, Commented Nov 14, 2011 at 0:09

slugonamission · Accepted Answer · 2011-11-14 00:05:51Z

1

The issue is with the $date = date... line. I'm not going to give you the direct answer to your question, but have a look at the documentation for date() for starters. Also, you should really be using a DATE database field rather than a string to store that

answered Nov 14, 2011 at 0:05

slugonamission

9,6741 gold badge36 silver badges41 bronze badges

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

Comments

malletjo · Accepted Answer · 2011-11-14 00:07:08Z

0

Change this line :

date('Y/m/d');

for

date('d/m/Y');

answered Nov 14, 2011 at 0:07

malletjo

1,78616 silver badges19 bronze badges

4 Comments

Jahed Over a year ago

if i change it to date('d/m/Y'); it returns with : 0000-00-00

slugonamission Over a year ago

In that case, it's because your date field is of data type DATE and expects inserted data to be in the MySQL date format, which is YYYY-MM-DD

Jahed Over a year ago

yes it was DATE as a data type of which i have now changed it to an integer....it now outputs the date, not the month or year. my php code looks like this now: $date=date('d/m/Y');

slugonamission Over a year ago

No, it wanted to be the DATE data type. By changing it to integer, it'll just store the first number, or try and do some strange maths, or something just plain undefined. You need to insert it as Y/m/d as that is what MySQL expects (and it's stored as YYYY-mm-dd hh:mm:ss internally).

Collectives™ on Stack Overflow

php wrong date format

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related