The following is the PHP section of the file.
Code: Select all
<?php
require_once "FCKeditor/fckeditor.php";
if(isset($_REQUEST['btnSubmit'])){
$bool=false;
$class->begin();
$prID=$class->getMaximum("prID","ver_pro")+1;
$cID=$_REQUEST['subjects'];
$pID=$_REQUEST['links'];
$mID=1;
$name=$class->sql_quote($_REQUEST['name']);
$avail=$class->sql_quote($_REQUEST['avail']);
$prCode=$class->sql_quote($_REQUEST['prCode']);
$price=$class->sql_quote($_REQUEST['price']);
if($_FILES['ImageFile']['name']!=''){
$image_path=$_FILES['ImageFile']['name'];
}else{
$image_path="default1.gif";
}
$description=$class->sql_quote($_REQUEST['description']);
$stitle=$class->sql_quote($_REQUEST['stitle']);
$sdescription=$class->sql_quote($_REQUEST['sdescription']);
$skeywords=$class->sql_quote($_REQUEST['skeywords']);
$active=1;
$otherpro = $_POST['otherproduct'];
$temp_gallery ="../upload/tmp/";
$target_dir ="../upload/";
$query="INSERT INTO ver_pro(prID,cID,pID,mID,name,avail,prCode,price,image_path,description,active,stitle,sdescription,skeywords)
VALUES('".$prID."','".$cID."','".$pID."','".$mID."','".$name."','".$avail."','".$prCode."','".$price."','".$image_path."','".$description."','".$active."','".$stitle."','".$sdescription."','".$skeywords."')";
/*echo $query;
die();*/
if($class->executeQuery($query)==false) $bool=true;
if($bool==true){
$class->rollback();
header("Location: index.php?cmd=11&error=0");
exit;
}else{
$class->commit();
if($_FILES['ImageFile']['name']!=''){
$file1=$temp_gallery.$ID.$_FILES[ImageFile][name];
move_uploaded_file ($_FILES[ImageFile][tmp_name],$file1);
include_once("resizeimage.inc.php");
$rimg=new RESIZEIMAGE($temp_gallery.basename($file1));
echo $rimg->error();
$rimg->resize(300,240,$target_dir."1_".basename($file1));
$filename = $target_dir."2_".basename($file1);
copy($file1, $filename);
//$rimg->resize($target_dir."/3_".basename($file));
@unlink($temp_gallery.basename($file1));
$rimg->close();
}
$sSQL = "INSERT INTO ver_otherpro (prCode, prOther) values ";
$bAppened = FALSE;
foreach($otherpro as $other)
{
if ($bAppened)
$sSQL .= ',';
else
$bAppened = TRUE;
$sSQL .= "('".$prCode."','".$other."')";
}
if($class->executeQuery($sSQL)==false) $bool=true;
if($bool==true){
$class->rollback();
}else{
$class->commit();
}
header("Location: index.php?cmd=11&err=1");
exit;
}//end of if
}
?>
Basically I'm not sure how to go about getting the code in the above file working in the same way the files in the .zip from the image thread work.
Any help I'd really appriciate!
Aravona