by dummydeveloper » 18. October 2012 18:55
As I mentioned before I must provide the source code clarifying the issue so:
------------------------------------------------------------------------------------------
<HTML>
<BODY text="#000000" bgcolor="wheat">
<h1><p align="center"><font face="Verdana">Inserting File in DataBase</h1></font></p>
<hr>
<?php
$name = $_FILES['myfile']['name'];
$type = $_FILES['myfile']['type'];
$size = $_FILES['myfile']['size'];
$temp = $_FILES['myfile']['tmp_name'];
$fp = fopen($temp, 'r');
$data = fread($fp, filesize($temp));
$data = addslashes($data);
fclose($fp);
?>
<font face="Verdana">
<?php
echo "file name: "; echo $name; echo "<br>";
echo "file type: "; echo $type; echo "<br>";
echo "file size: "; echo $size; echo "<br>";
echo "temp location: "; echo $temp ; echo "";
?>
<br>
</font>
<hr>
<?php
if (($name and $type and $data and $size and $temp) <> NULL)
{
$curdate = date('Y/m/d H:i');
// $curdate = "Europe/Athens";
$db = mysql_connect("localhost", "root", "");
mysql_select_db("alpha", $db) or die(mysql_errno() . ": " . mysql_error() . "<br>");
$qry = "insert into myfiles (name, type, size, date, data) values
(\"$name\", \"$type\", \"$size\", \"$curdate\", \"$data\")";
mysql_query($qry) or die("Error... Query Failed!"); echo "<br>";
echo "<p align = \"center\"><font face =\"VERDANA\" color=\"GREEN\">Record Inserted</font><hr>";
echo "</p>";
echo "<br>";
//mysql_free_result($result);
mysql_close($db);
echo "<p align=\"center\">";
echo "<a href=\"select_file.php\"><img src=\"rewind.jpg\"></a>";
echo "</p>";
}
else
{
echo "<p align = \"center\"><font face =\"VERDANA\" color=\"RED\">Unable to Insert Record<hr></font></p>";
echo "<font color=\"BLUE\"<hr>$data</font><hr>";
echo "<p align=\"center\">"; echo "<br>";
echo "<a href=\"select_file.php\"><img src=\"rewind.jpg\"></a>";
echo "</p>";
}
?>
</BODY>
</HTML>
-----------------------------------------------------------------------------------------
the calling script is:
------------------------
HTML>
<BODY text="#000000" bgcolor="wheat">
<h1><p align="center"><font face="Verdana">Select</h1></font></p>
<hr>
<p align = "center">
<font face= "Verdana">
Max File Size Allowed for Upload up to 40 MB
<FORM METHOD= "post" ACTION= "insert_file.php" ENCTYPE= "multipart/form-data">
<INPUT TYPE = "hidden" NAME= "MAX_FILE_SIZE" VALUE = "20000000">
<INPUT TYPE = "hidden" NAME= "action" VALUE = "upload">
<TABLE BORDER = "6" bgcolor="pink">
<TR>
<TR>
<TD>File</TD>
<TD>
<?php
echo "<INPUT TYPE = \"file\" NAME= \"myfile\">";
?>
</TD>
</TR>
<TR>
<TD COLSPAN = "10"> <p align = "center"> <INPUT TYPE = "submit" VALUE = "Upload"> </p> </TD>
</TR>
</TABLE>
</FORM>
</font>
</p>
</BODY>
</HTML>
--------------------------
the deriving msg is: My SQL Server has gone away in line ......