Menu
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" >
   
</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'];
?>
258
asked Aug 24 '26 11:08
Change the data type of the images into Long Blob.
171
answered Aug 27 '26 03:08
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With