Commit | Line | Data |
---|---|---|
bc13d5d6 H |
1 | <? |
2 | ||
3 | ini_set("include_path","./inc:./boxiky/:./config:../inc:../boxiky/:../config"); | |
4 | include_once("kyberia.inc"); | |
5 | $database=new CLASS_KYBERIA(); | |
6 | ||
7 | $describe=$_GET['describe']; | |
8 | $table=$_GET['table']; | |
9 | $where=$_GET['where']; | |
10 | ||
11 | ?> | |
12 | <form action='?' method='get'> | |
13 | describe | |
14 | <input type='text' name='describe' value='<? echo $describe;?>'> | |
15 | <input type='submit' value='send'> | |
16 | </form> | |
17 | <form action='?' method='get'> | |
18 | select * from | |
19 | <input type='text' name='table' value='<? echo $table;?>'> | |
20 | where | |
21 | <input type='text' name='where' value='<? echo $where;?>'> | |
22 | <input type='submit' value='send'> | |
23 | </form> | |
24 | <br> | |
25 | <? | |
26 | ||
27 | ||
28 | if ($table) selectni($table,$where); | |
29 | if ($describe) descni($describe); | |
30 | ||
31 | function descni($tablename){ | |
32 | global $database; | |
33 | $q="describe $tablename"; | |
34 | $set=$database->query($q); | |
35 | ||
36 | echo "<table border='1'><tr><td><b>Field</b></td><td><b>Type</b></td> <td><b>Null</b></td></tr>"; | |
37 | while($set->next()){ | |
38 | $field=$set->getString('Field'); | |
39 | $fields[]=$field; | |
40 | $type=$set->getString('Type'); | |
41 | $null=$set->getString('Null'); | |
42 | echo "<tr><td>".$field."</td>"; | |
43 | echo "<td>".$type."</td>"; | |
44 | echo "<td>".$null."</td></tr>"; | |
45 | } | |
46 | echo "</table>"; | |
47 | } | |
48 | ||
49 | ||
50 | ||
51 | ||
52 | function selectni($tablename,$where){ | |
53 | global $database; | |
54 | $q="describe $tablename"; | |
55 | $set=$database->query($q); | |
56 | if ($where=="") { | |
57 | $q2="select * from $tablename"; | |
58 | }else{ | |
59 | $where=StripSlashes($where); | |
60 | $q2="select * from $tablename where $where"; | |
61 | } | |
62 | echo $q2."<br>"; | |
63 | $set2=$database->query($q2); | |
64 | ||
65 | while($set->next()){ | |
66 | $field=$set->getString('Field'); | |
67 | $fields[]=$field; | |
68 | $type=$set->getString('Type'); | |
69 | $null=$set->getString('Null'); | |
70 | } | |
71 | echo "<table border='1'><tr>"; | |
72 | for($i=0;$i<count($fields);$i++){ | |
73 | echo "<td><b>".$fields[$i]."</b></td>"; | |
74 | } | |
75 | ||
76 | echo "</tr><tr>"; | |
77 | ||
78 | while($set2->next()){ | |
79 | for($i=0;$i<count($fields);$i++){ | |
80 | $onefield=$set2->getString($fields[$i]); | |
81 | echo "<td>".$onefield."</td>"; | |
82 | } | |
83 | echo "</tr><tr>"; | |
84 | } | |
85 | echo "</tr></table>"; | |
86 | } | |
87 | ?> |