设为首页收藏本站
B. Malaysia手机版

佳礼资讯网

 找回密码
 注册

ADVERTISEMENT

佳礼资讯网»论坛 › 电脑手机 › 系统，软件 › 已解决！！
返回列表 发新帖
查看: 1386|回复: 3

已解决！！

[复制链接]
uglyboy
发表于 1-6-2009 05:22 PM | 显示全部楼层 |阅读模式
想问下，为什么我会有这个error 的呢？？

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\zipper\update.php on line 349

我看了很久，我还是不知道自己错在哪里。


<?php
session_start();
//include "auth_admin.inc.php";
include "connection.php";
$getlist=$_GET['getlist'];

if (isset($_POST['submit']) && $_POST['submit'] == "Submit")
{
/* //---------------------------------------3 don't have-------------------------------------------
if ($_FILES['product_picture']['name'] == "" && $_FILES['product_file']['name'] == "" && $_FILES['product_demo']['name'] == "")
{
  $query = "update product set pname='".$_POST['product_name']."',pidesc='".$_POST['product_desc']."',pidetails='".$_POST['prod_details']."' where pid='".$_POST['productupdate']."'";
  $result = mysql_query($query);
  
  include "product.php";
}

//---------------------------------picture & file don't have-------------------------------------
else if ($_FILES['product_picture']['name'] == "" && $_FILES['product_file']['name'] == "")
{
  $uploaddir = 'upload_image/';
  $uploaddemo_path = $uploaddir . $_FILES['product_demo']['name'];
  
  echo "<pre>";
   if (move_uploaded_file($_FILES['product_demo']['tmp_name'],$uploaddemo_path))
   {
    // echo "Upload successfully !";
     //header("location:reg_success.php");
   }
   else
   {
     echo "Possible file upload attack! Here's some debugging info:\n";
     //print_r($_FILES);
   }
  echo "</pre>";
  
  $name21 = $_FILES['product_demo']['name'];
  $temp_add21 = 'upload_image/'.$name21;
  
  $address21 = $temp_add21;  
  
  $query = "update product set pname='".$_POST['product_name']."',pidesc='".$_POST['product_desc']."',pidetails='".$_POST['prod_details']."',pdemo='".$address21."' where pid='".$_POST['productupdate']."'";
  $result = mysql_query($query);
  
  include "product.php";
}

//----------------------------------picture & demo don't have-----------------------------------
else if ($_FILES['product_picture']['name'] == "" && $_FILES['product_demo']['name'] == "")
{
  $uploaddir = 'upload_image/';
  $uploadfile_path = $uploaddir . $_FILES['product_file']['name'];
  
  echo "<pre>";
   if (move_uploaded_file($_FILES['product_file']['tmp_name'],$uploadfile_path))
   {
    // echo "Upload successfully !";
     //header("location:reg_success.php");
   }
   else
   {
     echo "Possible file upload attack! Here's some debugging info:\n";
     //print_r($_FILES);
   }
  echo "</pre>";
  
  $name11 = $_FILES['product_file']['name'];
  
  $temp_add11 = 'upload_image/'.$name11;
  
  $address11 = $temp_add11;

  $query = "update product set pname='".$_POST['product_name']."',pidesc='".$_POST['product_desc']."',pidetails='".$_POST['prod_details']."',pfile='".$address11."' where pid='".$_POST['productupdate']."'";
  $result = mysql_query($query);

  include "product.php";
}

//---------------------------------file & demo don't have---------------------------------
else if ($_FILES['product_file']['name'] == "" && $_FILES['product_demo']['name'] == "")
{
  $uploaddir = 'upload_image/';
  $uploadfile = $uploaddir . $_FILES['product_picture']['name'];
  echo "<pre>";
   if (move_uploaded_file($_FILES['product_picture']['tmp_name'],$uploadfile))
   {
    // echo "Upload successfully !";
     //header("location:reg_success.php");
   }
   else
   {
     echo "Possible file upload attack! Here's some debugging info:\n";
     //print_r($_FILES);
   }
  echo "</pre>";  
  
  $name01 = $_FILES['product_picture']['name'];
  
  $temp_add01 = 'upload_image/'.$name01;
  
  $address01 = $temp_add01;

  $query = "update product set pname='".$_POST['product_name']."',pidesc='".$_POST['product_desc']."',pidetails='".$_POST['prod_details']."',piname='".$address01."' where pid='".$_POST['productupdate']."'";
  $result = mysql_query($query);

  include "product.php";
} */

//------------------------------------------picture------------------------------------------
  if ($_FILES['product_image']['name'] == "")
{
  $uploaddir = 'upload_images/';
  /*$uploadfile_path = $uploaddir . $_FILES['product_file']['name'];
  $uploaddemo_path = $uploaddir . $_FILES['product_demo']['name'];
//------------------------------------------------------------------------------------------------
  echo "<pre>";
   if (move_uploaded_file($_FILES['product_file']['tmp_name'],$uploadfile_path))
   {
    // echo "Upload successfully !";
     //header("location:reg_success.php");
   }
   else
   {
     echo "Possible file upload attack! Here's some debugging info:\n";
     //print_r($_FILES);
   }
  echo "</pre>";
//-----------------------------------

  echo "<pre>";
   if (move_uploaded_file($_FILES['product_demo']['tmp_name'],$uploaddemo_path))
   {
    // echo "Upload successfully !";
     //header("location:reg_success.php");
   }
   else
   {
     echo "Possible file upload attack! Here's some debugging info:\n";
     //print_r($_FILES);
   }
  echo "</pre>";
//-------------------------------------------------------------------------------------------------
  $name1 = $_FILES['product_file']['name'];
  $name2 = $_FILES['product_demo']['name'];
  
  $temp_add1 = 'upload_image/'.$name1;
  $temp_add2 = 'upload_image/'.$name2;
  
  $address1 = $temp_add1;
  $address2 = $temp_add2; */

  $query = "update product set product_name='".$_POST['product_name']."',product_type='".$_POST['product_type']."',product-size='".$_POST['product_size']."',product_vol='".$_POST['product_vol']."',prodcut_inner='".$_POST['product_inner']."' where product_code='".$_POST['productupdate']."'";
  $result = mysql_query($query);

  include "product.php";
}

/* //----------------------------------------------file-----------------------------------------
else if ($_FILES['product_file']['name'] == "")
{
  $uploaddir = 'upload_image/';
  $uploadfile = $uploaddir . $_FILES['product_picture']['name'];
  $uploaddemo_path = $uploaddir . $_FILES['product_demo']['name'];
//------------------------------------------------------------------------------------------------
  echo "<pre>";
   if (move_uploaded_file($_FILES['product_picture']['tmp_name'],$uploadfile))
   {
    // echo "Upload successfully !";
     //header("location:reg_success.php");
   }
   else
   {
     echo "Possible file upload attack! Here's some debugging info:\n";
     //print_r($_FILES);
   }
  echo "</pre>";
//-----------------------------------

  echo "<pre>";
   if (move_uploaded_file($_FILES['product_demo']['tmp_name'],$uploaddemo_path))
   {
    // echo "Upload successfully !";
     //header("location:reg_success.php");
   }
   else
   {
     echo "Possible file upload attack! Here's some debugging info:\n";
     //print_r($_FILES);
   }
  echo "</pre>";
//-------------------------------------------------------------------------------------------------
  $name = $_FILES['product_picture']['name'];
  $name2 = $_FILES['product_demo']['name'];
  
  $temp_add = 'upload_image/'.$name;
  $temp_add2 = 'upload_image/'.$name2;
  
  $address = $temp_add;
  $address2 = $temp_add2;

  $query = "update product set pname='".$_POST['product_name']."',pidesc='".$_POST['product_desc']."',pidetails='".$_POST['prod_details']."',piname='".$address."',pdemo='".$address2."' where pid='".$_POST['productupdate']."'";
  $result = mysql_query($query);

  include "product.php";
}

//---------------------------------------------demo------------------------------------------
else if ($_FILES['product_demo']['name'] == "")
{
  $uploaddir = 'upload_image/';
  $uploadfile = $uploaddir . $_FILES['product_picture']['name'];
  $uploadfile_path = $uploaddir . $_FILES['product_file']['name'];
//------------------------------------------------------------------------------------------------
  echo "<pre>";
   if (move_uploaded_file($_FILES['product_picture']['tmp_name'],$uploadfile))
   {
    // echo "Upload successfully !";
     //header("location:reg_success.php");
   }
   else
   {
     echo "Possible file upload attack! Here's some debugging info:\n";
     //print_r($_FILES);
   }
  echo "</pre>";
//-----------------------------------

  echo "<pre>";
   if (move_uploaded_file($_FILES['product_file']['tmp_name'],$uploadfile_path))
   {
    // echo "Upload successfully !";
     //header("location:reg_success.php");
   }
   else
   {
     echo "Possible file upload attack! Here's some debugging info:\n";
     //print_r($_FILES);
   }
  echo "</pre>";
//-------------------------------------------------------------------------------------------------
  $name = $_FILES['product_picture']['name'];
  $name1 = $_FILES['product_file']['name'];
  
  $temp_add = 'upload_image/'.$name;
  $temp_add1 = 'upload_image/'.$name1;
  
  $address = $temp_add;
  $address1 = $temp_add1;

  $query = "update product set pname='".$_POST['product_name']."',pidesc='".$_POST['product_desc']."',pidetails='".$_POST['prod_details']."',piname='".$address."',pfile='".$address1."' where pid='".$_POST['productupdate']."'";
  $result = mysql_query($query);

[ 本帖最后由 uglyboy 于 2-6-2009 05:26 PM 编辑 ]
回复

使用道具 举报


ADVERTISEMENT

uglyboy
 楼主| 发表于 1-6-2009 05:23 PM | 显示全部楼层
include "product.php";
} */

//-----------------------------------------3 have-----------------------------------------------
else
{
  $uploaddir = 'upload_images/';
  $uploadfile = $uploaddir . $_FILES['product_image']['name'];
  //$uploadfile_path = $uploaddir . $_FILES['product_file']['name'];
  //$uploaddemo_path = $uploaddir . $_FILES['product_demo']['name'];

//-------------------------------------picture--------------------------------------------------------
  echo "<pre>";
  if (move_uploaded_file($_FILES['product_image']['tmp_name'],$uploadfile))
  {
   // echo "Upload successfully !";
    //header("location:reg_success.php");
  }
  else
  {
    echo "Possible file upload attack! Here's some debugging info:\n";
   // print_r($_FILES);
  }
  echo "</pre>";
//---------------------------------------file---------------------------------------------------------
/* echo "<pre>";
  if (move_uploaded_file($_FILES['product_file']['tmp_name'],$uploadfile_path))
  {
   // echo "Upload successfully !";
    //header("location:reg_success.php");
  }
  else
  {
    echo "Possible file upload attack! Here's some debugging info:\n";
   // print_r($_FILES);
  }
  echo "</pre>";
//----------------------------------------demo--------------------------------------------------------
  echo "<pre>";
  if (move_uploaded_file($_FILES['product_demo']['tmp_name'],$uploaddemo_path))
  {
   // echo "Upload successfully !";
    //header("location:reg_success.php");
  }
  else
  {
    echo "Possible file upload attack! Here's some debugging info:\n";
   // print_r($_FILES);
  }
  echo "</pre>"; */
//----------------------------------------------------------------------------------------------------

  $name = $_FILES['product_image']['name'];
  //$name1 = $_FILES['product_file']['name'];
  //$name2 = $_FILES['product_demo']['name'];
  
  $temp_add = 'upload_images/'.$name;
  //$temp_add1 = 'upload_image/'.$name1;
  //$temp_add2 = 'upload_image/'.$name2;
  
  $address = $temp_add;
  //$address1 = $temp_add1;
  //$address2 = $temp_add2;
  
   $product_name = $_POST["product_name"];
   $cn = $_POST["product_type"];
   $product_size = $_POST["product_size"];
   $product_vol = $_POST["product_vol"];
   $product_inner = $_POST["product_inner"];
   //$product_image = $_POST["product_image"];
   $productupdate = $_POST["prodcutupdate"];
  
  $query = "update product SET product_name='$product_name', product_type='$cn', product_size='$product_size', product_vol='$product_vol',
            product_inner='$product_inner', product_image='$address' where product_code='".$_POST['productupdate']."'";
/* $query = "update product set product_name='".$_POST['product_name']."',product_type='".$_POST['product_type']."',product_size='".$_POST['product_size']."',product_vol='".$_POST['product_vol']."',product_inner='".$_POST['product_inner']."',product_image='".$address."' where product_code='".$_POST['productupdate']."'";
  $result = mysql_query($query);    */

  include "product.php";
}

}
else
{

require('connection.php');
$psql=("select * from product where product_code=$getlist") ;
$pquery=mysql_query($psql,$con);
$prshow=mysql_fetch_array($pquery);
$pshowdetails = $pshow['pidetails'];

$plistsql="select * from product";
$plistquery=mysql_query($plistsql);
$plistshow=mysql_num_rows($plistquery);
?>

<html>
<head>
<link rel="stylesheet" href="style.css" type="text/css">
<title>Administrator Area - Products & Services - Update</title>
<script language="JavaScript" type="text/javascript" src="scripts/wysiwyg.js"></script>
<script language="JavaScript" type="text/javascript" src="scripts/wysiwyg-settings.js"></script>
<script language="javascript" type="text/javascript">
var mysettings = new WYSIWYG.Settings();
mysettings.InvertIELineBreaks = true;
</script>
</head>

<body class="main">

<table width=760 height="100%" align="center" cellspacing="0" cellpadding="0" border="2" background="images/bg4.jpg">
<div>
<tr valign="middle">
   <td rowspan="2" align="center" width="200"><img src="images/Ologo.JPG"></td>
</tr>
<tr valign="middle"><td width="560" height="140" align="center" class="a2">Industrial Automation Solutions Sdn. Bhd.
   <p><b>Administrator Area </b></p></td>
</tr>
</div>
<div>
<tr valign="middle">
  <td colspan="2">
   <table width="100%" height="10%" border="1" background="images/bg4.jpg">
    <tr valign="middle">
      <td width="10%" align="center"><a href="home.php" class="a1">Home</a></td>
      <td width="11%" align="center"><a href="about.php" class="a1">About Us</a></td>
      <td width="12%" align="center"><a href="nande.php" class="a1">News & Events</a></td>
      <td width="14%" align="center">Products & <br>Services</td>
      <td width="12%" align="center"><a href="download.php" class="a1">Download Area</a></td>
      <td width="10%" align="center"><a href="pa_partner.php" class="a1">Partner</a></td>
      <td width="10%" align="center"><a href="cu_customer.php" class="a1">Customer</a></td>
      <td width="11%" align="center"><a href="contact.php" class="a1">Contact Us</a></td>
      <td width="10%" align="center"><a href="admin_logout.php" class="a1">Logout</a></td>
    </tr>
   </table>
  </div>
  <div>
      <tr>
     <td height="100%" background="images/bg4.jpg" colspan="6">
      <table width="100%" height="100%" border="1">
       <form enctype="multipart/form-data" name="update" method='post' action='update.php'>
       <tr valign='middle'>
         <td align='center' colspan='6'>
           <table width="753" border="0" cellspacing="2" cellpadding="2">
                                        <tr>
                                          <td>Product Name: </td>
                                          <td><input type='hidden' name='productupdate' value='<?php echo $pshow['product_code']; ?>'>
            <input type="text" size="30" name="product_name" value='<?php echo $pshow['product_name'] ?>'></td>
                                          
                                        </tr>
                                        <tr>
                                          <td>Product Type:</td>
                                          <td>
                                            <select name="product_type" id="product_type" value='<?php echo $prshow['product_type'] ?>'>
           <?
             $sql_command="Select * from product group by product_type;";
             $types=mysql_query($sql_command);
             while ($type=mysql_fetch_assoc($types))
             {
              $cn = $type['product_type'];
              //print "here".$cn;
              //$cloc = $CLUB['location'];
              echo "<option  value=\"$cn\">".$cn."</option>";

             }
           ?>
           </select>

                                          </td>
                                        </tr>
          <tr>
                                          <td>Product Size:</td>
                                          <td><input type="text" size="20" name="product_size" value='<?php echo $pshow['product_size'] ?>'></td>
                                        </tr>
                                        <tr>
                                          <td>Product vol:</td>
                                          <td><input type="text" size="20" name="product_vol" value='<?php echo $pshow['product_vol'] ?>'></td>
                                        </tr>      
         <tr>
         <td width = "123" valign ="top">Product Inner</td>
          <td>
          <input name="product_inner" type="text" id="product_inner" size="20" value='<?php echo $pshow['product_inner'] ?>'>
          </td>
            </tr>
         <td width = "123" valign ="top">Product Image</td>
          <td>
          <input type="file" size="50" name="product_image" >
          <img src='<?php echo $pshow['product_image']; ?>' width='30' height='30'>
          </td>
            </tr>  
         </table>
         
         </td>
         </tr>
         
        <tr valign='bottom'>
         <td align='center' colspan='6'>
         <input type='submit' name='submit' value='Submit'>
        </td>
           </tr>
      
       </form>

       <tr valign="bottom">
       <td align="center"><b>
        <a href="product.php">Product List</a>&nbsp;|&nbsp;<a href="insert.php">Add</a>&nbsp;|&nbsp;<font size="+1">Update</font>&nbsp;|&nbsp;<a href="delete.php">Delete</a>
        </b><br><br>
        Your have <?php echo "<font class='f'>".$plistshow."</font>"; ?> products in database.
       </td>
      </tr>
      </table>
       </td>
    </tr>
   </div>
   <div>
<tr valign="bottom">
  <td colspan="2">
   <table cellpadding="0" cellspacing="0" border="1" width="100%" background="images/bg4.jpg">
    <tr>
     <td height="23" align="center">Copyright 2007, <font class="a1">my-i@s.com</font> All rights reserved.</td>
    </tr>
   </table>  
  </td>
</tr>
</div>
</table>

</body>
</html>

<?php
}
?>
回复

使用道具 举报

小陈陈
发表于 1-6-2009 11:07 PM | 显示全部楼层
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\zipper\update.php on line 349

你的update.php这个file有问题。。。
但是。。 你的update.php这个file在那里？
回复

使用道具 举报

uglyboy
 楼主| 发表于 2-6-2009 09:53 AM | 显示全部楼层
我的update file ,就是我post 在上面的，
那是我update 的file.
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

 

所属分类: 电脑手机


ADVERTISEMENT


本周最热论坛帖子本周最热论坛帖子

ADVERTISEMENT


佳礼网 面子书


ADVERTISEMENT

ADVERTISEMENT


版权所有 © 1996-2023 Cari Internet Sdn Bhd (483575-W)|IPSERVERONE 提供云主机|广告刊登|关于我们|私隐权|免控|投诉|联络|脸书|佳礼资讯网

GMT+8, 11-12-2025 05:07 AM , Processed in 0.124570 second(s), 24 queries , Gzip On.

Powered by Discuz! X3.4

Copyright © 2001-2021, Tencent Cloud.

快速回复 返回顶部 返回列表