1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Trouble with (Next Page) * (Previous Page)

Discussion in 'PHP' started by LongshotMP, Apr 26, 2017.

  1. #1
    Hi everyone.

    I'm trying very hard to add some sort of pagination on my script, but it seems to be going horribly. I've been trying for hours, and although I feel I am close, it just seems to not be working so I thought I'd ask for help.
    SEMrush
    Without the pagination script I have inserted, there is a list of cars.
    When I add it, the list complete disappears.

    The row that I have inserted is abour 3/4 of the way down, starting with
    <?php
    //check if the starting row variable was passed in the URL or not
    if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {


    Please help me!


    <?php include"mainmenu.php"; ?>
    <?php
    if ($_POST['sell'] && $_POST['car']){
    
    $sell = $_POST['car'];
        foreach($sell as $checkboxid)
        {
            $sql="SELECT * from cars WHERE id='$checkboxid'";
    $result=mysql_query($sql);
    while($rows=mysql_fetch_array($result)){ // Start looping table row
    $id= $rows['id'];
    $cprice= $rows['price'];
    $carname= $rows['name'];
    }
    mysql_query("DELETE FROM cars WHERE id='$checkboxid'");
    mysql_query("UPDATE users SET `cash`=`cash`+'$cprice' WHERE username='$username'");
    }
    echo "You sold your car(s)!";   
    
    }
    
    ?>
    
    <?php
    if ($_POST['rcar'] && $_POST['car']){
    
    $rcar = $_POST['car'];
        foreach($rcar as $checkboxid)
        {
       
    $sql="SELECT * from cars WHERE id='$checkboxid'";
    $result=mysql_query($sql);
    
    while($rows=mysql_fetch_array($result)){ // Start looping table row
    
    
    $id= $rows['id'];
    $carname= $rows['name'];
    
    ?>
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=topleft NOWRAP>
    </td>
    <td class=leftbar NOWRAP>
    </td>
    <td class=bar NOWRAP>
    
    </td>
    <td class=rightbar NOWRAP>
    </td>
    <td class=topright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=left NOWRAP>
    </td>
    <td class=main>
    <div align="left">
    
    <?php echo "This car already has 0% damage!"; ?>
    
    
    </div>
    </td>
    <td class=right NOWRAP>
    </td>
    </tr>
    </Tbody>
    </table>
    
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=bottomleft NOWRAP>
    </td>
    <td class=bottom NOWRAP>
    </td>
    <td class=bottomright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    
    <?php
    }//loop
    }//loop
    
    }//if submit
    ?>
    
    <?php
    
    if ($_POST['drop'] && $_POST['car']){
    
    $dcar = $_POST['car'];
    
        foreach($dcar as $dropcar)
        {
          mysql_query("DELETE FROM cars WHERE id='$dropcar' AND owner='$username'");
    
        }
    
    echo "<b>Selected cars have been dropped!</b>";
    }//if submit
    ?>
    
    
    <?php
    
    if ($_POST['rcar'] && $_POST['car']){
    
    $rcar = $_POST['car'];
    
        foreach($rcar as $checkboxid)
        {
       
    $sql="SELECT * from cars WHERE id='$checkboxid'";
    $result=mysql_query($sql);
    
    while($rows=mysql_fetch_array($result)){ // Start looping table row
    
    $id= $rows['id'];
    $damage= $rows['damage'];
    $type= $rows['type'];
    
    if($type=="1"){$carname = $car_1;}
    if($type=="2"){$carname = $car_2;}
    if($type=="3"){$carname = $car_3;}
    if($type=="4"){$carname = $car_4;}
    if($type=="5"){$carname = $car_5;}
    if($type=="6"){$carname = $car_6;}
    if($type=="7"){$carname = $car_7;}
    if($type=="8"){$carname = $car_8;}
    if($type=="9"){$carname = $car_9;}
    if($type=="10"){$carname = $car_10;}
    if($type=="11"){$carname = $car_11;}
    if($type=="12"){$carname = $car_12;}
    if($type=="13"){$carname = $car_13;}
    
    if ($damage ==0){
    
    ?>
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=topleft NOWRAP>
    </td>
    <td class=leftbar NOWRAP>
    </td>
    <td class=bar NOWRAP>
    
    </td>
    <td class=rightbar NOWRAP>
    </td>
    <td class=topright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=left NOWRAP>
    </td>
    <td class=main>
    <div align="left">
    
    
    <?php echo "This car allready has 0% damage!"; ?>
    
    </div>
    </td>
    <td class=right NOWRAP>
    </td>
    </tr>
    </Tbody>
    </table>
    
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=bottomleft NOWRAP>
    </td>
    <td class=bottom NOWRAP>
    </td>
    <td class=bottomright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    
    
    
       
    
    <?php
    
    }else{
    $c = rand(9,110);
    
    if($repaircar>=1){
    
    
    mysql_query("UPDATE cars SET damage='0' WHERE id='$checkboxid' AND owner='$username'");
    ?>
    
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=topleft NOWRAP>
    </td>
    <td class=leftbar NOWRAP>
    </td>
    <td class=bar NOWRAP>
    
    </td>
    <td class=rightbar NOWRAP>
    </td>
    <td class=topright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=left NOWRAP>
    </td>
    <td class=main>
    <div align="left">
    
    
    <?php echo "You successfully fixed your $carname with $damage% damage!"; ?>
    
    
    </div>
    </td>
    <td class=right NOWRAP>
    </td>
    </tr>
    </Tbody>
    </table>
    
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=bottomleft NOWRAP>
    </td>
    <td class=bottom NOWRAP>
    </td>
    <td class=bottomright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    
    
    
       
    <?php
    mysql_query("UPDATE users SET `repaircar`=`repaircar`-'1' WHERE username='$username'");
    
    }else{
    
    if ($c < $damage){
    
    mysql_query("DELETE FROM cars WHERE id='$checkboxid'");
    
    ?>
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=topleft NOWRAP>
    </td>
    <td class=leftbar NOWRAP>
    </td>
    <td class=bar NOWRAP>
    
    </td>
    <td class=rightbar NOWRAP>
    </td>
    <td class=topright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=left NOWRAP>
    </td>
    <td class=main>
    <div align="left">
    
    <?php echo "You failed to repair your $carname with $damage% damage."; ?>
    
    
    </div>
    </td>
    <td class=right NOWRAP>
    </td>
    </tr>
    </Tbody>
    </table>
    
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=bottomleft NOWRAP>
    </td>
    <td class=bottom NOWRAP>
    </td>
    <td class=bottomright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    
    
       
    
    <?php
    
    
    }else{
    
    mysql_query("UPDATE cars SET damage='0' WHERE id='$checkboxid' AND owner='$username'");
    ?>
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=topleft NOWRAP>
    </td>
    <td class=leftbar NOWRAP>
    </td>
    <td class=bar NOWRAP>
    
    </td>
    <td class=rightbar NOWRAP>
    </td>
    <td class=topright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=left NOWRAP>
    </td>
    <td class=main>
    <div align="left">
    
    <?php echo "You successfully fixed your $carname with $damage% damage!"; ?>
    
    
    </div>
    </td>
    <td class=right NOWRAP>
    </td>
    </tr>
    </Tbody>
    </table>
    
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=bottomleft NOWRAP>
    </td>
    <td class=bottom NOWRAP>
    </td>
    <td class=bottomright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    
    
       
    
    <?php
    
    }//fail else
    }//damage not zero
    
    }//repair car successfully
    }//loop
    }//loop
    
    
    
    }//if submit
    ?>
    
    
    
    
    
    
    
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=topleft NOWRAP>
    </td>
    <td class=leftbar NOWRAP>
    </td>
    <td class=bar NOWRAP>
    
    </td>
    <td class=rightbar NOWRAP>
    </td>
    <td class=topright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=left NOWRAP>
    </td>
    <td class=main>
    <div align="center">
    
    <script language="javascript">
    checked = false;
          function checkAll () {
            if (checked == false){checked = true}else{checked = false}
        for (var i = 0; i < document.getElementById('crimes').elements.length; i++) {
          document.getElementById('crimes').elements[i].checked = checked;
        }
          }
    
    
    </script>
    
     
      <?php       
    //check if the starting row variable was passed in the URL or not
    if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
      //we give the value of the starting row to 0 because nothing was found in URL
      $startrow = 0;
    //otherwise we take the value from the URL
    } else {
      $startrow = (int)$_GET['startrow'];
    }
    //this part goes after the checking of the $_GET var
    $fetch = mysql_query("SELECT * FROM cars WHERE owner='".mysql_real_escape_string($username)."' ORDER BY type ASC LIMIT $startrow, 10")or
    die(mysql_error());
    
    
    while($row = mysql_fetch_array( $result )) {
    
    $id = $row['id'];
    $type = $row['type'];
    $damage = $row['damage'];
    $sale = $row['sale'];
    $price = number_format($row['price']);
    
    if($type=="1"){$carname = $car_1;}
    if($type=="2"){$carname = $car_2;}
    if($type=="3"){$carname = $car_3;}
    if($type=="4"){$carname = $car_4;}
    if($type=="5"){$carname = $car_5;}
    if($type=="6"){$carname = $car_6;}
    if($type=="7"){$carname = $car_7;}
    if($type=="8"){$carname = $car_8;}
    if($type=="9"){$carname = $car_9;}
    if($type=="10"){$carname = $car_10;}
    if($type=="11"){$carname = $car_11;}
    if($type=="12"){$carname = $car_12;}
    if($type=="13"){$carname = $car_13;}
    
       $num=Mysql_num_rows($fetch);
            if($num>0)
            {
            echo "<table>";
            echo "<tr><td>Car name</td><td>Car damage</div></td><td>Repair chance</td><td>Price</td></tr>";
            for($i=0;$i<$num;$i++)
            {
    
            $row=mysql_fetch_row($fetch);    
            ?>
    
    
    <tr>
    <td class="header" colspan="4">
    <div align="center" class="unnamed1">Cars</div>
    </td>
    </tr>
    
    
    <form action='' id=crimes method='post'>
    
    
                
    
    <tr>           
    
    <td width="40%" height="6" align="left" bgcolor="<?php echo "$tabcolor"; ?>" class="tabA">
    <label for="<?php echo $row['id']; ?>">
    <input name="car[]" type="checkbox" value="<? echo $id; ?>">
    <a href="viewcar.php?carid=<? echo $id; ?>"><?php echo $carname; ?></a>
    </label>
    </td>
    
    <td width="20%" height="6" align="left" bgcolor="<?php echo "$tabcolor"; ?>" class="tabA"><label>
    <?php echo $row['damage']."%"; ?>
    </label>
    </td>
    
    
    <td width="20%" height="6" align="left" bgcolor="<?php echo "$tabcolor"; ?>" class="tabA"><label>
    <?php
    if ($damage==0){ echo "100"; }else{echo 100-$damage;}
    ?>
    %</label>
    </td>
    
    <td width="20%" hight="6" align="left" bgcolor="<?php echo "$tabcolor"; ?>" class="tabA"><label>
    $ <?php
    echo $price;
    ?>
    </label>
    </td>
    
           
    </tr>
    
       <?php }// while loop ?>
    
    
    <?PHP      
            }//for
            echo"</table>";
            }
    //now this is the link..
    echo '<div class="pagination"><ul><li class="next"><a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+10).'">Next</a></li>';
    
    $prev = $startrow - 10;
    
    //only print a "Previous" link if a "Next" was clicked
    if ($prev >= 0)
        echo '<li class="prev"><a href="'.$_SERVER['PHP_SELF'].'?startrow='.$prev.'">Previous</a></li></ul></div>';
    ?>
    
    <input type='submit' name='rcar' class='tbox' value='Repair Cars'>
    
    <input type='submit' name='sell' class='tbox' value='Sell Cars'>
    
    </center>
    </form>
    
    
    
    
    </div>
    </td>
    <td class=right NOWRAP>
    </td>
    </tr>
    </Tbody>
    </table>
    
    
    <table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
    <Tbody>
    <tr>
    <td class=bottomleft NOWRAP>
    </td>
    <td class=bottom NOWRAP>
    </td>
    <td class=bottomright NOWRAP>
    </td>
    </tr>
    </tbody>
    </table>
    <br>
    <br>
    
    
    <?php include"rightside.php"; ?>
    PHP:
     
    LongshotMP, Apr 26, 2017 IP
    SEMrush
  2. davcheong

    davcheong Well-Known Member

    Messages:
    1,148
    Likes Received:
    51
    Best Answers:
    0
    Trophy Points:
    155
    #2
    Hi,

    The problems might be link to this :
    1. $username where or when user press link next it will be navigating to another page and it is not consider post to another page, unless the $username were actually store at the back memory such as session or cookies.
     
    Last edited: Jun 14, 2017
    davcheong, Jun 14, 2017 IP