saiprasad1996/fileupload.php

## fileupload.php
<?php
$target_dir = "uploads/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$text = $_POST["description"];

$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
    $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
    if($check !== false) {
        echo "File is an image - " . $check["mime"] . ".";
        $uploadOk = 1;
    } else {
        echo "File is not an image.";
        $uploadOk = 0;
    }
}
// Check if file already exists
if (file_exists($target_file)) {
    echo "Sorry, file already exists.";
    $uploadOk = 0;
}
// Check file size
if ($_FILES["fileToUpload"]["size"] > 500000) {
    echo "Sorry, your file is too large.";
    $uploadOk = 0;
}
// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
    echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
    $uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
    echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
    if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
        echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded.";

		//Your mysql insert logic here for uploading data to the table from the text box
		$sql = "INSERT INTO $tablename(`name`,`photo`,`description`) VALUES('name','$target_file','$text')";
		$servername = "localhost";
		$username = "username";
		$password = "password";

		// Create connection
		$conn = mysqli_connect($servername, $username, $password);
		if (!$conn) {
			die("Connection failed: " . mysqli_connect_error());
		}
		if (mysqli_query($conn, $sql)) {
			echo "New record inserted successfully";
		} else {
			echo "Error: " . $sql . "<br>" . mysqli_error($conn);
		}

		mysqli_close($conn);

    } else {
        echo "Sorry, there was an error uploading your file.";
    }
}
?>

## index.php
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<title>File upload example</title>
</head>
<body>

<form action="fileupload.php" method="post" enctype="multipart/form-data">
    Select image to upload:
	<textarea name="description">Description</textarea>
    <input type="file" name="fileToUpload" id="fileToUpload">
    <input type="submit" value="Upload Picture" name="submit">
</form>

</body>
</html>
	<?php
	$target_dir = "uploads/";
	$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
	$text = $_POST["description"];

	$uploadOk = 1;
	$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
	// Check if image file is a actual image or fake image
	if(isset($_POST["submit"])) {
	$check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
	if($check !== false) {
	echo "File is an image - " . $check["mime"] . ".";
	$uploadOk = 1;
	} else {
	echo "File is not an image.";
	$uploadOk = 0;
	}
	}
	// Check if file already exists
	if (file_exists($target_file)) {
	echo "Sorry, file already exists.";
	$uploadOk = 0;
	}
	// Check file size
	if ($_FILES["fileToUpload"]["size"] > 500000) {
	echo "Sorry, your file is too large.";
	$uploadOk = 0;
	}
	// Allow certain file formats
	if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
	&& $imageFileType != "gif" ) {
	echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
	$uploadOk = 0;
	}
	// Check if $uploadOk is set to 0 by an error
	if ($uploadOk == 0) {
	echo "Sorry, your file was not uploaded.";
	// if everything is ok, try to upload file
	} else {
	if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
	echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded.";

	//Your mysql insert logic here for uploading data to the table from the text box
	$sql = "INSERT INTO $tablename(`name`,`photo`,`description`) VALUES('name','$target_file','$text')";
	$servername = "localhost";
	$username = "username";
	$password = "password";

	// Create connection
	$conn = mysqli_connect($servername, $username, $password);
	if (!$conn) {
	die("Connection failed: " . mysqli_connect_error());
	}
	if (mysqli_query($conn, $sql)) {
	echo "New record inserted successfully";
	} else {
	echo "Error: " . $sql . "<br>" . mysqli_error($conn);
	}

	mysqli_close($conn);

	} else {
	echo "Sorry, there was an error uploading your file.";
	}
	}
	?>
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<title>File upload example</title>
	</head>
	<body>

	<form action="fileupload.php" method="post" enctype="multipart/form-data">
	Select image to upload:
	<textarea name="description">Description</textarea>
	<input type="file" name="fileToUpload" id="fileToUpload">
	<input type="submit" value="Upload Picture" name="submit">
	</form>

	</body>
	</html>