Customer/Price Level Help

eraps

Hello,

I am trying to add multiple prices for various customer levels to a shopping cart. I am gettting various error messages such as "unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING". I would appreciate any help.

I am trying to do the following:

[INDENT]retrieve the customer_id field from the table Anphdaba_customer
if there is a customer_id field then retrieve the customer_level from the same row identified by the customer_id

retrieve product_id from the table Anphdaba_inventory
display the price in the same row identified by product_id

if customer_level is 100 then replace the price with price100 from the same row identified by product_id
................etc.
else
if there is not a customer_level (the customer has not logged in) then replace price and with price0 from the same row identified by product_id [/INDENT]

Here is the entire code

 <?php

if(!isset($config)){
	echo "<html>\r\n<head>\r\n<title>Forbidden 403</title>\r\n</head>\r\n<body><h3>Forbidden 403</h3>\r\nThe document you are requesting is forbidden.\r\n</body>\r\n</html>";
	exit;
}

// query database

$query = "SELECT productId, productCode, quantity, name, description, image, noImages,  price, price0, price100, price200, price300, price400, price500, popularity, sale_price, stock_level, useStockLevel, digital, digitalDir, cat_name,".$glob['dbprefix']."Anphdaba_customer.customer_level = ".$glob['dbprefix']."Anphdaba_inventory.cat_id, cat_father_id, cat_image, per_ship, item_ship, item_int_ship, per_int_ship, noProducts FROM ".$glob['dbprefix']."Anphdaba_inventory INNER JOIN ".$glob['dbprefix']."Anphdaba_category ON ".$glob['dbprefix']."Anphdaba_inventory.cat_id = ".$glob['dbprefix']."Anphdaba_category.cat_id where productId = ".$db->mySQLSafe($_GET['productId']);




$prodArray = $db->select($query);

$meta['siteTitle'] = " - ".$prodArray[0]['name'];
$meta['metaDescription'] = strip_tags($prodArray[0]['description']);

$view_prod = new XTemplate ("skins/".$config['skinDir']."/styleTemplates/content/viewProd.tpl");

if($prodArray == TRUE){

$val = "";

if(($val = prodAltLang($prodArray[0]['productId'])) == TRUE){

	$prodArray[0]['name'] = $val['name'];
	$prodArray[0]['description'] = $val['description'];

}

// update amount of views
	$upPop['popularity'] = "popularity+1";
	$db->update($glob['dbprefix']."Anphdaba_inventory",$upPop,"productId = ".$db->mySQLSafe($_GET['productId']));

$view_prod->assign("LANG_PRODTITLE",$lang['front']['viewProd']['product']);
$view_prod->assign("LANG_PRODINFO",$lang['front']['viewProd']['product_info']);
$view_prod->assign("LANG_PRICE",$lang['front']['viewProd']['price']);
$view_prod->assign("LANG_PRODCODE",$lang['front']['viewProd']['product_code']);
$view_prod->assign("LANG_TELLFRIEND",$lang['front']['viewProd']['tellafriend']);
$view_prod->assign("TXT_PRODTITLE",$prodArray[0]['name']);
$view_prod->assign("TXT_DESCRIPTION",$prodArray[0]['description']);


$view_prod->assign("LANG_DESCRIPTION",$lang['front']['viewProd']['description']);


if(isset($_GET['add']) && isset($_GET['quan'])){
	$view_prod->assign("CURRENT_URL",str_replace(array("&amp;add=".$_GET['add'],"&amp;quan=".$_GET['quan']),"",currentPage()));
} else {
	$view_prod->assign("CURRENT_URL",currentPage());
}




if($prodArray[$i]['customer_level']==100){
		$view_prod->assign("TXT_PRICE100",priceFormat($prodArray[0]['price100']));
} else {
		$view_prod->assign("TXT_PRICE0",priceFormat($prodArray[0]['price0']));
}

if($prodArray[$i]['customer_level']==200){
		$view_prod->assign("TXT_PRICE200",priceFormat($prodArray[0]['price0']));
} else {
		$view_prod->assign("TXT_PRICE0",priceFormat($prodArray[0]['price0']));
}






if(salePrice($prodArray[0]['price'], $prodArray[0]['sale_price'])==FALSE){
	$view_prod->assign("TXT_PRICE",priceFormat($prodArray[0]['price']));
} else {
	$view_prod->assign("TXT_PRICE","<span class='txtOldPrice'>".priceFormat($prodArray[0]['price'])."</span>");
}









$salePrice = salePrice($prodArray[0]['price'], $prodArray[0]['sale_price']);
$view_prod->assign("TXT_SALE_PRICE", priceFormat($salePrice));
$view_prod->assign("TXT_PRODCODE", $prodArray[0]['productCode']);

$view_prod->assign("CURRENT_DIR",getCatDir($prodArray[0]['cat_name'],$prodArray[0]['cat_father_id'], $prodArray[0]['cat_id'],$link=TRUE));

$view_prod->assign("LANG_QUAN",$lang['front']['viewProd']['quantity']);

$view_prod->assign("PRODUCT_ID",$prodArray[0]['productId']);



if(!empty($prodArray[0]['image'])){
	$view_prod->assign("IMG_SRC","images/uploads/".$prodArray[0]['image']);
} else {
	$view_prod->assign("IMG_SRC","skins/".$config['skinDir']."/styleImages/nophoto.gif");
}

if($prodArray[0]['noImages']>0){
	$view_prod->assign("LANG_MORE_IMAGES",$lang['front']['viewProd']['more_images']);
	$view_prod->parse("view_prod.prod_true.more_images");

}



if($config['outofstockPurchase']==1){

	$view_prod->assign("BTN_ADDBASKET",$lang['front']['viewProd']['add_to_basket']);
	$view_prod->parse("view_prod.prod_true.buy_btn");


} elseif($prodArray[0]['useStockLevel']==1 && $prodArray[0]['stock_level']>0){

	$view_prod->assign("BTN_ADDBASKET",$lang['front']['viewProd']['add_to_basket']);
	$view_prod->parse("view_prod.prod_true.buy_btn");

} elseif($prodArray[0]['useStockLevel']==0){

	$view_prod->assign("BTN_ADDBASKET",$lang['front']['viewProd']['add_to_basket']);
	$view_prod->parse("view_prod.prod_true.buy_btn");

}

$view_prod->assign("LANG_DIR_LOC",$lang['front']['viewProd']['location']);


if($config['stockLevel']==1 && $prodArray[0]['useStockLevel']==1 && $prodArray[0]['stock_level']>0){

	$view_prod->assign("TXT_INSTOCK",$lang['front']['viewProd']['no_instock']." ".$prodArray[0]['stock_level']);

} elseif($prodArray[0]['useStockLevel']==1 && $prodArray[0]['stock_level']>0) {

	$view_prod->assign("TXT_INSTOCK",$lang['front']['viewProd']['instock']);

} else {

	$view_prod->assign("TXT_INSTOCK","");

}


if($prodArray[0]['stock_level']<1 && $prodArray[0]['useStockLevel']==1 && $prodArray[0]['digital']==0){

	$view_prod->assign("TXT_OUTOFSTOCK",$lang['front']['viewProd']['out_of_stock']);

} else {

	$view_prod->assign("TXT_OUTOFSTOCK","");

}

// build sql query for product options
	$query = "SELECT ".$glob['dbprefix']."Anphdaba_options_bot.option_id, ".$glob['dbprefix']."Anphdaba_options_bot.value_id, option_price, option_symbol, value_name, option_name, assign_id FROM `".$glob['dbprefix']."Anphdaba_options_bot` INNER JOIN `".$glob['dbprefix']."Anphdaba_options_mid` ON ".$glob['dbprefix']."Anphdaba_options_mid.value_id = ".$glob['dbprefix']."Anphdaba_options_bot.value_id INNER JOIN `".$glob['dbprefix']."Anphdaba_options_top` ON ".$glob['dbprefix']."Anphdaba_options_bot.option_id = ".$glob['dbprefix']."Anphdaba_options_top.option_id WHERE product =".$db->mySQLSafe($_GET['productId'])." ORDER BY option_name, value_name ASC";

$options = $db->select($query);


if($options == TRUE){

	$view_prod->assign("TXT_PROD_OPTIONS",$lang['front']['viewProd']['prod_opts']);

	// start loop

	for ($i=0; $i<count($options); $i++){

		$view_prod->assign("VAL_ASSIGN_ID", $options[$i]['assign_id']);
		$view_prod->assign("VAL_VALUE_NAME", $options[$i]['value_name']);


		if($options[$i]['option_price']>0){
			$view_prod->assign("VAL_OPT_SIGN",$options[$i]['option_symbol']);
			$view_prod->assign("VAL_OPT_PRICE",priceFormat($options[$i]['option_price']));
			$view_prod->parse("view_prod.prod_true.prod_opts.repeat_options.repeat_values.repeat_price");
		}
		$view_prod->parse("view_prod.prod_true.prod_opts.repeat_options.repeat_values");

   if($options[$i]['option_id']!==$options[$i+1]['option_id']){

			$view_prod->assign("VAL_OPTS_NAME", $options[$i]['option_name']);
			$view_prod->parse("view_prod.prod_true.prod_opts.repeat_options");

		}


	}

	$view_prod->parse("view_prod.prod_true.prod_opts");

} // end if product options are true

$view_prod->parse("view_prod.prod_true");

} else {// end if product array is true

$view_prod->assign("LANG_PRODUCT_EXPIRED",$lang['front']['viewProd']['prod_not_found']);
$view_prod->parse("view_prod.prod_false");
}
$view_prod->parse("view_prod");
$page_content = $view_prod->text("view_prod");
<?php

Then I added a 'price' field to the customer table and removed all mentions of price in the first query (with the product info) inserted

$query = "SELECT `price0` as `price` FROM ".$glob['dbprefix']."Anphdaba_inventory; $x = mysql_fetch_assoc(mysql_query($query)); $base_price = $x['price'];

$query = "SELECT `price".$prodArray[$i]['customer_level']."` as `price` FROM ".$glob['dbprefix']."Anphdaba_inventory;"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) { $row = mysql_fetch_assoc($result); $view_prod->assign("TXT_PRICE".$prodArray[$i]['customer_level'],priceFormat($row['price'])); } else { $view_prod->assign("TXT_PRICE0",$base_price); }

I'm still getting error messages. PLEASE HELP!!!

Weedpacket

First of all, syntax highlighting can make syntax errors like these a lot easier to spot (and parse errors are already among the easiest to spot - PHP doesn't even need to run the code to find them, it just needs to look at it to see it's wrong.). Use [php] instead of [code] when posting PHP code. To use your other two lines (tidied up to make it legible to humans - a very important requirement for any source code):

<?php
$query = "SELECT `price0` as `price` FROM ".$glob['dbprefix']."Anphdaba_inventory;
$x = mysql_fetch_assoc(mysql_query($query));
$base_price = $x['price'];

$query = "SELECT `price".$prodArray[$i]['customer_level']."` as `price` FROM ".$glob['dbprefix']."Anphdaba_inventory;";
$result = mysql_query($query);
if (mysql_num_rows($result) > 0)
{
	$row = mysql_fetch_assoc($result);
	$view_prod->assign("TXT_PRICE".$prodArray[$i]['customer_level'],priceFormat($row['price']));
}
else
{
	$view_prod->assign("TXT_PRICE0",$base_price);
}

and it is immediately obvious where the colours go wonky: a missing " after Anphdaba_inventory in the first case,

First thing I notice about the original code is that you have <?php at the very end where I presume you meant to put ?>.

Other than that, the error message would contain a line number. This is often the line on which the error occurs, or shortly after.

eraps

Oh, thank you. I see what you mean. Now I can see the color change. I guess I need to stop hacking at PHP using Notepad and get some real software.

Yes, that was an error with the <?php

The error that I am getting now is
" Call to a member function on a non-object in......on line 53"
Line 50-59 as they appear in the code to be used on the site are

    $result = mysql_query($query);
if (mysql_num_rows($result) > 0)
{
$row = mysql_fetch_assoc($result);
$view_prod->assign("TXT_PRICE".$prodArray[$i]['customer_level'],priceFormat($row['price']));
}
else
{
    $view_prod->assign("TXT_PRICE0",$base_price);
}

So I added this (lines 43 and 44)

$prodArray = $db->select($query);
$db->query(`price'".$prodArray[$i]['customer_level']." as `price` FROM ".$glob['dbprefix']."Anphdaba_inventory";);

and now I am getting "Parse error: syntax error, unexpected T_AS in ... on line 43"
If I remove "as `price` " and I get "Parse error: syntax error, unexpected T_STRING in ... on line 43"

What if I removed the "base price" reference? Could that be confusing things? I don't need a "base price" per se, only different prices for each customer level.