Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // Connect to MySQL database
- require_once('conn_db.php');
- $page = 1; // The current page
- $rp = 10;
- $sortname = 'agenzia'; // Sort column
- $sortorder = 'asc'; // Sort order
- $qtype = ''; // Search column
- $query = ''; // Search string
- // Get posted data
- if (isset($_POST['page'])) {
- $page = mysql_real_escape_string($_POST['page']);
- }
- if (isset($_POST['sortname'])) {
- $sortname = mysql_real_escape_string($_POST['sortname']);
- }
- if (isset($_POST['sortorder'])) {
- $sortorder = mysql_real_escape_string($_POST['sortorder']);
- }
- if (isset($_POST['qtype'])) {
- $qtype = mysql_real_escape_string($_POST['qtype']);
- }
- if (isset($_POST['query'])) {
- $query = mysql_real_escape_string($_POST['query']);
- }
- if (isset($_POST['rp'])) {
- $rp = mysql_real_escape_string($_POST['rp']);
- }
- // Setup sort and search SQL using posted data
- $sortSql = "order by $sortname $sortorder";
- $searchSql = ($qtype != '' && $query != '') ? "where $qtype = '$query'" : '';
- // Get total count of records
- $sql = "select count(*) from fas_agenzie $searchSql";
- $result = mysql_query($sql);
- $row = mysql_fetch_array($result);
- $total = $row[0];
- // Setup paging SQL
- $pageStart = ($page-1)*$rp;
- $limitSql = "limit $pageStart, $rp";
- // Return JSON data
- $data = array();
- $data['page'] = $page;
- $data['total'] = $total;
- $data['rows'] = array();
- $sql = "select IDagenzia, agenzia, agenzia_comune, agenzia_telefono from fas_agenzie $searchSql $sortSql $limitSql";
- $results = mysql_query($sql);
- while ($row = mysql_fetch_assoc($results)) {
- $data['rows'][] = array(
- 'id' => $row['IDagenzia'],
- 'cell' => array($row['IDagenzia'], $row['agenzia'], $row['agenzia_comune'], $row['agenzia_telefono'])
- );
- }
- echo json_encode($data);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement