php - Upload image and insert data to db issue -


trying build page adding new products,for client page form - 1)to upload image 2)add price , name data

for reason not working. after click on submit button,nothing happens,its stayens on saveimage.php page

<form action="saveimage.php" enctype="multipart/form-data" method="post">    <input name="name" type="text">שם:</br>    <input name="price" type="text">מחיר:</br>     <input name="category" value="<?php $category ?>" type="hidden">     <input name="uploadedimage" type="file">    <input name="new_product" type="submit" value="upload image">     </form> 

the php page

 <?php  include("../../dbconn.php");        function getimageextension($imagetype)     	 {         if(empty($imagetype)) return false;         switch($imagetype)         {             case 'image/bmp': return '.bmp';             case 'image/gif': return '.gif';             case 'image/jpeg': return '.jpg';             case 'image/png': return '.png';  		   case 'jpeg': return '.jpg';  		   case 'png': return '.png';  		   case 'jpg': return '.jpg';             default: return false;         }       }  	   	   	   if (!empty($_files["uploadedimage"]["name"])) {    	$file_name=$_files["uploadedimage"]["name"];  	$temp_name=$_files["uploadedimage"]["tmp_name"];  	$imgtype=$_files["uploadedimage"]["type"];  	$ext= getimageextension($imgtype);  	$imagename=date("d-m-y")."-".time().$ext;  	$target_path = "img/".$imagename;  }    if(isset($_post['new_product'])) {        if(isset($_post['name']) && isset($_post['price']))       {  	$product_name = strip_tags($_post['name']);  	$product_price = strip_tags($_post['price']);  	$category = strip_tags($_post['category']);  	}    if(move_uploaded_file($temp_name, $target_path)) {     	$query_upload="insert products ('product_name','product_price','product_pic','category') values ('".$product_name."', '".$product_price."', '".$image_name."', '".$category."')";      	mysql_query($query_upload) or die("error in $query_upload == ----> ".mysql_error());    	  }else{       exit("error while uploading image on server");  }   else{       header('location: upload_image_food.php?cname='.$category.');      }  }   ?>;

few changes.

1) change

<input name="category" value="<?php $category ?>" type="hidden">

to

<input name="category" value="<?php echo $category; ?>" type="hidden">

2) change (remove single quotes ' around column name)

$query_upload="insert products ('product_name','product_price','product_pic','category') values ('".$product_name."', '".$product_price."', '".$image_name."', '".$category."')"; 

to

$query_upload = "insert products (product_name,product_price,product_pic,category) values ('$product_name', '$product_price', '$image_name','$category')"; 

3) add header("location: upload_image_food.php?cname=$category&message=success"); inside move_uploaded_file because when success then, need go desired location message. reason why it's showing blank.

4) change

}else{     exit("error while uploading image on server"); }  else{     header('location: upload_image_food.php?cname='.$category.');     } }  ?>; 

to

}else{           exit("error while uploading image on server");     } } else{     header("location: upload_image_food.php?cname=$category"); } ?> 

somepage.php

<form action="saveimage.php" enctype="multipart/form-data" method="post">     <input name="name" type="text">שם:</br>     <input name="price" type="text">מחיר:</br>     <input name="category" value="<?php echo $category ?>" type="hidden">     <input name="uploadedimage" type="file">     <input name="new_product" type="submit" value="upload image"> </form>  

saveimage.php

function getimageextension($imagetype) {     if(empty($imagetype)) return false;     switch($imagetype)     {          case 'image/bmp': return '.bmp';          case 'image/gif': return '.gif';          case 'image/jpeg': return '.jpg';          case 'image/png': return '.png';          case 'jpeg': return '.jpg';          case 'png': return '.png';          case 'jpg': return '.jpg';          default: return false;     } }    if (!empty($_files["uploadedimage"]["name"])) {      $file_name=$_files["uploadedimage"]["name"];     $temp_name=$_files["uploadedimage"]["tmp_name"];     $imgtype=$_files["uploadedimage"]["type"];     $ext= getimageextension($imgtype);     $imagename=date("d-m-y")."-".time().$ext;     $target_path = "img/".$imagename; }  if(isset($_post['new_product']))  {    if(isset($_post['name']) && isset($_post['price']))    {         $product_name = strip_tags($_post['name']);         $product_price = strip_tags($_post['price']);         $category = strip_tags($_post['category']);     }      if(move_uploaded_file($temp_name, $target_path))      {          $query_upload = "insert products (product_name,product_price,product_pic,category) values ('$product_name', '$product_price', '$image_name','$category')";          mysql_query($query_upload) or die("error in $query_upload == ----> ".mysql_error());           header("location: upload_image_food.php?cname=$category&message=success");     }     else     {          exit("error while uploading image on server");     }  else {         header("location: upload_image_food.php?cname=$category"); } ?> 

Comments

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

javascript - Get parameter of GET request -

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -