<?
include(_LIBPATH."class.easyformproc.inc.php");
include("paginate.php");
//Create Instance
$mySqlObj = new dBAccess(_DBHOST, _DBUSERNAME, _DBPASSWORD);//MySQL Database Instance
$mySqlObj -> selectDB(_DBNAME);
$allFieldsList = array("*");
$sortby = array("catid","temp_id");
$res = $mySqlObj -> querySelect("template",$allFieldsList,$sortby,"D");
$cont[0][0] = array("value" => "<b>Item ID</b>", "width" => "100");
$cont[0][1] = array("value" => "<b>Item Image</b>", "width" => "200");
$cont[0][2] = array("value" => "<b>Item Name </b>");
$cont[0][3] = array("value" => "<b>Item Category</b>");
$cont[0][4] = array("value" => " ");
$qryStr ="&action=".$_REQUEST['action'];
$arr = paginate("select * from template order by temp_id desc",10);
$i=0;
while($res = mysql_fetch_array($arr["result"]))
{
//getting the category name
$cana = array("catlink");
$catnacon = "catid='".$res["catid"]."'";
$catnames = $mySqlObj -> querySelect("categories",$cana,"","",$catnacon);
$catname = $catnames[0]['catlink'];
//getting the category name
$cont[$i+1][0] = array("value" => $res["temp_id"],"valign" => "top");
$cont[$i+1][1] = array("value" => '<img src="../item_images/'.$res["temp_img"].'" width="150px" height="120px" />');
$cont[$i+1][2] = array("value" => $res["title"],"valign" => "top");
<?
include(_LIBPATH."class.easyformproc.inc.php");
//Create Instance
$mySqlObj = new dBAccess(_DBHOST, _DBUSERNAME, _DBPASSWORD);//MySQL Database Instance
$mySqlObj -> selectDB(_DBNAME);
$allFieldsList = array("*");
$res = $mySqlObj -> querySelect("categories",$allFieldsList);
//Create Instance
$formGen = new easyFormProc();
for($r=0;$r<count($res);$r++)
{
//$formGen -> setTextElement("order".$r,$res[$r]["ordering"],5, 5,"txtboxes");
$formGen -> setHiddenElement("id".$r,$res[$r]["catid"]);
}
#Process Form
$disForm = $formGen -> processForm("Update","buttons", "submit", "index.php?action=categories");
#Get HTML of the elements
$disElementHTML = $formGen -> getDisElementHTML();
#Get Error Messages
$errMsg = $formGen -> getErrorMsg("The following errors occured","style2");
#Get Posted Values
$postedVals = $formGen -> getPostedElementValues();
$cont[0][1] = array("value" => "<b>user name</b>", "width" => "200", "align" => "center");
$cont[0][2] = array("value" => "<b>website</b>", "align" => "center");
$cont[0][3] = array("value" => "<b>status</b>", "align" => "center");
$cont[0][4] = array("value" => "<b>view</b>", "align" => "center");
$cont[0][5] = array("value" => "<b>delete</b>", "align" => "center");
$qryStr ="&action=".$_REQUEST['action'];
$arr = paginate("select * from comments order by com_id desc",10);
$i=0;
while($res = mysql_fetch_array($arr["result"]))
{
//getting the category name
$cana = array("catlink");
$catnacon = "catid='".$res["catid"]."'";
$catnames = $mySqlObj -> querySelect("categories",$cana,"","",$catnacon);
$catname = $catnames[0]['catlink'];
//$numOfPpl = mysql_num_rows(mysql_query("select * from ratings where rating_id='".$res["temp_id"]."'"));
//getting the category name
$cont[$i+1][0] = array("value" => $res["com_id"],"valign" => "top", "align" => "center");
$cont[$i+1][1] = array("value" => $res["name"],"valign" => "top", "align" => "center");
$cont[$i+1][2] = array("value" => $res["website"] ,"valign" => "top", "align" => "center");
$cont[$i+1][3] = array("value" => $res["status"] ,"valign" => "top", "align" => "center");
$cont[$i+1][4] = array("value" => "<a href=\"index.php?action=viewcomment&id=".$res["com_id"]."\">view</a>" ,"valign" => "top", "align" => "center");
$cont[$i+1][5] = array("value" => genHTMLLink("index.php?action=comment&confirm=false&table=comments&field=com_id&com_id=".$res["com_id"]."&name=".$res["name"]."&comment=".$res["comment"],"Delete"),"valign" => "top","align" => "center");
$i=$i+1;//
}
$tbllist = genHTMLTable($i+1,6, $cont, "100%", 3, 4,"",0);
