cant inert image into mysql

tbobker

i cant get my image into mysql, have tried everything and it simply wont work. I have specified the enctype="multipart/form-data" in the form but here is my code to insert into the database, there are other input fields which i am trying to submit at the same time:

<?php
    // User details can be amended through this script

session_start();
include("dbconnect.inc");

if ($_POST[submit]){

$file = fopen($_FILES['new_image']['tmp_name']); 
$imagefile = addslashes(fread(fopen($file, "r"), filesize($file)));

$sql = "insert into student values('$_POST[new_user]', '$_POST[new_pass]','$_POST[new_fristname]','$_POST[new_lastname]','$_POST[new_DOB]','$_POST[new_house]','$_POST[new_town]','$_POST[new_county]','$_POST[new_country]','$_POST[new_postcode]','$imagefile');";

$result = mysql_query($sql,$conn);

?>

help would be appreciated.

dschreck

are you trying to insert file into a blob?

The way you handle uploaded images is as follows:

if(is_uploaded_file($_FILES['file']['tmp_name'])) { // that means it's up

   $mySavePath = "/upload/images/".$_FILES['file']['name'];

   if(move_uploaded_file($_FILES['file']['tmp_name'], $mySavePath)) { 
            // and that means we can actually store it in a safe location
                                @chmod($mySavePath, 0644);
           // changed the chmod on it so I can delete it later if I want. 
          // here is where you'd preform any actions to take upon successfully
        // uploading a file.
   }
}

And then what I do, is I insert into the DB the direct file path so I can make image links later on.
A good idea would be to have a table named files or images or something of the like, and store all of the files you upload there. And then just use the id numbers to reference to other items.

Point being here, is that you have to upload the image and store it on your server, unless you wanna try the blob technique, which I wouldn't.

tbobker

Thanks for the quick reply, but have you done it to upload into a directory on the server or does it get uploaded to a tempary file then from there into the database.

Thanks for the help.