Učitelé
Přítomni
\ or
// , when using a non default port number
$server = '192.168.3.50:1433';
// Connect to MSSQL
$link = mssql_connect($server, 'sa', 'goa34901');
if (!$link) {
die('Something went wrong while connecting to MSSQL');
}
mssql_select_db('card', $link);
$result = mssql_query("select last_name,first_name,last_in from t_user where last_in > last_out and personal_id='ucitel' order by last_name ");
if ( mssql_num_rows ($result) > 0) {
while ($record = mssql_fetch_assoc($result)) {
echo "
$record[last_name] $record[first_name] ($record[last_in])";
}
}
?>
Mimo
0) {
while ($record = mssql_fetch_assoc($result)) {
echo "
$record[last_name] $record[first_name] ($record[last_out])";
}
}
// Clean up
mssql_free_result($result);
//mssql_close($link);
?>
Provozní zaměstnanci a vedení
Přítomni
last_out and personal_id='provoz' order by last_name ");
if ( mssql_num_rows ($result) > 0) {
while ($record = mssql_fetch_assoc($result)) {
echo "
$record[last_name] $record[first_name] ($record[last_in])";
}
}
?>
Mimo
0) {
while ($record = mssql_fetch_assoc($result)) {
echo "
$record[last_name] $record[first_name] ($record[last_out])";
}
}
// Clean up
mssql_free_result($result);
// tohle snad uvolnà paměť
mssql_free_statement ($stmt);
//mssql_close($link);
?>