How to use PHP & MySQL Display Multiple Column and Paging/Pagination

add just image folder and insert some images in it.

<html>
<head>
<title>phpmyqlmaster.blogspot.com</title>
</head>
<body>
    <?php
        $objConnect = mysql_connect("localhost","root","") or die(mysql_error());
        $objDB = mysql_select_db("test");
        $strSQL = "SELECT * FROM gallery";
        $objQuery = mysql_query($strSQL);
        $Num_Rows = mysql_num_rows($objQuery);

        $Per_Page = 4;   // Per Page

        $Page = $_GET["Page"];
        if(!$_GET["Page"])
        {
            $Page=1;
        }

        $Prev_Page = $Page-1;
        $Next_Page = $Page+1;

        $Page_Start = (($Per_Page*$Page)-$Per_Page);
        if($Num_Rows<=$Per_Page)
        {
            $Num_Pages =1;
        }
        else if(($Num_Rows % $Per_Page)==0)
        {
            $Num_Pages =($Num_Rows/$Per_Page) ;
        }
        else
        {
            $Num_Pages =($Num_Rows/$Per_Page)+1;
            $Num_Pages = (int)$Num_Pages;
        }

        $strSQL .=" order by GalleryID ASC LIMIT $Page_Start , $Per_Page";
        $objQuery = mysql_query($strSQL);

        echo"<table border=\"0\" cellspacing=\"1\" cellpadding=\"1\"><tr>";
        $intRows = 0;
        while($objResult = mysql_fetch_array($objQuery))
        {
            echo "<td>";
            $intRows++;
    ?>
            <center>
                <img src="images/<?php echo $objResult["Picture"]; ?>"><br>
                <?php echo $objResult["GalleryName"];?>
                <br>
            </center>
    <?php
            echo"</td>";
            if(($intRows)%2==0)
            {
                echo"</tr>";
            }
        }
        echo"</tr></table>";
    ?>

        <br>
        Total <?php echo $Num_Rows; ?> Record : <?php echo $Num_Pages; ?> Page :
        <?php
        if($Prev_Page)
        {
            echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> ";
        }

        for($i=1; $i<=$Num_Pages; $i++){
            if($i != $Page)
            {
                echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
            }
            else
            {
                echo "<b> $i </b>";
            }
        }
        if($Page!=$Num_Pages)
        {
            echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> ";
        }
        ?>

</body>
</html>
<?php
mysql_close($objConnect);
?>

PHP MYSQL DATABASE

CREATE TABLE `gallery` (
`GalleryID` int(11) NOT NULL auto_increment,
`GalleryName` varchar(100) NOT NULL,
`Picture` varchar(100) NOT NULL,
PRIMARY KEY (`GalleryID`)
) ENGINE=MyISAM ;

INSERT INTO `gallery` VALUES (1, 'Picture 1', 'img1.jpg');
INSERT INTO `gallery` VALUES (2, 'Picture 2', 'img2.jpg');
INSERT INTO `gallery` VALUES (3, 'Picture 3', 'img3.jpg');
INSERT INTO `gallery` VALUES (4, 'Picture 4', 'img4.jpg');
INSERT INTO `gallery` VALUES (5, 'Picture 5', 'img5.jpg');
INSERT INTO `gallery` VALUES (6, 'Picture 6', 'img6.jpg');
INSERT INTO `gallery` VALUES (7, 'Picture 7', 'img7.jpg');
INSERT INTO `gallery` VALUES (8, 'Picture 8', 'img8.jpg');

Web Development PHP MYSQL Projects

Tuesday, 15 April 2014

How to use PHP & MySQL Display Multiple Column and Paging/Pagination

No comments:

Post a Comment