<?php

//Create connection variables
$server = "localhost";
$username = "Stu324";
$password = "Stu8195!";
$dbname= "stu324";

//create connection to database

$conn = new mysqli ($server, $username, $password, $dbname);

// Check connection

if($conn->connect_error)
	{
		die("Connection failed: " . $conn->connect_error);
	}
if(isset($_POST['upload']))
{
	$target = $_FILES['image']['name'];
	$sql = "INSERT INTO uploadimage (image) VALUE ('$target')";
	$conn->query($sql);
	$target_dir = "image/";

	if (!file_exists($target_dir) )
	{
		mkdir ($target_dir, 0744);

	}

	$target = $target_dir.basename($_FILES['image']['name']);

	if(move_uploaded_file($_FILES['image']['tmp_name'], $target))
	{
		echo " Image has been uploaded ";

	}
	else
	{
		echo "Error while uploading";

	}

	if($conn->query($sql) === TRUE)
	{
		echo "New record created";

	}
	else
	{

		echo "Error: " . $sql . "<br>" . $conn->error;
	}
}

	?>



    <form action="uploadimg.php" method="post" enctype="multipart/form-data">
    Select image to upload:
    <input type="file" name="image">
    <input type="submit" value="Submit" name="upload">
</form>

 <?php
	$sql = "SELECT * FROM uploadimage";
	$result = mysqli_query($conn, $sql);
	while ($row = mysqli_fetch_array($result))

		$img = $row['image'];
		echo "<img src='" . $target . "'>";

	$conn->close()

	?>