Learn VBA & Macros in 1 Week!

PHP - Echo Showing Results In Pagination Page

Full Excel VBA Course - Beginner to Expert

Echo Showing Results In Pagination Page	View Content

i have built pages that paginate with 10 rows per page (some pages show more but for the moment i want to focus on this particular page)

//Define Some Options for Pagination
$num_rec_per_page=10;
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * $num_rec_per_page;

$results = mysql_query("SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name) LIMIT $start_from, $num_rec_per_page") or die(mysql_error());

	$results_array = array();
	while ($row = mysql_fetch_array($results)) {
    	$results_array[$row['characterID']] = $row;
}

The above sets the variables for the pagination and below the results are echo with 10 rows per page then i show the pagination links:

<?php 
$sql = "SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name)";

$rs_result = mysql_query($sql); //run the query
$total_records = mysql_num_rows($rs_result);  //count number of records
$total_pages = ceil($total_records / $num_rec_per_page); 
?>


      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td align="center"><div style="width:100%; text-align:center;">
          <ul class="pagination">
    <li class="selected">
	<?php
echo "<a href='capitalmember.php?page=1'>".'«'."</a> ";?> 
</li>
<?
for ($i=1; $i<=$total_pages; $i++) { 
            echo "<li><a href='capitalmember.php?page=".$i."'>".$i."</a></li> "; 
};
?>
<li class="selected">
<? 
echo "<a href='capitalmember.php?page=$total_pages'>".'»'."</a> "; // Goto last page
?></li>
  </ul></div>
    <?php
  $pageNr = $page;   // Get Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  // 3 * 10 = 30
$to = $from + $rowsPerPage;      // 30 + 10 = 40
echo $pageNr;
/* Result: From page 30 to 40 */
  ?></td>
        </tr>
      </table>

this works great and shows me 10 results per page, what i need to work out and work on next is: echo the number of results above the records (for example: "showing records 1 to 10" and then on page 2 "showing records 11 to 21" and page 3 "showing records 22 to 32" how can i work out the maths for this echo? i was thinking along the lines of;

    <?php
$pageNr = $page;   // Gets Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  
$to = $from + $rowsPerPage;      // 30 + 10 = 40
// Now Show Results
echo $from; // Echo from
echo $to // Echo to
  ?>

but i'm still working on this.. then i need to look at shortening the amount of page links on the page if for example i have 500 records it shows me links 1 to 50 and eats up the page.... Appreciate any help and light onto my problems. Many thanks
Edited by jacko_162, 11 January 2015 - 05:43 PM.

Full Excel VBA Course - Beginner to Expert

Results From Echo Not Showing

Similar Tutorials

View Content

Code: [Select]
if (isset($_POST['update']))
{
$signature = $_POST['signature'];
$type = $_POST['type'];
$name = $_POST['name'];
$b=0;
While ($b < $i)
{
echo $signature[$b]."<br>";
echo $type[$b]."<br>";
echo $name[$b]."<br><br>";
$b++;
}}
I did echo '<pre>';
print_r($_POST);
echo '</pre>';

The results are
Code: [Select]
Array
(
[sname] =>
[notes] =>
[signature] => Array
(
[0] => 1-1
[1] => 1-2
[2] => 1-3
)

[type] => Array
(
[0] => Test1
[1] => Test2
[2] => Test3
)

[name] => Array
(
[0] => Testa
[1] => Testb
[2] => Testc
)

[update] => Update
)

But for some reason nothing is showing up on the screen.

Similar Tutorials

View Content

Pagination Of Search Results

Similar Tutorials

View Content

Hello, im new here, and i have little experience to php and mysql as i started for 2 weeks ago.
I started out with some tutorials and feeling im getting the hang of it.

Enough of me, lets get to the point:
<?php

$con = mysql_connect('localhost',$user,$pass)or die(mysql_error());
$selectdb = mysql_select_db($selectdb)or die(mysql_error());

$sql = "SELECT * From table";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$myarray = array($result);
$i =0;

while ($i < $num){

echo $myarray[$i];
$i++;
}

?>

Here i have written a dummyscript that does what the original script does, it tries to fetch the keys from the table and then trying to loop it and echo out the results.
The output in the browser is this: Resource id #3

I know this probably is a simple fix but i cant seem to get it sorted out. Hope some of you could help me get this baby work, or maybe have another way of doing it more "simple".

Thanks in advance!
Dan-Levi