001.
<?php
require_once
(
'../Connections/dbconn.php'
); ?>
002.
<?php
003.
if
(!function_exists(
"GetSQLValueString"
)) {
004.
function
GetSQLValueString(
$theValue
,
$theType
,
$theDefinedValue
=
""
,
$theNotDefinedValue
=
""
)
005.
{
006.
if
(PHP_VERSION < 6) {
007.
$theValue
= get_magic_quotes_gpc() ?
stripslashes
(
$theValue
) :
$theValue
;
008.
}
009.
$theValue
= function_exists(
"mysql_real_escape_string"
) ? mysql_real_escape_string(
$theValue
) : mysql_escape_string(
$theValue
);
010.
switch
(
$theType
) {
011.
case
"text"
:
012.
$theValue
= (
$theValue
!=
""
) ?
"'"
.
$theValue
.
"'"
:
"NULL"
;
013.
break
;
014.
case
"long"
:
015.
case
"int"
:
016.
$theValue
= (
$theValue
!=
""
) ?
intval
(
$theValue
) :
"NULL"
;
017.
break
;
018.
case
"double"
:
019.
$theValue
= (
$theValue
!=
""
) ? doubleval(
$theValue
) :
"NULL"
;
020.
break
;
021.
case
"date"
:
022.
$theValue
= (
$theValue
!=
""
) ?
"'"
.
$theValue
.
"'"
:
"NULL"
;
023.
break
;
024.
case
"defined"
:
025.
$theValue
= (
$theValue
!=
""
) ?
$theDefinedValue
:
$theNotDefinedValue
;
026.
break
;
027.
}
028.
return
$theValue
;
029.
}
030.
}
031.
if
((isset(
$_GET
[
'empid'
])) && (
$_GET
[
'empid'
] !=
""
)) {
032.
$deleteSQL
= sprintf(
"DELETE FROM employees WHERE employeeid=%s"
,
033.
GetSQLValueString(
$_GET
[
'empid'
],
"int"
));
034.
mysql_select_db(
$database_dbconn
,
$dbconn
);
035.
$Result1
= mysql_query(
$deleteSQL
,
$dbconn
)
or
die
(mysql_error());
036.
$deleteGoTo
=
"employees.php"
;
037.
if
(isset(
$_SERVER
[
'QUERY_STRING'
])) {
038.
$deleteGoTo
.= (
strpos
(
$deleteGoTo
,
'?'
)) ?
"&"
:
"?"
;
039.
$deleteGoTo
.=
$_SERVER
[
'QUERY_STRING'
];
040.
}
041.
header(sprintf(
"Location: %s"
,
$deleteGoTo
));
042.
}
043.
$colname_Recordset1
=
"-1"
;
044.
if
(isset(
$_GET
[
'empid'
])) {
045.
$colname_Recordset1
=
$_GET
[
'empid'
];
046.
}
047.
mysql_select_db(
$database_dbconn
,
$dbconn
);
048.
$query_Recordset1
= sprintf(
"SELECT * FROM employees WHERE employeeid = %s"
, GetSQLValueString(
$colname_Recordset1
,
"int"
));
049.
$Recordset1
= mysql_query(
$query_Recordset1
,
$dbconn
)
or
die
(mysql_error());
050.
$row_Recordset1
= mysql_fetch_assoc(
$Recordset1
);
051.
$totalRows_Recordset1
= mysql_num_rows(
$Recordset1
);
052.
?>
055.
<head>
056.
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=windows-874"
/>
057.
<!-- InstanceBeginEditable name=
"doctitle"
-->
058.
<title>index.php</title>
059.
<!-- InstanceEndEditable -->
060.
<!-- InstanceBeginEditable name=
"head"
-->
061.
<style type=
"text/css"
>
062.
#form1 p {
063.
font-size: small;
064.
}
065.
#form1 table {
066.
font-size: small;
067.
}
068.
#fmdelete table tr td {
069.
font-size: small;
070.
}
071.
#fmdelete p {
072.
font-size: small;
073.
}
074.
.ห {
075.
font-size: small;
076.
}
077.
</style>
078.
<!-- InstanceEndEditable -->
079.
<style type=
"text/css"
>
080.
.style1 {
081.
font-size: small;
082.
color: #009;
083.
}
084.
.style {
085.
font-size: small;
086.
color: #00F;
087.
}
088.
.style {
089.
font-size: small;
090.
}
091.
.style11 {
092.
font-size: small;
093.
color: #000;
094.
}
095.
.style {
096.
color: #000;
097.
}
098.
</style>
099.
</head>
100.
<body>
101.
<table width=
"1000"
border=
"0"
align=
"center"
>
102.
<tr>
103.
<td><img src=
"../image/1259920035yx1.jpg"
width=
"100%"
height=
"125"
/></td>
104.
</tr>
105.
<tr>
106.
<td bgcolor=
"#FF99CC"
> </td>
107.
</tr>
108.
<tr>
109.
<td><table width=
"100%"
border=
"0"
>
110.
<tr>
111.
<td><table width=
"104%"
border=
"0"
>
112.
<tr valign=
"top"
>
113.
<td width=
"21%"
><table width=
"100%"
border=
"0"
>
114.
<tr valign=
"top"
>
115.
<td colspan=
"2"
bgcolor=
"#FFCC00"
><span
class
=
"style1"
>ระบบข้อมูลพนักงาน</span></td>
116.
</tr>
117.
<tr>
118.
<td width=
"13%"
bgcolor=
"#FFCC00"
><img src=
"../image/View.png"
width=
"20"
height=
"20"
/></td>
119.
<td width=
"87%"
bgcolor=
"#FFCC00"
><a
class
=
"style"
>เรียกดูข้อมูลพนักงาน</a></td>
120.
</tr>
121.
<tr>
122.
<td bgcolor=
"#FFCC00"
><img src=
"../image/Add.png"
width=
"20"
height=
"20"
/></td>
123.
<td bgcolor=
"#FFCC00"
><a
class
=
"style"
>เพิ่มข้อมูลพนักงาน</a></td>
124.
</tr>
125.
<tr>
126.
<td bgcolor=
"#FFCC00"
><img src=
"../image/Lock.png"
width=
"20"
height=
"20"
/></td>
127.
<td bgcolor=
"#FFCC00"
><span
class
=
"style11"
>แก้ไขข้อมูลพนักงาน</span></td>
128.
</tr>
129.
<tr>
130.
<td bgcolor=
"#FFCC00"
> </td>
131.
<td bgcolor=
"#FFCC00"
> </td>
132.
</tr>
133.
<tr>
134.
<td bgcolor=
"#FFCC00"
> </td>
135.
<td bgcolor=
"#FFCC00"
> </td>
136.
</tr>
137.
<tr>
138.
<td bgcolor=
"#FFCC00"
> </td>
139.
<td bgcolor=
"#FFCC00"
> </td>
140.
</tr>
141.
<tr>
142.
<td bgcolor=
"#FFCC00"
> </td>
143.
<td bgcolor=
"#FFCC00"
> </td>
144.
</tr>
145.
<tr>
146.
<td bgcolor=
"#FFCC00"
> </td>
147.
<td bgcolor=
"#FFCC00"
> </td>
148.
</tr>
149.
<tr>
150.
<td bgcolor=
"#FFCC00"
> </td>
151.
<td bgcolor=
"#FFCC00"
> </td>
152.
</tr>
153.
<tr>
154.
<td bgcolor=
"#FFCC00"
> </td>
155.
<td bgcolor=
"#FFCC00"
> </td>
156.
</tr>
157.
<tr>
158.
<td bgcolor=
"#FFCC00"
> </td>
159.
<td bgcolor=
"#FFCC00"
> </td>
160.
</tr>
161.
<tr>
162.
<td bgcolor=
"#FFCC00"
> </td>
163.
<td bgcolor=
"#FFCC00"
> </td>
164.
</tr>
165.
<tr>
166.
<td bgcolor=
"#FFCC00"
> </td>
167.
<td bgcolor=
"#FFCC00"
> </td>
168.
</tr>
169.
<tr>
170.
<td bgcolor=
"#FFCC00"
> </td>
171.
<td bgcolor=
"#FFCC00"
> </td>
172.
</tr>
173.
<tr>
174.
<td bgcolor=
"#FFCC00"
> </td>
175.
<td bgcolor=
"#FFCC00"
> </td>
176.
</tr>
177.
<tr>
178.
<td bgcolor=
"#FFCC00"
> </td>
179.
<td bgcolor=
"#FFCC00"
> </td>
180.
</tr>
181.
<tr>
182.
<td bgcolor=
"#FFCC00"
> </td>
183.
<td bgcolor=
"#FFCC00"
> </td>
184.
</tr>
185.
<tr>
186.
<td bgcolor=
"#FFCC00"
> </td>
187.
<td bgcolor=
"#FFCC00"
> </td>
188.
</tr>
189.
<tr>
190.
<td bgcolor=
"#FFCC00"
> </td>
191.
<td bgcolor=
"#FFCC00"
> </td>
192.
</tr>
193.
<tr>
194.
<td bgcolor=
"#FFCC00"
> </td>
195.
<td bgcolor=
"#FFCC00"
> </td>
196.
</tr>
197.
<tr>
198.
<td bgcolor=
"#FFCC00"
> </td>
199.
<td bgcolor=
"#FFCC00"
> </td>
200.
</tr>
201.
<tr>
202.
<td bgcolor=
"#FFCC00"
> </td>
203.
<td bgcolor=
"#FFCC00"
> </td>
204.
</tr>
205.
<tr>
206.
<td bgcolor=
"#FFCC00"
> </td>
207.
<td bgcolor=
"#FFCC00"
> </td>
208.
</tr>
209.
<tr>
210.
<td bgcolor=
"#FFCC00"
> </td>
211.
<td bgcolor=
"#FFCC00"
> </td>
212.
</tr>
213.
<tr>
214.
<td bgcolor=
"#FFCC00"
> </td>
215.
<td bgcolor=
"#FFCC00"
> </td>
216.
</tr>
217.
</table></td>
218.
<td width=
"79%"
><!-- InstanceBeginEditable name=
"EditRegion1"
-->
219.
<form id=
"fmdelete"
name=
"fmdelete"
method=
"post"
action=
"delete_emp1.php?emp=<?php echo $row_Recordset1['employeeid']; ?>"
>
220.
<p> </p>
221.
<table width=
"100%"
border=
"0"
>
222.
<tr>
223.
<td width=
"31%"
>รหัส</td>
224.
<td width=
"69%"
><label
for
=
"employeeid"
>
225.
<input name=
"employeeid"
type=
"text"
id=
"employeeid"
value=
"<?php echo $row_Recordset1['employeeid']; ?>"
size=
"30"
maxlength=
"30"
/>
226.
</label></td>
227.
</tr>
228.
<tr>
229.
<td>ชื่อ</td>
230.
<td><label
for
=
"firstname"
></label>
231.
<input name=
"firstname"
type=
"text"
id=
"firstname"
value=
"<?php echo $row_Recordset1['firstname']; ?>"
size=
"30"
maxlength=
"30"
/></td>
232.
</tr>
233.
<tr>
234.
<td>นามสกุล</td>
235.
<td><label
for
=
"lastname"
></label>
236.
<input name=
"lastname"
type=
"text"
id=
"lastname"
value=
"<?php echo $row_Recordset1['lastname']; ?>"
size=
"30"
maxlength=
"30"
/></td>
237.
</tr>
238.
</table>
239.
<p>ต้องการจะลบข้อมูลเร็คคอร์ดนี้จริงหรือไม่?</p>
240.
<p>
241.
<input type=
"submit"
name=
"Submit"
id=
"bntSubmit"
value=
"ตกลง"
/>
242.
<input type=
"reset"
name=
"Reset"
id=
"bntReset"
value=
"ยกเลิก"
/>
243.
</p>
244.
</form>
245.
<p
class
=
"ห"
><a href=
"employees.php"
>[กลับสู่หน้าหลัก]</a></p>
246.
<!-- InstanceEndEditable --></td>
247.
</tr>
248.
</table></td>
249.
</tr>
250.
</table></td>
251.
</tr>
252.
<tr>
253.
<td bgcolor=
"#99FF00"
> </td>
254.
</tr>
255.
</table>
256.
</body>
257.
<!-- InstanceEnd --></html>
258.
<?php
259.
mysql_free_result(
$Recordset1
);
260.
?>