9 <a href='showtable.php?table=macaddrs'>macaddrs</a>
10 <a href='showtable.php?table=sessionmd'>sessionmd</a>
11 <a href='showtable.php?table=sessionview'>sessionview</a>
12 <a href='showtable.php?table=nicvendors'>nicvendors</a> <br>
13 (Show max 1000 rows of selected table).
19 if(getenv('REMOTE_USER')=='') die('Cannot get auth');
21 // no table is indicated
22 if(!isset($_GET['table']))return;
24 // connect and access to MySql DB
25 $link = mysql_connect('localhost', 'root', '');
26 if (!$link) die('Cannot connect DB'.mysql_error());
28 $db_selected = mysql_select_db('opengatem', $link);
29 if (!$db_selected) die('Cannot select DB'.mysql_error());
31 mysql_set_charset('utf8');
33 $result = mysql_query('SELECT * FROM '.$_GET['table'].' limit 1000');
34 if (!$result) die('Fail query'.mysql_error());
37 print("<table border=1>");
40 while ($field = mysql_fetch_field($result)) {
41 print('<td>'.$field->name.'</td>');
47 while ($row = mysql_fetch_row($result)) {
49 for($i=0; $i<$count; $i++){
50 print('<td>'.$row[$i].'</td>');
55 $close_flag = mysql_close($link);