<?PHP
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = "";
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'course';
$connection = mysql_select_db($dbname);

$limit = 2;
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * $limit;

//this part goes after the checking of the $_GET var
$fetch = mysql_query("SELECT * FROM course LIMIT $start_from, $limit")or
die(mysql_error());
   $num=Mysql_num_rows($fetch);
        if($num>0)
        {
      echo  '<div class="carousel slide" id="fade-courses-carousel" data-ride="carousel" data-interval="5000">
                 <!-- Carousel items -->
                  <div class="carousel-inner">
                    <div class="active item">
                            <div class="active item">
                        <ul class="courses-list">';
        for($i=0;$i<$num;$i++)
        {
        $row=mysql_fetch_row($fetch);

         echo'<li><a href="hindi_tutorials.php?cat='.$row[0].'"><img width="245" height="185" src="http://localhost/websoft/myadmin/uploads/course/'.$row[2].'" alt="courses"/><span class="courses-name">'.$row[1].'</span></a></li>';


        }//for
      echo ' </ul>';


      $sql = "SELECT * FROM course";
    $rs_result = mysql_query($sql);
    $row = Mysql_num_rows($rs_result);

    $total_records = $row;

    $total_pages = ceil($total_records / $limit);
$pagLink = "<div class='pagination'>";
for ($i=1; $i<=$total_pages; $i++) {
             $pagLink .= "<a href='test.php?page=".$i."'>".$i."</a>";
}
echo $pagLink . "</div>";
        }
?>