$paramsData['status'] = 1; $where = sprintf('id = %s', $Models_General->qstr($_POST['id'])); $Models_General->updateDetails('askquestion', $paramsData, $where); mail($_POST['email'], 'New Answer Submitted For Your Question on ' . SITEURL, "\n\nQuestion: " . $_REQUEST['question'] . "\n\nAnswer: " . $_POST['answer'], 'From:' . FROMNAME . '<' . FROMEMAIL . '>'); } if (isset($_GET['delete'])) { $paramsData = array(); $paramsData['deleted'] = 1; $where = sprintf('id = %s', $Models_General->qstr($_GET['id'])); $Models_General->updateDetails('askquestion', $paramsData, $where); } $status = 0; if (!empty($_GET['status'])) { $status = $_GET['status']; } $data = $Models_General->ask($max, $page, $status, 0); $totalRows_rsView = isset($data['totalRows']) ? $data['totalRows'] : 0; $totalPages_rsView = isset($data['totalPages']) ? $data['totalPages'] : 0; $queryString_rsView = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsView") == false && stristr($param, "totalRows_rsView") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsView = "&" . htmlentities(implode("&", $newParams)); } }
<?php require_once '../../../../Connections/connBayAreaCont.php'; include '../functions.php'; $Models_General = new Models_General(); $result = array(); try { $page = 0; if (!empty($_GET['page'])) { $page = $_GET['page']; } $max = 5; $data = $Models_General->ask($max, $page, 1, 0); $result = array('success' => 1, 'data' => $data); } catch (Exception $e) { $result = array('success' => 0, 'msg' => $e->getMessage()); } echo json_encode($result);