[RESOLVED] Help placing file name in database

mjgdunne

Hi all, i have a script which uploads images to the server, and sends attributes of car name, car make, car registration to the database, i need now to be able to store some kind of link to the image stored.
Any help would be great, thanks.
Here is my upload code:


<form enctype="multipart/form-data" action="upload.php" method="post" name="upload_file">
<input type="hidden" name="MAX_FILE_SIZE" value="5000000">

Please enter the car make: <input name=mymake><br>
Please enter the car model: <input name=mymodel><br>
Please enter the car registration: <input name=myreg><br>
Please select an image to upload:
<input name="userfile" type="file"></br>

<input type="submit" value="upload" name="file_uploaded">

</form>

Here is my code which places the details into the database and places the image on the server.

<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="root"; // Mysql password
$db_name="test"; // Database name
$tbl_name="reff"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "root", "root")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");



$mymake=$_POST['mymake'];
$mymake=$_POST['mymodel'];
$myreg=$_POST['myreg'];
$userfile=$_POST['userfile'];


mysql_select_db("test");
 $result = mysql_query("INSERT INTO reff (make, model, registration, imgdata)
  VALUES ('$_POST[mymake]', '$_POST[mymodel]', '$_POST[myreg]', '$_POST[userfile]')");



if (is_uploaded_file($_FILES['userfile']['tmp_name']))
{
$file_realname = $_FILES['userfile']['name'];
copy($_FILES['userfile']['tmp_name'], realpath("upload").trim($file_realname));
}
else
{
echo "<b><font color=red>No file uploaded.</font></b><BR>No file available or file too big to upload.";
}
echo $file_realname;
?>

Neumy

It sounds like you need to add another field to your DB called image where you store the path. My suggestion would be to do all your file upload first, save the path/filename, and insert into the DB. That way, if there is an error on upload, you can dynamically adjust the DB insert accordingly.

mjgdunne

Hi Neumy, i have the upload working, the image goes to the directory and the details go to the database, what kind of field would i use, a text?

Neumy

Hey mjgdunne,

It all depends on what your path/filename length is. I would use a Var with about 50-100 (depending on how long of filename you want to allow).

Example:
I'll assume you'll have an image directory where you store things off root like: "images/carpics"
And if the picture uploaded is: "this_is_my_car_pic.png"
So, the stored data would be: "images/carpics/this_is_my_car_pic.png" (length = 37).
Or since we know the image directory will never change: "this_is_my_car_pic.png" (length = 22)
When you call your image:
<img src='<?=$db_path_filename>?>'> OR <img src='images/carpics/<?=$db_filename?>'>

Hopefully that helps.

mjgdunne

Hi, i have changed my code, and i have the details saving to the database, the image uploading into the directory, i now have the image field in the database, my problem is that it is only saving the image name to the database and not the location, any suggestions?
Thanks.

<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="root"; // Mysql password
$db_name="test"; // Database name
$tbl_name="reff"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "root", "root")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");



$mymake=$_POST['mymake'];
$mymake=$_POST['mymodel'];
$myreg=$_POST['myreg'];



if (is_uploaded_file($_FILES['userfile']['tmp_name']))
{
$file_realname = $_FILES['userfile']['name'];
copy($_FILES['userfile']['tmp_name'], realpath("upload").trim($file_realname));
}
else
{
echo "<b><font color=red>No file uploaded.</font></b><BR>No file available or file too big to upload.";
}
echo $file_realname;


mysql_select_db("test");
 $result = mysql_query("INSERT INTO reff (make, model, registration, image)
  VALUES ('$_POST[mymake]', '$_POST[mymodel]', '$_POST[myreg]', '$file_realname')");


?>

mjgdunne

OK i got the file name saving to the database now is used:

$result = mysql_query("INSERT INTO reff (make, model, registration, image)
VALUES ('$POST[mymake]', '$POST[mymodel]', '$_POST[myreg]', '$file_realname')");

Now when i search for the car by make or model i want the image uploaded displyed, so i my question is how to code in a static file path?