Jump to content

Help with date() and mktime() functions


bballer

Recommended Posts

New user of PHP here! I'm using it to display entries from my MYSQL database. Image below.

 

levelsk.png

 

This is the code snippet that displays information from the 'name', 'author' and 'date' columns of my database. I learned this technique from w3schools.

 

$result = mysql_query("SELECT * FROM levels ORDER BY date DESC");

while($row = mysql_fetch_array($result))
{
	echo "<tr>";
	echo "<td>" . $row['name'] . "</td>";
	echo "<td>" . $row['author'] . "</td>";
	echo "<td align='right'>" . $row['date'] . "</td>";
	echo "</tr>";
}

 

I would like to use the date() function to format the date differently. But the date() function requires that I convert my time into a timestamp. I know you have to use the mktime() function for this, but I don't know how.

 

Can someone show me how to pass the contents from $row[date] into the mktime() function?

Link to comment
https://forums.phpfreaks.com/topic/219775-help-with-date-and-mktime-functions/
Share on other sites

Much simpler to format it in the query using MySQL's native DATE_FORMAT() function, as long as the data is stored properly (which it is).

 

$result = mysql_query("SELECT `name`, `author`, DATE_FORMAT(`date`, '%b-%e-%Y') as `form_date` FROM `levels` ORDER BY `date` DESC");
while( $row = mysql_fetch_array($result) ) {
{
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['author'] . "</td>";
echo "<td align='right'>" . $row['form_date'] . "</td>";
echo "</tr>";
}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.