Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

A very small PHP error...


ComicWisdom

Recommended Posts

I am trying to get this to upload the image location to:

 

movies/"category"/ "imagename"

 

For some reason that I can't seemto find, it is uploading the image location to:

 

store//movies/"category"/"imagename"

 

Can someone with a sharp eye find the error. I've looked and searched for a couple of hours now, but it escapes me?

 

I know this is a long piece of code, and I thank anyone who looks at it for me.

 

 

<?php

 

require('includes/application_top.php');

set_time_limit(0);

 

$Esc="\t";

$CR="\n";

 

/*======================================== E.X.P.O.R.T.E.R START==============================================*/

if ($status){

 

$col1="Manufacturer Name";

$col2="Manufacturer Image";

$col3="Main Category";

$col4="Sub Categories";

$col5="Sub Sub Categories";

$col6="Product Model";

$col7="Product Image";

$col8="Product Price";

$col9="Product Weight";

$col10="Product Name";

$col11="Product Description";

 

$head=$col1." ".$col2." ".$col3." ".$col4." ".$col5." ".$col6." ".$col7." ".$col8." ".$col9." ".$col10." ".$col11."\n";

 

$ProdSql="select manufacturers_name, manufacturers_image, products_model, substring(products_image,locate('/',products_image)+1, length(products_image)) products_image, products_price, products_weight, products_name, products_description ";

$ProdSql.="from products a, products_description b, products_to_categories c , manufacturers d where c.products_id=a.products_id";

$ProdSql.=" and a.products_id=b.products_id and d.manufacturers_id=a.manufacturers_id and c.categories_id=";

 

 

$CatList="";

 

$CatList=$head;

 

 

$res1=tep_db_query("select a.categories_id categories_id, categories_name from categories a, categories_description b where a.categories_id=b.categories_id and parent_id=0");

 

while ($cat1=tep_db_fetch_array($res1)){

 

$res2=tep_db_query("select a.categories_id categories_id, categories_name from categories a, categories_description b where a.categories_id=b.categories_id and parent_id=".$cat1["categories_id"]);

 

if (tep_db_num_rows($res2)>0){

while ($cat2=tep_db_fetch_array($res2)){

 

 

 

$res3=tep_db_query("select a.categories_id categories_id, categories_name from categories a, categories_description b where a.categories_id=b.categories_id and parent_id=".$cat2["categories_id"]);

if (tep_db_num_rows($res3)>0){

while ($cat3=tep_db_fetch_array($res3)){

 

 

$Pres3=tep_db_query($ProdSql.$cat3['categories_id']);

if (tep_db_num_rows($Pres3)){

while ($prod3=tep_db_fetch_array($Pres3)){

 

$manufacturer=$prod3['manufacturers_name'];

$CatList.=$prod3['manufacturers_name'].$Esc.$prod3['manufacturers_image'].$Esc.$cat1['categories_name'].$Esc.$cat2['categories_name'].$Esc;

$CatList.=$cat3['categories_name'].$Esc.$prod3['products_model'].$Esc.$prod3['products_image'].$Esc;

$CatList.=$prod3['products_price'].$Esc.$prod3['products_weight'].$Esc.$prod3['products_name'].$Esc;

$CatList.=$prod3['products_description'].$CR;

}

}else{

$CatList.=$cat1['categories_name'].$Esc. $cat2['categories_name'].$Esc.$cat3['categories_name'].$CR;

}

 

}

}else{

 

$Pres2=tep_db_query($ProdSql.$cat2['categories_id']);

if (tep_db_num_rows($Pres2)){

while ($prod2=tep_db_fetch_array($Pres2)){

 

$manufacturer=$prod2['manufacturers_name'];

$CatList.=$prod2['manufacturers_name'].$Esc.$prod1['manufacturers_image'].$Esc.$cat1['categories_name'].$Esc.$cat2['categories_name'].$Esc;

$CatList.=$Esc.$prod2['products_model'].$Esc.$prod2['products_image'].$Esc;

$CatList.=$prod2['products_price'].$Esc.$prod2['products_weight'].$Esc.$prod2['products_name'].$Esc;

$CatList.=$prod2['products_description'].$CR;

 

 

}

}else{

$CatList.=$cat1['categories_name'].$Esc. $cat2['categories_name'].$CR;

}

}

 

}

}else{

 

$Pres1=tep_db_query($ProdSql.$cat1['categories_id']);

if (tep_db_num_rows($Pres1)){

while ($prod1=tep_db_fetch_array($Pres1)){

$manufacturer=$prod1['manufacturers_name'];

$CatList.=$prod1['manufacturers_name'].$Esc.$prod1['manufacturers_image'].$Esc.$cat1['categories_name'].$Esc.$Esc.$Esc;

$CatList.=$prod1['products_model'].$Esc.$prod1['products_image'].$Esc;

$CatList.=$prod1['products_price'].$Esc.$prod1['products_weight'].$Esc.$prod1['products_name'].$Esc;

$CatList.=$prod1['products_description'].$CR;

}

}else{

}

}

}

/* IF YOU WANT TO COPY THE EXPORTED DATA INTO SOME FILE,

UNCOMMENT THE FOLLOWING CODE AND MAKE CHANGES ACCORDING TO YOUR REQUIREMENTS*/

 

 

/*EXPORT DATA INTO A TAB DELIMETED TEXT FILE*/

/*$filename="full_data_export.txt";

$handle=fopen("full_data_export.txt",'w');

fwrite($handle,$CatList );

fclose($handle);

header("location:".$filename);

*/

 

}

/*======================================== E.X.P.O.R.T.E.R END==============================================*/

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

<script language="JavaScript" type="text/JavaScript">

<!--

function MM_reloadPage(init) { //reloads the window if Nav4 resized

if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {

document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}

else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();

}

MM_reloadPage(true);

//-->

</script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

 

<table border="0" width="100%" cellspacing="2" cellpadding="2">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top" height="27">

<table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php');?>

</table></td>

<td class="pageHeading" valign="top"><?php

echo "Manufacturers, Categories and Products import/export";

?>

 

<p class="smallText">

<?

 

function set_date($datepart){ //4/23/2001 9:26

 

//EXPLODE ON THE BASES OF SPACE FIRST

if (strstr($datepart,' ' )>0)

{

$exp1=explode(' ',$datepart);

 

$exp2=explode("/",$exp1[0]);

 

return $exp2[2]."-". $exp2[0]."-". $exp2[1]." ". $exp1[1];

}

else{

$exp2=explode("/",$datepart);

return $exp2[2]."-". $exp2[0]."-". $exp2[1];

}

}

 

function walk( $item1 ) {

 

 

$item1 = str_replace(' ','|',$item1);

// $item1 = str_replace(';"',';',$item1);

$item1 = str_replace('"','',$item1);

// $item1 = str_replace(',','.',$item1);

 

$item1 = str_replace("\n",'',$item1);

$item1 = str_replace("\r",'',$item1);

$item1 = str_replace("?",'',$item1); //DON'T KNOW WHAT THIS CHARACTER IS BUT FOUND IN DATA

$item1 = str_replace("?",'',$item1);

//$item1 = str_replace("?",'',$item1);

$item1 = str_replace('"','\"',$item1);

$item1 = str_replace("'",'\"',$item1);

 

//echo $item1."<br>";

$item1 = chop($item1);

//echo $item1."<br>";

$items = explode("|", $item1);

// echo $items[0];

 

 

/*$res=tep_db_query("select manufacturers_id id from manufacturers where manufacturers_name='".$_POST['man_id'] ."'");

$manid=tep_db_fetch_array($res);

*/

//echo strlen($items[1])."<br>";

 

 

 

$default_product_quantity=100;

 

$v_categories_date_added = date("Y-m-d"); //$items[0];//CATEGORIES.categories_date_added

//$v_categories_id = $items[0]; //CATEGORIES_DESCRIPTION.category_id

$v_language_id = 1; //$items[2];//CATEGORIES_DESCRIPTION.language_id //DEFAULT =1

 

// $v_categores_description = $items[2]; //CATEGORIES_DESCRIPTION.categories_name

$v_manufacturers_name = $items[0];

$v_manufacturers_image = $items[1];

$v_categores1_name = $items[2]; //CATEGORIES_DESCRIPTION.categories_name

$v_categores2_name = $items[3];

$v_categores3_name = $items[4];

 

$v_products_quantity = 0;//$items[4]; //PRODUCTS.products_quantity

$v_products_model = $items[5]; //PRODUCTS.products_model

$v_products_image = "movies/".$items[3].$items[6];//movies/category/products_image

$v_products_price = $items[7]; //PRODUCTS.products_price

$v_products_date_added = date("Y-m-d"); //set_date($items[5]); //PRODUCTS.products_date_added

$v_products_last_modified = date("Y-m-d"); //set_date($items[6]); //PRODUCTS.products_last_modified

$v_products_date_available = date("Y-m-d"); //set_date($items[7]); //PRODUCTS.products_date_available

$v_products_weight = $items[8]; //PRODUCTS.products_weight

$v_products_tax_class_id = 0;//$items[12]; //PRODUCTS.producst_tax_class_id

$v_manufacturers_id = $manid['id']; //$items[13];//PRODUCTS.manufacturers_id [USE THE DEFAULT ONE]

$v_products_name = $items[9]; //PRODUCTS_DESCRIPTION.products_name

$v_products_status = 1;//$items[15]; //PRODUCTS_DESCRIPTION.products_status

$v_products_description = $items[10]; //PRODUCTS_DESCRIPTION.products_status

 

if (strlen($items[0])<=1 && strlen($items[2])<=1){}

else{

 

 

if ($v_tax_class_id == '') {$v_tax_class_id = 0;}

if ($v_categores1_name==''){$v_categores1_name='Misc';};

//if ($v_categores2_name==''){$v_categores2_name='Misc';};

//if ($v_categores3_name==''){$v_categores3_name=$v_products_name;};

if ($v_products_quantity == '') {$v_products_quantity = $default_product_quantity;}

if ($v_products_quantity == ' ') {$v_products_quantity = $default_product_quantity;}

$catname.=$v_categores1_name." " . $v_categores2_name." ".$v_categores3_name."<br>";

// echo $v_categores1_name."<-->".$v_categores2_name."<-->".$v_categores3_name."\n";

//CHECK FOR MANUFACTURER

$man_res=tep_db_query("select * from manufacturers where manufacturers_name='".$v_manufacturers_name."'");

if (tep_db_num_rows($man_res)>0)

{

$manufacturer_id=tep_db_fetch_array($man_res);

$v_manufacturers_id=$manufacturer_id['manufacturers_id'];

}else{

tep_db_query("insert into manufacturers(manufacturers_name,manufacturers_image,date_added) values('".$v_manufacturers_name."','".$v_manufacturers_image."','".date(Y-m-d)."')");

$man_id=tep_db_query ("select max(manufacturers_id) manufacturers_id from manufacturers");

$manid=tep_db_fetch_array($man_id);

$v_manufacturers_id=$manid['manufacturers_id'];

}

 

 

/*=== CATEGORY LEVEL 1 START===*/

/*BEFORE INSERTING THE CATEGORY.. FIRST FIND OUT EITHER THE CATEGORY IS ALREADY IN DB OR NOT*/

$cat_count=tep_db_query("select a.* from categories_description a, categories b where categories_name='".$v_categores1_name."' and b.parent_id=0 and a.categories_id=b.categories_id");

 

//echo "select * from categories_description where categories_name='".$v_categores_name."'";

if (tep_db_num_rows($cat_count) != 0)

{

$catid=tep_db_fetch_array($cat_count);

$Category_id=$catid['categories_id'];

 

}else{

 

$cat_sql="insert into categories(date_added, parent_id) values ('". $v_categories_date_added."',0)";

tep_db_query($cat_sql);

 

$catid_sql=tep_db_query("select max(categories_id) categories_id from categories where date_added='".$v_categories_date_added."'");

$catid = tep_db_fetch_array($catid_sql);

 

$cat_desc_sql="insert into categories_description (categories_id,language_id,categories_name)values(".$catid['categories_id'].",".$v_language_id.",'".$v_categores1_name."')";

 

tep_db_query($cat_desc_sql);

$Category_id=$catid['categories_id'];

//$Progress.="Category Level1 inserted...\n";

}

$Parent1=$Category_id;

/*=== CATEGORY LEVEL 1 END===*/

 

/*=== CATEGORY LEVEL 2 START===*/

/*BEFORE INSERTING THE CATEGORY.. FIRST FIND OUT EITHER THE CATEGORY IS ALREADY IN DB OR NOT*/

 

if (strlen($v_categores2_name)>0){

//

$cat_count=tep_db_query("select b.* from categories_description b, categories a where categories_name='".$v_categores2_name."' and a.parent_id=".$Parent1." and a.categories_id=b.categories_id");

 

//echo "select b.* from categories_description b, categories a where categories_name='".$v_categores2_name."' and a.parent_id > 0 and a.categories_id=b.categories_id<br>";

if (tep_db_num_rows($cat_count) >=1)

{

$catid=tep_db_fetch_array($cat_count);

$Category_id=$catid['categories_id'];

 

}else{

//BEFORE INSERTING GET THE PARENT_ID

$parent_sql="select a.categories_id from categories_description a , categories b where categories_name='".$v_categores1_name."' and b.parent_id =0 and a.categories_id=b.categories_id";

//echo $parent_sql."<br>";

 

 

$parent_res=tep_db_query($parent_sql);

if (tep_db_num_rows($parent_res)<1){

$cat_sql="insert into categories(date_added, parent_id) values ('". $v_categories_date_added."',1)";

}else{;

$parent_id=tep_db_fetch_array($parent_res);

$cat_sql="insert into categories(date_added, parent_id) values ('". $v_categories_date_added."',".$parent_id['categories_id'].")";

}

 

//echo $cat_sql."-2-<br>";

tep_db_query($cat_sql);

 

$catid_sql=tep_db_query("select max(categories_id) categories_id from categories where date_added='".$v_categories_date_added."'");

$catid = tep_db_fetch_array($catid_sql);

 

$cat_desc_sql="insert into categories_description (categories_id,language_id,categories_name)values(".$catid['categories_id'].",".$v_language_id.",'".$v_categores2_name."')";

tep_db_query($cat_desc_sql);

$Category_id=$catid['categories_id'];

//$Progress.="Category Level2 inserted...\n";

}

$Parent2=$Category_id;

}

/*=== CATEGORY LEVEL 2 END===*/

 

/*=== CATEGORY LEVEL 3 START===*/

/*BEFORE INSERTING THE CATEGORY.. FIRST FIND OUT EITHER THE CATEGORY IS ALREADY IN DB OR NOT*/

if (strlen($v_categores3_name)>0){

$cat_count=tep_db_query("select b.* from categories_description b, categories a where categories_name='".$v_categores3_name."' and a.parent_id=".$Parent2." and a.categories_id=b.categories_id");

//echo "select b.* from categories_description b, categories a where categories_name='".$v_categores3_name."' and a.parent_id>0 and a.categories_id=b.categories_id<br>";

 

if (tep_db_num_rows($cat_count) >= 1)

{

$catid=tep_db_fetch_array($cat_count);

$Category_id=$catid['categories_id'];

 

}else{

//BEFORE INSERTING GET THE PARENT_ID

$parent_sql="select a.categories_id from categories_description a, categories b where categories_name='".$v_categores2_name."' and b.parent_id=".$Parent1." and a.categories_id=b.categories_id";

//echo $parent_sql."<br>";

$parent_res=tep_db_query($parent_sql);

$parent_id=tep_db_fetch_array($parent_res);

 

 

$cat_sql="insert into categories(date_added, parent_id) values ('". $v_categories_date_added."',".$parent_id['categories_id'].")";

 

tep_db_query($cat_sql);

 

$catid_sql=tep_db_query("select max(categories_id) categories_id from categories where date_added='".$v_categories_date_added."'");

$catid = tep_db_fetch_array($catid_sql);

 

$cat_desc_sql="insert into categories_description (categories_id,language_id,categories_name)values(".$catid['categories_id'].",".$v_language_id.",'".$v_categores3_name."')";

tep_db_query($cat_desc_sql);

$Category_id=$catid['categories_id'];

//$Progress.="Category Level3 inserted...\n";

 

}

}

/*=== CATEGORY LEVEL 3 END===*/

 

//echo $Progress;

 

 

$prod_sql="insert into products (products_quantity,products_model,products_image,products_price,products_date

_added, ";

$prod_sql.="products_last_modified,products_date_available,products_weight,products_stat

us,products_tax_class_id,manufacturers_id)";

$prod_sql.="values(".$v_products_quantity.",'".$v_products_model."','".$v_products_image."','".$v_products_price."','";

$prod_sql.=$v_products_date_added."','".$v_products_last_modified."','".$v_products_date_available."','". $v_products_weight."','";

$prod_sql.=$v_products_status."',".$v_products_tax_class_id.",".$v_manufacturers_id.")";

 

tep_db_query($prod_sql);

 

$products_id_sql="select max(products_id) products_id from products";

$res3=tep_db_query($products_id_sql);

$products_id=tep_db_fetch_array($res3);

 

$product_to_category_sql="insert into products_to_categories values(".$products_id['products_id'].",".$Category_id.")";

tep_db_query($product_to_category_sql);

 

$prod_desc_sql="insert into products_description (products_id,language_id,products_name,products_description) values(";

$prod_desc_sql.=$products_id['products_id'].",".$v_language_id.",'".$v_products_name."','".$v_products_description."')";

 

tep_db_query($prod_desc_sql);

 

//echo $catname;

//$Progress.=$v_categores_name."->".$v_products_name."\n";

}

}

 

?>

 

</p>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="48%" height="91"><table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>

<td bgcolor="#003399"> <font color="#FFFFFF" size="5" face="Arial, Helvetica, sans-serif"><strong>Import

<input name="status2" type="hidden" id="status2">

</strong></font></td></tr>

<tr>

<td bgcolor="#003399"><div align="center"> </div>

</td>

</tr>

<tr>

<td bgcolor="#003399"><div align="center"> </div>

</td>

</tr>

<tr>

<td height="314" valign="top" >

<table width="100%" border="0" bgcolor="#eeeeee">

<tr>

<td width="75%" height="99" valign="top">

<FORM ENCTYPE="multipart/form-data" ACTION="excel.php" METHOD=POST>

 

 

<p>

<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="2000000">

</p>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>

<td bgcolor="#336666"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Rules

to import data</strong></font></td>

</tr>

<tr>

<td valign="top"><table width="100%" border="0" cellspacing="2" cellpadding="0">

<tr>

<td width="5%" valign="top"><font color="#000000" size="2">1.</font></td>

<td width="95%"><font color="#000000" size="2">The

data must be tab delimeted</font></td>

</tr>

<tr>

<td height="16" valign="top"><font color="#000000" size="2">2.</font></td>

<td><font color="#000000" size="2">Remove all currency symbols ($ or GBP)

from price data</font></td>

</tr>

<tr>

<td valign="top"><font color="#000000" size="2">3.</font></td>

<td><font color="#000000" size="2">Remove all non-standard characters and

bullet points from data before import</font></td>

</tr>

<tr>

<td valign="top"><font color="#000000" size="2">4.</font></td>

<td><font color="#000000" size="2">Do not use

bullet points in the data</font></td>

</tr>

<tr>

<td valign="top"><font color="#000000" size="2">5.</font></td>

<td><font color="#000000" size="2">images must

be uploaded saperately in the 'movies/category'

folder</font></td>

</tr>

<tr>

<td valign="top"><font color="#000000" size="2">6.</font></td>

<td><font color="#000000" size="2">Leave the

first line as the heading</font></td>

</tr>

<tr>

<td valign="top"><font color="#000000" size="2">7.</font></td>

<td><font color="#000000" size="2">Quantity

is assumed to be given or else 100 will

be used as default..</font></td>

</tr>

<tr>

<td valign="top"><font color="#000000" size="2">8.</font></td>

<td><font color="#000000" size="2">Keep the

sequence of the columns as it is given

below. If any of the column doesnot contain

any <br>

data. Leave it blank but donot remove it from the list</font></td>

</tr>

<tr>

<td valign="top"><font color="#000000" size="2">9.</font></td>

<td><font color="#000000" size="2">The importer

tries to find the parent of any category,

but if not found it puts in the 'Misc'

General category. if you are looking for

some products and found no where please

try it in 'Misc' Category</font></td>

</tr>

<tr>

<td valign="top"><font color="#000000" size="2"> </font></td>

<td><font color="#000000" size="2"> </font></td>

</tr>

<tr>

<td valign="top"><font color="#000000" size="2"> </font></td>

<td><font color="#000000" size="2"> </font></td>

</tr>

</table>

</td>

</tr>

&n

Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Link to comment
Share on other sites

I am now getting

 

movies/movies/"category"/"imagename"

Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Link to comment
Share on other sites

I am now getting

 

movies/movies/"category"/"imagename"

 

 

 

I have it fixed!!! :D

Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...