| 1 |
6daefa8c
|
Petr Lukašík
|
<HTML>
|
| 2 |
|
|
|
| 3 |
|
|
<HEAD>
|
| 4 |
|
|
<META content=text/html; http-equiv=Content-Type>
|
| 5 |
|
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
|
| 6 |
|
|
<TITLE></TITLE>
|
| 7 |
|
|
</HEAD>
|
| 8 |
|
|
|
| 9 |
|
|
<BODY>
|
| 10 |
|
|
|
| 11 |
|
|
<h1><center> Aktualizace dat pro hledani</center></h1>
|
| 12 |
|
|
<br>
|
| 13 |
|
|
<?
|
| 14 |
|
|
$spojeni = Pg_Connect("user=vadmin dbname=vseved2");
|
| 15 |
|
|
|
| 16 |
|
|
Pg_Exec ($spojeni, "DROP TABLE hledani");
|
| 17 |
|
|
|
| 18 |
|
|
if ($msg = Pg_Exec ($spojeni, "SELECT klic, webnazev, webpopis, ascnazev, ascpopis, wapnazev, wappopis, obor4, obor5, obor6, obor7 INTO TABLE hledani FROM ezetdat WHERE (obor1='1') ORDER BY ascnazev"))
|
| 19 |
|
|
{
|
| 20 |
|
|
echo ("<br>Aktualizace dat pro HLEDANI probehla v poradku.<br>\n");
|
| 21 |
|
|
Pg_Exec ($spojeni, "GRANT select ON hledani TO vviewer");
|
| 22 |
|
|
Pg_Exec ($spojeni, "GRANT all ON hledani TO dbowner");
|
| 23 |
|
|
Pg_Exec ($spojeni, "GRANT select ON hledani TO vadmin");
|
| 24 |
|
|
echo ("<br>Prirazeni prav probehlo v poradku.<br>\n");
|
| 25 |
|
|
}
|
| 26 |
|
|
Pg_Close ($spojeni);
|
| 27 |
|
|
|
| 28 |
|
|
?>
|
| 29 |
|
|
<form action="../index.php3">
|
| 30 |
|
|
<input type=submit value="Zpet na menu">
|
| 31 |
|
|
</form>
|
| 32 |
|
|
|
| 33 |
|
|
</BODY>
|
| 34 |
|
|
</HTML>
|