Untitled

<!DOCTYPE>
<html>
<head>
    <title>View Records</title>
    <link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<?php
    include("header.php");
    require('config.php');

    $tableName = "tracking_records";
    $targetpage = "view.php";
    $limit = 10;

    $query = "SELECT COUNT(*) as num FROM $tableName";
    $total_pages = mysql_fetch_array(mysql_query($query));
    $total_pages = $total_pages['num'];

    $stages = 10;

    $getpage = (isset($_GET['page'])) ? (int)$_GET['page'] : 0;
    $page = mysql_escape_string($getpage);

    if($page){
        $start = ($page - 1) * $limit;
    }else{
        $start = 0;
    }

    $query1 = "SELECT * FROM $tableName LIMIT $start, $limit";
    $result = mysql_query($query1) or die(mysql_error());

    if($page == 0){$page = 1;}
    $prev = $page - 1;
    $next = $page + 1;
    $lastpage = ceil($total_pages/$limit);
    $LastPagem1 = $lastpage - 1;

    $paginate = '';
    if($lastpage > 1){
        $paginate .= "<div class='paginate'>";
        if($page > 1){
            $paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
        }else{
            $paginate.= "<span class='disabled'>previous</span>";
        }
        if($lastpage < 7 + ($stages * 2)){
            for($counter = 1; $counter <= $lastpage; $counter++){
                if($counter == $page){
                    $paginate.= "<span class='current'>$counter</span>";
                }else{
                    $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                }
            }
        }
        elseif($lastpage > 5 + ($stages * 2)){
            if($page < 1 + ($stages * 2)){
                for($counter = 1; $counter < 4 + ($stages * 2); $counter++){
                    if($counter == $page){
                        $paginate.= "<span class='current'>$counter</span>";
                    }else{
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                    }
                }
                $paginate.= "...";
                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
            }
            // Middle hide some front and some back
            elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2)){
                $paginate.= "<a href='$targetpage?page=1'>1</a>";
                $paginate.= "<a href='$targetpage?page=2'>2</a>";
                $paginate.= "...";
                for($counter = $page - $stages; $counter <= $page + $stages; $counter++){
                    if($counter == $page){
                        $paginate.= "<span class='current'>$counter</span>";
                    }else{
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                    }
                }
                $paginate.= "...";
                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
            }else{
                $paginate.= "<a href='$targetpage?page=1'>1</a>";
                $paginate.= "<a href='$targetpage?page=2'>2</a>";
                $paginate.= "...";
                for($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++){
                    if($counter == $page){
                        $paginate.= "<span class='current'>$counter</span>";
                    }else{
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
                    }
                }
            }
        }
        if($page < $counter - 1){
            $paginate.= "<a href='$targetpage?page=$next'>next</a>";
        }else{
            $paginate.= "<span class='disabled'>next</span>";
        }
        $paginate.= "</div>";
    }
    echo '&nbsp;&nbsp;&nbsp;'.$total_pages.' Results';
    echo $paginate;
?>
<table border='1'>
    <tr>
        <th>Contract #</th><th>Date</th>
        <th>Vessel</th><th>Work Description</th>
        <th>Specs PKG</th><th>Period of Performance</th>
        <th>Required Delivery Date</th><th>IGE Amount</th>
        <th>PM / SBS / MM</th><th>IDIQ</th>
        <th>Solicitation #</th><th>RFP/RFQ Closing Date</th>
        <th>RFP/RFQ Closing Time</th><th>Status</th>
        <th>Award Amount</th><th>Award Date</th>
        <th>Contractor</th><th>Remarks</th>
        <th>Edit / Delete</th>
    </tr>
<?php
    while($row = mysql_fetch_array($result))
    {
        echo "<tr>
            <td>$row[0]</td><td>$row[1]</td>
            <td>$row[2]</td><td>$row[3]</td>
            <td>$row[4]</td><td>$row[5]</td>
            <td>$row[6]</td><td>$row[7]</td>
            <td>$row[8]</td><td>$row[9]</td>
            <td>$row[10]</td><td>$row[11]</td>
            <td>$row[12]</td><td>$row[13]</td>
            <td>$row[14]</td><td>$row[15]</td>
            <td>$row[16]</td><td>$row[17]</td>
            <td>
                <a href='edit.php?cn=$row[0]'>Edit</a><br />
                <a href='delete.php?cn=$row[0]' onClick="return confirm('Delete this record?')";>Delete</a>
            </td>
        </tr>";
    }
    echo "</table>";
    mysql_free_result($result);
    mysql_close($connection);
?>
</body>
</html>