001.
<?
include
"connDB.php"
; ?>
002.
<?
include
"uName.php"
; ?>
003.
<?
004.
if
(
$submit
==
"OK"
){
005.
006.
if
(
$id1
==
""
){
007.
include
"connDB.php"
;
008.
$strSQL
=
"SELECT * FROM computer WHERE ID_com = '"
.
$_POST
[
"ID_com"
].
"' "
;
009.
$objQuery
= mysql_query(
$strSQL
);
010.
$objResult
= mysql_fetch_array(
$objQuery
);
011.
if
(
$objResult
)
012.
{
013.
?>
014.
<script> alert(
"รหัสคอมพิวเตอร์ซ้ำ"
);
015.
window.location=
"computer.php?submit=Add&show="
;
016.
</script>
017.
<?
018.
}
019.
if
(
$id1
==
""
){
020.
$sql
=
"INSERT INTO computer set ID_com='"
.
$ID_com
.
"',name_com='"
.
$name_com
.
"',User='"
.
$User
.
"',ID_Dep='"
.
$ID_Dep
.
"',CPU='"
.
$CPU
.
"',Mainborad='"
.
$Mainborad
.
"',Ram='"
.
$Ram
.
"',HDD='"
.
$HDD
.
"',VGA='"
.
$VGA
.
"',Moniter='"
.
$Moniter
.
"',Mouse='"
.
$Mouse
.
"',Keyboard='"
.
$Keyboard
.
"',Date='"
.
$Date
.
"'"
;
021.
?>
022.
<script> alert(
"บันทึกข้อมูลเรียบร้อยแล้ว"
);
023.
window.location=
"computer.php"
;
024.
</script>
025.
<?
026.
027.
}}
028.
else
{
029.
$sql
=
"UPDATE computer set ID_com='"
.
$ID_com
.
"',name_com='"
.
$name_com
.
"',User='"
.
$User
.
"',ID_Dep='"
.
$ID_Dep
.
"',CPU='"
.
$CPU
.
"',Mainborad='"
.
$Mainborad
.
"',Ram='"
.
$Ram
.
"',HDD='"
.
$HDD
.
"',VGA='"
.
$VGA
.
"',Moniter='"
.
$Moniter
.
"',Mouse='"
.
$Mouse
.
"',Keyboard='"
.
$Keyboard
.
"',Date='"
.
$Date
.
"'WHERE ID_com='"
.
$id1
.
"'"
;
030.
031.
?>
032.
<script> alert(
"แก้ไขข้อมูลเรียบร้อยแล้ว"
);
033.
window.location=
"computer.php"
;
034.
history.go(-1);
035.
036.
</script>
037.
<?
038.
}
039.
mysql_query(
$sql
);
040.
}
041.
if
(
$submit
==
"DEL"
){
042.
$sql
=
"delete from computer where ID_com ='"
.
$id1
.
"'"
;
043.
mysql_query(
$sql
);
044.
}
045.
?>
046.
<script language=
"JavaScript"
>
047.
function
chkdel(){
048.
if
(confirm(
' กรุณายืนยันการลบอีกครั้ง !! '
)){
049.
return
true;
050.
}
else
{
051.
return
false;
052.
}
053.
}
054.
055.
function
Check_txt()
056.
057.
{
058.
if
(document.getElementById(
'ID_com'
).value==
""
){
059.
alert(
"กรุณาระบุ รหัส ด้วยค่ะ"
);
060.
document.getElementById(
'ID_com'
).focus();
061.
return
false;
062.
}
063.
if
(document.getElementById(
'name_com'
).value==
""
){
064.
alert(
"กรุณาระบุ ชื่อเครื่อง ด้วยค่ะ"
);
065.
document.getElementById(
'name_com'
).focus();
066.
return
false;
067.
}
068.
if
(document.getElementById(
'ID_Dep'
).value==
"000"
){
069.
alert(
"กรุณาระบุ แผนก ด้วยค่ะ"
);
070.
document.getElementById(
'ID_Dep'
).focus();
071.
return
false;
072.
}
073.
if
(document.getElementById(
'Date'
).value==
""
){
074.
alert(
"กรุณาระบุ วันที่รับเครื่อง ด้วยค่ะ"
);
075.
document.getElementById(
'Date'
).focus();
076.
return
false;
077.
}
078.
}
079.
function
isEmail(str) {
080.
var
supported = 0;
081.
if
(window.RegExp) {
082.
var
tempStr =
'a'
;
083.
var
tempReg =
new
RegExp(tempStr);
084.
if
(tempReg.test(tempStr)) supported = 1;
085.
}
086.
if
(!supported)
087.
return
(str.indexOf(
'.'
) > 2) && (str.indexOf(
'@'
) > 0);
088.
var
r1 =
new
RegExp(
'(@.*@)|(\\.\\.)|(@\\.)|(^\\.)'
);
089.
var
r2 =
new
RegExp(
'^.+\\@(\\[?)[a-zA-Z0-9\\-\\.]+\\.([a-zA-Z]{2,3}|[0-9]{1,3})(\\]?)$'
);
090.
return
(!r1.test(str) && r2.test(str));
091.
}
092.
093.
</script><head>
094.
<meta http-equiv=Content-Type content=
"text/html; charset=utf-8"
>
095.
096.
<title>::::DATA Computer Winner.in.th ::::</title>
097.
<link href=
"style/style.css"
rel=
"stylesheet"
type=
"text/css"
/>
098.
<style type=
"text/css"
>
099.
<!--
100.
.style1 {color: #FF0000}
101.
.style4 {font-size: 16; font-weight: bold; }
102.
a:link {
103.
color: #0000FF;
104.
text-decoration: none;
105.
}
106.
a:visited {
107.
color: #0000FF;
108.
text-decoration: none;
109.
}
110.
a:hover {
111.
color: #FF0000;
112.
text-decoration: none;
113.
}
114.
a:active {
115.
color: #0033CC;
116.
text-decoration: none;
117.
}
118.
.style6 {font-size: 16px; font-weight: bold; }
119.
#container #header #header_main .style4 a {
120.
font-size: 16px;
121.
font-style: normal;
122.
color: #FFFFFF;
123.
}
124.
#Layer1 {
125.
position:absolute;
126.
left:1030px;
127.
top:51px;
128.
width:61px;
129.
height:24px;
130.
z-index:1;
131.
}
132.
body {
133.
background-image: url(image/BG001.png);
134.
}
135.
#Layer2 {
136.
position:absolute;
137.
left:1008px;
138.
top:94px;
139.
width:54px;
140.
height:25px;
141.
z-index:2;
142.
}
143.
.style7 {
144.
color: #FF0000;
145.
font-size: 16px;
146.
font-weight: bold;
147.
}
148.
-->
149.
</style>
150.
<style type=
"text/css"
>
151.
<!--
152.
#miniflex {
153.
width: 71%;
154.
float: left;
155.
font-size: small;
156.
margin: 20 0 0 150px;
157.
padding: 0 10px 0 10px;
158.
border-bottom: 1px solid #0099FF;
159.
position:relative;
160.
z-index:2;
161.
}
162.
163.
#miniflex li {
164.
float: left;
165.
margin: 0;
166.
padding: 0;
167.
display: inline;
168.
list-style: none;
169.
position:relative;
170.
}
171.
172.
#miniflex a:link, #miniflex a:visited {
173.
float: left;
174.
font-size: 85%;
175.
line-height: 20px;
176.
font-weight: bold;
177.
margin: 0 10px 0 10px;
178.
text-decoration: none;
179.
color: #0033CC;
180.
}
181.
182.
#miniflex a.active:link, #miniflex a.active:visited, #miniflex a:hover {
183.
border-bottom: 4px solid #696;
184.
padding-bottom: 2px;
185.
color: #0099FF;
186.
}
187.
188.
#animated-tab {
189.
position: absolute;
190.
z-index: 1;
191.
font-size: 85%;
192.
line-height: 20px;
193.
padding-bottom: 2px;
194.
border-bottom: 4px solid #0099FF;
195.
}
196.
.style9 {color: #0000FF}
197.
.style10 {font-weight: bold}
198.
#Layer3 {
199.
position:absolute;
200.
left:1030px;
201.
top:96px;
202.
width:62px;
203.
height:26px;
204.
z-index:3;
205.
}
206.
.style11 {
207.
color: #000000;
208.
font-weight: bold;
209.
}
210.
#Layer4 {
211.
position:absolute;
212.
left:17px;
213.
top:142px;
214.
width:236px;
215.
height:306px;
216.
z-index:4;
217.
}
218.
#Layer5 {
219.
position:absolute;
220.
left:1px;
221.
top:142px;
222.
width:172px;
223.
height:282px;
224.
z-index:4;
225.
}
226.
#Layer6 {
227.
position:absolute;
228.
left:5px;
229.
top:219px;
230.
width:240px;
231.
height:27px;
232.
z-index:4;
233.
}
234.
-->
235.
</style><script type=
"text/javascript"
>
236.
<!--
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
var
miniTab = {
274.
currentTab: 0,
275.
activeTab: 0,
276.
destX: 0,
277.
destW: 0,
278.
t: 0,
279.
b: 0,
280.
c: 0,
281.
d: 20,
282.
animInterval: null,
283.
sliderObj: null,
284.
aHeight: 0,
285.
286.
init:
function
() {
287.
if
(!document.getElementById || !document.getElementById(
"miniflex"
))
return
;
288.
289.
var
ul = document.getElementById(
"miniflex"
);
290.
var
liArr = ul.getElementsByTagName(
"li"
);
291.
var
aArr = ul.getElementsByTagName(
"a"
);
292.
293.
for
(
var
i = 0, li; li = liArr[i]; i++) {
294.
liArr[i].onmouseover = aArr[i].onfocus =
function
(e) {
295.
var
pos = 0;
296.
var
elem = this.nodeName ==
"LI"
? this : this.parentNode;
297.
while
(elem.previousSibling) {
298.
elem = elem.previousSibling;
299.
if
(elem.tagName && elem.tagName ==
"LI"
) pos++;
300.
}
301.
miniTab.initSlide(pos);
302.
}
303.
}
304.
305.
ul.onmouseout =
function
(e) {
306.
miniTab.initSlide(miniTab.currentTab);
307.
};
308.
309.
for
(
var
i = 0; i < aArr.length; i++) {
310.
if
(document.location.href.indexOf(aArr[i].href)>=0) {
311.
miniTab.activeTab = miniTab.currentTab = i;
312.
}
313.
aArr[i].style.borderBottom =
"0px"
;
314.
aArr[i].style.paddingBottom =
"6px"
;
315.
}
316.
317.
miniTab.slideObj = ul.parentNode.appendChild(document.createElement(
"div"
));
318.
miniTab.slideObj.appendChild(document.createTextNode(String.fromCharCode(160)));
319.
miniTab.slideObj.id =
"animated-tab"
;
320.
miniTab.slideObj.style.top = (ul.offsetTop + liArr[miniTab.activeTab].offsetTop + aArr[miniTab.activeTab].offsetTop) +
"px"
;
321.
miniTab.slideObj.style.left = (ul.offsetLeft + + liArr[miniTab.activeTab].offsetLeft + aArr[miniTab.activeTab].offsetLeft) +
"px"
;
322.
miniTab.slideObj.style.width = aArr[miniTab.activeTab].offsetWidth +
"px"
;
323.
miniTab.aHeight = ul.offsetTop + liArr[miniTab.activeTab].offsetTop + aArr[miniTab.activeTab].offsetTop;
324.
325.
miniTab.initSlide(miniTab.activeTab, true);
326.
327.
var
intervalMethod =
function
() { miniTab.slideIt(); }
328.
miniTab.animInterval = setInterval(intervalMethod,10);
329.
},
330.
331.
cleanUp:
function
() {
332.
clearInterval(miniTab.animInterval);
333.
miniTab.animInterval = null;
334.
},
335.
336.
initSlide:
function
(pos, force) {
337.
if
(!force && pos == miniTab.activeTab)
return
;
338.
miniTab.activeTab = pos;
339.
miniTab.initAnim();
340.
},
341.
342.
initAnim:
function
() {
343.
var
ul = document.getElementById(
"miniflex"
);
344.
var
liArr = ul.getElementsByTagName(
"li"
);
345.
var
aArr = ul.getElementsByTagName(
"a"
);
346.
miniTab.destX = parseInt(liArr[miniTab.activeTab].offsetLeft + liArr[miniTab.activeTab].getElementsByTagName(
"a"
)[0].offsetLeft + ul.offsetLeft);
347.
miniTab.destW = parseInt(liArr[miniTab.activeTab].getElementsByTagName(
"a"
)[0].offsetWidth);
348.
miniTab.t = 0;
349.
miniTab.b = miniTab.slideObj.offsetLeft;
350.
miniTab.c = miniTab.destX - miniTab.b;
351.
miniTab.bW = miniTab.slideObj.offsetWidth;
352.
miniTab.cW = miniTab.destW - miniTab.bW;
353.
miniTab.slideObj.style.top = (ul.offsetTop + liArr[miniTab.activeTab].offsetTop + aArr[miniTab.activeTab].offsetTop) +
"px"
;
354.
},
355.
356.
slideIt:
function
() {
357.
var
ul = document.getElementById(
"miniflex"
);
358.
var
liArr = ul.getElementsByTagName(
"li"
);
359.
var
aArr = ul.getElementsByTagName(
"a"
);
360.
361.
362.
if
(miniTab.aHeight != ul.offsetTop + liArr[miniTab.activeTab].offsetTop + aArr[miniTab.activeTab].offsetTop) {
363.
miniTab.initAnim();
364.
miniTab.aHeight = ul.offsetTop + liArr[miniTab.activeTab].offsetTop + aArr[miniTab.activeTab].offsetTop
365.
};
366.
367.
if
(miniTab.t++ < miniTab.d) {
368.
var
x = miniTab.animate(miniTab.t,miniTab.b,miniTab.c,miniTab.d);
369.
var
w = miniTab.animate(miniTab.t,miniTab.bW,miniTab.cW,miniTab.d);
370.
miniTab.slideObj.style.left = parseInt(x) +
"px"
;
371.
miniTab.slideObj.style.width = parseInt(w) +
"px"
;
372.
}
else
{
373.
miniTab.slideObj.style.left = miniTab.destX +
"px"
;
374.
miniTab.slideObj.style.width = miniTab.destW +
"px"
;
375.
}
376.
},
377.
378.
animate:
function
(t,b,c,d) {
379.
if
((t/=d/2) < 1)
return
c/2*t*t + b;
380.
return
-c/2 * ((--t)*(t-2) - 1) + b;
381.
}
382.
}
383.
384.
window.onload = miniTab.init;
385.
window.onunload = miniTab.cleanUp;
386.
387.
</script>
388.
389.
</head>
390.
<script type=
'text/javascript'
language=
'javascript'
src=
'date_time/prototype-1.js'
></script>
391.
<script type=
'text/javascript'
language=
'javascript'
src=
'date_time/prototype-date-extensions.js'
></script>
392.
<script type=
'text/javascript'
language=
'javascript'
src=
'date_time/behaviour.js'
></script>
393.
<script type=
'text/javascript'
language=
'javascript'
src=
'date_time/datepicker.js'
></script>
394.
<script type=
'text/javascript'
language=
'javascript'
src=
'date_time/behaviors.js'
></script>
395.
<link rel=
'stylesheet'
href=
'date_time/datepicker.css'
>
396.
<body>
397.
398.
<div id=
"Layer1"
>
399.
<form name=
"form2"
method=
"post"
action=
"logout.php"
>
400.
<label></label>
401.
<input name=
"Logout"
type=
"submit"
id=
"Logout"
value=
"Logout"
>
402.
</form>
403.
</div>
404.
<div id=
"Layer3"
>
405.
<div align=
"center"
class
=
"style11"
><a href=
"file_upload/spsetup120.exe"
>Speccy</a></div>
406.
</div>
407.
408.
<div id=
"Layer6"
>
409.
<table width=
"230"
border=
"1"
align=
"center"
bgcolor=
"#FFFFFF"
class
=
"style4"
>
410.
<tr>
411.
<td><?
include
(
"typelist.php"
);
412.
</tr>
413.
</table>
414.
</div>
415.
<center>
416.
<div id=
"container"
>
417.
<div id=
"header"
>
418.
<div id=
"header_left"
></div>
419.
<div id=
"header_main"
><span
class
=
"style4"
><a href=
"computer.php"
>ระบบจัดการข้อมูล computer Winner.in.th </a></span></div>
420.
<div id=
"header_right"
></div>
421.
</div>
422.
<div id=
"content"
>
423.
<table width=
"775"
border=
"0"
>
424.
<tr>
425.
<td><ul id=
"miniflex"
>
426.
<li><a
class
=
"active"
href=
"computer.php"
>ระบบคอมพิวเตอร์</a></li>
427.
<li><a href=
"computer.php?submit=Add&show="
>เพิ่มคอมพิวเตอร์</a></li>
428.
<li><a href=
"repair.php"
>ระบบซ่อมคอมพิวเตอร์</a></li>
429.
<li><a href=
"device.php"
>ระบบPrinter</a></li>
430.
<li><a href=
"Department.php"
>ระบบแผนก</a></li>
431.
432.
</ul></td>
433.
</tr>
434.
</table>
435.
<p><br>
436.
437.
<?
if
(
$submit
==
""
or
$show
==
"OK"
){?>
438.
</p>
439.
<center><form name=
"form1"
method=
"post"
action=
"computer.php?show=OK&strSearch=Y"
; >
440.
<table width=
"98%"
>
441.
<tr>
442.
<td width=
"50%"
><div align=
"right"
>ค้นหา :<select name=
"Search2"
>
443.
<option value=
"ID_com"
<?
if
(
$Search2
==
"ID_com"
){ ?>selected<? }?>>รหัส</option>
444.
<option value=
"name_com"
<?
if
(
$Search2
==
"name_com"
){ ?>selected<? }?>>ชื่อเครื่อง</option>
445.
<option value=
"User"
<?
if
(
$Search2
==
"User"
){ ?>selected<? }?>>User</option>
446.
<option value=
"ID_Dep"
<?
if
(
$Search2
==
"ID_Dep"
){ ?>selected<? }?>>แผนก</option>
447.
<option value=
"Date"
<?
if
(
$Search2
==
"Date"
){ ?>selected<? }?>>วันที่รับเครื่อง</option>
448.
</select></div></td>
449.
<td width=
"64%"
><div align=
"left"
>
450.
<input name=
"Search"
type=
"text"
size=
"20"
value=
"<? echo $Search?>"
onFocus=
"this.value = '';"
>
451.
<input type=
"submit"
name=
"submit"
value=
"Search"
>
452.
</div></td>
453.
<div id=
"hint"
></div>
454.
</tr>
455.
</table>
456.
</form>
457.
</center>
458.
<?
459.
if
(!isset(
$start
)){
460.
$start
= 0;
461.
$page
=1;
462.
}
463.
$limit
=
'15'
;
464.
465.
if
(
$strSearch
==
"Y"
){
466.
$Qtotal
= mysql_query(
"select * from computer Where "
.
$Search2
.
" like '%"
.
$Search
.
"%' "
);
467.
}
else
{
468.
$Qtotal
= mysql_query(
"select * from computer"
);
469.
}
470.
$total
= mysql_num_rows(
$Qtotal
);
471.
if
(
$strSearch
==
"Y"
){
472.
$Query
= mysql_query(
"select * from computer Where "
.
$Search2
.
" like '%"
.
$Search
.
"%' order by ID_com ASC LIMIT $start,$limit"
);
473.
}
else
{
474.
$Query
= mysql_query(
"select * from computer order by ID_com ASC LIMIT $start,$limit"
);
475.
}
476.
477.
$totalp
= mysql_num_rows(
$Query
);
478.
$xx
=
$totalp
+
$start
;
479.
$yy
=
$start
+1;
480.
echo
"ข้อมูลที่ "
.
$yy
.
" ถึงข้อมูลที่ "
.
$xx
;
481.
printf(
" | จากทั้งหมด %d รายการ "
,
$total
);
482.
printf(
" | หน้าที่ %d <br />"
,
$page
);
483.
?><br>
484.
<span
class
=
"style4"
><a href=
"computer.php?submit=Add&show="
></a></span><br>
485.
486.
<table width=
"99%"
>
487.
<tr bgcolor=
"#999999"
height=
'40'
>
488.
<td width=
"9%"
align=
'center'
bgcolor=
"#CCCCCC"
><span
class
=
"style6"
>รหัส </span></td>
489.
<td width=
"15%"
align=
'center'
bgcolor=
"#CCCCCC"
><span
class
=
"style6"
>ชื่อเครื่อง </span></td>
490.
<td width=
"16%"
align=
'center'
bgcolor=
"#CCCCCC"
><div align=
"center"
><strong>User</strong></div></td>
491.
<td width=
"22%"
align=
'center'
bgcolor=
"#CCCCCC"
><span
class
=
"style6"
>แผนก</span></td>
492.
<td width=
"14%"
align=
'center'
bgcolor=
"#CCCCCC"
><span
class
=
"style6"
>วันที่รับเครื่อง </span></td>
493.
<td width=
"9%"
bgcolor=
"#CCCCCC"
class
=
"style6"
><div align=
"center"
>ซ่อม</div></td>
494.
<td width=
"7%"
bgcolor=
"#CCCCCC"
class
=
"style6"
><div align=
"center"
>ลบ</div></td>
495.
<td width=
"8%"
bgcolor=
"#CCCCCC"
class
=
"style6"
><div align=
"center"
>แก้ไข</div></td>
496.
</tr>
497.
<?
498.
while
(
$arr
= mysql_fetch_array(
$Query
)){
499.
$autoid
=
$arr
[
'ID_com'
];
500.
$autoid2
=
$arr
[
'name_com'
];
501.
$i
++;
502.
if
(
$i
%2==0){
503.
$bg
=
"#FFFFFF"
;
504.
}
else
{
505.
$bg
=
"#FFFFFF"
;
506.
}
507.
?>
508.
<tr bgcolor=
"<? echo $bg?>"
onMouseOver=
"this.style.backgroundColor='#CCFFCC'"
onMouseOut=
"this.style.backgroundColor=''"
valign=
"top"
>
509.
<td align=
'center'
><div align=
"center"
><?
echo
$arr
[
'ID_com'
] ?>
510.
</div><div align=
"left"
></div></td>
511.
<td align=
'center'
><div align=
"center"
><?
echo
$arr
[
'name_com'
] ?></div></td>
512.
<td align=
'center'
><div align=
"center"
><?
echo
$arr
[
'User'
] ?></div></td>
513.
<td align=
'center'
><div align=
"center"
>
514.
<?
515.
$rstTemp
=mysql_query(
'select * from department where ID_Dep='
.
$arr
[ID_Dep].
' '
);
516.
while
(
$arr_2
=mysql_fetch_array(
$rstTemp
)){
517.
?>
518.
<option value=
"<?=$arr_2['ID_Dep']?>"
<?
if
(
$row3
[
"ID_Dep"
]==
$arr_2
[
'ID_Dep'
])
echo
'selected'
; ?>>
519.
<?=
$arr_2
[
'Department'
]?>
520.
</option>
521.
<? }?>
522.
</div></td>
523.
<td align=
'center'
><div align=
"center"
><?
echo
$arr
[
'Date'
] ?></div></td>
524.
525.
<td align=
"center"
><div align=
"center"
><a href=
"repair2.php?&id1=<? echo $autoid;?>&name_com=<? echo $autoid2 ?>"
><img src=
"style/images/config_32.png"
width=
"30"
height=
"30"
border=
"0"
></a></div></td>
526.
<td align=
"center"
><div align=
"center"
><a href=
"computer.php?submit=DEL&show=OK&id1=<? echo $autoid;?>"
onClick=
"return chkdel();"
><img src=
"style/images/delete.png"
width=
"30"
height=
"30"
border=
"0"
></a></div></td>
527.
<td align=
"center"
><div align=
"center"
><a href=
"computer.php?submit=Edit&id1=<? echo $autoid;?>"
></a><a href=
"computer.php?submit=Edit&id1=<? echo $autoid;?>"
><img src=
"style/images/edit.png"
width=
"25"
height=
"25"
border=
"0"
></a></div></td>
528.
</tr>
529.
<? }?>
530.
</table>
531.
532.
<p>
533.
<? }?>
534.
535.
<br>
536.
<?
if
(
$submit
==
"Add"
){?>
537.
</p>
538.
<hr />
539.
<strong
class
=
"style6 style7 style10 style9"
>เพิ่มคอมพิวเตอร์</strong><br>
540.
<hr /> </p>
541.
<form action=
"computer.php?submit=OK&show=OK&id1="
method=
"post"
onSubmit=
"return Check_txt()"
enctype=
'multipart/form-data'
>
542.
<table width=
"98%"
>
543.
<tr>
544.
<td width=
'30%'
align=
'right'
><div align=
"right"
>รหัส : </div></td>
545.
<td width=
'70%'
><div align=
"left"
>
546.
<input name=
'ID_com'
id=
'ID_com'
type=
'text'
size=
'20'
>
547.
<span
class
=
"style1"
>*</span> </div></td>
548.
</tr>
549.
<tr>
550.
<td width=
'30%'
align=
'right'
><div align=
"right"
>ชื่อเครื่อง : </div></td>
551.
<td width=
'70%'
><div align=
"left"
>
552.
<input name=
'name_com'
id=
'name_com'
type=
'text'
size=
'20'
>
553.
<span
class
=
"style1"
>* </span></div></td>
554.
</tr>
555.
<tr>
556.
<td align=
'right'
><div align=
"right"
>ผู้ใช้</div></td>
557.
<td><div align=
"left"
>
558.
<input name=
'User'
id=
'User'
type=
'text'
size=
'20'
>
559.
</div></td>
560.
</tr>
561.
<tr>
562.
<td align=
'right'
><div align=
"right"
>แผนก : </div></td>
563.
<td><div align=
"left"
><span
class
=
"style1"
>
564.
<select name=
'ID_Dep'
id=
'ID_Dep'
>
565.
<option value=
"000"
>--- เลือกแผนก----</option>
566.
<?
567.
$rstTemp
=mysql_query(
'select * from department order by ID_Dep ASC LIMIT 0,100 '
);
568.
while
(
$arr_2
=mysql_fetch_array(
$rstTemp
)){
569.
?>
570.
<option value=
"<?=$arr_2['ID_Dep']?>"
>
571.
<?=
$arr_2
[
'Department'
]?>
572.
</option>
573.
<? }?>
574.
</select>
575.
*</span></div></td>
576.
</tr>
577.
<tr>
578.
<td width=
'30%'
align=
'right'
><div align=
"right"
>CPU : </div></td>
579.
<td width=
'70%'
><div align=
"left"
>
580.
<input name=
'CPU'
id=
'CPU'
type=
'text'
size=
'50'
>
581.
582.
</div></td>
583.
</tr>
584.
<tr>
585.
<td width=
'30%'
align=
'right'
><div align=
"right"
>Mainborad : </div></td>
586.
<td width=
'70%'
><div align=
"left"
>
587.
<input name=
'Mainborad'
id=
'Mainborad'
type=
'text'
size=
'50'
>
588.
</div></td>
589.
</tr>
590.
<tr>
591.
<td width=
'30%'
align=
'right'
><div align=
"right"
>Ram : </div></td>
592.
<td width=
'70%'
><div align=
"left"
>
593.
<input name=
'Ram'
id=
'Ram'
type=
'text'
size=
'50'
>
594.
</div></td>
595.
</tr>
596.
<tr>
597.
<td width=
'30%'
align=
'right'
><div align=
"right"
>HDD : </div></td>
598.
<td width=
'70%'
><div align=
"left"
>
599.
<input name=
'HDD'
id=
'HDD'
type=
'text'
size=
'50'
>
600.
</div></td>
601.
</tr>
602.
<tr>
603.
<td width=
'30%'
align=
'right'
><div align=
"right"
>VGA : </div></td>
604.
<td width=
'70%'
><div align=
"left"
>
605.
<input name=
'VGA'
id=
'VGA'
type=
'text'
size=
'50'
>
606.
</div></td>
607.
</tr>
608.
<tr>
609.
<td width=
'30%'
align=
'right'
><div align=
"right"
>Moniter : </div></td>
610.
<td width=
'70%'
><div align=
"left"
>
611.
<input name=
'Moniter'
id=
'Moniter'
type=
'text'
size=
'50'
>
612.
</div></td>
613.
</tr>
614.
<tr>
615.
<td width=
'30%'
align=
'right'
><div align=
"right"
>Mouse : </div></td>
616.
<td width=
'70% '
><div align=
"left"
>
617.
<input name=
'Mouse'
id=
'Mouse'
type=
'text'
size=
'50'
>
618.
</div></td>
619.
</tr>
620.
<tr>
621.
<td width=
'30%'
align=
'right'
><div align=
"right"
>Keyboard : </div></td>
622.
<td width=
'70%'
><div align=
"left"
>
623.
<input name=
'Keyboard'
id=
'Keyboard'
type=
'text'
size=
'50'
>
624.
</div></td>
625.
</tr>
626.
<tr>
627.
<td width=
'30%'
align=
'right'
><div align=
"right"
>วันที่รับเครื่อง : </div></td>
628.
<td width=
'70%'
><div align=
"left"
>
629.
<input name=
'Date'
class
=
'datepicker'
id=
'Date'
size=
"20"
>
630.
<a href=
"javascript:displayDatePicker('txtEditstartDate')"
></a><span
class
=
"style1"
>* </span></div></td>
631.
</tr>
632.
<tr height=
'50'
>
633.
<td></td>
634.
<td align=
'left'
valign=
'middle'
><input type=
'submit'
name=
'Submit'
value=
' บันทึก '
> <input type=
'reset'
name=
'Submit2'
value=
'ล้างข้อมูล'
> <input type=
'button'
name=
'Submit222'
value=
' กลับ '
onClick=
"document.location.href='computer.php?show=OK'"
></td>
635.
</tr>
636.
</table>
637.
</form>
638.
<p>
639.
<? }?>
640.
<?
if
(
$submit
==
"Edit"
){
641.
$sql
=
"select * from computer where ID_com ='"
.
$id1
.
"' "
;
642.
$tem
= mysql_query(
$sql
);
643.
$row3
=mysql_fetch_array(
$tem
);
644.
?>
645.
</p>
646.
<form action=
"computer.php?submit=OK&show=OK&id1=<? echo $id1?>"
method=
"post"
onSubmit=
"return Check_txt();"
enctype=
'multipart/form-data'
>
647.
<hr />
648.
<strong
class
=
"style6 style7 style10 style9"
>แก้ไขคอมพิวเตอร์</strong><br>
649.
<hr /> <br>
650.
<input type=
'hidden'
name=
'ID_com'
value=
"<?=$row3['ID_com']?>"
>
651.
<table width=
"98%"
>
652.
<tr>
653.
<td width=
'30%'
align=
'right'
><div align=
"right"
>รหัส : </div></td>
654.
<td width=
'70%'
><div align=
"left"
>
655.
<input name=
'ID_com'
id=
'ID_com'
type=
'text'
size=
'20'
value=
'<?=$row3["ID_com"]?>'
>
656.
<span
class
=
"style1"
>* </span></div></td>
657.
</tr>
658.
<tr>
659.
<td width=
'30%'
align=
'right'
><div align=
"right"
>ชื่อเครื่อง : </div></td>
660.
<td width=
'70%'
><div align=
"left"
>
661.
<input name=
'name_com'
id=
'name_com'
type=
'text'
size=
'20'
value=
'<?=$row3["name_com"]?>'
>
662.
<span
class
=
"style1"
></span></div></td>
663.
</tr>
664.
<tr>
665.
<td align=
'right'
><div align=
"right"
>ชื่อผู้ใช้</div></td>
666.
<td><div align=
"left"
>
667.
<input name=
'User'
id=
'User'
type=
'text'
size=
'20'
value=
'<?=$row3["User"]?>'
>
668.
</div></td>
669.
</tr>
670.
<tr>
671.
<td align=
'right'
><div align=
"right"
>แผนก : </div></td>
672.
<td><div align=
"left"
><span
class
=
"style1"
>
673.
<select name=
'ID_Dep'
id=
'ID_Dep'
>
674.
<?
675.
$rstTemp
=mysql_query(
'select * from department order by ID_Dep ASC LIMIT 0,34'
);
676.
while
(
$arr_2
=mysql_fetch_array(
$rstTemp
)){
677.
?>
678.
<option value=
"<?=$arr_2['ID_Dep']?>"
<?
if
(
$row3
[
"ID_Dep"
]==
$arr_2
[
'ID_Dep'
])
echo
'selected'
; ?>>
679.
<?=
$arr_2
[
'Department'
]?>
680.
</option>
681.
<? }?>
682.
</select>
683.
* </span></div></td>
684.
</tr>
685.
<tr>
686.
<td width=
'30%'
align=
'right'
><div align=
"right"
>CPU : </div></td>
687.
<td width=
'70%'
><div align=
"left"
>
688.
<input name=
'CPU'
type=
'text'
id=
'CPU'
value=
'<?=$row3["CPU"]?>'
size=
'50'
>
689.
</div></td>
690.
</tr>
691.
<tr>
692.
<td width=
'30%'
align=
'right'
><div align=
"right"
>Mainborad : </div></td>
693.
<td width=
'70%'
><div align=
"left"
>
694.
<input name=
'Mainborad'
id=
'Mainborad'
type=
'text'
size=
'50'
value=
'<?=$row3["Mainborad"]?>'
>
695.
</div></td>
696.
</tr>
697.
<tr>
698.
<td width=
'30%'
align=
'right'
><div align=
"right"
>Ram : </div></td>
699.
<td width=
'70%'
><div align=
"left"
>
700.
<input name=
'Ram'
id=
'Ram'
type=
'text'
size=
'50'
value=
'<?=$row3["Ram"]?>'
>
701.
</div></td>
702.
</tr>
703.
<tr>
704.
<td width=
'30%'
align=
'right'
><div align=
"right"
>HDD : </div></td>
705.
<td width=
'70%'
><div align=
"left"
>
706.
<input name=
'HDD'
id=
'HDD'
type=
'text'
size=
'50'
value=
'<?=$row3["HDD"]?>'
>
707.
</div></td>
708.
</tr>
709.
<tr>
710.
<td width=
'30%'
align=
'right'
><div align=
"right"
>VGA : </div></td>
711.
<td width=
'70%'
><div align=
"left"
>
712.
<input name=
'VGA'
id=
'VGA'
type=
'text'
size=
'50'
value=
'<?=$row3["VGA"]?>'
>
713.
</div></td>
714.
</tr>
715.
<tr>
716.
<td width=
'30%'
align=
'right'
><div align=
"right"
>Moniter : </div></td>
717.
<td width=
'70%'
><div align=
"left"
>
718.
<input name=
'Moniter'
id=
'Moniter'
type=
'text'
size=
'50'
value=
'<?=$row3["Moniter"]?>'
>
719.
</div></td>
720.
</tr>
721.
<tr>
722.
<td width=
'30%'
align=
'right'
><div align=
"right"
>Mouse : </div></td>
723.
<td width=
'70%'
><div align=
"left"
>
724.
<input name=
'Mouse'
id=
'Mouse'
type=
'text'
size=
'50'
value=
'<?=$row3["Mouse"]?>'
>
725.
</div></td>
726.
</tr>
727.
<tr>
728.
<td align=
'right'
><div align=
"right"
>Keyboard : </div></td>
729.
<td><div align=
"left"
>
730.
<input name=
'Keyboard'
id=
'Keyboard'
type=
'text'
size=
'50'
value=
'<?=$row3["Keyboard"]?>'
>
731.
</div></td>
732.
</tr>
733.
<tr>
734.
<td align=
'right'
><div align=
"right"
>วันที่รับเครื่อง : </div></td>
735.
<td><div align=
"left"
>
736.
<input name=
'Date'
class
=
'datepicker'
id=
'Date'
value=
'<?=$row3["Date"]?>'
size=
"20"
>
737.
<span
class
=
"style1"
>* </span></div></td>
738.
</tr>
739.
<tr height=
"50"
>
740.
<td height=
"38"
></td>
741.
<td>
742.
<div align=
"left"
>
743.
<input type=
"submit"
name=
"Submit"
value=
" บันทึก "
>
744.
<input type=
"button"
name=
"Submit222"
value=
" ยกเลิก "
onClick=
"JavaScript:history.go(-1);"
onClick=
"document.location.href='computer.php?show=OK'"
/>
745.
</div></td></tr>
746.
</table>
747.
<p>
748.
<? }?>
749.
</p>
750.
</form>
751.
<br>
752.
<br>
753.
</div>
754.
<div id=
"footer"
>
755.
<p><br>
756.
<?
if
(
$submit
==
""
or
$show
==
"OK"
){
757.
$page
=
ceil
(
$total
/
$limit
);
758.
for
(
$i
=1;
$i
<=
$page
;
$i
++){
759.
if
(
$_GET
[
'page'
]==
$i
){
760.
echo
"[<a href='?start="
.
$limit
*(
$i
-1).
"&page=$i&strSearch=$strSearch&Search=$Search&Search2=$Search2'><B>หน้า $i</B></A>]"
;
761.
}
else
{
762.
echo
"[<a href='?start="
.
$limit
*(
$i
-1).
"&page=$i&strSearch=$strSearch&Search=$Search&Search2=$Search2'> หน้า $i</A>]"
;
763.
}}} ?>
764.
</p>
765.
</div>
766.
</div>
767.
</center>
768.
</body>