Example 1: how to upload image in php and store in database and folder
$Get_image_name = $_FILES['image']['name'];
$image_Path = "images/".basename($Get_image_name);
$sql = "INSERT INTO student_table (imagename, contact) VALUES ('$Get_image_name', 'USA')";
mysqli_query($conn, $sql);
if (move_uploaded_file($_FILES['image']['tmp_name'], $image_Path)) {
echo "Your Image uploaded successfully";
}else{
echo "Not Insert Image";
}
}
Example 2: image upload in php code with databases
<?php
$db = mysqli_connect("localhost", "root", "", "image_upload");
$msg = "";
if (isset($_POST['upload'])) {
$image = $_FILES['image']['name'];
$image_text = mysqli_real_escape_string($db, $_POST['image_text']);
$target = "images/".basename($image);
$sql = "INSERT INTO images (image, image_text) VALUES ('$image', '$image_text')";
mysqli_query($db, $sql);
if (move_uploaded_file($_FILES['image']['tmp_name'], $target)) {
$msg = "Image uploaded successfully";
}else{
$msg = "Failed to upload image";
}
}
$result = mysqli_query($db, "SELECT * FROM images");
?>
<!DOCTYPE html>
<html>
<head>
<title>Image Upload</title>
<style type="text/css">
#content{
width: 50%;
margin: 20px auto;
border: 1px solid #cbcbcb;
}
form{
width: 50%;
margin: 20px auto;
}
form div{
margin-top: 5px;
}
#img_div{
width: 80%;
padding: 5px;
margin: 15px auto;
border: 1px solid #cbcbcb;
}
#img_div:after{
content: "";
display: block;
clear: both;
}
img{
float: left;
margin: 5px;
width: 300px;
height: 140px;
}
</style>
</head>
<body>
<div id="content">
<?php
while ($row = mysqli_fetch_array($result)) {
echo "<div id='img_div'>";
echo "<img src='images/".$row['image']."' >";
echo "<p>".$row['image_text']."</p>";
echo "</div>";
}
?>
<form method="POST" action="index.php" enctype="multipart/form-data">
<input type="hidden" name="size" value="1000000">
<div>
<input type="file" name="image">
</div>
<div>
<textarea
id="text"
cols="40"
rows="4"
name="image_text"
placeholder="Say something about this image..."></textarea>
</div>
<div>
<button type="submit" name="upload">POST</button>
</div>
</form>
</div>
</body>
</html>
Example 3: php image upload in database
<?php
error_reporting(0);
?>
<?php
$msg = "";
if (isset($_POST['upload'])) {
$filename = $_FILES["uploadfile"]["name"];
$tempname = $_FILES["uploadfile"]["tmp_name"];
$folder = "image/".$filename;
$db = mysqli_connect("localhost", "root", "", "image_upload");
$sql = "INSERT INTO images (filename) VALUES ('$filename')";
mysqli_query($db, $sql);
if (move_uploaded_file($tempname, $folder)) {
$msg = "Image uploaded successfully";
}else{
$msg = "Failed to upload image";
}
}
$result = mysqli_query($db, "SELECT * FROM images");
?>
<!DOCTYPE html>
<html>
<head>
<title>Image Upload</title>
<link rel="stylesheet" type= "text/css" href ="style.css"/>
<div id="content">
<form method="POST" action="" enctype="multipart/form-data">
<input type="file" name="uploadfile" value=""/>
<div>
<button type="submit" name="upload">UPLOAD</button>
</div>
</form>
</div>
</body>
</html>
Example 4: download image from mysql using php
//You can save this to test.php and call it with test.php?id=1 for example
<?php
require_once("database.php");
$database = new Database();
$pdo = $database->dbConnection();
if (isset($_GET["id"])) {
$id=(int)$_GET["id"];
} else {
echo "Wrong input";
exit;
}
$q = $pdo->prepare("SELECT * FROM `table_with_image` WHERE `id`=:p_id");
$q->bindparam(":p_id", $id);
$q->execute();
if ($q->rowCount() == 1) {
$row = $q->fetch(PDO::FETCH_ASSOC);
$image = $row['image'];
$database->disconnect();
header("Content-type: image/jpeg");
header('Content-Disposition: attachment; filename="table_with_image_image'.$id.'.jpg"');
header("Content-Transfer-Encoding: binary");
header('Expires: 0');
header('Pragma: no-cache');
header("Content-Length: ".strlen($image));
echo $image;
} else {
$database->disconnect();
echo "No image found";
}
exit();
Example 5: how to print image just on side where upload php
<?php $galleryPath = "Gallery/"; $descriptions = new DOMDocument("1.0"); $descriptions->appendChild($descriptions->createElement("files")); while (($uploadedFile = UploadedFiles::fetchNext()) != null){ $sourceFile = $uploadedFile->getSourceFile(); $sourceFileName = $sourceFile->getFileName(); $descriptionsFile = $descriptions->createElement("file"); $descriptionsFile->setAttribute("name", $sourceFileName); $descriptionsFile->setAttribute("width", $sourceFile->getWidth()); $descriptionsFile->setAttribute("height", $sourceFile->getHeight()); $descriptionsFile->setAttribute("description", $uploadedFile->getDescription()); $descriptions->documentElement->appendChild($descriptionsFile); $sourceFile->save($galleryPath. "/" .$sourceFileName); } $descriptions->save("Descriptions.xml");?>
Example 6: how to upload image in php
<!DOCTYPE html><html><body><form action="upload.php" method="post"
enctype="multipart/form-data"> Select image to upload: <input type="file" name="fileToUpload" id="fileToUpload"> <input type="submit" value="Upload Image" name="submit">
</form></body></html>