PHP Classes
elePHPant
Icontem

File: example.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Protung Dragos  >  SQL Data Browsing  >  example.php  >  Download  
File: example.php
Role: Example script
Content type: text/plain
Description: Example script
Class: SQL Data Browsing
Browse and paginate MySQL query results
Author: By
Last change:
Date: 10 years ago
Size: 2,441 bytes
 

Contents

Class file image Download
<!--

 include a CSS file with definitions for
   table.sql_data_browsing
   tr.sql_data_browsing
   td.sql_data_browsing

//-->
<link rel="stylesheet" type="text/css" href="css.css">

<?php

// connect to the mySQL server
$dbcon = mysql_connect("localhost", "root", "")
   or die (
"Could not connect to MySQL");

// select the database
mysql_select_db ("test")
   or die (
"Could not select database");

// make the query
$sql_result = mysql_query ("SELECT * FROM test_table");

// include the classes
require_once ("sql_data_browsing.class.php");
require_once (
"pagination.class.php");


/*
  ##
  ## Configuration
  ##
*/

$records_per_page = 25; // number of records on a page

(int)$page = $_GET["pag"]; // get the curent page
                           // first page is 0 and not 1
                           // on output the first page will be 1 so users will not get something like: page 0 , page 1 , page 2 , etc

$table_colors = "EFEFEF_CCCCCC_E0E1BF_E1C05C"; // the 4 colors used in the table
                                               // HTML code without the "#" in front
                                               // color 1 = backgroud for odd rows
                                               // color 2 = background for even rows
                                               // color 3 = background for mouse over rows
                                               // color 4 = background for selected rows (after a click on a row)

$no_data_text = "No data to show"; // text to show when there is no data retrived from the query

$pagination_link ="$PHP_SELF?pag="; // the URL for the pagination links
                                    // the page number will be added after the link

$pagination_links_patern = "[ %s ]"; // the patern for showing the page numbers
                                     // where there is %s , there will the page number will be shown


$sql_data = new sql_data_browsing($sql_result, $page, $records_per_page, $table_colors, $no_data_text);
$sql_pag = new pagination($sql_result, $page, $records_per_page, $pagination_link, $pagination_links_patern);

// output data
$sql_data -> show_data(); // output the data from the sql result
$sql_pag -> show_pagination(); // output the page numbers (pagination links)

// Please send your suggestions, bug reports and general feedback to dragos@protung.ro


?>