Home > Backend Development > PHP Tutorial > asp.net database connection integrates the previous PHP database connection class~~ to make a paging class!

asp.net database connection integrates the previous PHP database connection class~~ to make a paging class!

WBOY
Release: 2016-07-29 08:35:20
Original
976 people have browsed it

I don’t know if there is any future for learning PHP~ Hey, the more I write, the more boring I feel.
;//Username;
var $dbpwd = "";//Password;
var $dbtable = "mysql";//Database used
var $conn; //Database connection;
var $result; //Result Set
var $mysql; //Executed mysql
var $row; //Find data in the result set
function createconn() //This class method starts a conn connection and then starts to select the database
{
$this-> conn = mysql_connect($this->db,$this->dbname,$this->dbpwd);
mysql_select_db($this->dbtable,$this->conn);
}
function getresule( ) //This is to get a result set
{
$this->result = mysql_query($this->mysql,$this->conn);
}
function getrow() //Create a forward Result set pointer
{
$this->row = mysql_fetch_array($this->result);
return $this->row;
}
function closedatabase()
{
mysql_close($this->conn ; ->createconn(); // Call the connection of the class
$bb->mysql="select * from friends_conf";
$bb->getresule(); // Call the class to get the result set
while($bb ->getrow()){ //Call the class to create a pointer and read the data forward in a loop,
echo($bb->row["confname"]);
echo($bb->row["confvalue" ]);
}*/
?>
//Page class~ Inherits the above method
Class pagefy extends createdb{
var $nametatol; ; //The number of records to be displayed on each page
var $pageall;
var $i = 1;
var $m;
var $p = 8; //The page number to be displayed;
var $a;
function gettatol() //How to get the total number of records
{ //Connect to the database first
$this->nametatol = $this->row[0]; //Total number of records
}
function getpage() //Get the total number of pages
{
$this->pageall = $this->nametatol % $this->namemust;
if($this->pageall)
{
$this->pageall = (int)($this->nametatol / $this->namemust) + 1;
return $this->a = $this->pageall ;
}
else
{
return $this-> a = $this->pageall = (int)($this->nametatol / $this->namemust);
}
}
function num_pl() //Page number display
{
$this->pageall = $this->pageall - ($this->pageall - $this->p);
while($this->pageall)
{
echo("$this->i");
echo(" "); //If you want to show the style, add it yourself
$this->i++;
$this ->pageall =$this->pageall -1;
}
}
function get_num_pl() //Get the previous parameter of LIMIT (starting ROW number)
{
$this->m = $_GET[ "n"] * $this->namemust - $this->namemust;
}
function showpage() //Show paginated content
{
$this->createconn();
$this->mysql="select * from friends_conf limit $this->m,$this->namemust ";
$this->getresule();
while($this->getrow())
{
echo($this->row["confname"]); //The field you want to read out , add it yourself
echo($this->row["confvalue"]);
}
}
function firstpage() //Home page
{
echo("Homepage");
}
function backpage() //Previous page
{
if($this->i = $_GET["n"] - 1)
{
echo( "
Previous page");
}
}
function nextpage() //Next page
{
$ this->i = $_GET["n"] + 1;
if($this->i <= $this->a)
{
echo("
Next page");
}
}
function footpage() //Last page
{
echo("
Last page");
}
}
?>
$mm = new pagefy;
$mm ->createconn();
$mm->mysql="select count(*) from friends_conf";
$mm->getresule();
$mm->closedatabase();
$mm-> ;getrow();
$mm->gettatol();
$mm->getpage();
$mm->num_pl();
$mm->get_num_pl();
$mm-> ;showpage();
$mm->closedatabase();
$mm->firstpage();
$mm->backpage();
$mm->nextpage();
$mm-> ;footpage();
?>
This class has been debugged! It is very easy to use~~~~~~~~~~~~~~~~~
The class is your knife~If you don’t refine it in advance, it will be difficult to use it. Go to practice when you fight! ~ Early death ~~
All I have time! Write a functional category ~~~~~~
I should say this category ~~ It's relatively simple ~~~ Look If you don’t understand, ask~

The above introduces the asp.net database connection. It integrates the previous PHP database connection class~~ and makes it into a paging class! It includes the content of asp.net database connection. I hope it will be helpful to friends who are interested in PHP tutorials.

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template