Shulou(Shulou.com)06/03 Report--

This article mainly introduces "the example explanation of php face object database operation class". In the daily operation, I believe that many people have doubts on the example explanation of php face image object database operation class. The editor has consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "php face image object database operation class example explanation". Next, please follow the editor to study!

In this paper, an example is given to describe the operation class of php object database. Share it with you for your reference.

The specific implementation code is as follows:

The copy code is as follows:

/ / construct a database operation class here to encapsulate all database operations

/ / it can be expanded 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

/ / connect to the database at the same time

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 operation

Function Query ($queryStr)

{

$res = Mysql_query ($queryStr, $this- > conn) or

Die ("Could not query database")

Return $res

}

/ / this function returns the recordset

Function getRows ($res)

{

$rowno = 0

$rowno = MySQL_num_rows ($res)

If ($rowno > 0)

{

For ($row=0;$rowgetFieldsNum ($res)

If ($fno > 0)

{

For ($iQuery ($sql); / / query

$rs = $SqlDB- > getRows ($result); / / get the recordset

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

... The rest of the operation is to loop the value.

For ($iClose ()

Of course, you don't need this sentence, php will log out automatically! But this can form a good habit, it is best to add! Others are their own analogies.

At this point, the study on the "example explanation of php object database operation class" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.