Latest posts for the topic "Website Integration - SSI?"

Website Integration - SSI?

pureplayer — GMT

Hi, I'm wondering if there's a script available or can be written that will allow the last x guestbook entries be viewed on another webpage. Like the Invision Power Board uses the SSI to view the last x posts.

Any help will be appreciated

Thanks

Carbonize — GMT

I did write a script for someone that pulls the last five entries and displays them. I can try and dig it up.

great

pureplayer — GMT

That would be great and much appreciated.

Thanks

Carbonize — GMT

I was going to upload it somewhere but I'll just post it in here for you to copy and paste. Just put the file in the guestbook folder then include it where you want the entries to be displayed.
[code]
//
// Put in some error handling
//

ini_set('display_errors', 1);
error_reporting(E_ALL & ~E_NOTICE);

//
// Include the config file to get the database settings
//

include "admin/config.inc.php";

//
// Connect to MySQL server and select database if possible
//

if ($dbc = @mysql_connect ($GB_DB['host'] , $GB_DB['user'] , $GB_DB['pass'] ))
{
if (!@mysql_select_db ($GB_DB['dbName']))
{
die ('

Could not select the database because: '.mysql_error().'

');
}
}
else
{
die ('

Could not connect to MySQL because: '.mysql_error().'

');
}

//
// Here we put any HTML that goes before our entries
//

print "
";

//
// Run our MySQL query
//

$r = @mysql_query('SELECT * FROM '.$GB_TBL["data"].' ORDER BY id DESC LIMIT 5');

//
// Turn the results into an array and go through the array formatting each entry
//

while ($lentry = mysql_fetch_array($r))
{
$ldate = date("l jS F Y", $lentry['date']);
print "

";
}

//
// Here goes any HTML for after the entries
//

print "

Name:	$lentry['name']
Posted:	$ldate
Message:	$lentry['comment']

";

//
// Close the MySQL connection
//

mysql_close();
?>[/code]

pureplayer — GMT

thanks very much.

Carbonize — GMT

You can change the date format if you know PHP date code and the number of entries in the query. Can you let me see it in action ?

JohnnyUSA — GMT

After the code include .. I receive these kind of errors

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/username/public_html/book/latest.php on line 54

Carbonize — GMT

It means you have an error on line 54.

JohnnyUSA — GMT

I just copied your instruction code .. so what's that error ?

JTD — GMT

[quote="JohnnyUSA"]I just copied your instruction code .. so what's that error ?[/quote]

[b]T_ENCAPSED_AND_WHITESPACE[/b]

Carbonize — GMT

Line 54 is

$lentry['name']

Can't see a reason for th eerror.

JohnnyUSA — GMT

Could you please check the code again? to make sure it work right ?

Auron — GMT

[code]//
// Here we put any HTML that goes before our entries
//

print "
";

//
// Run our MySQL query
// [/code]

The print on two lines maybe?

Anyway, post what you have on line 54.

Carbonize — GMT

Ah the wanderer returns.

JohnnyUSA — GMT

Something is really wrong with the Line: 54

and Line: 61

After I remove those 2 out, the display seem like work without error, but what is the right code for entry comment and name?

Carbonize — GMT

I will play with it soon.

$lentry['name']

$lentry['comment']