MySQL Delete and change tool PHP class

Previous development projects did not use a framework, directly object-oriented development of a very useful MySQL tool class. Header ("Content-type:text/html;charset=utf-8"); Class dbutils{ /** * Generic Update method Insert Update Delete operation * @param sql * @return bool True False */ Public Function Update ($sql) { $link = $this->getconn (); mysql_query ($sql); If an error is displayed if (DEBUG) { Echo Mysql_error (); } $rs = Mysql_affected_rows ($link); $rs = $rs > 0; Mysql_close ($link); return $rs; } /** * General Query Method Select operation * @param sql * @return Array */ Public Function QueryRows ($sql) { Create connection, encode, database $link = $this->getconn (); Send SQL $rs = mysql_query ($sql); If an error is displayed if (DEBUG) { Echo Mysql_error (); } $rows = Array (); while ($row = Mysql_fetch_array ($rs)) { $rows [] = $row;//pdemo7.php } // Mysql_free_result ($RS); Mysql_close ($link); return $rows; } /** * General Query method Select operation query result row data * @param sql * @return Array if the failure returns false; */ Public Function Queryrow ($sql) { $rs = $this->queryrows ($sql); if (!empty ($rs [0])) { return $rs [0]; } return false; } /** * General Query method Select operation query result one data * @param sql * @return Array if the failure returns false; * Example: SELECT COUNT (*) from user; */ Public Function Queryobj ($sql) { $rs = $this->queryrows ($sql); Var_dump ($RS); if (!empty ($rs [0][0])) { return $rs [0][0]; } return false; } Private Function Getconn () { $link = mysql_connect (' 127.0.0.1 ', ' root ', '); mysql_query ("Set names UTF8"); mysql_select_db ("News"); return $link; } } Copy Code

MySQL, PHP

