PHP Classes

File: testpage.php

Recommend this page to a friend!
  Classes of Reneesh T K   Paginations   testpage.php   Download  
File: testpage.php
Role: Example script
Content type: text/plain
Description: test page
Class: Paginations
Split MySQL query result listings
Author: By
Last change:
Date: 16 years ago
Size: 2,592 bytes
 

Contents

Class file image Download
<?php

include('pagination_class.php');
mysql_connect('localhost', 'user', 'pass') or die(mysql_error());
mysql_select_db('std_db');


/*
-- Table structure for table `students`

CREATE TABLE `students` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY (`id`)
);

INSERT INTO `students` VALUES (1, 'Reneesh');
INSERT INTO `students` VALUES (2, 'Aniesh');
INSERT INTO `students` VALUES (3, 'Babu');
INSERT INTO `students` VALUES (4, 'Antony');
INSERT INTO `students` VALUES (5, 'Praveesh');
INSERT INTO `students` VALUES (6, 'Dixon');
INSERT INTO `students` VALUES (7, 'Sanju');
INSERT INTO `students` VALUES (8, 'Neeraj');
INSERT INTO `students` VALUES (9, 'Siju');
INSERT INTO `students` VALUES (10, 'Noble');
INSERT INTO `students` VALUES (11, 'Bibin');
INSERT INTO `students` VALUES (12, 'Febin');
INSERT INTO `students` VALUES (13, 'Binu');
INSERT INTO `students` VALUES (14, 'Charles');
INSERT INTO `students` VALUES (15, 'jaggu');
INSERT INTO `students` VALUES (16, 'mani');
INSERT INTO `students` VALUES (17, 'milu');
INSERT INTO `students` VALUES (18, 'aravind');
INSERT INTO `students` VALUES (19, 'jay');
INSERT INTO `students` VALUES (20, 'hari');
*/
?>

<script language="JavaScript">
function pagination(page)
{
    window.location = "testpage.php?search_text="+document.form1.search_text.value+"&starting="+page;
}
</script>
<?
$qry
= "SELECT * FROM students";

if(
$_REQUEST['search_text']!=""){
   
$searchText = $_REQUEST['search_text'];
   
$qry .=" where name like '$searchText%'";
}

//for pagination
if(isset($_GET['starting'])&& !isset($_REQUEST['submit'])){
   
$starting=$_GET['starting'];
}else{
   
$starting=0;
}
$recpage = 2;//number of records per page
   
$obj = new pagination_class($qry,$starting,$recpage);
$result = $obj->result;

           
           
?><form name="form1" action="testpage.php" method="POST">
           
            <table border="1" width="40%">
            <tr>
              <TD colspan="2">
                Search <input type="text" name="search_text" value="<? echo $searchText;?>">
                    <input type="submit" value="Search">
              </TD>
            </tr>
            <tr><TD>Sl no</TD><TD>Name</TD></tr>
            <?if(mysql_num_rows($result)!=0){
               
$counter = $starting + 1;
                while(
$data = mysql_fetch_array($result)) {?>
<tr>
                    <TD><? echo $counter; ?></TD>
                    <TD><? echo $data['name']; ?></TD>
                    </tr><?
                    $counter
++;
                }
?>

                   
                <tr><TD align="center" colspan="2"><? echo $obj->anchors; ?></TD></tr>
                <tr><TD align="center" colspan="2"><? echo $obj->total; ?></TD></tr>
            <?}else{
                echo
"No Data Found";
            }
?>
</TD></tr></table></form>