Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

First!, I have investigated so many similar posts on the site about this title : "Upload image to mysql using php", but did not get my answer.
I am coding a php script to post images from html form to mysql database. please help me fixed it because it is not working. tnx

this is html form

<form name="main_form" action="main.php" method="post" enctype="multipart/form-data">
  <input type="text" name="title" >
  <input type="file" name="img" ><br/>
  <input type="text" name="body" >
  <input type="text" name="link" >
  <input type="text" name="linktext" >
  <input type="submit" value="submit">
</form>

this is main.php

if(isset($_POST['title'])){
  $sql="INSERT INTO main (title, img, body, link, linktext)
  VALUES
  ('$_POST[title]','','$_POST[body]','$_POST[link]','$_POST[linktext]')";
  if (!mysql_query($sql,$con)){
    die('Error: ' . mysql_error());}
  if ($_FILES['img']['tmp_name'] != ''){
    $image = addslashes(file_get_contents($_FILES['img']['tmp_name']));
    if ($image == ''){
      echo 'Image type not supported';
    } else {
      $query  = "UPDATE main SET img='$image' WHERE title='$title'";
      $result = mysql_query($query);
      var_dump($result);
      if ($result){
        echo 'Image scaled and uploaded';
      } else {
        echo 'Error running the query';}
    }
  }
  $alert='record inserted';
  echo '<script>alert("'.$alert.'");</script>';
};

img in database has type=BLOB record inserts successfully in database but img field (BLOB) has nothing in it and is always 0 bytes. 

var_dump($result);

will display: boolean false

I am getting this message at the display: Error running the query

please help!
Thanks :)

share|improve this question
1  
mysql_error() will tell you the particular error. –  Dagon Jul 9 '12 at 7:17
 
Please add after echo 'Error running the query'; the following line: echo mysql_error(); and update your post with returned error. –  Spiritfyre Jul 9 '12 at 7:17
 
What did you see when you echo $title; before your update sql line. –  Lake Jul 9 '12 at 7:18

2 Answers

up vote 0 down vote

It was my mistake!

sorry for spamming stackoverflow with this question. really sorry for that.

I had two connections to two databases. I have one users database and one other main database. the page. the error origins in connection. I corrected the query by adding the right connection string variable so that the connection is established to the main database where the main table exists.

sorry again and so many thanks to Dagon & Spiritfyre

share|improve this answer
up vote 0 down vote

You can delete the post if it is answered. There is a second answer though for adding images to database via form:

form page :

<form enctype="multipart/form-data" action="insert_image.php" method="post" name="changer">
<input name="image" accept="image/jpeg" type="file">
<input value="Submit" type="submit">
</form>

insert to database page :

<?php

  include 'conf.php';

  if ($_FILES["image"]["error"] > 0)
  {
     echo "<font size = '5'><font color=\"#e31919\">Error: NO CHOSEN FILE <br />";
     echo"<p><font size = '5'><font color=\"#e31919\">INSERT TO DATABASE FAILED";
   }
   else
   {
     move_uploaded_file($_FILES["image"]["tmp_name"],"images/" . $_FILES["image"]["name"]);
     echo"<font size = '5'><font color=\"#0CF44A\">SAVED<br>";

     $file="images/".$_FILES["image"]["name"];
     $sql="INSERT INTO database_table (table_column_1, table_column_2) VALUES ('','$file')";

     if (!mysql_query($sql))
     {
        die('Error: ' . mysql_error());
     }
     echo "<font size = '5'><font color=\"#0CF44A\">SAVED TO DATABASE";

   }

   mysql_close();

?>
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.