I don't think my form is parsing the php code. Though,
I'm not getting any errors, I should see a detailed
message confirming the file i've uploaded and I should
see my sql table updated with this information. If
anything, I should see mysql errors if there is a
connection problem. Niether of these things is
happening.
There is obviously a communication problem between the
html and the php. Can someone take a look here to see
if there is something missing?
<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
<html>
<head>
<title>Listing 13.1 Opening a Connection to a
Database</title>
</head>
<body>
<form enctype="multipart/form-data"
name="frmUploadFile" action="<?PHP echo $me;?>">
<?php
print "<form method='post'
action='{$_SERVER['PHP_SELF']}'>";
?>
<a href="http://www.devarticles.com";>
<img border="0"
src="http://www.devarticles.com/dlogo.gif";>
</a>
<table border="0" cellpadding="0" cellspacing="0"
bordercolor="#111111" width="100%">
<tr>
<td width="100%" bgcolor="#FF9900" height="22"
colspan="2">
<p style="margin-left: 10"><b><font face="Verdana"
size="2" color="#FFFFFF">
Upload a File</font></b></td>
</tr>
<tr>
<td width="100%" bgcolor="#FFE3BB" colspan="2">
<p style="margin-left: 10; margin-right: 10"><font
face="Verdana" size="2">
<br>Please select a file from your local computer to
upload to our web server
for saving in our database. This file can be of any
type you like. Once you
have chosen a file, please click on the "Upload
this file" button below.
<br> </font></td>
</tr>
<tr>
<td width="15%" bgcolor="#FFE3BB">
<p style="margin-left: 10"><font face="Verdana"
size="2">
File Description:</font></td>
<td width="85%" bgcolor="#FFE3BB">
<input type="text" name="strDesc" size="20"
maxlength="50"></td>
</tr>
<tr>
<td width="15%" bgcolor="#FFE3BB">
<p style="margin-left: 10"><font face="Verdana"
size="2">File Location:</font></td>
<td width="85%" bgcolor="#FFE3BB">
<font face="Verdana" size="2">
<input type="file" name="fileUpload"
size="20"></font></td>
</tr>
<tr>
<td width="33%" bgcolor="#FFE3BB">
<p style="margin-left: 10"><font face="Verdana"
size="2">
<br>
<br>
</font></td>
<td width="67%" bgcolor="#FFE3BB">
<font face="Verdana" size="2">
<input type="submit" value="Upload this file"
name="cmdSubmit"></font></td>
</tr>
</table>
</form>
<?php
//} else {
// GrabFile.php: Takes the details
// of the new file posted as part
// of the form and adds it to the
// myBlobs table of our myFiles DB.
global $strDesc;
global $fileUpload;
global $fileUpload_name;
global $fileUpload_size;
global $fileUpload_type;
// Make sure both a description and
// file have been entered
if(empty($strDesc) || $fileUpload == "none")
die("You must enter both a description and file");
// Database connection variables
$dbServer = "localhost";
$dbDatabase = "myfiles";
$dbUser = "";
$dbPass = "";
$fileHandle = fopen($fileUpload, "r");
$fileContent = fread($fileHandle, $fileUpload_size);
$fileContent = addslashes($fileContent);
$sConn = mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldn't connect to database server");
$dConn = mysql_select_db($dbDatabase, $sConn)
or die("Couldn't connect to database $dbDatabase");
$dbQuery = "INSERT INTO myBlobs VALUES ";
$dbQuery .= "(0, '$strDesc', '$fileContent',
'$fileUpload_type')";
mysql_query($dbQuery) or die("Couldn't add file to
database");
echo "<h1>File Uploaded</h1>";
echo "The details of the uploaded file are shown
below:<br><br>";
echo "<b>File name:</b> $fileUpload_name <br>";
echo "<b>File type:</b> $fileUpload_type <br>";
echo "<b>File size:</b> $fileUpload_size <br>";
echo "<b>Uploaded to:</b> $fileUpload <br><br>";
echo "<a href='uploadfile.php'>Add Another File</a>";
//}
?>
</body>
</html>
=====
Patrick Roane
Web design and development
www.franklin-band.com
Fox River Grove, Il.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
![http://www.devarticles.com/dlogo.gif"](http://www.devarticles.com/dlogo.gif"){kind=link}