Tutorials: UPLOAD AND INSERT IMAGE INTO THE DATABASE HTML SQL PHP

PHOTO EMBED

Wed Mar 17 2021 03:16:18 GMT+0000 (UTC)

Saved by @ladycodemonkey

SOURCE CODE

First you need to create database :

CREATE DATABASE uploadfile;

Then create table :

CREATE TABLE IF NOT EXISTS `uploadedimage` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `imagename` varchar(100) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


uploadimage.php
<?php
//This code shows how to Upload And Insert Image Into Mysql Database Using Php Html.
//connecting to uploadFile database.
$conn = mysqli_connect("localhost", "root", "", "uploadFile");
if($conn) {
//if connection has been established display connected.
echo "connected";
}
//if button with the name uploadfilesub has been clicked
if(isset($_POST['uploadfilesub'])) {
//declaring variables
$filename = $_FILES['uploadfile']['name'];
$filetmpname = $_FILES['uploadfile']['tmp_name'];
//folder where images will be uploaded
$folder = 'imagesuploadedf/';
//function for saving the uploaded images in a specific folder
move_uploaded_file($filetmpname, $folder.$filename);
//inserting image details (ie image name) in the database
$sql = "INSERT INTO `uploadedimage` (`imagename`)  VALUES ('$filename')";
$qry = mysqli_query($conn,  $sql);
if( $qry) {
echo "image uploaded";
}
}

?>


<!DOCTYPE html>
<html>
<body>
<!--Make sure to put "enctype="multipart/form-data" inside form tag when uploading files -->
<form action="" method="post" enctype="multipart/form-data" >
<!--input tag for file types should have a "type" attribute with value "file"-->
<input type="file" name="uploadfile" />
<input type="submit" name="uploadfilesub" value="upload" />
</form>
</body>
</html>
content_copyCOPY

https://mauricemutetingundi.blogspot.com/2017/06/upload-and-insert-image-into-database.html