Databases
StackOverflow2013
Postsdbo
POPHP Pagination using SELECT COUNT (*) as
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP Pagination using SELECT COUNT (*) as
    primarykey
    data
    text
    <p>Hi stackoverflow readers and staff, I have a problem using a pagination code. All is fine when I'm using SELECT COUNT(*) as num FROM $tbl_name, but when I try to SELECT COUNT(*) as num FROM $tbl_name WHERE marca=nokia, To paginate just results containing "nokia" word in line "marca" from an table named "modele" and I receive an error: "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in E:\server\htdocs\pag.php on line 17" </p> <p>This is the frame of code:</p> <pre><code>$marca = $_GET['marca']; /* First get total number of rows in data table. If you have a WHERE clause in your query, make sure you mirror it here. */ $query = "SELECT COUNT(*) as num FROM $tbl_name WHERE marca=$marca"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages1 = $total_pages['num']; /* Setup vars for query. */ $targetpage = "paginare.php"; //your file name (the name of this file) $limit = 5; //how many items to show per page $page = $_GET['pagina']; if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; //if no page var is given, set start to 0 /* Get data. */ $sql = "SELECT * FROM $tbl_name LIMIT $start, $limit"; $result = mysql_query($sql); if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 /* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once. */ $pagination = ""; if($lastpage &gt; 1) { $pagination .= "&lt;div class=\"pagination\"&gt;"; //previous button if ($page &gt; 1) $pagination.= "&lt;a href=\"$targetpage?page=$prev\"&gt;« Inapoi&lt;/a&gt;"; else $pagination.= "&lt;span class=\"disabled\"&gt;« Inapoi&lt;/span&gt;"; //pages if ($lastpage &lt; 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter &lt;= $lastpage; $counter++) { if ($counter == $page) $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;"; else $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;"; } } elseif($lastpage &gt; 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page &lt; 1 + ($adjacents * 2)) { for ($counter = 1; $counter &lt; 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;"; else $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;"; } $pagination.= "..."; $pagination.= "&lt;a href=\"$targetpage?pagina=$lpm1\"&gt;$lpm1&lt;/a&gt;"; $pagination.= "&lt;a href=\"$targetpage?pagina=$lastpage\"&gt;$lastpage&lt;/a&gt;"; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) &gt; $page &amp;&amp; $page &gt; ($adjacents * 2)) { $pagination.= "&lt;a href=\"$targetpage?pagina=1\"&gt;1&lt;/a&gt;"; $pagination.= "&lt;a href=\"$targetpage?pagina=2\"&gt;2&lt;/a&gt;"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter &lt;= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;"; else $pagination.= "&lt;a href=\"$targetpage?pagina=$counter\"&gt;$counter&lt;/a&gt;"; } $pagination.= "..."; $pagination.= "&lt;a href=\"$targetpage?pagina=$lpm1\"&gt;$lpm1&lt;/a&gt;"; $pagination.= "&lt;a href=\"$targetpage?pagina=$lastpage\"&gt;$lastpage&lt;/a&gt;"; } //close to end; only hide early pages else { $pagination.= "&lt;a href=\"$targetpage?pagina=1\"&gt;1&lt;/a&gt;"; $pagination.= "&lt;a href=\"$targetpage?pagina=2\"&gt;2&lt;/a&gt;"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter &lt;= $lastpage; $counter++) { if ($counter == $page) $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;"; else $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;"; } } } //next button if ($page &lt; $counter - 1) $pagination.= "&lt;a href=\"$targetpage?page=$next\"&gt;Inainte »&lt;/a&gt;"; else $pagination.= "&lt;span class=\"disabled\"&gt;Inainte »&lt;/span&gt;"; $pagination.= "&lt;/div&gt;\n"; } </code></pre> <p>And here my php is ending, sorry for bad english and thank you in advance. Marcel</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USİsmet Alkan
    1. USDomuta Marcel
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPHP Pagination using SELECT COUNT (*) as
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POPHP Pagination using SELECT COUNT (*) as
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POPHP Pagination using SELECT COUNT (*) as
      1. USDomuta Marcel
      1. VTFavorite
    1. COhave you tired to echo the query
      singulars
      1. POPHP Pagination using SELECT COUNT (*) as
      1. USknightrider
    2. CO[**Please, don't use `mysql_*` functions in new code**](http://bit.ly/phpmsql). They are no longer maintained [and are officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). See the [**red box**](http://j.mp/Te9zIL)? Learn about [*prepared statements*](http://j.mp/T9hLWi) instead, and use [PDO](http://php.net/pdo) or [MySQLi](http://php.net/mysqli) - [this article](http://j.mp/QEx8IB) will help you decide which. If you choose PDO, [here is a good tutorial](http://j.mp/PoWehJ).
      singulars
      1. POPHP Pagination using SELECT COUNT (*) as
      1. USKermit
    3. COas with every OTHER duplicate on this site: you get that error because a query failed, you assumed it succeeded, and blindly plowed on ahead using that failed query.
      singulars
      1. POPHP Pagination using SELECT COUNT (*) as
      1. USMarc B
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload