PHP basic------Database Operations classes

classdb{//member Fields    Private$_dbhost; Private$_dbuser; Private$_dbpwd; Private$_dbname; Private$_dbchar; //constructor to initialize data && connect to database && Select Database && Select Character Set     Publicfunction __construct ($dbhost, $dbuser, $dbpwd, $dbname, $dbchar) {//Initializing Data$ This->_dbhost =$dbhost; $ This->_dbuser =$dbuser; $ This->_dbpwd =$dbpwd; $ This->_dbname =$dbname; $ This->_dbchar =$dbchar; //connecting to a database$link = @mysql_connect ($ This->_dbhost,$ This->_dbuser,$ This->_DBPWD) or Die ("database connection Failed!". Mysql_error ()); //Select Databasemysql_select_db ($ This-_dbname, $link); //Select a character setmysql_query ("Set Names".$ This-_dbchar); }        //Execute SQL statements are executed directly for additions and deletions, and return a result set for the query     Publicfunction Query ($sql) {returnmysql_query ($sql); }        //number of statistics records     Publicfunction num ($sql) {//call the Query method of this class to get the result set$result = $ This-query ($sql); //returns the number of records        returnmysql_num_rows ($result); }        //returns the number of rows affected, for insert update     Publicfunction affected () {returnmysql_affected_rows (); }        //Select gets a record     Publicfunction GetOne ($sql) {$result= $ This-query ($sql); //returns an associative array        returnMysql_fetch_assoc ($result); }        //Select to get a two-dimensional array     Publicfunction GetAll ($sql) {$result= $ This-query ($sql); $arr=Array ();  while($rows =Mysql_fetch_assoc ($result)) {$arr []=$rows; }        return$arr; }}

PHP basic------Database Operations classes