Difficulty in inserting to a MySQL database

bobjob

Hello!

I am having trouble with inserting fields from an HTML form to a MySQL database. Briefly, the objective is to allow a user to upload files to a temporary directory on my server, and then insert the details of the file, as well as the file itself (field BLO😎 to a mysql database called Resource, table name: resource_details.

Below are snippets of my code. An echo message is returned to verify the database has been connected, and also an extra row is added, only to have the ID field there (by auto icrement) All the rest of the fields remain empty.

My code is as follows

<HTML>
<HEAD><TITLE>INSERT Data via PHP</TITLE></HEAD><BODY>

<?PHP

$connection=mysql_connect("localhost","root","") or die('Could not connect to the database server');
$db = mysql_select_db("Resource", $connection) or die ("Unable to select database.");

$userfile_name = $FILES['fileupload']['name'][0];
$userfile_tmp = $FILES['fileupload']['tmp_name'][0];
$filedir = "c:\program files\apache group\apache2\htdocs\Up_files\";

$location = "$filedir/$userfile_tmp";

$fileHandle = fopen($location, "rb");

$fileContent = fread ($fileHandle, $fileupload_size);

$fileContent = addslashes($fileContent);
$sql = "INSERT INTO resource_details VALUES ('$resource_id', '$name', '$file_type', '$title', '$language', '$author', '$keyword_1', '$keyword_2', '$keyword_3', '$original_date', '$fileContent')";
$sql_result = mysql_query($sql,$connection) or die ('Could not insert data');
echo('Data inserted successfully.');

mysql_close($connection);

</form>

</BODY>
</HTML>

Any help would be much appreciated.

Cheers

sleeping_sloth

Alright bud,

I think your problem lies in your INSERT INTO line - you've forgotten to add the field names to insert into.

INSERT INTO resource_details(resource_id,name,file_type,title,language,author...... etc etc) VALUES ('$resource_id', '$name', '$file_type', '$title', '$language', '$author', '$keyword_1', '$keyword_2', '$keyword_3', '$original_date', '$fileContent')";

The field names are whatever the field names in your SQL database are called.

Hope this helps,
Sleeping_Sloth

sgoku01

You have to specify which rows you want to add information to.
Like this:

$sql = "INSERT INTO resource_details (id, name, type, title, etc) VALUES ('$resource_id', '$name', '$file_type', '$title', '$language', '$author', '$keyword_1', '$keyword_2', '$keyword_3', '$original_date', '$fileContent')";

bobjob

Thank you both. Unfortunately I have already tried that - and it still didnt work.

I did try something else though, which solved my problem - I had forgotten to put the POST expressions which obtain the values from the form handler. For example for 'name' I added the expression $name=$_POST['name'];

and it worked.

I got another problem now, all the values get passed into the database fine, BUT the fileContent does not get added to the BLOB field. Any ideas why that is? I have used the relevant:
fopen(), fread() and addSlashes() functions, but to no avail.

I have two choices now, I can find a solution for this problem, or place a pointer in the database that directs me to the directory where the file has been uploaded. Any advice will be much appreciated, as well as if anybody has ready made scripts for downloading files either contained within a DB or a file that has to be referenced via the DB

Cheers