>
> <?
>
> /* Replace the following credentials with yours */
>
> $server = "localhost";
> $username = "user";
> $password = "pass";
> $database = "your_db";
> $table = "your_table";
>
>
> // Connect To MySQL Server
> @mysql_connect($server, $username, $password) or die("Couldn't Connect to
> Database");
>
> // Select Database
> @mysql_select_db($database) or die("Couldn't Select Database");
>
> // set number of results to display per page (in this case, 10 per page)
> $pagelimit = "10";
>
> // run query
> $strSQL = mysql_query("SELECT * FROM $table") or die(mysql_error());
>
> // count number of matches
> $totalrows = mysql_num_rows($strSQL);
>
> // determine how many pages there will be by using ceil() and dividing
> total rows by pagelimit
> $pagenums = ceil ($totalrows/$pagelimit);
>
> // if no value for page, page = 1
> if ($page==''){
> $page='1';
> }
> // create a start value
> $start = ($page-1) * $pagelimit;
>
> // blank matches found
> echo "<b>" . $totalrows . " matches found</b><br>\n";
>
> // Showing Results 1 to 10 (or if you're page limit were 15) 1 to 15, etc.
>
> $starting_no = $start + 1;
>
> if ($totalrows - $start < $pagelimit) {
> $end_count = $totalrows;
> } elseif ($totalrows - $start >= $pagelimit) {
> $end_count = $start + $pagelimit;
> }
>
>
> echo "Results $starting_no to $end_count shown.<br>\n";
>
> // create dynamic next, previous, and page links
>
> /* lets say you're set to show 10 results per page and your script comes
> out with 12 results.
> this will allow your script to say next 2 if you're on the first page and
> previous 10 if you're on the second page. */
>
> if ($totalrows - $end_count > $pagelimit) {
> $var2 = $pagelimit;
> } elseif ($totalrows - $end_count <= $pagelimit) {
> $var2 = $totalrows - $end_count;
> }
>
> $space = " ";
>
> // previous link (if you're on any page besides the first, create previous
> link)
> if ($page>1) {
> echo "« <a href='" . $PHP_SELF . "?page=".($page-1)."'
> class=main>Previous" . $space . $pagelimit . "</a>" . $space . $space . "";
>
> }
>
> // dynamic page number links
>
> for ($i=1; $i<=$pagenums; $i++) {
> if ($i!=$page) {
> echo " <a href='" . $PHP_SELF . "?page=$i' class=main>$i</a>";
>
> }
> else {
> echo " <b>[".$i."]</b>";
> }
> }
>
>
> // next link (if the page you are on is less than the total amount of page
> numbers, there are more pages left)
>
> if ($page<$pagenums) {
> echo "" . $space . $space . $space . $space . " <a href='" . $PHP_SELF
> . "?page=".($page+1)."' class=main>Next " . $var2 . "</a> »";
> }
>
> /* output your data wherever you'd like.
>
> BUT
>
> in order for this all to work, before outputting your data, you have to
> run the query over using MySQL's LIMIT.
> This will limit how many results are actually displayed on the page. */
>
> $strSQL = mysql_query("SELECT * FROM $table LIMIT $start,$pagelimit")
> or die(mysql_error());
>
> // LIMIT 0,10 will start at 0 and display 10 results
> // LIMIT 10,5 will start at 10 and display 5 results
>
> /* now you can do whatever you'd like with this query. it will only output
> ten results per page.
> change the $pagelimit variable to whatever to output more than 10 result
> per page. */
>
>
> ?>
>
On 11/24/05, antonius j-free <[EMAIL PROTECTED]> wrote:
>
> Temans, saya butuh bantuannya nih dari yang jago2 sql sama php :D
>
> saya pemula nih. gimana yah sintaks php sama sql buat nampilin list
> yang mao dibagi jadi per page ? maksudnya, misalkan saya punya 100
> record list, nah supaya bisa ditampilin per 10 record (jadi 10
> halaman )gimana yah? trus bisa loncat juga ke halaman mana aja.
>
> soalnya kalo mao ditampilin semua, bisa lama banget loadingnya.
> makasih banyak responnya :D
>
> regards
>
--
saylow
| website : www.saylows.com |
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/IHFolB/TM
--------------------------------------------------------------------~->
----------------------------------------------------------
Komunitas MasterWeb Indonesia http://www.master.web.id
----------------------------------------------------------
MWN, Masternya WEBHOSTING di Indonesia, Indo/USA Servers,
Customer Support 24 jam http://www.masterwebnet.com
----------------------------------------------------------
WebDevelopment,Designing/Programming http://www.dlanet.com
----------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/milis-masterweb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
