<?php
include(CART_DIR."SimpleImage.php");
$image = new SimpleImage();
include(CART_DIR."ps_pagination.php");
 
echo "<table border=\"0\" cellpadding=\"20\" cellspacing=\"0\" align=center width='100%'><tr>";
    
$sql = 'SELECT * FROM products';
$pager = new PS_Pagination($db, $sql, 3, 5);
 
$rs = $pager->paginate();
    
while($row = mysql_fetch_assoc($rs)) {
    $image->load(CART_DIR."gallery/$row[image].jpg");
    $image->resize(100,100);
    $image->save(CART_DIR."gallery/$row[image]2.jpg");
 
    list($width, $height, $type, $attr) = getimagesize(CART_DIR."gallery/$row[image].jpg");
   
    if(preg_match("/group(4)([^\d]|$)/", $user_info['group'])) { 
        $cost = $row[cost] - ($row[cost] * 0.10);
    } else {
        $cost = $row[cost];
    }
   
    echo "<td>
        <img src=\"".CART_DIR."gallery/$row[image]2.jpg\" border=0>
        <br />Name: $row[title] 
        <br />Type: $row[product_type] 
        <br />Cost: <b> $cost C</b>
        <br /><a href=\"http://www.divineshadowsonline.com/store/includes/desc.php\" target=\"_blank\" onClick=\"window.open(this.href, this.target, 'width=300px,height=100px'); return false;\">View Description</a><br /><br />
                  
        <form method=post action=\"index.php\" name=\"frm_add_to_cart\">
        <input type=hidden name=\"product_id\" value=\"$row[id]\">
        <input type=hidden name=\"session_id\" value=\"$_SERVER[REMOTE_ADDR]\">
        <input type=hidden name=\"title\" value=\"$row[title]\">
        <input type=hidden name=\"cost\" value=\"$cost\">
        <input type=hidden name=\"product_type\" value=\"$row[product_type]\">";
 
        if($logged_in) {
            echo "<input type=submit value=\"Add to cart\" name=\"add_to_cart\" class=\"atc\"></form>";
        }
        echo "</td>";
    }
    
echo "</tr></table>";
echo "<center>"  .  $pager->renderFullNav() . "</center>";
?>

<?php
require("../includes/Database.class.php");
$db = new Database($DBhost, $DBuser, $DBpass, $DBname, $DBpre);
$db->connect();
 
$inventory = "SELECT product_id, session_id, title, cost FROM stock WHERE session_id LIKE '". $db->escape($_SERVER[REMOTE_ADDR]) ."%' ORDER BY product_id DESC"; 
$inventorycount = $db->query($inventory); 
$num_rows = mysql_num_rows($inventorycount);
 
if($_POST[add_to_cart]) {
    $data['product_id'] = $_POST[product_id];
    $data['session_id'] = $_POST[session_id];
    $data['title'] = $_POST[title];
    $data['cost'] = $_POST[cost];
    $data['product_type'] = $_POST[product_type];
    $db->query_insert("stock", $data);
    header( 'refresh: 0' ); 
}
 
$total = 0;
$sql0 = "SELECT id, product_id, session_id, title, cost, product_type FROM stock WHERE session_id LIKE '". $db->escape($_SERVER[REMOTE_ADDR]) ."%' ORDER BY product_id DESC";
$countRows0 = $db->query($sql0); 
 
while ($countRow0 = $db->fetch_array($countRows0)) { 
    $total = $total+$countRow0[cost];
    $products = $countRow0[product_id];
    $title = $$countRow0[title];
} 
 
include(CART_DIR."SimpleImage.php");
$image = new SimpleImage();
include(CART_DIR."ps_pagination.php");
    
$sql = 'SELECT * FROM products';
$pager = new PS_Pagination($db, $sql, 9, 5);
 
$rs = $pager->paginate();
    
echo "<table border=\"0\" cellpadding=\"20\" cellspacing=\"0\" align=center width='100%'>";
 
while($row = mysql_fetch_assoc($rs)) {
 
    $image->load(CART_DIR."gallery/$row[image].jpg");
    $image->resize(100,100);
    $image->save(CART_DIR."gallery/$row[image]2.jpg");
 
    list($width, $height, $type, $attr) = getimagesize(CART_DIR."gallery/$row[image].jpg");
   
    if(preg_match("/group(4)([^\d]|$)/", $user_info['group'])) { 
        $cost = $row[cost] - ($row[cost] * 0.10);
    } else {
        $cost = $row[cost];
    }
    
    echo"<tr>";
    while($row = mysql_fetch_assoc($rs)) {
    
        echo "<td>
            <img src=\"".CART_DIR."gallery/$row[image]2.jpg\" border=0>
            <br />Name: $row[title] 
            <br />Type: $row[product_type] 
            <br />Cost: <b> $cost C</b>
            <br /><a href=\"http://www.divineshadowsonline.com/store/includes/desc.php\" target=\"_blank\" onClick=\"window.open(this.href, this.target, 'width=300px,height=100px'); return false;\">View Description</a><br /><br />
                  
            <form method=post action=\"index.php\" name=\"frm_add_to_cart\">
            <input type=hidden name=\"product_id\" value=\"$row[id]\">
            <input type=hidden name=\"session_id\" value=\"$_SERVER[REMOTE_ADDR]\">
            <input type=hidden name=\"title\" value=\"$row[title]\">
            <input type=hidden name=\"cost\" value=\"$cost\">
            <input type=hidden name=\"product_type\" value=\"$row[product_type]\">";
 
            if($logged_in) {
                echo "<input type=submit value=\"Add to cart\" name=\"add_to_cart\" class=\"atc\"></form>";
            }
        echo "</td>";
 
    }
    echo "</tr>";
}
    
echo "</table>";
 
echo "<center>"  .  $pager->renderFullNav() . "</center>";
 
$db->close();
?>

<?php
if (($variable % 3) == 0)
  echo "<br />";
?>

<?php
class PS_Pagination {
    var $php_self;
    var $rows_per_page; //Number of records to display per page
    var $total_rows; //Total number of rows returned by the query
    var $links_per_page; //Number of links to display per page
    var $sql;
    var $debug;
    var $conn;
    var $page;
    var $max_pages;
    var $offset;
    
    /**
     * Constructor
     *
     * @param resource $connection Mysql connection link
     * @param string $sql SQL query to paginate. Example : SELECT * FROM users
     * @param integer $rows_per_page Number of records to display per page. Defaults to 10
     * @param integer $links_per_page Number of links to display per page. Defaults to 5
     */
     
    function PS_Pagination($connection, $sql, $rows_per_page = 10, $links_per_page = 5) {
        $this->conn = $connection;
        $this->sql = $sql;
        $this->rows_per_page = $rows_per_page;
        $this->links_per_page = $links_per_page;
        $this->php_self = htmlspecialchars($_SERVER['PHP_SELF']);
        if(isset($_GET['page'])) {
            $this->page = intval($_GET['page']);
        }
    }
    
    /**
     * Executes the SQL query and initializes internal variables
     *
     * @access public
     * @return resource
     */
    function paginate() {
        if(!$this->conn) {
            if($this->debug) echo "MySQL connection missing<br />";
            return false;
        }
        
        $all_rs = @mysql_query($this->sql);
        if(!$all_rs) {
            if($this->debug) echo "SQL query failed. Check your query.<br />";
            return false;
        }
        $this->total_rows = mysql_num_rows($all_rs);
        @mysql_close($all_rs);
        
        $this->max_pages = ceil($this->total_rows/$this->rows_per_page);
        //Check the page value just in case someone is trying to input an aribitrary value
        if($this->page > $this->max_pages || $this->page <= 0) {
            $this->page = 1;
        }
        
        //Calculate Offset
        $this->offset = $this->rows_per_page * ($this->page-1);
        
        //Fetch the required result set
        $rs = @mysql_query($this->sql." LIMIT {$this->offset}, {$this->rows_per_page}");
        if(!$rs) {
            if($this->debug) echo "Pagination query failed. Check your query.<br />";
            return false;
        }
        return $rs;
    }
    
    /**
     * Display the link to the first page
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to 'First'
     * @return string
     */
    function renderFirst($tag='First') {
        if($this->page == 1) {
            return $tag;
        }
        else {
            return '<a href="'.$this->php_self.'?page=1">'.$tag.'</a>';
        }
    }
    
    /**
     * Display the link to the last page
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to 'Last'
     * @return string
     */
    function renderLast($tag='Last') {
        if($this->page == $this->max_pages) {
            return $tag;
        }
        else {
            return '<a href="'.$this->php_self.'?page='.$this->max_pages.'">'.$tag.'</a>';
        }
    }
    
    /**
     * Display the next link
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to '>>'
     * @return string
     */
    function renderNext($tag=' >>') {
        if($this->page < $this->max_pages) {
            return '<a href="'.$this->php_self.'?page='.($this->page+1).'">'.$tag.'</a>';
        }
        else {
            return $tag;
        }
    }
    
    /**
     * Display the previous link
     *
     * @access public
     * @param string $tag Text string to be displayed as the link. Defaults to '<<'
     * @return string
     */
    function renderPrev($tag='<<') {
        if($this->page > 1) {
            return '<a href="'.$this->php_self.'?page='.($this->page-1).'">'.$tag.'</a>';
        }
        else {
            return $tag;
        }
    }
    
    /**
     * Display the page links
     *
     * @access public
     * @return string
     */
    function renderNav() {
        for($i=1;$i<=$this->max_pages;$i+=$this->links_per_page) {
            if($this->page >= $i) {
                $start = $i;
            }
        }
        
        if($this->max_pages > $this->links_per_page) {
            $end = $start+$this->links_per_page;
            if($end > $this->max_pages) $end = $this->max_pages+1;
        }
        else {
            $end = $this->max_pages;
        }
            
        $links = '';
        
        for( $i=$start ; $i<$end ; $i++) {
            if($i == $this->page) {
                $links .= " $i ";
            }
            else {
                $links .= ' <a href="'.$this->php_self.'?page='.$i.'">'.$i.'</a> ';
            }
        }
        
        return $links;
    }
    
    /**
     * Display full pagination navigation
     *
     * @access public
     * @return string
     */
    function renderFullNav() {
        return $this->renderFirst().' '.$this->renderPrev().' '.$this->renderNav().' '.$this->renderNext().' '.$this->renderLast();    
    }
    
    /**
     * Set debug mode
     *
     * @access public
     * @param bool $debug Set to TRUE to enable debug messages
     * @return void
     */
    function setDebug($debug) {
        $this->debug = $debug;
    }
}
?>