Slide 55
Slide 55 text
require_once('config.php');
$db = new PDO('mysql:dbname='.$db_name.';host='.$db_server,
$db_user, $db_pass);
$newsSQL = "SELECT * FROM NEWS ORDER BY published_at DESC";
$stmt = $db->prepare($newsSQL);
$stmt->execute();
while($row = $stmt->fetch(PDO::FETCH_ASSOC))
{
echo $row['published_at'] . ': ' . $row['title'].'
';
echo nl2br($row['message']) . '
';
}
Thursday, August 22, 13