-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathdelete_examination_request.php
executable file
·114 lines (93 loc) · 2.61 KB
/
delete_examination_request.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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
<?php
session_start();
echo '<html>';
echo '<head>';
echo '</head>';
echo '<body>';
/*
echo '<pre>';
print_r($GLOBALS);
echo '</pre>';
*/
include 'common.php';
function read_sample_id($value)
{
echo '<table border=1>
<form method=post action=delete_examination_request.php >';
echo '<tr>';
echo '<td>sample_id</td>';
echo '<td><input type=text name=sample_id ></td>';
echo '</tr>';
echo '<tr><td colspan=2 align=center><button type=submit name=action value='.$value.'>'.$value.'</button></td></tr>';
echo '</form></table>';
}
function delete_examination($sample_id,$filename,$disabled)
{
$link=start_nchsls();
$sql='select * from examination where sample_id=\''.$sample_id.'\'';
//echo $sql;
if(!$result=mysql_query($sql,$link)){echo 'No such Sample';return FALSE;}
if(mysql_num_rows($result)<1){echo 'No examinations';return FALSE;}
echo '<table border=1 bgcolor=lightgrey CELLPADDING=0 CELLSPACING=0>';
echo '<form method=post action=\''.$filename.'\'>';
echo '<tr><td>';
echo '<input type=hidden name=sample_id value=\''.$sample_id.'\'>';
echo '<input type=hidden name=action value=delete_examination>';
echo '</td></tr>';
echo '<tr><th colspan=18 align=left>Delete Examination Form</th></tr>';
$first='true';
while($ar=mysql_fetch_assoc($result))
{
echo '<tr>';
if($first=='true')
{
foreach ($ar as $key => $value) //for every row in scope
{
echo '<th nowrap>'.$key.'</th>';
}
$first='false';
echo '</tr>';
}
foreach ($ar as $key => $value) //for every row in scope
{
if($key=='id')
{
echo '<td nowrap><input type=submit '.$disabled.' name=id \' value=\''.$value.'\'></td>';
}
else
{
echo '<td nowrap>'.$value.'</td>';
}
}
echo '</tr>';
}
echo '</form></table>';
}
if(!login_varify())
{
exit();
}
main_menu();
if(!isset($_POST['sample_id']) || !isset($_POST['action']))
{
read_sample_id('delete_examination');
}
elseif(isset($_POST['sample_id']) && isset($_POST['action']))
{
if($_POST['action']=='delete_examination')
{
if(isset($_POST['id']))
{
$link=start_nchsls();
$sql='delete from examination where sample_id=\''.$_POST['sample_id'].'\' and id=\''.$_POST['id'].'\'';
//echo $sql;
$result=mysql_query($sql,$link);
//echo mysql_error();
//echo 'deleted '.mysql_affected_rows($link).' examination<br>';
}
edit_sample($_POST['sample_id'],'edit_request.php ','disabled','no');
//echo 'deleting...';
delete_examination($_POST['sample_id'],'delete_examination_request.php ','');
}
}
?>