I Want to Upload an image in database through php,the image is not uploading in database

Question

i tried to upload an image but when getimagesize the image is empty it is returning false.. and warning is coming ,it is not saving in database .the database name is project and table name is images and fields are name and image .Here is a code...

<?php
 ini_set('mysql.connect_timeout',300);
 ini_set('default_socket_timeout',300);

?>
<html>
<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/formdata">
<input type="file" name="image"><br><br>
<input type="submit" name="submit" value="upload">
</form>
<?php
// Create connection
$conn = mysql_connect('localhost', 'root', '');
// Check connection
if (mysqli_connect_error()) {
  die("Database connection failed: " . mysqli_connect_error());
}
else
{
  echo "Connected successfully";
}
 //data upload
 if( isset($_POST['submit'] ))
 {
     if(getimagesize($_FILES['image']['tmp_name'])==FALSE) //image size is checked
     {
            echo "upload image";
     }
     else
     {
        $image= addslashes($_FILES['image']['tmp_name']);
        $name=addslashes($_FILES['image']['name']);
        $image=file_get_contents($image);
        $image= base64_encode($image);
        saveimage($name,$image);
      }
    }
    function saveimage($name,$image)
    {
      $conn = mysql_connect('localhost', 'root','');
      mysql_select_db("project",$conn);
      $result = mysql_query("insert into images(name,image) values('$name','$image')");    //query implemented

    }
    ?>      //function written to save image
    </body>
    </html>

Error message? What is the column type of image? Is it BLOB? Have you considered storing images in your system rather than in your database? Try using === instead of ==. — Logan Wayne
– Logan Wayne, Commented Apr 13, 2016 at 4:00
You should store image in system and store that image folder path in database... — Piyush Gupta
– Piyush Gupta, Commented Apr 13, 2016 at 4:06
@Logan Wayne ,this the error message Undefined index: image in C:\wamp\www\imageupload.php on line 37 getimagesize() [function.getimagesize]: Filename cannot be empty in C:\wamp\www\imageupload.php on line 37 and column type is LONGBLOB nd i trying to store image in local server nd i tried using === it is still not working — upasana arora
– upasana arora, Commented Apr 13, 2016 at 4:17

Maulik · Accepted Answer · 2016-04-13 04:19:53Z

0

Edit this line

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data">

answered Apr 13, 2016 at 4:19

Maulik

8971 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

22 Comments

upasana arora Over a year ago

a new warning came,Warning: mysql_query() [function.mysql-query]: MySQL server has gone away in C:\wamp\www\imageupload.php on line 58 and Warning: mysql_query() [function.mysql-query]: Error reading result set's header in C:\wamp\www\imageupload.php on line 58 and still the image is not stored in database

Maulik Over a year ago

ok replace this code $uploads_dir = '/uploads'; $image= addslashes($_FILES['image']['tmp_name']); $name=addslashes($_FILES['image']['name']); $image=file_get_contents($image); $image= base64_encode($image); move_uploaded_file($image, "$uploads_dir/$name");

upasana arora Over a year ago

still warning,Warning: mysql_query() [function.mysql-query]: MySQL server has gone away in C:\wamp\www\imageupload.php on line 66 and Warning: mysql_query() [function.mysql-query]: Error reading result set's header in C:\wamp\www\imageupload.php on line 66

Maulik Over a year ago

create uploads folder in your project

upasana arora Over a year ago

oh,i removed saveimage function now its working,but i want to save image in database.please help

|

ghaziksibi · Accepted Answer · 2016-04-13 05:16:58Z

0

<?php
 ini_set('mysql.connect_timeout',300);
 ini_set('default_socket_timeout',300);

?>
<html>
<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data">
<input type="file" name="image"><br><br>
<input type="submit" name="submit" value="upload">
</form>
<?php
// Create connection
$conn = mysql_connect('localhost', 'root', '');
// Check connection
if (mysqli_connect_error()) {
  die("Database connection failed: " . mysqli_connect_error());
}
else
{
  echo "Connected successfully";
}
 //data upload
 if( isset($_POST['submit'] ))
 {
    mysql_select_db("project",$conn);
    $image = addslashes(file_get_contents($_FILES['image']['tmp_name']));
        $name=addslashes($_FILES['image']['name']);
    $result = mysql_query("insert into images(name,image) values('.$name.','.$image.')");  
    mysql_close($conn); 
    }?>
    </body>
    </html>

edited Apr 13, 2016 at 5:16

answered Apr 13, 2016 at 4:11

ghaziksibi

4713 silver badges13 bronze badges

4 Comments

upasana arora Over a year ago

warnings,Undefined index: image in C:\wamp\www\imageupload.php on line 27 and Warning: file_get_contents() [function.file-get-contents]: Filename cannot be empty in C:\wamp\www\imageupload.php on line 27 and Notice: Undefined index: image in C:\wamp\www\imageupload.php on line 28

ghaziksibi Over a year ago

$name=basename($_FILES['image']['name']);

upasana arora Over a year ago

it did not made any change

ghaziksibi Over a year ago

change enctype from "multipart/formdata" to "multipart/form-data"

Collectives™ on Stack Overflow

I Want to Upload an image in database through php,the image is not uploading in database

2 Answers 2

22 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

22 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related