1. ročník 2017

[insert_php]

header(“Content-Type: text/html; charset=UTF-8”);

error_reporting(-1);
ini_set(‘display_errors’, ‘On’);

$config = array();
$config[‘host’] = ‘192.168.33.49’;
$config[‘user’] = ‘web247’;
$config[‘pass’] = ‘Vj247Sel’;
$config[‘db’] = ‘ZAM’;

$conn = mssql_connect($config[‘host’], $config[‘user’], $config[‘pass’]) or die(mssql_get_last_message());
mssql_select_db($config[‘db’]) or die(mssql_get_last_message());

function query($s)
{
$res = mssql_query($s) or die(mssql_get_last_message());
return $res;
}

function show_results($res, $columns=false)
{
echo “

“;
echo “

“;
for ($i=0; $i < mssql_num_fields($res); $i++) { echo "

“;
}
echo “

“;
while ($row = mssql_fetch_array($res)) {
echo “

“;
for ($i=0; $i < mssql_num_fields($res); $i++) { echo "

“;
}
echo “

“;
}
echo “

“; if ($columns && $columns[$i]) { echo(htmlspecialchars($columns[$i])); } else { echo(htmlspecialchars(mssql_field_name($res, $i))); } echo “

“; echo(htmlspecialchars($row[$i])); echo “

“;
}
query(“set language Czech”);

$res = query(“select ROW_NUMBER() over (order by dbpocetvyst desc) as poradi, dbPocetVyst, dbOsobniCislo, dbJmeno, dbObec,dbRokNar,dbFunkce from WvjPristupy247countLoni order by dbPocetVyst desc, dbosobnicislo”);
show_results($res, [“poradi”,”pocet vystupu”, “osobni cislo”, “jmeno”, “obec”, “rok narozeni”, “pohlavi”]);

[/insert_php]