Using vbdate

[inthezone]

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

[NTLDR]

PHP Code:

$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:

PHP Code:

$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

PHP Code:

$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:

PHP Code:

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
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

PHP Code:

$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:

PHP Code:

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
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:

PHP Code:

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');