[insert_php]
$link = mysqli_connect(‘localhost’, ‘stic15’, ‘P0Pd2GAd’, ‘stic15_WMR’);
if(!$link)
{
trigger_error(‘Fout bij verbinden met database: ‘.mysqli_connect_error());
}
$sql = “SELECT * FROM `Agenda` order by ‘Datum’ desc”;
if(!$res = mysqli_query($link, $sql))
{
trigger_error(‘Fout in query: ‘.mysqli_error());
}
else
{
$aantal = mysqli_num_rows($res);
echo ‘Aantal records: ‘.$aantal.’
‘;
while($row = mysqli_fetch_assoc($res))
{
echo $row[‘Datum’]; echo ‘ – ‘ ; echo $row[‘Item’].’
‘;
}
}
[/insert_php]