Upload Files

[emediastudios]

Hi,

Can someone please help, i want to upload 3 images, this is a code i got off the net but only uploads one file, (photo)

I have 2 new fields in my sql file called photo2 and photo3, the image names and all other information from the form get sent successfully , but i cannot work out how to upload the other 2 files,

My field is called photo in my sql database but the code below uses the word (pic) i dont know why as i never wrote it but it works.

 

i have this code i use in my add property file...

 

<?php

 

//This is the directory where images will be saved

$target = "../images/";

$target = $target . basename( $_FILES['photo']['name']);

 

 

//This gets all the other information from the form

$name=$_POST['name'];

$suburb=$_POST['suburb'];

$price=$_POST['price'];

$content=$_POST['content'];

$photo2=$_FILES['photo2']['name'];

$photo3=$_FILES['photo3']['name'];

$pic=($_FILES['photo']['name']);

 

 

// Connects to your Database

mysql_connect("localhost", "root", "**********") or die(mysql_error()) ;

mysql_select_db("gcproperty") or die(mysql_error()) ;

 

//Writes the information to the database

mysql_query("INSERT INTO `employees` VALUES ('$name', '$suburb', '$price', '$content', '$pic', '$photo2', '$photo3')") ;

 

//Writes the photo to the server

if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))

{

 

 

//Tells you if its all ok

print "<meta http-equiv=\"refresh\" content=\"0;URL=property_added_successfully.php\">";

}

else {

 

//Gives and error if its not

echo "Sorry, there was a problem uploading your file.";

}

?>

[benjaminbeazy]

it only works on the first phot because that's the only one specificed to move to your target folder, found here in your code...

 

if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 

 

the code you have now is rather vulerable to mysql injection among other things, because you have no sort of filters for your photos and data input. but i'm too tired to go into that. try the code below. if it doesn't work, just copy the if else statement above (the WHOLE thing, including the else, "sorry...problem", and closing brace. and just change 'photo' to 'photo2', etc..

 

 

 

<?php

//This is the directory where images will be saved
$target = "../images/";
$target = $target . basename( $_FILES['photo']['name']);


//This gets all the other information from the form
$name=$_POST['name'];
$suburb=$_POST['suburb'];
$price=$_POST['price'];
$content=$_POST['content'];
$photo2=$_FILES['photo2']['name'];
$photo3=$_FILES['photo3']['name'];
$pic=($_FILES['photo']['name']);


// Connects to your Database
mysql_connect("localhost", "root", "**********") or die(mysql_error()) ;
mysql_select_db("gcproperty") or die(mysql_error()) ;

//Writes the information to the database
mysql_query("INSERT INTO `employees` VALUES ('$name', '$suburb', '$price', '$content', '$pic', '$photo2', '$photo3')") ;

//Writes the photo to the server
foreach($_FILES as $val){
  if(!move_uploaded_file($_FILES[$val]['tmp_name'], $target)){
    $error = yes;
  }
}

if($error){
  //Tells you if its all ok
  print "<meta http-equiv=\"refresh\" content=\"0;URL=property_added_successfully.php\">";
} else {
  //Gives and error if its not
  echo "Sorry, there was a problem uploading your file.";
}
?>

[emediastudios]

Hi there Ben

Used the code, it goes to the successful page, but doesn’t upload the files, i get a white page with some code just after i hit the submit button but is to quick to read.

Thanks for your help, im still stuck

 

[emediastudios]

Hey ben

I Know it only works on the first phot because that's the only one specificed to move to your target folder, do you know an easy way to alter the code to include the other 2 files (photo2 and photo3) i will add some filters after i get the code working.

Thanks for your help, is one of the the last problems i have in this project im doing, if you can help me i am willing to pay you, or donate to this site.

Really want to wrap this up.

 

it only works on the first phot because that's the only one specificed to move to your target folder, found here in your code...

 

if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 

 

the code you have now is rather vulerable to mysql injection among other things, because you have no sort of filters for your photos and data input. but i'm too tired to go into that. try the code below. if it doesn't work, just copy the if else statement above (the WHOLE thing, including the else, "sorry...problem", and closing brace. and just change 'photo' to 'photo2', etc..

 

 

 

<?php

//This is the directory where images will be saved
$target = "../images/";
$target = $target . basename( $_FILES['photo']['name']);


//This gets all the other information from the form
$name=$_POST['name'];
$suburb=$_POST['suburb'];
$price=$_POST['price'];
$content=$_POST['content'];
$photo2=$_FILES['photo2']['name'];
$photo3=$_FILES['photo3']['name'];
$pic=($_FILES['photo']['name']);


// Connects to your Database
mysql_connect("localhost", "root", "**********") or die(mysql_error()) ;
mysql_select_db("gcproperty") or die(mysql_error()) ;

//Writes the information to the database
mysql_query("INSERT INTO `employees` VALUES ('$name', '$suburb', '$price', '$content', '$pic', '$photo2', '$photo3')") ;

//Writes the photo to the server
foreach($_FILES as $val){
  if(!move_uploaded_file($_FILES[$val]['tmp_name'], $target)){
    $error = yes;
  }
}

if($error){
  //Tells you if its all ok
  print "<meta http-equiv=\"refresh\" content=\"0;URL=property_added_successfully.php\">";
} else {
  //Gives and error if its not
  echo "Sorry, there was a problem uploading your file.";
}
?>