Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\test1\coffeeshop\admin\addproduct.php on line 32
Code (PHP) addproduct.php
<?
include "../include/connectiondb.php";
include "checksession.php";
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>เพิ่มข้อมูลเครื่องดื่ม</title>
</head>
<body>
<?
$page=$_GET[page];
if ($page==" ") {
$page=1;
}
$each=15;
$sql_item = "SELECT * FROM product ";
$result_item = mysql_query($sql_item);
$totals = mysql_num_rows($result_item);
$totalpages=ceil($totals/$each);
$goto = ($page-1)*$each;
$sql_item = "SELECT * FROM product ORDER BY item_id DESC limit $goto,$each";
$result_item = mysql_query($sql_item);
$sql="SELECT max(itemid) AS maxitemid FROM product";
$result=mysql_db_query($dbname,$sql);
$dbarr=mysql_fetch_array($result);
if ($dbarr) {
$total=$dbarr['maxitemid']+1;
if (strlen($total)=="1") {
$total= "0" .$total;
} else {
$total=$total;
}
} else {
$total =$item_id ;
}
?>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr bgcolor="#FFCC99">
<td colspan="2" bgcolor="#FF9900"><strong>:: เพิ่มข้อมูลเครื่องดื่ม ::</strong></td>
</tr>
<tr>
<td align="right">รหัสเครื่องดื่ม</td>
<td><? echo $total; ?></td>
</tr>
<tr>
<td align="right">ชนิดเครื่องดื่ม</td>
<td>
<select name="ref_type_id">
<option value="0">กรุณาเลือกชนิดเครื่องดื่ม</option>
<?
$sql_type="SELECT * FROM type";
$result_type = mysql_query($sql_type);
while($dbarr_type=mysql_fetch_array($result_type)) {
echo "<option value=" . $dbarr_type['type_id'] . ">" . $dbarr_type ['type_name'] . "</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td align="right">ประเภทเครื่องดื่ม</td>
<td>
<select name="ref_cat_id">
<option value="0">กรุณาเลือกประเภทเครื่องดื่ม</option>
<?
$sql="SELECT * FROM category";
$result = mysql_query($sql);
while($dbarr_cat=mysql_fetch_array($result)) {
echo "<option value=" . $dbarr_cat['cat_id'] . ">" . $dbarr_cat['cat_name'] . "</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td align="right">ชื่อเครื่องดื่ม</td>
<td><input maxlength="50" name="item_name"></td>
</tr>
<tr>
<td align="right">รายละเอียด</td>
<td><textarea name="detail" cols="40" rows="4"></textarea></td>
</tr>
<tr>
<td align="right">ราคา/หน่วย</td>
<td><input maxlength="50" name="item_price" size="8"> บาท</td>
</tr>
<tr>
<td align="right">ไฟล์รูปภาพ</td>
<td><input type="file" name="photo"><input type="hidden" name="MAX_FILE_SIZE" value="100000"></td>
</tr>
<tr>
<td colspan="2" align="right">
<div align="center">
<input type="submit"name="submit" value="บันทึก" >
<input type="reset" name="reset" value="ยกเลิก">
<input type="hidden" name="item_no" value="<? echo $total; ?>">
</div></td>
</tr>
</table>
</form>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr bgcolor="#FFCC99">
<td bgcolor="#FF9900"><div align="center"><strong>ลำดับที่</strong></div></td>
<td bgcolor="#FF9900"><div align="center"><strong>รายการ</strong></div></td>
<td bgcolor="#FF9900"><div align="center"><strong>ชนิด</strong></div></td>
<td bgcolor="#FF9900"><div align="center"><strong>แก้ไข</strong></div></td>
<td bgcolor="#FF9900"><div align="center"><strong>ลบ</strong></div></td>
</tr>
<?
while ($dbarr = mysql_fetch_array($result)) {
?>
<tr>
<td align="center" width="10%"><? echo $dbarr_item['item_id']; ?></td>
<td><? echo $dbarr_item['item_name']; ?></td>
<td>
<?
$sql1="SELECT * FROM type WHERE type_id='$dbarr_item[ref_type_id]' ";
$result1 = mysql_query($sql1);
$dbarr1=mysql_fetch_array($result1);
echo $dbarr1['type_name'];
?>
</td>
<td align="center" width="15%">[<a href="product_action.php?do=frmedit&id=<? echo $dbarr_item['item_id']; ?>">แก้ไข</a>]</td>
<td align="center" width="15%">[<a href="product_action.php?do=delete&id=<? echo $dbarr_item['item_id']; ?>">ลบ</a>]</td>
</tr>
<?
}
?>
<tr>
<td align="center"></td>
<td colspan="4" align="right">รวมทั้งหมด <? echo $totals?> รายการ :
<?
if ($totalpages>1) {
for ($i=1;$i<=$totalpages;$i++) {
if ($i == $page) {
echo "<b>หน้า $page</b>";
} else {
echo " | <a href=\"addproduct.php&page=$i\">$i</a> ";
}
}
}
?>
</td>
</tr>
</table>
</body>
</html>
Code (PHP) product_action.php
<?
include "../include/connection.php";
if ($_REQUEST['do']=="add") {
$item_id=$_POST['item_no'];
$type_id=$_POST['ref_type_id'];
$cat_id=$_POST['ref_cat_id'];
$tname=$_POST['item_name'];
$detail=$_POST['detail'];
$price=number_format($_POST['itemprice'],2,'.',' ');
if (($item_id=="") or ($tname=="") or ($type_id=="" ) or ($cat_id=="")) {
echo "คุณใส่ข้อมูลไม่ครบ";
} else {
$photo=$_FILES['photo']['tmp_name'];
$photo_name=$_FILES['photo']['name'];
$photo_size=$_FILES['photo']['size'];
$photo_type=$_FILES['photo']['type'];
if ($photo=="") {
$sql_add="INSERT INTO product (item_id, item_name, unitprice, ref_cat_id, ref_type_id, detail, picture) Values ('$item_id','$tname', '$price', '$cat_id', '$type_id', '1', '$detail', '')";
$result_add=mysql_query($sql_add);
echo "บันทึกข้อมูลเรียบร้อยแล้ว";
echo "<meta http-equive='refresh' content='1;url=addproduct.php'>";
} else {
$array_last=explode(".", $photo_name);
$c=count($array_last)-1;
$lastname=strtolower($array_last[$c]);
if ($lastname=="gif" or $lastname=="jpg" or $lastname=="jpeg") {
$set_photo=explode(".", $photo_name);
$pname="item_" .$_POST['item_no'];
$plname=$set_photo[1];
$photoname=$pname ."." .$plname;
copy ($photo, "../images/item/" .$photoname);
$sql_add="INSERT INTO product (item_id, item_name, unitprice, ref_cat_id, ref_type_id, status, detail, picture) VALUES ('$item_id','$tname', '$price', '$cat_id', '$type_id', '1', '$detail', '$photoname')";
$result_add=mysql_query($sql_add);
echo "บันทึกข้อมูลเรียบร้อยแล้ว";
echo "<meta http-equiv='refresh' content='1;url=addproduct.php'>";
} else {
echo "<h3>ERROR : ไม่สามารถบันทึกไฟล์รูปภาพได้ (ต้องเป็น .jpg, .gif เท่านั้น)</h3>";
echo "<meta http-equiv='refresh' content='1;url=addproduct.php'>";
}
unlink ($photo);
}
}
}
include "../include/closedb.php";
?>
Tag PHP, MySQL
Date :
2012-02-15 14:33:36By :
yuiiView :
1668Reply :
2
มันหาค่าของ $dbname ไม่เจอรึป่าวคะ
Date :
2012-02-15 14:39:59By :
teukkead
SELECT max(item_
Date :
2012-02-15 14:49:41By :
ikikkok
Server 03
Load balance : Server 03
