Using vbdate

[inthezone]

How would I use vbdate to format the date/time of a 'lastpost' number from the DB table called 'thread'?

[NTLDR]

$date = vbdate($dateformat, $thread['dateline']);
$time = vbdate($timeformat, $thread['dateline']);

Replacing $thread with the variable that holds in information from the DB.

[inthezone]

I've done this:


$query = @mysql_query("SELECT * FROM thread");
while ($row= mysql_fetch_array($query))
{

$lastpost = vbdate($dateformat,$row['lastpost']);
.
.
.
echo "$lastpost<br>";

}



But the dates don't appear...

[NTLDR]

Firstly, if you including vB's global.php then there is no need to use mysql_query, use the builtin MySQL functions that coem with vB :)

$threads = $DB_site->query("SELECT * FROM thread");
while($thread =$DB_site->fetch_array($threads)) {

$lastpost = vbdate($dateformat, $thread['lastpost']);

echo "$lastpost<br />";

}

If this code is in a function then make sure you have:

global $DB_site, $timeformat, $dateformat;

Also note that if the page is outputing templates then the echo isn't likly to output anything to the browser.

[inthezone]

Today at 01:01 PM NTLDR said this in Post #4 (https://vborg.vbsupport.ru/showthread.php?postid=420247#post420247)
Firstly, if you including vB's global.php then there is no need to use mysql_query, use the builtin MySQL functions that coem with vB :)

$threads = $DB_site->query("SELECT * FROM thread");
while($thread =$DB_site->fetch_array($threads)) {

$lastpost = vbdate($dateformat, $thread['lastpost']);

echo "$lastpost<br />";

}

If this code is in a function then make sure you have:

global $DB_site, $timeformat, $dateformat;

Also note that if the page is outputing templates then the echo isn't likly to output anything to the browser.


I am using global.php on this page for user identification purposes, but the above code doesn't print out the dates. Does the page automatically recognize vbdate() when you require global.php?

[NTLDR]

Yes, if you haven't included global.php you will see and error saying something saying call to undefined function vbdate() on line x in file x.php.

Are you using echo/print and HTML within the PHP file or are you using templates for the page?

[inthezone]

Today at 01:18 PM NTLDR said this in Post #6 (https://vborg.vbsupport.ru/showthread.php?postid=420254#post420254)
Yes, if you haven't included global.php you will see and error saying something saying call to undefined function vbdate() on line x in file x.php.

Are you using echo/print and HTML within the PHP file or are you using templates for the page?


I'm using HTML/PHP rather than the vB templates for the page. The site is separate from the forum content-wise (aside from displaying recent threads), but is integrated with the vB user database via global.php, and most of the pages are structured like this:


chdir('./vB/');
require('global.php');
require ('header.php');

if ($bbuserinfo['userid']>0)
{
// Page content
}

if ($bbuserinfo['userid']==0)
{
echo "You must be registered to view this page. Please login or register";
}

require ('footer.php');