Volgens mij staan ze prima, ik zet het script er even bij zodat het misschien iets duidelijker wordt.
[script]
<?php
require_once "prepend.php";
if ($_SESSION['user'] == null) {
require "form.php";
} else {
$user = $_SESSION['user'];
}
if (!check_auth_user($user,'expert')) return;
?>
<html>
<head>
<title>Database Zaanland - Groep</title>
<link href="beeldscherm.css" rel="stylesheet" type="text/css" media="screen" />
<link href="printer.css" rel="stylesheet" type="text/css" media="print" />
</head>
<body>
<div id="PrintKlaar">
<?php
include("header.html");
include("db_werk.php");
$mysql_id=mysql_connect($dbhost,$dbuser,$dbpass)
or die("kan geen verbinding maken met de de database: ".mysql_error());
mysql_select_db("werk", $mysql_id);
$sql="select * from werk";
$res=mysql_query($sql);
$fout=mysql_errno($mysql_id);
if ($fout != 0) {
$fout=mysql_error($mysql_id);
echo '<font color="#FF2306">' . $fout . '</font>';
mysql_close($mysql_id);
echo '</body></html>';
exit;
}
$mysql_id=mysql_connect($dbhost,$dbuser,$dbpass)
or die("kan geen verbinding maken met de de database: ".mysql_error());
mysql_select_db("werk", $mysql_id);
$sql= "select CONCAT(
ELT(DAYOFWEEK(datum), 'zondag', 'maandag', 'dinsdag', 'woensdag', 'donderdag', 'vrijdag', 'zaterdag'),
' ',
DAYOFMONTH(datum),
' ',
ELT(MONTH(datum), 'januari', 'februari', 'maart', 'april', 'mei', 'juni', 'juli', 'augustus', 'september', 'oktober', 'november', 'december'),
' ',
YEAR(datum)
) AS datum_NL,TIME_FORMAT( tijd, '%H:%i' ) AS tijd,nacht,soort,rit,user from werk WHERE datum >= NOW() ORDER BY datum,tijd";
$res=mysql_query($sql);
$fout=mysql_errno($mysql_id);
if ($fout != 0) {
$fout=mysql_error($mysql_id);
echo '<font color="#FF2306">' . $fout . '</font>';
mysql_close($mysql_id);
echo '</body></html>';
exit;
}
while ($row = mysql_fetch_assoc($res))
{
echo '<div align="left" >';
echo '<table cellpadding="4" cellspacing="0" width="100%" height="25" style=" border-top: none; border-left: none; border-bottom: 1px solid blue; border-right: none;" >';
echo '<tr><td width="15%" height="15">'.$row['soort'].'</td>';
echo '<td class="mijnstijl" width="30%" height="15">'.$row['datum_NL'].'</td>';
echo '<td class="mijnstijl" width="15%" height="15">'.$row['tijd'].'</td>';
echo '<td width="15%" height="15">'.$row['nacht'].'</td>';
echo '<td width="25%" align="right" height="15">'.$row['user'].'<tr>';
echo '<td colspan="5" height="16" >'.$row['rit'].'</td></tr>';
}
echo'</table>';
echo'</div>';
include("footer.html");
?>
</body>
</html>
[/script]
