i trying insert multiple images in mysql database. program working fine when inserting single image in database, when have added 3 images, giving me error message. not giving mysql error message. kindly check it. thanks
not valid image
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>untitled document</title> </head> <body> <a href="dashboard.php"> dashboard </a> </body> </html> <?php error_reporting(e_parse); //to remove notices!! global $current_id; session_start(); if(isset($_session['username'])) { include 'connect.php'; $select_query= 'select * category'; $select_query_run = mysql_query($select_query); echo " <form action='insert_product.php' method='post' enctype='multipart/form-data' ></br> product name: <input type='text' name='product_name' /></br> price : <input type= 'text' name= 'price' /></br> description : <input type='text' name='description' />*seperate comma</br> image1 : <input type='file' name= 'image' > image2 : <input type='file' name= 'image' > image3 : <input type='file' name= 'image3' > "; /*------------------ drop down list start ------------------*/ echo "<select name='category'>"; while ($select_query_array= mysql_fetch_array($select_query_run) ) { echo "<option value='".$select_query_array['category_id']."' >". htmlspecialchars($select_query_array["name"])."</option>"; } $selecttag= "<input type='submit' value='insert' /></select></form>"; echo $selecttag; /*----------------- drop down list end ------------------*/ if(isset($_post['product_name']) && isset($_post['price']) && isset($_post['description']) ) { $product_name = $_post['product_name']; $price = $_post['price']; $description = $_post['description']; $category = $_post['category']; $query= "insert products (name, price, description, category_id ) values( '$product_name', $price, '$description', $category )"; if($query_run= mysql_query($query) ) { echo 'data inserted'; $current_id= mysql_insert_id(); //$_session['current_id']= mysql_insert_id(); } else { 'error in sql'.mysql_error(); } } else { echo 'plesae fill fields'; } /*------------------- image query ---------------*/ $file =$_files['image']['tmp_name']; if(!isset($file)) { echo 'please select image'; } else { $image_check= getimagesize($_files['image']['tmp_name']); $image_check2= getimagesize($_files['image2']['tmp_name']); $image_check3= getimagesize($_files['image3']['tmp_name']); if($image_check==false || $image_check2==false || $image_check3==false) { echo 'not valid image'; } else { /* $image =file_get_contents ($_files['image']['tmp_name'] ); $image_name =$_files['image']['name']; $image_query ="insert product_images values ($current_id, '$image_name', '$image')"; */ //for image 1 $image =mysql_real_escape_string(file_get_contents ($_files['image']['tmp_name'])); $image_name =mysql_real_escape_string($_files['image']['name']); $image_query ="insert product_images values ($current_id, '$image_name', '$image')"; //for image2 $image2= mysql_real_escape_string(file_get_contents($_files['image2']['tmp_name'])); $image2_name= mysql_real_escape_string($_files['image2']['name']); $image2_query= "insert product_images values ($current_id,'$image2_name','$image2')"; //for image3 $image3= mysql_real_escape_string(file_get_contents($_files['image3']['tmp_name'])); $image3_name= mysql_real_escape_string($_files['image3']['name']); $image3_query= "insert product_images values ($current_id, '$image3_name', '$image3')"; // $image_query= "insert `product_images` (`product_id`, `name`, `image`) //values ('1', '{$image_name}', '{$image}')"; if (mysql_query($image_query) && mysql_query($image3_query) && mysql_query($image2_query)) { //if ($image_query =mysql_query (insert product_images values // ($current_id, $image_name, $image")) // echo $current_id; //echo 'successfull'; } else { echo "<br>". mysql_error(); } } } /*----------------- image query end ---------------------*/ } else { echo 'you must log in view page!'; } ?>
you cannot have 2 <input type="file"> same name. try rename different names, , handle them 1 one.
i.e. 2nd file input image should image2.
in additionally, based on comments below, 3 images exceed maximum upload size, results web server terminated post request. try increase upload_max_filesize in php.ini or via ini_set().
also, here sidenotes posted in question comments (which codes have potential problems):
stop using deprecated
mysql_*functions. use mysqli or pdo instead.your code subjected sql injection attack, directly allow post values inserted in query.
Comments
Post a Comment