GetFirstRowOfSet($strSQL, &$ascProdResult, SQL_GET_ROW_COUNT, "Get all Shop Product data");
if($g_objDB->HasError())
{
$g_objDB->DisplayError(__FILE__, __LINE__, "Product Not Found!");
include "bottom.phtml";
exit;
}
elseif(($intNumRows = $g_objDB->GetRowCount($sclResultID)) == 0)
{
$g_objDB->DisplayError("", 0, "Product Data Not Found.");
include "bottom.phtml";
exit;
}
$g_objDB->FreeResults($sclResultID);
?>
| Product ID |
Category
*/
?>
Name |
Price |
|
Quantity |
|
GetAllRows($strSQL, &$ascAttrResult, &$blnMoreRows, SQL_GET_ROW_COUNT, &$sclAttrResultID, "Get attributes");
if($g_objDB->HasError())
{
$g_objDB->DisplayError(__FILE__, __LINE__, "Get attributes failed!");
$g_intAttrRowCount = 0;
}
else
$g_intAttrRowCount = $g_objDB->GetRowCount($sclAttrResultID);
if($g_intAttrRowCount == 0)
$strHasAttributes = "N";
}
AddForm($strProdID, $intCatID, $strName, $dblPrice, $dblWeight, $intNumRows, $strHasAttributes, $strPictureURL);
?>
GetFirstRowOfSet($strSQL, &$ascCatResult, SQL_GET_ROW_COUNT, "Get Category name and parent data");
if($g_objDB->HasError())
{
$g_objDB->DisplayError(__FILE__, __LINE__);
include "bottom.phtml";
exit;
}
elseif($g_objDB->GetRowCount($sclCResultID) == 0)
{
$g_objDB->DisplayError("", 0, "Category name and parent data not found.");
include "bottom.phtml";
exit;
}
$strCatName = $ascCatResult['CategoryName'];
$strSQL = "SELECT CategoryName FROM tblCategory WHERE CatID = ".$ascCatResult['ParentID'];
$sclResultID = $g_objDB->GetFirstRowOfSet($strSQL, &$ascCatParentResult, SQL_GET_ROW_COUNT, "Get Category parent data");
if($g_objDB->HasError())
{
$g_objDB->DisplayError(__FILE__, __LINE__);
include "bottom.phtml";
exit;
}
elseif($g_objDB->GetRowCount($sclResultID) > 0)
{
if($ascCatParentResult['CategoryName'] != "")
{
$strCatName = $ascCatParentResult['CategoryName'].", ".$ascCatResult['CategoryName'];
}
$g_objDB->FreeResults($sclResultID);
}
$g_objDB->FreeResults($sclCResultID);
?>
Return to