Slide 29
Slide 29 text
$db_server = '127.0.0.1';
$db_user = 'root';
$db_pass = '';
$db_name = 'refactoring';
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']) . '
';
}