Sunday, August 23, 2015

how to find total number of record with limit parameter in mysql

#1          
  $stmt = $this->link->prepare("SELECT *,(SELECT COUNT(*) FROM clients) total_count                  FROM clients LIMIT 0, 10");
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$rowcount = $rows[0]['total_count'];
echo $rowcount; // return total number of row
                print_r($rows);  // return data



#2

$query = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM table WHERE name LIKE 'a%' LIMIT 0,50");
$query_count = mysql_query("SELECT FOUND_ROWS()");
$result = mysql_fetch_array($query_count);
$total_num_rows = $result[0];

/* HERE IS YOUR CODE PARCING THE RESULTS OF MAIN QUERY */

#3 using PDO

 $query = $this->link->query("SELECT SQL_CALC_FOUND_ROWS * FROM clients LIMIT 0,50");
 $query_count = $this->link->query("SELECT FOUND_ROWS()");
 $result = $query_count->fetchAll(PDO::FETCH_ASSOC);
 $total_num_rows = $result[0];
 print_r($total_num_rows);

No comments:

Post a Comment