Home  >  Article  >  Backend Development  >  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
WBOYOriginal
2016-07-29 08:35:20939browse

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.