saving multiple files path in the database
Posted: Wed Jan 17, 2007 9:58 am
ok, i have a code that uploads multiple files it works if i use is_uploaded_file() but it send the files to diffrent rows which means i will have diffrent ID. when i use move_uploaded_file() which is the one i need then i doest upload anything iit says it did but when i look in the database there is nothing there
PLEASE HELP
PLEASE HELP
Code: Select all
$uploaddir = '/home/townsfin/public_html/business_images/';
$uploadfile1 = $_FILES['Picture1']['name'];
if(isset ($_FILES['Picture1']))
{
If (is_uploaded_file($_FILES['Picture1']['tmp_name'])&&
is_uploaded_file($_FILES['Picture2']['tmp_name']));
$fullpath1 = $uploaddir . $uploadfile1;
$filename1=$_POST['name']. "1";
$result= move_uploaded_file($_FILES['Picture1']['tmp_name'], $fullpath1. "$filename1");
if($result==1)
{
echo"picture one uploaded";
}
$uploadfile2= $_FILES['Picture2']['name'];
$fullpath2=$uploaddir . $uploadfile2;
$filename2= $_POST['name']. "2";
$result = move_uploaded_file($_FILES['Picture2']['tmp_name'], $fullpath. "$filename2");
if ($result==1)
{
echo"Picture2 uploaded";
}
If (is_uploaded_file ($_FILES['Picture1']['tmp_name']) &&
($_FILES['Picture2']['tmp_name']))
{
$sql="INSERT INTO `business_info`(`BusinessName`,`Slogan`,`Business_Address`,`Tel`,`Website`,`Email`,
`Fax`,`type`,`make`,`Categories`,`Keyword`,`Picture1`,`Headline`,`Slogan2`,`Description1`,`Description2`,`Description3`,
`Picture2`,`Picture3`,`User_Name`,`Password`)
Values('$BusinessName','$Slogan','$Business_Address','$Tel','$Website','$Email','$Fax','$type','$make','$Categories','$Keyword',
'$fullpath1','$Headline','$Slogan2','$Description1',
'$Description2','$Description3','$fullpath2','$fullpath1','$User_Name','$Password')";
}
}
?>