uploading multiple files path in the database
Posted: Tue Jan 16, 2007 1:43 pm
i want to upload multiples file path in the database the problem is that it is not updating anything but it is not displaying anything saying what the problem is here is my code
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']));
$fullpath = $uploaddir . $uploadfile1;
$filename1=$_POST['name']. "1";
$result= move_uploaded_file($_FILES['picture1']['tmp_name'], $fullpath."/". "$filename1");
if($result==1)
{
$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',
'$fullpath','$Headline','$Slogan2','$Description1',
'$Description2','$Description3','$fullpath','$fullpath','$User_Name','$Password')";
$result = mysql_query($sql) or die("SQL Error: $sql<br>" . mysql_error());
echo "picture1 front of business 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)
{
$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')";
$result = mysql_query($sql) or die("SQL Error: $sql<br>" . mysql_error());
echo " <br> Picture2 uploaded";
}
}