<!doctype html>
<html lang=en>
<head>
<title>upload pdf</title>
<meta charset=utf-8>
</head>
<body>
<form action="index.php" method="POST" enctype="multipart/form-data">
<input type="file" name="pdf"><input type="submit" name="submit" value="upload">
</form>
<?php
if(isset($_POST['submit']))
{
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "pdf_upload";
$con = mysql_connect($servername,$username,$password);
if (!$con)
{
die("Connect Fail:" . mysql_error());
}
$db_select = mysql_select_db($dbname, $con);
if (!$db_select)
{
die ("DB Select fail:" . mysql_error());
}
$pdfName= mysql_real_escape_string($_FILES["pdf"]["name"]);
$pdfData= mysql_real_escape_string(file_get_contents($_FILES["pdf"]["tmp_name"]));
$pdfType= mysql_real_escape_string($_FILES["pdf"]["type"]);
//echo $pdfData;
if(substr($pdfType,0,15) == "application/pdf")
{
echo "working code";
$sqlquery="INSERT INTO blob1 VALUES ('',$pdfName,$pdfData)";
if ($results = mysql_query($sqlquery))
{
$numrows = mysql_affected_rows();
echo 'affected rows: ' .$numrows;
$event = stripslashes($event);
} else
{
echo 'MySQL Error (' .mysql_errno(). '): ' .mysql_error();
}
echo "<hr>$sqlquery<hr>";
}
else
{
echo "only pdf allowed!!";
}
mysql_query($sqlquery) or die('<p>Error, query failed');
}
?>
</body>
</html>
the connection worksfine, but the table blob1 doesnt update
please help