1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / karyaninfotech / public_html /
Filename : photo.php
back
<html>
<head>
<title>Photo | Karyan Infotech</title>
</head>
</html>

<?php include("header.php");?>
    <!-- Page Header Start -->
    <div class="container-fluid page-header d-flex flex-column align-items-center justify-content-center pt-0 pt-lg-5 mb-5" id="page-headerr">
        <h1 class="display-4 text-white mb-3 mt-0 mt-lg-5">Photo</h1>
        <div class="d-inline-flex text-white">
            <p class="m-0"><a class="text-white" href="index.php">Home</a></p>
            <p class="m-0 px-2">/</p>
            <p class="m-0">Photo</p>
        </div>
    </div>
    <!-- Page Header Start -->
<div class="container">
<div class="row">

<?php  

  

    //database connection  

   $conn = mysqli_connect("localhost","karyaninfotech_3k",",(x4@!1GVVta","karyaninfotech_3k");

    if (! $conn) {  

die("Connection failed" . mysqli_connect_error());  

    }  

    else {  

mysqli_select_db($conn, 'karyaninfotech_3k');  

    }  

  

    //define total number of results you want per page  

    $results_per_page =12;  

  

    //find the total number of results stored in the database  

    $query = "select *from gallery";  

    $result = mysqli_query($conn, $query);  

    $number_of_result = mysqli_num_rows($result);  

  

    //determine the total number of pages available  

    $number_of_page = ceil ($number_of_result / $results_per_page);  

  

    //determine which page number visitor is currently on  

    if (!isset ($_GET['page']) ) {  

        $page = 1;  

    } else {  

        $page = $_GET['page'];  

    }  

  

    //determine the sql LIMIT starting number for the results on the displaying page  

    $page_first_result = ($page-1) * $results_per_page;  

  

    //retrieve the selected results from database   

    $query = "SELECT *FROM gallery LIMIT " . $page_first_result . ',' . $results_per_page;  

    $result = mysqli_query($conn, $query);  

      

    //display the retrieved result on the webpage  

    while ($row = mysqli_fetch_array($result)) { 

     

        

      ?> 

      

      <div class="col-sm-4">

          <br>

          

         <a href="<?php echo $row["link"];?>"><img src="admin/card-1/<?php echo $row["photo1"];?>" class="video22" style="width:400px;height:400px" >

    

       <br>

       <i class="fa fa-thumbs-up"></i> &nbsp; <?php echo $row['like02'];?>

       &nbsp;&nbsp;&nbsp;&nbsp;<i class="fa fa-eye"></i>&nbsp; <?php echo $row['view02'];?>

 </div></a>

      <?php

      

    }  

  

  

    //display the link of the pages in URL  

    for($page = 1; $page<= $number_of_page; $page++) { 

        

        

       

        echo  '<a href="photo.php?page='.$page.'"> <input type="button" style="width:50px;height:30px;" name="page" value="'.$page.'">
      
 '.'</a>'; 

    }  

  

?>  

                                    
                                    
 
</div>
</div>


  <?php include("footer.php");?>