日期无法显示

Question

I'm trying to fetch and display all user information from mysql database but it doesn't able to show the time on row, but the rest information such as User ID and Username can be displayed. If I run the system in my windows localhost it's just working fine but when I run it using web hosting it doesn't show the date.

Database :

Database Record :

My current coding :

<?php
    $sql_select = "SELECT * FROM tbluserinfo";
    $result = $conn->query($sql_select);
    if ($result->num_rows > 0) 
    {
        while($row = $result->fetch_assoc()) 
        {
            echo "<tr>";
            echo "<td>".$row['user_id']."</td>";
            echo "<td>".$row['user_name']."</td>";
            echo "<td>".$row['user_created_date']."</td>";
            echo "</tr>";
        }
    }
    else
    {
        echo "<td colspan='3' style='color: red;'>No record found.</td>";
    }
?>

Answer 1

You could try :

echo date('j F, Y', strtotime($row['user_created_date']));

and make sure your $row['user_created_date'] is not null otherwise it will give you this date:

1 January, 1970