|
 |
| |
รบกวนด้วยนะค่ะ อีกนิดเดียว รบกวนช่วยดูให้หน่อนะค่ะ ติดมา 2 วันแว้วอ่า ม่ายเข้าใจว่าทำไม่เวลาแก้ไขมันไม่ save |
| |
 |
|
|
 |
 |
|
รบกวนช่วยดูให้หน่อนะค่ะ ติดมา 2 วันแว้วอ่า ม่ายเข้าใจว่าทำไม่เวลาแก้ไขมันไม่ save ลงฐานข้อมูล งง มากมาย
อันนี้รูปตอนเรียกข้อมูลมาโชว์หน้าแก้ไข
อันนี้รูปหน้า Report
/////////////////////////////////////////////////////////////report.php
<style type="text/css">
<!--
body {
background-color: #CCCCCC;
}
.style2 {
font-size: 14px;
font-weight: bold;
}
-->
</style>
<div align="center">
<p align="right" class="style2">[ <a href="addstatus.php">เพิ่มบิลขายใหม่</a> ]</p>
</div>
<?
include "function.php";
include "connect.php";
$no=1;
$sql="select * from alai order by id_status desc";
$result=mysql_db_query($dbname, $sql);
$sqlquery=mysql_db_query($dbname,$sql);
echo "
<center><h3>รายงานบิลขาย</h3>
<h4>จำนวนรายการบิลขาย มีทั้งหมด ".mysql_num_rows($sqlquery)." รายการ</h4></center>
<center><table width='80%' border='0'>
<tr bgcolor='#000000'>
<td width='2%'><center><b><font color='#FFFFFF' font size='2' face='MS Sans Serif'> ลำดับ</font></b></center></td>
<td width='4%'><center><b><font color='#FFFFFF'font size='2' face='MS Sans Serif'>วันที่</font></b></center></td>
<td width='5%'><center><b><font color='#FFFFFF'font size='2' face='MS Sans Serif'>เลขที่บิล</font></b></center></td>
<td width='5%'><center><b><font color='#FFFFFF'font size='2' face='MS Sans Serif'>หมายเลขสมาชิก</font></b></center></td>
<td width='3%'><center><b><font color='#FFFFFF'font size='2' face='MS Sans Serif'>จำนวน</font></b></center></td>
<td width='5%'><center><b><font color='#FFFFFF'font size='2' face='MS Sans Serif'>ชื่อผู้เปิดบิลขาย</font></b></center></td>
<td width='5%'><center><b><font color='#FFFFFF'font size='2' face='MS Sans Serif'>ชื่อผู้หยิบ</font></b></center></td>
<td width='5%'><center><b><font color='#FFFFFF'font size='2' face='MS Sans Serif'>สถานะบิล</font></b></center></td>
<td width='5%'><center><b><font color='#FFFFFF'font size='2' face='MS Sans Serif'>หมายเหตุ</font></b></center></td>
<td width='3%'><center><b><font color='#FFFFFF'font size='2' face='MS Sans Serif'>ต้องการ</font></b></center></td>
</tr>";
while ($record=mysql_fetch_array($result)) {
$id_status=$record[id_status];
$po_status=$record[po_status];
$number_status=$record[number_status];
$count_status=$record[count_status];
$fname_status=$record[fname_status];
$name_status=$record[name_status];
$status=$record[status];
$memo=$record[memo];
$date_today=$record[date_today];
$date_today=htmlspecialchars($date_today);
$po_status=htmlspecialchars($po_status);
$number_status=htmlspecialchars($number_status);
$count_status=htmlspecialchars($count_status);
$fname_status=htmlspecialchars($fname_status);
$name_status=htmlspecialchars($name_status);
$status=htmlspecialchars($status);
$memo=htmlspecialchars($memo);
echo "
<tr bgcolor='#FFFFFF'>
<td width='2%' ><center><font size='2' face='MS Sane Serif'>$no</font></center></td>
<td width='4%' ><center><font size='2' face='MS Sane Serif'>$date_today</font></center></td>
<td width='5%' ><center><font size='2' face='MS Sane Serif'>$po_status</font></center></td>
<td width='5%' ><center><font size='2' face='MS Sane Serif'>$number_status</font></center></td>
<td width='3%' ><center><font size='2' face='MS Sane Serif'>$count_status</font></center></td>
<td width='5%' ><center><font size='2' face='MS Sane Serif'> $fnametype[$fname_status]</font></center></td>
<td width='5%' ><center><font size='2' face='MS Sane Serif'> $nametype[$name_status]</font></center></td>
<td width='5%' ><center><font size='2' face='MS Sane Serif'> $statustype[$status]</font></center></td>
<td width='5%' ><center><font size='2' face='MS Sane Serif'>$memo</font></center></td>
<td width='3%' ><center><font size='2' face='MS Sane Serif'><a href=\"editstatus.php?id_edit=$id_status\">[ Edit ]</a></font></center></td>
</tr>";
$no++;
}
echo "</table>";
?>
////////////////////////////////////////////////////////editstatus.php
<?
$id_edit=$_GET[id_edit];
include "function.php";
include "connect.php";
$sql="select * from alai where id_status='$id_edit'";
$result=mysql_db_query($dbname,$sql);
$r=mysql_fetch_array($result);
$id_status=$r[id_status];
$po_status=$r[po_status];
$number_status=$r[number_status];
$count_status=$r[count_status];
$fname_status=$r[fname_status];
$name_status=$r[name_status];
$status=$r[status];
$memo=$r[memo];
?>
<html>
<head><title>แก้ไขบิลขาย</title>
<style type="text/css">
<!--
.style1 {
font-size: 14px;
font-weight: bold;
}
.style3 {font-size: 14}
.style4 {
color: #FF0000;
font-weight: bold;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" /></head>
<body>
<h3 align="left"><span class="style1">[ <a href="report.php">กลับหน้ารายงาน</a> ]</span></h3>
<table width="800" border="0">
<tr>
<th bgcolor="#0000FF" scope="col"><div align="right"></div></th>
</tr>
</table>
<p align="left"><strong>แก้ไขบิลขาย</strong></p>
<table width="800" border="0">
<tr>
<th bgcolor="#0000FF" scope="col"><div align="right"></div></th>
</tr>
</table>
<form action="editstatus2.php" method="post" enctype="multipart/form-data">
<table bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<tr>
<td bgcolor="#FFFFFF"><div align="left"><strong><span class="style3">เลขที่บิล :</span></strong></div></td>
<td bgcolor="#FFFFFF"><div align="left"><span class="style3">
<input name="po_status" type="text" size="12" value="<?=$po_status?>" />
<span class="style4">* </span></span></div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="left"><strong><span class="style3">หมายเลขสมาชิก :</span></strong></div></td>
<td bgcolor="#FFFFFF"><div align="left"><span class="style3">
<input name="number_status" type="text" size="12" value="<?=$number_status?>" />
</span><span class="style4">*</span> </div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="left"><strong><span class="style3">จำนวนรายการอะไหล่ :</span></strong></div></td>
<td bgcolor="#FFFFFF"><div align="left"><span class="style3">
<input name="count_status" type="text" size="12" value="<?=$count_status?>" />
<strong>รายการ</strong> </span><span class="style4">*</span> </div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="left"><strong><span class="style3">ชื่อผู้เปิดบิลขาย :</span></strong></div></td>
<td bgcolor="#FFFFFF">
<div align="left"><span class="style3">
<select name="fname_status" >
<option value="0"> -- เลือก -- </option>
<?
for ($i=1;$i<=count($fnametype);$i++) {
if ($fname_status==$i) {
echo "<option value='$i' selected>
$fnametype[$i]</option>";
} else {
echo "<option value='$i' >$fnametype[$i]
</option>";
}
}
?>
</select>
</span><span class="style4">*</span> </div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="left"><strong><span class="style3">ชื่อผู้หยิบ :</span></strong></div></td>
<td bgcolor="#FFFFFF">
<div align="left"><span class="style3">
<select name="name_status" >
<option value="0"> -- เลือก -- </option>
<?
for ($i=1;$i<=count($nametype);$i++) {
if ($name_status==$i) {
echo "<option value='$i' selected>
$nametype[$i]</option>";
} else {
echo "<option value='$i' >$nametype[$i]
</option>";
}
}
?>
</select>
</span><span class="style4">*</span> </div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="left"><strong><span class="style3">ชื่อผู้เปิดบิลขาย :</span></strong></div></td>
<td bgcolor="#FFFFFF">
<div align="left"><span class="style3">
<select name="status" >
<option value="0"> -- เลือก -- </option>
<?
for ($i=1;$i<=count($statustype);$i++) {
if ($fname_status==$i) {
echo "<option value='$i' selected>
$statustype[$i]</option>";
} else {
echo "<option value='$i' >$statustype[$i]
</option>";
}
}
?>
</select>
</span><span class="style4">*</span> </div></td>
</tr>
<tr>
<td valign="top" bgcolor="#FFFFFF"><div align="left"><strong><span class="style3">หมายเหตุ :</span></strong></div></td>
<td bgcolor="#FFFFFF"><div align="left"><span class="style3">
<textarea name="memo" cols="35" rows="5"><?=$memo?>
</textarea>
</span><span class="style4"> *</span> </div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<div align="left">
<input name="id_edit" type="hidden" value="<?=id_edit?>" >
</div></td>
<td bgcolor="#FFFFFF">
<div align="left"><span class="style3">
<input type="Submit" value="Submit" >
<input type="Reset" value="Reset" >
</span></div></td>
</tr>
</table>
</form>
<div align="center" class="style1"></div>
</body>
</html>
///////////////////////////////////////////////////////////////////// editstaus2.php
<?
$po_status=$_POST[po_status];
$number_status=$_POST[number_status];
$count_status=$_POST[count_status];
$fname_status=$_POST[fname_status];
$name_status=$_POST[name_status];
$status=$_POST[status];
$memo=$_POST[memo];
include "connect.php";
$sql="update alai set po_status='$po_status',number_status='$number_status',count_status='$count_status',fname_status='$fnametype',name_status='$nametype',status='$statustype',memo='$memo' where id_status='id_edit' ";
$result=mysql_db_query($dbname,$sql);
if ($result) {
echo "<h3>แก้ไข บิลขายเรียบร้อยแล้วครับ</h3>";
echo "[ <a href=report.php>กลับหน้าหลัก</a> ] ";
} else {
echo "<h3>ไม่สามารถแก้ไขบิลขายได้</h3>";
}
mysql_close();
?>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2009-07-07 16:45:31 |
By :
memee |
View :
827 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ค่ะ ขอบคุณมากค่ะ ผ่านแว้วค่ะ
|
| |
|
|
| |
| Date :
2009-07-09 12:58:37 |
By :
memee |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 01
|
