php mysql 插入图片_php如何向MYSQL里插入图片或者图片路径？

session_start();

include("conn.php");

$mingcheng=$_POST[mingcheng];

$nian=$_POST[nian];

$yue=$_POST[yue];

$ri=$_POST[ri];

$price=$_POST[price];

$meas=$_POST[meas];

$upfile=$_POST[upfile];

$packing=$_POST[packing];

function getname($exname){

$dir = "upimages/";//列出产品图片的上传目录

$i=1;

if(!is_dir($dir)){

mkdir($dir,0777);

}

while(true){

if(! is_file($dir.$i.".".$exname)){

$name=$i.".".$exname;

break;

}

$i++;

}

return $dir.$name;

}

$exname=strtolower(substr($_FILES['upfile']['name'],(strrpos($_FILES['upfile']['name'],'.')+1)));

$uploadfile = getname($exname);

move_uploaded_file($_FILES['upfile']['tmp_name'],$uploadfile);

if(trim($_FILES['upfile']['name']!="")){

$uploadfile="admin/".$uploadfile;

}

else{

$uploadfile="";

}

$addtime=$nian."-".$yue."-".$ri;

mysql_query("insert into tb_shangpin(mingcheng,meas,addtime,tupian,packing,price)values

('$mingcheng','$meas','$addtime','$tupian','$packing','$price')",$conn);

echo "";

?> //上传成功转向addgoods.php页面

按照这个代码 上传图片 数据表里图片那个栏显示空白

展开