Getting date column from database in PHP

Question

I have a field Publish_on in my mysql database table. It stores the date and time when a post was added.

I am not able to get the publish dates. Instead, the output I get is today's date, even if the post belongs to other dates.

$id = (int) ($_GET['postid']);

$result = mysqli_query("
    SELECT Publish_on 
      FROM `post_head` 
     WHERE `post_id` = '" . $_GET['id'] . "'
");

$row = mysqli_fetch_row($result);
$date = date_create($row['Publish_on']);

echo date_format($date, 'g:ia \o\n l jS F Y');

Can you please try $date = date_create(strtotime($row['Publish_on'])); — Veerendra
– Veerendra, Commented Nov 22, 2016 at 5:56
its working fine ... Please check live demo : eval.in/682415 — RJParikh
– RJParikh, Commented Nov 22, 2016 at 5:59

Irvin · Accepted Answer · 2016-11-22 06:01:31Z

1

If you are going to use mysqli_fetch_row, then you need to use $row[0] instead of $row['Publish_on'].

http://php.net/manual/en/mysqli-result.fetch-row.php

mysqli_result::fetch_row -- mysqli_fetch_row — Get a result row as an enumerated array

<?php

  $id     = (int) ($_GET['postid']);
  $result = mysqli_query("SELECT Publish_on FROM `post_head` WHERE `post_id` = '" . $_GET['id'] . "'");
  $row    = mysqli_fetch_row($result);
  $date   = date_create($row[0]);
  echo date_format($date, 'g:ia \o\n l jS F Y');

?>

But if you still prefer to use $row['Publish_on'] then use mysqli_fetch_array or mysqli_fetch_assoc.

answered Nov 22, 2016 at 6:01

Irvin

8325 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Getting date column from database in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related