Upload Image using Php and mySQL

Question

I am trying to upload image using php and save in mysql database that would accept the different extension of it such as bmp, jpeg etc. By using the following codes, some of the uploaded images displayed incomplete.

This is the uploadForm:

<html>
  <form method="post" action="updateImage1.php" enctype="multipart/form-data">
  <table border=0>
  <tr>
    <td><center><img src="getImage.php?id='.$row["No"].'" width=250 height=180/></center><br>      
    <input type="file" name="s4"><br>
    <input name="update" type="submit" id="update" value="Save Changes" class="btn btn-primary" >
    &nbsp &nbsp
     </form><a href="admin3.php"><button type="button" class="btn btn-primary">Cancel</button></a>
 </tr>

 </table>
 </html>

This is the updateImage1.php:

<?php
$s1 = addslashes(file_get_contents($_FILES['s4']['tmp_name']));

$host="localhost";
$user_name="root";
$database_name="5r";
$db=mysql_connect($host, $user_name,'');
if (mysql_error() > "") echo mysql_error() . "<br>";
mysql_select_db($database_name, $db);
if (mysql_error() > "") echo mysql_error() . "<br>";

$query = "UPDATE tblMain SET images='$s1' WHERE No=3";
$qresult = mysql_query($query);
echo "<script>alert('Records Successfully Updated'); location.href='admin3.php';</script>";
?>

This is the getImage.php:

 <?php

 $No = $_GET['id'];
 $link = mysql_connect("localhost", "root", "");
 mysql_select_db("5r");
 $sql = "SELECT images FROM tblMain WHERE No=$No";
 $result = mysql_query("$sql");
 $row = mysql_fetch_assoc($result);
 mysql_close($link);

 header("Content-type: image/jpeg/bmp/png");
 echo $row['images'];
 ?>

1) Where is the insert inside db? 2) mysql_* is deprecated, 3) how big of image are we talking about? — Marco Mura
– Marco Mura, Commented Nov 19, 2014 at 13:19
I doubt this is valid header("Content-type: image/jpeg/bmp/png"); as per the manual php.net/manual/en/function.image-type-to-mime-type.php - I suggest you look at stackoverflow.com/a/2634072 — Funk Forty Niner
– Funk Forty Niner, Commented Nov 19, 2014 at 13:21
I did not used the Insert statement, because I'm trying to update the uploaded image on database. But every time I uploaded an image that has been edited in picasa photo viewer and has an extension of bmp, the image displayed incomplete. — Rachelle Tud
– Rachelle Tud, Commented Nov 19, 2014 at 13:41

Jenny Perez · Accepted Answer · 2015-01-13 05:07:35Z

2

Change the data type of the images into Long Blob.

answered Jan 13, 2015 at 5:07

Jenny Perez

585 bronze badges

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

Collectives™ on Stack Overflow

Upload Image using Php and mySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related