-
Notifications
You must be signed in to change notification settings - Fork 0
/
edit_any_step_1.php
70 lines (55 loc) · 1.15 KB
/
edit_any_step_1.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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<?php
session_start();
echo '<html>';
echo '<head>';
echo '<title>Clinical Chemistry, LSB</title>';
echo '</head>';
echo '<body>';
//echo '<pre>';
//print_r($GLOBALS);
//echo '</pre>';
include 'common.php';
function make_array_inventory($sql_str, $fld,$dfl)
{
//echo $sql_str;
$link=start_nchsls();
$result=mysql_query($sql_str,$link);
echo mysql_error();
while ($ops=mysql_fetch_assoc($result))
{
$ar[]=$ops[$fld];
}
//echo $ar;
echo '<select name='.$fld.'>';
foreach ($ar as $key => $value)
{
if($value==$dfl)
{
echo '<option selected > '.$value.' </option>';
}
else
{
echo '<option > '.$value.' </option>';
}
}
echo '</select>';
}
function list_tables()
{
$sql = 'show tables where Tables_in_biochemistry like \'record_%\'';
echo '<table border=1><th colspan=2>Select table to edit</th><form method=post action=\'edit_any_step_2.php\'>';
echo '<tr><td>';
make_array_inventory($sql,'Tables_in_biochemistry','');
echo '</td></tr>';
echo '<tr><td>';
echo '<input type=submit name=submit value=select_table>';
echo '</td></tr>';
echo '</form></table>';
}
if(!login_varify())
{
exit();
}
list_tables();
main_menu();
?>