|
go();
foreach ($this->links as $linkitem)
{
$toprint =<<{$linkitem->title}
http://{$linkitem->url}
{$linkitem->description}
AAA;
echo $toprint;
}
}
function go()
{
// ok open database
$dblink = dbopen();
$res = mysql_query('SELECT * FROM links');
while ($row = mysql_fetch_array($res,MYSQL_ASSOC)) $this->links[] = new linkitem($row['title'],$row['description'],$row['url']);
dbclose($dblink);
}
}
class linkitem {
var $title;
var $description;
var $url;
function linkitem($title,$description,$url)
{
$this->title = $title;
$this->description = $description;
$this->url = $url;
}
}
// database helper functions to open/close database--
function dbopen()
{
$link = mysql_connect(DB_HOST,DB_USER,DB_PASS) or die('could not connect');
mysql_select_db(DB_DATABASE,$link) or die("database not found");
return $link;
}
function dbclose($link) { mysql_close($link); }
$linkstuff = new links();
/************************************************************************
** end of links include
************************************************************************/
?>
|
