php商购网站后台上传图片到数据库前台显示

后台添加产品代码

<script language="JavaScript">


</script>
<form action="product_added.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
      <table width="600" align=center border="0" cellspacing="0" cellpadding="5">
        <tr>
          <td width="120"><div align="right">产品名称</div></td>
          <td width="480"><input name="name" type="text" id="name" /></td>
        </tr>
        <tr>
          <td><div align="right">产品分类</div></td>
          <td><select name="leixing" id="leixing">
             <option >请选择...</option>
             <option value="男包">男包</option>
             <option value="女包">女包</option>
             <option value="钱包">钱包</option>
             <option value="休闲包">休闲包</option>
             <option value="商务包">商务包</option>
             <option value="特价包">特价包</option>
               </select>
            <a href="product_category.php"></a>          </td>
        </tr>
        <tr>
          <td><div align="right">产品现价</div></td>
          <td><input name="xianjia" type="text" id="xianjia" /></td>
        </tr>
        <tr>
          <td><div align="right">产品原价</div></td>
          <td><input name="yuanjia" type="text" id="yuanjia" /></td>
        </tr>
        <tr>
          <td><div align="right">上传产品图片</div></td>
          <td><input type="hidden" name="MAX_FILE_SIZE" size="200000"/>
            <input type="file" name="file" /></td>
        </tr>
        <tr>
          <td> </td>
          <td><input type="submit" name="Submit" value="提交" />
            <input type="reset" name="Submit2" value="重置" /></td>
        </tr>
      </table>

    </form>

<?php
session_start();
//上传产品图片
$uploaddir = 'picture/'; //上传文件目录
//$RandomNum = rand(0,10000000);
$flname = $_FILES['file']['name'];
$flnames = explode('.',$flname);
$filename = $flnames[0].$RandomNum.'.'.$flnames[1];
$uploadfile = $uploaddir . $filename;
MOVE_UPLOADED_FILE($_FILES['file']['tmp_name'],$uploadfile);



//将产品信息写入数据库
//require("../inc/config.inc.php");
$name = $_POST['name'];
$leixing = $_POST['leixing'];
$xianjia = $_POST['xianjia'];
$yuanjia = $_POST['yuanjia'];
$s_path = $uploadfile;
$db = mysql_connect("localhost","root","654321") ;

    mysql_select_db("product",$db);
//判断是否输入为空
   if($_POST['submit']) {
    if($name=="" || $leixing=="" || $xianjia=="" || $yuanjia=="" || $shuliang=="" || $bianhao=="" || $s_path==""){

    echo "";

    echo "错误信息!";

    echo "对不起,输入信息不能为空！ ";

    echo "";

    echo "";

    echo "";

    exit ;
      }
   else {
       $query = "insert into product(name,leixing,xianjia,yuanjia,shuliang,bianhao,s_path) values (\"$name\",\"$leixing\",\"$xianjia\",\"$yuanjia\",\"$s_path\")";
//echo $query
   $result = mysql_query($query) or die("mysql_error");
}
if ($result)
{
    echo "";
    echo "产品添加成功!点击此处继续添加 ";
    echo "";
}
else
{
    echo "";
    echo "产品添加失败！ ";
    echo "";
}
}
?>

前台显示代码

<?Php
         $db = mysql_connect("localhost","root","654321") ;

     mysql_select_db("product",$db);
         $query_list = "select * from product order by id desc limit 0,36";
         $result_list = mysql_query($query_list);
         /*$num = mysql_num_rows($result_list);*/
         $i=0;
         /*for($i;$i<$num;$i++) {*/
               while ($row1 = mysql_fetch_object($result_list)){
                      $id = $row1 -> id;
                      $xianjia = $row1 -> xianjia;
                      $picture = $row1-> s_path;
                      $yuanjia = $row1-> yuanjia;
                                        //echo $picture;
    echo "

          

          

          
                          现价:$xianjia  原价:$yuanjia                ";








                                        $i++;
                                        if($i%3==0)
                                        echo "";

    }


?>