PHP object database operation class_PHP tutorial-PHP Tutorial-php.cn

PHP object database operation class_PHP tutorial

WBOY

Release： 2016-07-13 10:59:49

Original

882 people have browsed it

//************************************************ *******************
//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
// Simultaneous connection to 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
functionClose()
{
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 it was MySQL_fetch_row, but it cannot be extracted in the form of an array, only the index
                    //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;
       }
}

}

When using it, directly require the file and then instantiate it:

$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 connection $SqlDB->Close(); Of course, you don’t need to do this, php will automatically log out! But this can develop a good habit, so it’s best to add it!

...make your own analogy with others...if you don’t understand, you can ask questions!

http://www.bkjia.com/PHPjc/631859.html