| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/CAR - Copy/ |
Upload File : |
<?php
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
?>
<?php
include("dbconfig.php");
if (!empty($del))
{
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$dquery="delete from pmlist where item_id = '$del' ";
$dresult=mysql_query($dquery);
if($dresult)
{
echo "<script language='JavaScript'>";
echo "alert('ลบ เรียบร้อยแล้ว');";
echo "</script>";
}
}
//--------
if ( $cmdSubmit == "Submit" )
{
if ( empty( $code ) )
{
echo "<script language='JavaScript'>";
echo "alert('ไม่ได้กรอกรหัส');";
echo "history.back(1);";
echo "</script>";
}
if ( empty( $des ) )
{
echo "<script language='JavaScript'>";
echo "alert('ไม่ได้กรอกรายละเอียด');";
echo "history.back(1);";
echo "</script>";
}
// ป้องกันการกรอกแท็ก HTML จากผู้ใช
$name = htmlspecialchars($name);
$place = htmlspecialchars($place);
$pwd = htmlspecialchars($pwd);
// ป้อนกันการเกิด error ของ sql เมื่อ user ป้อน เครื่องหมาย "-" และ '-'
$name = addslashes($name);
$place = addslashes($place);
$pwd = addslashes($pwd);
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql = "insert into pmlist (item_id, item_name) values ('$code','$des')";
$result = mysql_query($sql );
if (!$result)
{
echo("เก็บเข้าฐานข้อมูลไม่ได้" . mysql_error() );
exit;
}
else
{
echo "<script language='JavaScript'>";
echo "alert('บันทึกเพิ่มรายการเสร็จแล้ว');";
echo "</script>";
}
}
?>
<html>
<head>
<title>เพิ่มรายการ</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<LINK href="style.css" rel=stylesheet>
<script language="JavaScript1.2">
<!--
/*
Auto Maximize Window Script- By Nick Lowe (nicklowe@ukonline.co.uk)
*/
top.window.moveTo(0,0);
if (document.all) {
top.window.resizeTo(screen.availWidth,screen.availHeight);
}
else if (document.layersdocument.getElementById) {
if (top.window.outerHeight<screen.availHeighttop.window.outerWidth<screen.availWidth){
top.window.outerHeight = screen.availHeight;
top.window.outerWidth = screen.availWidth;
}
}
//-->
</script>
</head>
<body>
<TABLE height=82 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD style="BACKGROUND-COLOR: #f0f7ff" colSpan=2></TD>
</TR>
<TR bgColor=#c7d2e7>
<TD class=thwbold width="35%" height=25>
</TD>
<TD class=thsans vAlign=center align=right bgColor=#c7d1e7 height=25><A
href=""><IMG height=18
alt="" src="../images/youraccount.gif" width=18
align=absMiddle border=0></A> <A
href=""></A> <A
href=""><IMG height=18 alt=Help!
src="../images/q.gif" width=18 align=absMiddle border=0></A> <A href=""></A>
<IMG height=18
alt="" hspace=3 src="../images/cart.gif" width=18
align=absMiddle border=0><A
href=""></A> </TD>
</TR>
<TR>
<TD style="BACKGROUND-COLOR: black" colSpan=2></TD>
</TR>
<TR>
<TD style="BACKGROUND-COLOR: #f0f8ff" colSpan=2></TD>
</TR>
<TR vAlign=center bgColor=#216289>
<TD class=thwbold colSpan=2 height=21> <TABLE height="95%" cellSpacing=0 cellPadding=1 width="99%" align=center
border=0>
<TBODY>
<TR>
<TD width="10%" height="22"
align=middle><SPAN class=thsans2
id=n1><a href="index.php"><font color="#FFFFFF" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">หน้าแรก</font></a></SPAN></TD>
<TD
align=middle width="13%"><a href="pm_car_record.php"><font color="#FFFFFF" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">บันทึกซ่อมบำรุง</font></a></TD>
<TD
align=middle width="10%"> </TD>
<TD
align=middle width="10%"> </TD>
<TD
align=middle width="14%"><SPAN
class=thsans2 id=n5></SPAN></TD>
<TD
align=middle width="16%"> </TD>
<TD
align=middle width="20%"><A
class=no_de href=" "></A><SPAN
class=thsans2 id=n5></SPAN></TD>
<TD class=thtahomasmall
align=middle width="7%"> </TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD style="BACKGROUND-COLOR: black; heigth: 1"
colSpan=2></TD>
</TR>
</TBODY>
</TABLE>
<form name="form1" method="post" action="add_pm_item.php">
<TABLE cellSpacing=0 cellPadding=3 width="98%" align=center border=0>
<TBODY>
<TR>
<TD width="20%" height="126" vAlign=top> <STYLE type=text/css>A.dealer:hover {
COLOR: #0000ff; FONT-STYLE: normal; TEXT-DECORATION: underline
}
A.menu:link {
COLOR: #000000; FONT-STYLE: normal; TEXT-DECORATION: none
}
A.menu:visited {
COLOR: #000000; FONT-STYLE: normal; TEXT-DECORATION: none
}
A.menu:hover {
COLOR: #000000; FONT-STYLE: normal; TEXT-DECORATION: underline
}
</STYLE> <TABLE cellSpacing=0 cellPadding=3 width="98%" border=0>
<TBODY>
<TR>
<TD class=thtahomasmall bgColor=#c7d2e7><FONT
color=#000000><A
class=no_de href=" "><SPAN
class=thsans2 id=n5>คำแนะนำ</SPAN></A></FONT></TD>
</TR>
<TR>
<TD class=thtahomasmall
style="BORDER-RIGHT: #c7d2e7 1px solid; BORDER-TOP: #c7d2e7 1px solid; BORDER-LEFT: #c7d2e7 1px solid; BORDER-BOTTOM: #c7d2e7 1px solid"
bgColor=#f0f8ff height=21><BR>
» <A
href=" "><FONT
color=red></FONT></A>ควรเพิ่มรายการ ให้ครบถ้วน<BR></TD>
</TR>
</TBODY>
</TABLE> </TD>
<TD vAlign=top width="60%"> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width="100%" colSpan=2> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width="91%"><IMG height=15 src="picture/home.gif"
width=16 align=absMiddle border=0> <SPAN
class=sidenev><font color="black">เพิ่มรายการ กำหนดรหัส</font></SPAN></TD>
<TD width="9%" align=right><font color=#c7d2e7> </font>
<img
src="../images/maximize_button.gif"
name=open width=12 height="12" style="CURSOR: hand"> <img
src="picture/close_button.gif"
name=close width=12 height="12" style="CURSOR: hand"></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width="100%" border=0>
<TBODY>
<TR>
<TD
style="BACKGROUND-IMAGE: url(pointsmall.gif); BACKGROUND-REPEAT: repeat-x"></TD>
</TR>
</TBODY>
</TABLE>
<DIV class=thtahomasmall
style="PADDING-RIGHT: 2px; PADDING-LEFT: 2px; PADDING-BOTTOM: 2px; PADDING-TOP: 2px"
align=right> </DIV>
<DIV id=news_newyear
style="BORDER-RIGHT: #c7d2e7 1px solid; PADDING-RIGHT: 3px; BORDER-TOP: #c7d2e7 1px solid; PADDING-LEFT: 3px; MARGIN-BOTTOM: 3px; PADDING-BOTTOM: 3px; BORDER-LEFT: #c7d2e7 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: #c7d2e7 1px solid; BACKGROUND-COLOR: #f0f8ff">
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="14%">รหัส</td>
<td width="86%"> <font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<input name="code" type="text" id="pwd" size="5">
</font></td>
</tr>
<tr>
<td height="28">รายการ</td>
<td><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<input name="des" type="text" id="code" size="30">
</font> </td>
</tr>
<tr>
<td height="28"> </td>
<td> </td>
</tr>
<tr>
<td height="28"> </td>
<td><input name="cmdSubmit" type="submit" id="cmdSubmit" value="Submit">
</td>
</tr>
</table>
</DIV></TD>
</TR>
</TBODY>
</TABLE>
<BR> </TD>
</TR>
</TBODY>
</TABLE>
</form>
<TABLE cellSpacing=0 cellPadding=3 width="100%" border=0>
<TBODY>
<TR>
<TD class=thtahomasmall bgColor=#c7d2e7
height=5><FONT color=#000000> แสดงรายการทั้งหมด</FONT></TD>
</TR>
<TR>
<TD height="46"
bgColor=#f0f8ff class=thtahomasmall
style="BORDER-RIGHT: #c7d2e7 1px solid; BORDER-TOP: #c7d2e7 1px solid; BORDER-LEFT: #c7d2e7 1px solid; BORDER-BOTTOM: #c7d2e7 1px solid"><table width="75%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td width="9%" height="24" bgColor=#c7d2ff class=thtahomasmall><div align="left"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ลำดับที่</font></div></td>
<td width="10%" class=thtahomasmall bgColor=#c7d2ff><div align="left"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">รหัส</font></div></td>
<td width="64%" class=thtahomasmall bgColor=#c7d2ff><div align="left"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">รายการ</font></div></td>
<td width="17%" class=thtahomasmall bgColor=#c7d2ff><div align="center"><font size="2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"></font></font></div></td>
</tr>
<?php
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$ssql = " select * from pmlist order by item_id";
$rresult = mysql_query($ssql );
$i=0 ;
while ($object = mysql_fetch_object($rresult))
{
if ($i %2 == 0)
{
$bg = "FFFFFF";
}
else
{
$bg = "FFFFCC";
}
$code = $object ->item_id;
$des = $object ->item_name;
?>
<tr bgcolor="<? echo $bg ;?>">
<td height="26"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $i ; ?></font></td>
<td> <font size="3" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $code ;?>
</font></td>
<td> <font size="3" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $des ; ?>
</font></td>
<td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">|<a href="add_pm_item.php?code=<? echo $code ; ?>">
แก้ไข</a> | <? echo"<a href=\"javascript:;\" onClick=\"cf=confirm('คุณกำลังจะลบ $des ?');if (cf)window.location='add_pm_item.php?del=$code'; return false;\" style=\"font-size: 12px;\"> ลบ | </a>"; ?></font></div></td>
</tr>
<?php
$i =$i+1 ;
}
?>
</table>
</TD>
</TR>
</TBODY>
</TABLE>
</body>
</html>