I followed a tutorial and the code below is for inserting images in database. I want to upload a PDF file instead of an image.
With the code I don't know what to change in order to insert a PDF file into database. I found another tutorial with location. I also want to allow users to upload the PDFs in any location/folder.
upload.php:
<!Doctype html>
<html>
<head>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="style.css">
<title>Success</title>
</head>
<body>
<div id="header">
<label>Anouncement</label>
</div>
<div class="aa">
<div class="vertical-menu">
<img src="abc.png" class="img-circle" alt="Ice" width="200" height="200" id="ice">
<h2 align="center">Milagros Quanico</h2>
<h3 align="center"><?php
$servername = "localhost";
$username = "id834551_teacherss";
$password = "";
$dbname = "id834551_teacher";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$conn->close();
?></h3>
<i><a align="center" class="active" href="welcome.php">Home</a></i>
<i><a align="center" href="Add1.php">Update Topics</a></i>
<i><a align="center" href="calendar1.php">Calendar</a></i>
<i><a align="center" href="db.php">#View</a></i>
<i><a align="center" href="logout.php">Log out</a></i>
<br><br><br></br></br></br>
</div>
<div class="dd"> <!--Content-->
<br>
<br>
<br>
<h1>Welcome Users </h1>
<?php
$msg = "";
if (isset($_POST['upload'])) {
if(getimagesize($_FILES['image']['tmp_name']) == FALSE)
{
echo "Please Select an image.";
}
else {
$image = addslashes($_FILES['image']['tmp_name']);
$name = addslashes($_FILES['image']['name']);
$image = file_get_contents($image);
$image = base64_encode($image);
saveimage($name,$image);
}
}
displayimage();
function saveimage($name,$image)
{
$servername = "localhost";
$username = "id834551_teacherss";
$password = "";
$dbname = "id834551_teacher";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
$query = "INSERT INTO images (name,images) values ('$name','$image')";
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$result = mysqli_query($conn,$query);
if($result) {
echo "<br/> Image uploaded.";
}
else {
echo "<br/> Image not uploaded.";
}
}
function displayimage()
{
$servername = "localhost";
$username = "id834551_teacherss";
$password = "jeromelim";
$dbname = "id834551_teacher";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
$query = "SELECT * FROM images";
$result = mysqli_query($conn,$query);
while($row = mysqli_fetch_array($result))
{
echo '<img height ="300" width ="300" src="data:image/jpeg;base64,'.$row[2].' "> ';
}
mysqli_close($conn);
}
?>
<form method = "post" action = "uploads.php" enctype = "multipart/form-data">
<input type = "hidden" name ="size" value = "1000000">
<div>
<input type = "file" name = "image"/>
</div>
<div>
<textarea name = "text" cols="40" rows="4" placeholder="Say Something Here">
</textarea>
</div>
<div>
<input type = "submit" name="upload" value="Upload File">
</div>
</form>
</div>
</div>
</body>
</html>
this is the actual code that the image being insert onto database. and i want to upload also the pdf file
<?php
$msg = "";
if (isset($_POST['upload'])) {
if(getimagesize($_FILES['image']['tmp_name']) == FALSE)
{
echo "Please Select an image.";
}
else {
$image = addslashes($_FILES[''])
$image = addslashes($_FILES['image']['tmp_name']);
$name = addslashes($_FILES['image']['name']);
$image = file_get_contents($image);
$image = base64_encode($image);
saveimage($name,$image);
}
}
displayimage();
function saveimage($name,$image)
{
$servername = "localhost";
$username = "id834551_teacherss";
$password = "jeromelim";
$dbname = "id834551_teacher";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
$query = "INSERT INTO images (name,images) values ('$name','$image')";
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$result = mysqli_query($conn,$query);
if($result) {
echo "<br/> Image uploaded.";
}
else {
echo "<br/> Image not uploaded.";
}
}
function displayimage()
{
$servername = "localhost";
$username = "id834551_teacherss";
$password = "jeromelim";
$dbname = "id834551_teacher";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
$query = "SELECT * FROM images";
$result = mysqli_query($conn,$query);
while($row = mysqli_fetch_array($result))
{
echo '<img height ="300" width ="300" src="data:image/jpeg;base64,'.$row[2].' "> ';
}
mysqli_close($conn);
}
?></div>
