index.php Source File

00001 <?php
00002 
00003 //include libs and read postgresql connection parameter from config.ini file 
00004 include('../include/init/init.php');
00005 
00006 $PgDbConn=pg_connect(
00007                      "dbname=".$CONFIG["DB"]['DBNAME'].
00008                      " user=".$CONFIG["DB"]['USER'].
00009                      " password=".$CONFIG["DB"]['PASSWORD'].
00010                      " host=".$CONFIG["DB"]['HOST']
00011                      ) 
00012      or die("Can't connect!");
00013 
00014 
00015 //get the list of table in current database
00016 $table_list=get_tables($PgDbConn);
00017 
00018 foreach($table_list as $key=>$row){
00019   $tables["Schema <tt>".$row["schemaname"].'</tt>']["Table <tt>".$row["tablename"].'</tt>']='Table <a href="./tables.php?tbInfo['.urlencode($row["schemaname"]).']['.urlencode($row["tablename"]).'][pkey]="><tt>'.$row["tablename"].'</tt></a>';
00020 }
00021 
00022 
00023 
00024 $tables= array_to_html($tables,0,2,false);
00025 $title="table lists";
00026 ?>
00027 <html>
00028 
00029 <head>
00030 <link rel="stylesheet" type="text/css" href="/css/main.css" />
00031 <title>phpPgWeb: <?=$title?></title>
00032 </head>
00033 
00034 <body>
00035    <div id="navigation">
00036      <p class="centrato"><a href="/" title="Home"><h1>phpPgWeb</h1></a></p>
00037    </div>
00038    
00039    <p class="titolo"><?=$title?></p>
00040    <p class="racconto">
00041       Tables of database <tt> "<?=$CONFIG["DB"]["DBNAME"]?>" </tt> on <tt> "<?=$CONFIG["DB"]["HOST"]?>"</tt>, user <tt> "<?=$CONFIG["DB"]["USER"]?>" </tt>
00042    </p>
00043    <p><?=$tables?></p>
00044 
00045 </body>
00046 </html>