#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
$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