SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2006
    Posts
    56
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help Needed in this php file "About PHP pagin"

    hi, i got the following php file as below, My database got 40 records, everything seems working but when i click the next button or [1][2][3] numbers like this on the page, it will change the url of the site
    example:
    [1] page: www.mysite.com/users.php
    [2] page: www.mysite.com/users.php?start=10
    [3] page: www.mysite.com/users.php?start=20

    but showing the same record, it should show first 10 records and 2nd 10 records and so on.... please anybody help me to find out what I have done wrong with this coding.

    Thank you very much.

    PHP Code:
    <!doctype html public "-//w3c//dtd html 3.2//en">

    <html>

    <head>
    <title>Try Paging with php and mysql</title>

    </head>

    <body>
    <?
    include("database.php");
    include 
    "header.html";

    $page_name="users.php"
    if(!isset(
    $start)) {                         
    $start 0;
    }

    $eu = ($start 0); 
    $limit 10;                                 
    $this1 $eu $limit
    $back $eu $limit
    $next $eu $limit

    if (!
    $_GET[user])
    {

    $query2=" SELECT * FROM users  ";
    $result2=mysql_query($query2);
    echo 
    mysql_error();
    $nume=mysql_num_rows($result2);

    echo <<<EOF

    <table width="724" border="0" align="center">
      <tr>
        <td><table width="724" border="0" align="left" class="title">

          <tr>

            <td width="111"><div align="center">Username &nbsp; |</div></td>
            <td width="104"><div align="center">Photo &nbsp; |</div></td>
            <td width="75">Types &nbsp; |</td>
            <td width="103"><div align="center">Nationality |</div></td>
            <td width="125">Marital Staus |</td>
            <td width="90">Children |</td>
            <td width="86">Religion</td>
            </tr>
        </table></td>
      </tr>
    </table>

    EOF;


    $query=" SELECT * FROM users  limit $eu$limit ";
    $result=mysql_query($query);
    echo 
    mysql_error();


    while(
    $user mysql_fetch_array($result))
    {


    echo <<<EOF

    <table width="724" border="0" align="center">
      <tr>
        <td><table width="724" border="0" align="left">

          <tr>
            <td>
    $user[id]</td>
            <td width="111"><div align="center"><a href="users.php?user=
    $user[username]">$user[username]</a></div></td>
            <td width="104"><div align="center"><a href="images/users/
    $user[pic]"><img src="images/users/$user[pic]" width="100"></a></div></td>
            <td width="75"><div align="center">
    $user[types]</div></td>
            <td width="103"><div align="center">
    $user[nationality]</div></td>
            <td width="125">
    $user[marital_status]</td>
            <td width="90">
    $user[children]</td>
            <td width="86">
    $user[religion]</td>
            </tr>
        </table></td>
      </tr>
    </table>

    EOF;
    }
    }


    ELSE
    {
    $getuser mysql_query("SELECT * from users where username = '$_GET[user]'");
    $usernum mysql_num_rows($getuser);
    if (
    $usernum == 0)
    {
    echo (
    "<center>User Not Found</center>");
    }
    else
    {
    $profile mysql_fetch_array($getuser);
    echo <<<EOF
    /* display user profile page with get */
    EOF;

    }
    }


    if(
    $nume $limit ){ 

    echo 
    "<table align = 'center' width='50%'><tr><td  align='left' width='30%'>";

    if(
    $back >=0) { 
    print 
    "<a href='$page_name?start=$back'><font face='Verdana' size='2'>PREV</font></a>"


    echo 
    "</td><td align=center width='30%'>";
    $i=0;
    $l=1;
    for(
    $i=0;$i $nume;$i=$i+$limit){
    if(
    $i <> $eu){
    echo 
    " <a href='$page_name?start=$i'><font face='Verdana' size='2'>$l</font></a> ";
    }
    else { echo 
    "<font face='Verdana' size='4' color=red>$l</font>";}       
    $l=$l+1;
    }


    echo 
    "</td><td  align='right' width='30%'>";

    if(
    $this1 $nume) { 
    print 
    "<a href='$page_name?start=$next'><font face='Verdana' size='2'>NEXT</font></a>";} 
    echo 
    "</td></tr></table>";

    }


    include 
    "footer.html";

    ?>

    </body>

    </html>

  2. #2
    Web Professional
    Join Date
    Oct 2008
    Location
    London
    Posts
    862
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    PHP Code:
    if(!isset($start)) {                         
        
    $start 0;

    Probably register_globals is off (which is a good thing) so you should do it like this:

    PHP Code:
    if(!isset($_GET['start'])) {                         
        
    $start 0;
    } else {
        
    $start $_GET['start'];


  3. #3
    SitePoint Enthusiast
    Join Date
    Oct 2006
    Posts
    56
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you very much decowski, it works.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •