Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook Tuesday at 01:29 PM
Remorse Posted March 12, 2019 Share Posted March 12, 2019 Why when I lf a date to display on my website its displayed like this : 1551181916 POST USER DATE Class balance system | Remorse | 1551181916 I'm trying to find information from mysql To show : last active post and the username and date any help? ssql query Link to comment Share on other sites More sharing options...
Adriano Faria Posted March 12, 2019 Share Posted March 12, 2019 On a template: {datetime="$date"} PHP: $myDate = \IPS\DateTime::ts( $date ); Link to comment Share on other sites More sharing options...
Remorse Posted March 12, 2019 Author Share Posted March 12, 2019 We want to show it on our website not in forum Link to comment Share on other sites More sharing options...
Adriano Faria Posted March 12, 2019 Share Posted March 12, 2019 http://php.net/manual/en/function.date.php Link to comment Share on other sites More sharing options...
Remorse Posted March 12, 2019 Author Share Posted March 12, 2019 This are my 10 recently posts on forum. I want to do the same info, and share it on my website like the 10 last active posts Link to comment Share on other sites More sharing options...
Remorse Posted March 12, 2019 Author Share Posted March 12, 2019 any advice wich sql querys to use to show last 10 active topics? Link to comment Share on other sites More sharing options...
bfarber Posted March 13, 2019 Share Posted March 13, 2019 If you have Pages, I would recommend simply creating a custom block in pages and then using the existing "Embed externally" feature, which will give you some javascript code you can insert into your website to display the block. To answer your original question, what is stored is known as a timestamp, and the PHP date function (among others, such as strftime) can convert that to a human-readable date. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.