Remorse Posted March 12, 2019 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
Adriano Faria Posted March 12, 2019 Posted March 12, 2019 On a template: {datetime="$date"} PHP: $myDate = \IPS\DateTime::ts( $date );
Remorse Posted March 12, 2019 Author Posted March 12, 2019 We want to show it on our website not in forum
Remorse Posted March 12, 2019 Author 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
Remorse Posted March 12, 2019 Author Posted March 12, 2019 any advice wich sql querys to use to show last 10 active topics?
bfarber Posted March 13, 2019 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.