Dynamic displays for eCart

1/21/2010 6:59 am | #1 fdotmedia

I've made an eCart page and want to see if I can show DB values based on whether it exists or not...

example:

id   name   address   email          sex
1    bob      123 s st  bob@b.com  M
2    kim      123 s st  kim@k.com  NULL

I want to return something that looks like this in the recordset...

Bob - M - 123 s st - bob@b.com
Kim - 123 s st - kim@k.com

Can I do that with eCart?

Thanks,
Ted

1/21/2010 10:28 am | #2 Jason ByrnesWebAssist

This is not a function of eCart, you need to add an if statement around the display for the sex column:

php:

<?php if($row_RecordSetName['ColumnName'] != NULL || $row_RecordSetName['ColumnName'] != "") { ?>

<?php echo $row_RecordSetName['ColumnName']; ?>

<?php } ?>

1/21/2010 12:46 pm | #5 fdotmedia

works like a charm thank you...

I have run into a different problem though...

I'm adding the "add to cart" button as a recordset and when you click on the 2nd button the script redirects to the same page and empties the recordset... It's eCart_2_ID_Add I'm not getting anything from eCart_1_ID_Add works as expected...

<?php
// WA eCart AddToCart
if (isset($_POST["eCart1_2_ATC"]) || isset($_POST["eCart1_2_ATC_x"]))     {
  $ATC_itemID = $_POST["eCart1_2_ID_Add"];
  $ATC_AddIfIn = 0;
  $ATC_RedirectAfter = "";
  $ATC_RedirectIfIn  = "";
  if (isset($totalRows_products) && $totalRows_products > 0)     {
    $row_products = WAEC_findRecordMySQL($products, "Pid", $ATC_itemID);
    if ($row_products)     {
      $ATC_itemName = "".$row_products['PFGtitle']  ."";// column binding
      $ATC_itemDescription = "";// column binding
      $ATC_itemWeight = floatval("0");// column binding
      $ATC_itemQuantity = "".$_POST["eCart1_2_Quantity_Add"]  ."";// column binding
      $ATC_itemPrice = floatval("".$row_products['PFGprice']  ."");// column binding
      mysql_data_seek($products, 0);
      $row_products = mysql_fetch_assoc($products);
    }
  }
  $ATC_itemQuantity = floatval($ATC_itemQuantity);
  if (is_numeric($ATC_itemQuantity) && $ATC_itemQuantity != 0)     {
    $eCart1->AddToCart($ATC_AddIfIn, $ATC_RedirectIfIn, $ATC_itemID, $ATC_itemName, $ATC_itemDescription, $ATC_itemWeight, $ATC_itemQuantity, $ATC_itemPrice);
    if ($ATC_RedirectAfter != "" && $eCart1->redirStr == "")     {
      $eCart1->redirStr = $ATC_RedirectAfter;
    }
    if (isset($_SERVER['QUERY_STRING']) && $_SERVER['QUERY_STRING'] != "")  {
      $_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING'];
    }
    else  {
      $_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF'];
    }
  }
}
?>
<?php
// WA eCart Redirect
if ($eCart1->redirStr != "")     {
  header("Location: ".$eCart1->redirStr);
}
?>

<?php if($row_products['PFGid'] != "" || $row_products['PFGid'] != "") { ?>
<p> <span style="color:#000; font-weight:bold; font-size:11px;"><?php echo $row_products['PFGid']; ?> - <?php echo $row_products['PFGtitle']; ?> - <?php echo $row_products['PFGprice']; ?></span>
          		<form name="eCart1_2_ATC_<?php echo $row_products['PFGid']; ?>" method="POST" action="<?php echo $_SERVER["PHP_SELF"]; ?><?php echo (isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] != "")?"?".$_SERVER["QUERY_STRING"]:""; ?>">
            		<input type="hidden" name="eCart1_2_ID_Add" value="<?php echo $row_products['PFGid']; ?>" >
            		<input type="text" name="eCart1_2_Quantity_Add" value="1" size="4" >
            		<input type="submit" value="Add to Cart" name="eCart1_2_ATC">
            	</form>
        	</p><?php } ?>

1/21/2010 4:25 pm | #6 Jason ByrnesWebAssist

How iis the recordset filtered?

Can you send a copy of your page so I can see the code in context?

Top send a php page, compress it into a zip archive and attach the zip file to your reply.

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Dynamic displays for eCart

1/21/2010 6:59 am | #1 fdotmedia