|
1
|
<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>
|