/
viewDatabase.php
48 lines (33 loc) · 936 Bytes
/
viewDatabase.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
<?php
// get request parms
$request = "get-question";
$failed = false;
require_once('config_category.php');
// $query = "delete from questions";
//
// $link->query($query);
$query = "SELECT * from ".$_GET['db'];
print "query: ".$query."<br>";
if ($result = $link->query($query)) {
/* Get field information for all columns */
$finfo = $result->fetch_fields();
print "<br>";
foreach ($finfo as $val) {
print "<br>";
printf("Name: %s\n <br>", $val->name);
printf("Table: %s\n <br>", $val->table);
printf("max. Len: %d\n <br>", $val->max_length);
printf("Flags: %d\n <br>", $val->flags);
printf("Type: %d\n <br>", $val->type);
}
while ( $row = $result->fetch_assoc() ) {
print_r($row);
print "<br>";
}
$result->close();
} else {
print "query failed. error: ".$link->error;
}
/* close connection */
$link->close();
?>