Troubleshooting this page (PHP) (Cartweaver), eCommerce page, php, cartweaver Options

[Ian A]

I'm trying to put together an ecommerce site using Dreamweaver and Cartweaver. I have to change cartweaver adding more fields to the product database. I added the fields in myphpadmin, success. I added the html inputs to the productform.php, success. And added the code to the CWProductAction.php to recognize the fields, failure? I'm not sure where the problem is but I'm fairly positive that it's in CWProductAction.php because everything APPEARS fine on the page and I enter all of the desired variables, but when I click update, the screen goes white.

Please don't point me to Cartweaver support.

I think it's a fatal error in here somewhere. I'm attaching the .php and pasting some sections of code. Could you please inspect my code for any errors?:

Line 36-90:
/* Set Default Values for form fields for insert */
$_POST["product_MerchantProductID"] = isset($_POST["product_MerchantProductID"]) ? $_POST["product_MerchantProductID"] : "NULL";
$_POST["product_Name"] = isset($_POST["product_Name"]) ? $_POST["product_Name"] : "NULL";
$_POST["product_Description"] = isset($_POST["product_Description"]) ? $_POST["product_Description"] : "NULL";
$_POST["product_ShortDescription"] = isset($_POST["product_ShortDescription"]) ? $_POST["product_ShortDescription"] : "NULL";
$_POST["product_Sort"] = isset($_POST["product_Sort"]) ? $_POST["product_Sort"] : "0";
$_POST["product_OnWeb"] = isset($_POST["product_OnWeb"]) ? $_POST["product_OnWeb"] : "NULL";
$_POST["product_Archive"] = isset($_POST["product_Archive"]) ? $_POST["product_Archive"] : "0";
$_POST["product_shipchrg"] = isset($_POST["product_shipchrg"]) ? $_POST["product_shipchrg"] : "1";
$_POST["product_style"] = isset($_POST["product_style"]) ? $_POST["product_style"] : "NULL";
$_POST["product_l"] = isset($_POST["product_l"]) ? $_POST["product_l"] : "NULL";
$_POST["product_w"] = isset($_POST["product_w"]) ? $_POST["product_w"] : "NULL";
$_POST["product_d"] = isset($_POST["product_d"]) ? $_POST["product_d"] : "NULL";
$_POST["product_board"] = isset($_POST["product_board"]) ? $_POST["product_board"] : "NULL";
$_POST["product_grade"] = isset($_POST["product_grade"]) ? $_POST["product_grade"] : "NULL";
$_POST["product_print"] = isset($_POST["product_print"]) ? $_POST["product_print"] : "NULL";
$_POST["product_used"] = isset($_POST["product_used"]) ? $_POST["product_used"] : "NULL";

$query_rsCW = sprintf("INSERT INTO tbl_products
(product_MerchantProductID,
product_Name,
product_Description,
product_ShortDescription,
product_Sort,
product_OnWeb,
product_Archive,
product_shipchrg,
product_taxgroupid,
product_style
product_l
product_w
product_d
product_board
product_grade
product_print
product_used)
VALUES ('%s','%s','%s','%s',%d,%d,%d,'%s',%d,'%s','%s','%s','%s','%s','%s','%s','%s'
)",$_POST["product_MerchantProductID"]
,$_POST["product_Name"]
,$_POST["product_Description"]
,$_POST["product_ShortDescription"]
,$_POST["product_Sort"]
,$_POST["product_OnWeb"]
,$_POST["product_Archive"]
,$_POST["product_shipchrg"]
,$_POST["product_taxgroupid"]
,$_POST["product_style"]
,$_POST["product_l"]
,$_POST["product_w"]
,$_POST["product_d"]
,$_POST["product_board"]
,$_POST["product_grade"]
,$_POST["product_print"]
,$_POST["product_used"]);
$rsCW = $cartweaver->db->executeQuery($query_rsCW, "rsCW");

Lines 310-364:

/* Set Default FORM values */
$_POST["product_Description"] = isset($_POST["product_Description"]) ? $_POST["product_Description"] : "NULL";
$_POST["product_ShortDescription"] = isset($_POST["product_ShortDescription"]) ? $_POST["product_ShortDescription"] : "NULL";
$_POST["product_Sort"] = isset($_POST["product_Sort"]) ? $_POST["product_Sort"] : "0";
$_POST["product_OnWeb"] = isset($_POST["product_OnWeb"]) ? $_POST["product_OnWeb"] : "NULL";
$_POST["product_Archive"] = isset($_POST["product_Archive"]) ? $_POST["product_Archive"] : "0";
$_POST["product_shipchrg"] = isset($_POST["product_shipchrg"]) ? $_POST["product_shipchrg"] : "1";
$_POST["product_Category_ID"] = isset($_POST["product_Category_ID"]) ? $_POST["product_Category_ID"] : array();
$_POST["product_style"] = isset($_POST["product_style"]) ? $_POST["product_style"] : "NULL";
$_POST["product_l"] = isset($_POST["product_l"]) ? $_POST["product_l"] : "NULL";
$_POST["product_w"] = isset($_POST["product_w"]) ? $_POST["product_w"] : "NULL";
$_POST["product_d"] = isset($_POST["product_d"]) ? $_POST["product_d"] : "NULL";
$_POST["product_board"] = isset($_POST["product_board"]) ? $_POST["product_board"] : "NULL";
$_POST["product_grade"] = isset($_POST["product_grade"]) ? $_POST["product_grade"] : "NULL";
$_POST["product_print"] = isset($_POST["product_print"]) ? $_POST["product_print"] : "NULL";
$_POST["product_used"] = isset($_POST["product_used"]) ? $_POST["product_used"] : "NULL";

$query_rsCW = sprintf("UPDATE tbl_products
SET
product_Name='%s',
product_Description = '%s',
product_ShortDescription = '%s',
product_Sort = %d,
product_OnWeb = %d,
product_Archive = %d,
product_shipchrg = %d,
product_taxgroupid = %d,
product_style='%s',
product_l='%s',
product_w='%s',
product_d='%s',
product_board='%s',
product_grade='%s',
product_print='%s',
product_used='%s'

WHERE product_ID=%d"
,$_POST["product_Name"]
,$_POST["product_Description"]
,$_POST["product_ShortDescription"]
,$_POST["product_Sort"]
,$_POST["product_OnWeb"]
,$_POST["product_Archive"]
,$_POST["product_shipchrg"]
,$_POST["product_taxgroupid"]
,$_POST["product_ID"]
,$_POST["product_style"]
,$_POST["product_l"]
,$_POST["product_w"]
,$_POST["product_d"]
,$_POST["product_board"]
,$_POST["product_grade"]
,$_POST["product_print"]
,$_POST["product_used"]);
$rsCW = $cartweaver->db->executeQuery($query_rsCW, "rsCW");

[oli @ CW]

Hi Ian ,

Set that specific page to show all PHP errors to see what the actual error message is. You can do that by adding this to the top of your page:
php error_reporting (E_ALL);

Oli
Cartweaver Support Team ;-)

[Ian A]

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\GrBx\cw3\admin\CWProductAction.php on line 2

The thing that gets me is that this is where the error report code is. I'll paste it...

<?php
php error_reporting (E_ALL);
/*

[Ian A]

Disregard last post. Here is the new error message.

Warning: require_once(../../GrBx/cw3/admin/application.php) [function.require-once]: failed to open stream: No such file or directory in C:\xampp\htdocs\GrBx\cw3\admin\ProductForm.php on line 2

Fatal error: require_once() [function.require]: Failed opening required '../../GrBx/cw3/admin/application.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\GrBx\cw3\admin\ProductForm.php on line 2