|
 |
| |
ช่วยดูให้หน่อยค่ะ จะแก้ไขข้อมูลแต่มันไม่ยอมบันทึกสักที |
| |
 |
|
|
 |
 |
|
editproduct.php
Code (PHP)
<?
/*session_start();
if ($sess_adminid<>session_id()) {
header( "Location: adminlogin.php"); exit();
}*/
$name=$_GET[name_prd];
include "connect.php";
$sql="select * from product where name_prd='$name' ";
$result=mysql_db_query($dbname,$sql);
$rs=mysql_fetch_array($result);
$id_prd=$rs[id_prd];
$code=sprintf("%05d",$id_prd);
$name_prd=$rs[name_prd];
$detail_prd=$rs[detail_prd];
$ref_id_type=$rs[ref_id_type];
$price_prd=$rs[price_prd];
$photo_prd=$rs[photo_prd];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
background-color: #577712;
}
.style1 {
font-family: "Microsoft Sans Serif";
font-size: 16px;
}
-->
</style></head>
<body><? include('header.php'); ?>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top" bgcolor="#FFFFFF"><table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="200" align="left" valign="top"><? include('menu.php'); ?></td>
<td width="615" align="left" valign="top"><table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="200" valign="middle"><div align="center">
<form action="editproduct_ok.php" method="post" enctype="multipart/form-data">
<p align="center"><b>แก้ไขสินค้า</b></p>
<table width="551" border="0" align="left" cellpadding="0" cellspacing="1">
<tr>
<td width="180"><div align="left">ชื่อสินค้า</div></td>
<td width="368"><div align="left">
<input type="text" name="name" size="40" value="<?=$name_prd?>" />
<span class="style1">* </span></div></td>
</tr>
<tr>
<td><div align="left">ประเภทสินค้า</div></td>
<td><div align="left">
<select name="ref_id_type">
<?
$sql="select * from type";
$result=mysql_db_query($dbname,$sql);
while($rs=mysql_fetch_array($result)) {
$id_type=$rs[id_type];
$name_type=$rs[name_type];
if ($ref_id_type==$id_type) {
echo "<OPTION VALUE='$id_type' SELECTED>$name_type</OPTION>";
} else {
echo "<OPTION VALUE='$id_type' >$name_type</OPTION>";
}
}
?>
</select>
</div></td>
</tr>
<tr>
<td valign="top"><div align="left">รายละเอียด</div></td>
<td><div align="left">
<textarea name="detail" cols="33" rows="4"><?=$detail_prd?>
</textarea>
<span class="style1">* </span></div></td>
</tr>
<tr>
<td><div align="left">ราคา</div></td>
<td><div align="left">
<input type="text" name="price" size="10" value="<?=$price_prd?>" />
บาท * </div></td>
</tr>
<tr>
<td><div align="left">รูปภาพ</div></td>
<td><div align="left">
<?
if ($photo_prd<>"") {
echo "<INPUT TYPE='checkbox' NAME='chkdel' VALUE='1'> ลบรูปภาพ <BR>";
echo "<a href='picture/$photo_prd' target='_blank' ><IMG SRC='picture/$photo_prd' width='200' height='200' border='0''></a>";
} else {
echo "<INPUT TYPE='file' NAME='fileupload' >";
echo "<INPUT TYPE='hidden' name='MAX_FILE_SIZE' value='100000'>";
}
?>
</div></td>
</tr>
<tr>
<td><div align="left"></div></td>
<td><div align="left">
<input type="submit" name="Submit" value="ตกลง" />
<input type="reset" name="Submit2" value="ยกเลิก" />
<input name="name_edit" type="hidden" value="<?=$name_edit?>" />
<input name="photo_del" type="hidden" value="<?=$photo_prd?>" />
</div></td>
</tr>
</table>
<p align="justify"> </p>
</form>
<p> </p>
</div></td>
</tr>
</table></td>
</tr>
</table>
<? include('footer.php'); ?></td>
</tr>
</table>
</body>
</html>
editproduct_ok.php
Code (PHP)
<?
/*session_start();
if ($sess_adminid<>session_id()) {
header( "Location: adminlogin.php"); exit();
}*/
$name_edit=$_POST[name_edit];
$name=$_POST[name];
$ref_id_type=$_POST[ref_id_type];
$detail=$_POST[detail];
$price=$_POST[price];
$photo=$_POST[photo];
include "connect.php";
if(trim($_FILES["fileUpload"]["tmp_name"]) != "")
{
$images = $_FILES["fileUpload"]["tmp_name"];
$new_images = "Thumbnails_".$_FILES["fileUpload"]["name"];
copy($_FILES["fileUpload"]["tmp_name"],"picture/".$_FILES["fileUpload"]["name"]);
$width=70; //*** Fix Width & Heigh (Autu caculate) ***//
$size=GetimageSize($images);
$height=round($width*$size[1]/$size[0]);
$images_orig = ImageCreateFromJPEG($images);
$photoX = ImagesX($images_orig);
$photoY = ImagesY($images_orig);
$images_fin = ImageCreateTrueColor($width, $height);
ImageCopyResampled($images_fin, $images_orig, 0, 0, 0, 0, $width+1, $height+1, $photoX, $photoY);
ImageJPEG($images_fin,"picture/".$new_images);
ImageDestroy($images_orig);
ImageDestroy($images_fin);
}
if ($chkdel=="1") {
$sql3="update product set photo_prd='' where id_prd ='$name_edit' ";
$result3=mysql_db_query($dbname,$sql3);
unlink("picture/$photo_del");
}
if ($fileupload) {
$array_last=explode(".",$fileupload_name);
$c=count($array_last)-1;
$lastname=strtolower($array_last[$c]) ;
if ($lastname=="gif" or $lastname=="jpg" or $lastname=="jpeg") {
$photoname=$id_edit.".".$lastname;
copy($fileupload,"picture/".$photoname);
$sql3="update product set photo_prd='$photoname' where id_prd ='$name_edit' ";
$result3=mysql_db_query($dbname,$sql3);
}
unlink($fileupload);
}
$sql="update product set
name_prd='$name',
ref_id_type='$ref_id_type',
detail_prd='$detail',
price_prd='$price' where id_prd='$name_edit' ";
$result=mysql_db_query($dbname,$sql);
if ($result) {
//echo "<H3>á¡éä¢ ÊÔ¹¤éÒàÃÕºÃéÍÂáÅéÇ</H3>";
//echo "[ <A HREF=adminproduct.php>¡ÅѺ˹éÒËÅÑ¡</A> ] ";
echo "<meta http-equiv=\"refresh\" content=\"1; URL=adminproduct.php\">";
} else {
echo "<H3>ERROR : äÁèÊÒÁÒöá¡éä¢ÊÔ¹¤éÒä´é</H3>";
}
mysql_close();
?>
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2010-06-28 18:21:15 |
By :
ก้อย |
View :
702 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
echo sql3 ออกมาดูครับว่ามีไอดีติดมาไหม ถ้าไม่มีก็สร้าง <input name="id" type="hidden" values="<?=$id?>">ลงไปในฟอร์มครับ
|
| |
|
|
| |
| Date :
2010-06-28 18:43:53 |
By :
Dragons_first |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 03
|
