"tutorialspoint.com/mysql/mysql-connection.htm"
"w3schools.com/php/php_mysql_connect.asp"
"simplifiedcoding.net/how-to-insert-image-in-mysql-database-in-php/"
<?php
$servername = "localhost";
$username = "username";
$password = "password";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>
<html>
<head>
<title>Insert Image</title>
</head>
<body>
<form action="index.php" method="post" enctype="multipart/form-data">
<input type="file" name="image" />
<button>Upload</button>
</form>
</body>
</html>
<?php
$msg = '';
if($_SERVER['REQUEST_METHOD']=='POST'){
$image = $_FILES['image']['tmp_name'];
$img = file_get_contents($image);
$con = mysqli_connect('localhost','root','','mysqldb') or die('Unable To connect');
$sql = "insert into images (image) values(?)";
$stmt = mysqli_prepare($con,$sql);
mysqli_stmt_bind_param($stmt, "s",$img);
mysqli_stmt_execute($stmt);
$check = mysqli_stmt_affected_rows($stmt);
if($check==1){
$msg = 'Successfullly UPloaded';
}else{
$msg = 'Could not upload';
}
mysqli_close($con);
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Insert Image</title>
</head>
<body>
<?php
$msg = '';
if($_SERVER['REQUEST_METHOD']=='POST'){
$image = $_FILES['image']['tmp_name'];
$img = file_get_contents($image);
$con = mysqli_connect('localhost','root','','mysqldb') or die('Unable To connect');
$sql = "insert into images (image) values(?)";
$stmt = mysqli_prepare($con,$sql);
mysqli_stmt_bind_param($stmt, "s",$img);
mysqli_stmt_execute($stmt);
$check = mysqli_stmt_affected_rows($stmt);
if($check==1){
$msg = 'Successfullly UPloaded';
}else{
$msg = 'Could not upload';
}
mysqli_close($con);
}
?>
<form action="index.php" method="post" enctype="multipart/form-data">
<input type="file" name="image" />
<button>Upload</button>
</form>
<?php
echo $msg;
?>
</body>
</html>
<?php
if(isset($_POST['btn-upload']))
{
$file = rand(1000,100000)."-".$_FILES['file']['name'];
$file_loc = $_FILES['file']['tmp_name'];
$file_size = $_FILES['file']['size'];
$file_type = $_FILES['file']['type'];
$folder="uploads/";
move_uploaded_file($file_loc,$folder.$file);
$sql="INSERT INTO tbl_uploads(file,type,size) VALUES('$file','$file_type','$file_size')";
mysql_query($sql);
}
?>
<html>
<head><title>Insertion</title></head>
<body>
Please select File
<form enctype="multipart/form-data" action=
"<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<input type="hidden" name="MAX_FILE_SIZE" value="99999999" />
<input name="userfile" type="file" />
<input type="submit" value="Submit" />
</form>
<?php
echo upload();
function upload() {
include "file_constants.php";
$maxsize = 99999999;
if($_FILES['userfile']['error']==UPLOAD_ERR_OK) {
if(is_uploaded_file($_FILES['userfile']['tmp_name'])) {
if( $_FILES['userfile']['size'] < $maxsize) {
//if(strpos(mime_content_type($_FILES['userfile']['tmp_name']),"image")===0) {
$finfo = finfo_open(FILEINFO_MIME_TYPE);
if(strpos(finfo_file($finfo, $_FILES['userfile']['tmp_name']),"image")===0) {
$imgData =addslashes (file_get_contents($_FILES['userfile']['tmp_name']));
mysql_connect($host, $user, $pass) OR DIE (mysql_error());
mysql_select_db ($db) OR DIE ("Unable to select db".mysql_error());
$sql = "INSERT INTO Table
(imageColumn, Column2)
VALUES
('{$imgData}', '{$_FILES['userfile']['name']}');";
mysql_query($sql) or die("Error in Query: " . mysql_error());
$msg='Image uploaded successfully';
}
else
$msg="Uploaded file is not an image.";
}
else {
// if the file is not less than the maximum allowed, print an error
$msg='File exceeds the Maximum File limit
Maximum File limit is '.$maxsize.' bytes
File '.$_FILES['userfile']['name'].' is '.$_FILES['userfile']['size'].
' bytes';
}
}
else
$msg="Error while uploading";
}
else {
$msg= "Error while uploading";
}
return $msg;
}
?>
</body>
</html>
<?php
include "file_constants.php";
error_reporting(E_ALL);
if(isset($_GET['id']) && is_numeric($_GET['id'])) {
$link = mysql_connect("$host", "$user", "$pass")
or die("Could not connect: " . mysql_error());
mysql_select_db("$db") or die(mysql_error());
$sql = "SELECT imageColumn FROM Table WHERE id=" .$_GET['id'] . ";";
$result = mysql_query("$sql") or die("Invalid sql query: " . mysql_error());
header("Content-type: image/jpeg");
echo mysql_result($result, 0);
mysql_close($link);
}
?>
