[RESOLVED] Add image upload to already existing form

[Pineapple]

Hi all PHPBuilders,

This is my first post, great forum 🙂

I have a form that is adding a product to my database. Does somebody knows how to add a "uploading script" so that i don't have to upload the images manually?

This is the form:
<form action="insert.php" method="post">
<b>Title: <input type="text" name="title" /></b><br /><br />
<b>Text: <input type="text" name="body" /></b><br /><br />
<b>Price: <input type="text" name="price" /></b><br /><br />
<b>Image: <input type="text" name="image" /></b><br /><br />
<input type="submit" value="Add produkt"/>
</form>

This is insert.php:
$sql="INSERT INTO products (title, body, price, image)
VALUES
('$POST[title]','$POST[body]','$POST[price]','$POST[image]')";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 product added";

Best regards,
Martin

[nevvermind]

You're script is as closest as can be to an "uploading script". At some point or another, you'll need to manually input your products, be it title, price etc. The problem is choosing the right method to populate your database. What's wrong with yours?

[Pineapple]

And how do I do that? Sorry but I'm a big noob...

[nevvermind]

Ah, sorry. I've misread your post. You want images. Well, images can be stored in a mysql database. Get your coffee, shut your door, throw your dog outside and start reading: link.

[Pineapple]

That's all right... Is there a more easy way to do it perhaps?

I have my coffee, my door is closed and i have no dog :-)

[bradgrafelman]

There are many people out there (me included) that disagree with the method of storing images in the SQL server itself.

Instead, look at some simple file upload examples (including the PHP manual: [man]features.file-upload[/man]) to understand how that works in PHP. Then, all you'd need to do is move the uploaded file(s) to whatever location you'd like and then store the filename/path in the DB along with all of the other data.

[Pineapple]

The thing I want is: Image uploaded to /upload/ folder, and the path written to the database...

Is there a easy/noob method to do that?

[mykg4orce]

I think you should just come out and ask for someone to give you the code.

Agree with previous poster, storing images in database, not a desired situation.

first of all make sure your form tag looks like this:

<form action="insert.php" method="post" enctype="multipart/form-data">

next you will need a file upload input field:

<input id="myfile" name="myfile" type="file" />

then in your insert.php file you are going to do this:

/*
you also need to store the file name into mysql
so create a file name variable
basename is a php function and will give you just the file name
*/
$filename = basename($_FILES['myfile']['name']);


/*
$_FILES['myfile'] is the name of the input field
/upload is the path to the upload directory
*/
move_uploaded_file($_FILES['myfile']['tmp_name'], "/upload")

This is a very dirty example with no validation or qualification. But you asked for a "easier way".

[Pineapple]

Hej everybody,

Thanks for your help so far. I found a tutorial and the upload to the folder now works.

My insert.php file is like this:

define ("MAX_SIZE","10000"); 

function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}

$errors=0;
if(isset($_POST['Submit'])) 
{
$image=$_FILES['image']['name'];
if ($image) 
{
$filename = stripslashes($_FILES['image']['name']);
$extension = getExtension($filename);
$extension = strtolower($extension);
if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))    

{
echo '<h1>Unknown fileex.!</h1>';
$errors=1;
}
else
{
$size=filesize($_FILES['image']['tmp_name']);

if ($size > MAX_SIZE*1024)
{
echo '<h1>The image is too big!</h1>';
$errors=1;
}

$image_name=time().'.'.$extension;
$newname="images/".$image_name;
$copied = copy($_FILES['image']['tmp_name'], $newname);
if (!$copied) 
{
echo '<h1>Could not upload!</h1>';
$errors=1;
}}}}

if(isset($_POST['Submit']) && !$errors) 
{
echo "<h1>Image is uploaded!</h1>";
}

$sql="INSERT INTO products (title, body, price, image)
VALUES
('$_POST[title]','$_POST[body]','$_POST[price]','$_POST[image]')";

if (!mysql_query($sql,$con))
  {
  die('Fejl: ' . mysql_error());
  }
echo "1 product added"; 

The only thing is miss now is that the filename (f.eks. 1283931724.jpg) could write it to the database.

The "image" filed in the database is empty :-(

Thanks again for all your help so far!

[nevvermind]

// hope I'm not mistaken

// I don't think there's a $_POST[image]. There's this, though: 
$image = $_FILES['image']['name']; 
// or this:
$filename = stripslashes($_FILES['image']['name']);

// query should look like this:
$sql="INSERT INTO products (title, body, price, image)
VALUES
('$_POST[title]','$_POST[body]','$_POST[price]','$filename')";

[Pineapple]

Thank you SO much for your help. It works fine...

[nevvermind]

If you're done, select "Thread Resolved" from "Thread Tools" above.