PHP object database operation class example, PHP example_PHP tutorial

php object database operation class instance, php instance

The example in this article describes the PHP object database operation class. Share it with everyone for your reference.

The specific implementation code is as follows:

Copy code The code is as follows:

//Construct a database operation class here to encapsulate all database operations
//Can be extended to facilitate the use of background management programs
Class MySQLDB
{
var $host;
var $user;
var $passwd;
var $database;
var $conn;

//Use constructor to initialize variables
// Simultaneously connect to the database operation
function MySQLDB($host,$user,$password,$database)
{ 
$this->host = $host;
$this->user = $user;
$this->passwd = $password;
$this->database = $database;
$this->conn=mysql_connect($this->host, $this->user,$this->passwd) or
Die("Could not connect to $this->host");
mysql_select_db($this->database,$this->conn) or
Die("Could not switch to database $this->database");
}  

//This function is used to close the database connection
function Close()
{ 
MySQL_close($this->conn);
}  

//This function implements database query operations
function Query($queryStr)
{ 
$res =Mysql_query($queryStr, $this->conn) or
         die("Could not query database");                                             Return $res;
}  

//This function returns the record set
function getRows($res)
{ 
$rowno = 0;
        $rowno = MySQL_num_rows($res);                                            If($rowno>0)
                                                                        for($row=0;$row<$rowno;$row++)
                                                                                                $rows[$row]=MySQL_fetch_array($res);
                         // Originally MySQL_fetch_row, but it cannot be fetched in the form of an array, only the index can be used
//This way you can use indexes and names, which is more convenient
                                                                                                        return $rows;                                 }  
}  

//This function retrieves the number of database records
Function getRowsNum($res)
{ 
$rowno = 0;
        $rowno = mysql_num_rows($res);
         return $rowno;
}  

//This function returns the number of database table fields
function getFieldsNum($res)
{
$fieldno = 0;
$fieldno = mysql_num_fields($res);
Return $fieldno;
}

//This function returns the database table field name set
function getFields($res)
{
$fno = $this->getFieldsNum($res);
If($fno>0)
                                                                        for($i=0;$i<$fno;$i++)
                                                                                                 $fs[$i]=MySQL_field_name($res,$i);//Get the name of the i-th field
                                                                                                       return $fs;
}  
}
}

//Require the file directly when using it, and then instantiate:

$SqlDB = new MySQLDB("localhost","root","root","testdb");

$sql = "select * from tableX...";

$result = $SqlDB->Query($sql);//Query

$rs = $SqlDB->getRows($result);//Get the record set

$num = $SqlDB->getRowsNum($result);//Get the number of records

...The remaining operation is to loop through the values,

for($i=0;$i<$num;$i++){
echo($rs[$i]["field name"]);
}

...

Finally, don’t forget to close the data path connection

Copy the code The code is as follows:

$SqlDB->Close();

Of course this sentence is not required , php will automatically log out! But this can develop a good habit, it is best to add it! Others can be deduced by analogy.

I hope this article will be helpful to everyone’s PHP programming design.

http://www.bkjia.com/PHPjc/920615.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/920615.htmlTechArticlephp object database operation class example, php example This article describes the php object database operation class. Share it with everyone for your reference. The specific implementation code is as follows: Copy code...