} if ($intError) { foreach ($_POST as $key => $value) { $_POST[$key] = mysql_escape_string(trim($value)); } $sql = "UPDATE tblpages SET page_name='" . $_POST["page_name"] . "',page_title='" . $_POST["page_title"] . "',by_whom='" . $_POST["by_whom"] . "',shot_description='" . $_POST["shot_description"] . "',long_description='" . $_POST["long_description"] . "',isorder='" . $_POST["isorder"] . "'" . $sqlfilename . " WHERE id=" . $_GET["id"]; mysql_query($sql) or die(mysql_error()); $return = $_GET["return"]; header("Location:message.php?mess=20&return={$return}"); } } if (!$intError) { $hdlTpl->setVariable("error_message", $strErrormessage); //Assigns values } $arrPages = $hldGlobal->fnFetchPage($_GET["id"]); if (is_array($arrPages) && count($arrPages) > 0) { if (is_array($arrPage) && count($arrPage) > 0) { $strOpt = ""; foreach ($arrPage as $key => $value) { if ($arrPages[0]["page_name"] == $key) { $strSel = "selected='selected'"; } else { $strSel = ""; } $strOpt .= "<option value='" . $key . "' " . $strSel . ">" . $value . "</option>"; } $hdlTpl->setVariable("optpagename", $strOpt); //Assigns option } $hdlTpl->setVariable("page_title", $arrPages[0]["page_title"]);
//Assigns footer $hdlTpl->setVariable("leftmenu", $strLeftMenu); //Assigns left menu if ($_POST["submit"] == "Go") { if ($_POST["status"] != "--") { $strSearch = $_POST["status"]; if ($strSearch) { $hdlTpl->setVariable("act", "selected='selected'"); } else { if (!$strSearch) { $hdlTpl->setVariable("inact", "selected='selected'"); } } } } $arrRecordSet = $hldGlobal->fnFetchPage(0, $strSearch); $arrPages = $hldGlobal->fnGetPagerArr($arrRecordSet); if (is_array($arrPages) && count($arrPages) > 0) { foreach ($arrPages as $key => $value) { if (is_numeric($key)) { if ($value["isactive"]) { $intstatus = 0; $hdlTpl->setVariable("status", "Active"); //Assigns status } else { $intstatus = 1; $hdlTpl->setVariable("status", "In Active"); //Assigns status } $hdlTpl->setVariable("returnurl", $hldGlobal->fnEncodeURL($_SERVER["REQUEST_URI"])); //Assigns encode url