phpmysql数据库类(php新手入门)

3. //by http://bbs.it-home.org

4. class mySql{
5. private $result;
6. private $conn;
7. public static $hasNew = false;
9. private __construct(){}
10. function __destruct(){
11. self::$hasnew=false;
12. }

13. function doNew(){

14. if(self::$have_new){
15. exit('数据库只能连接一次！');
16. }else{
17. self::$hasNew=true;
18. return new self;
19. }
20. }
22. private function connect($host,$user,$password,$dbname,$charset='utf8'){
23. $this->conn = mysql_connect($host,$user,$password) or exit('错误码：'.mysql_errno(). '数据库连接失败：'.mysql_error());
24. mysql_select_db($dbname,$this->conn) or exit('错误码：'.mysql_errno().'选择数据库失败：'.mysql_error());
25. mysql_query("set names $charset",$this->conn);
26. }

27. function query($sql,$buffer=true){

28. //mysql_real_escape_string($sql,$this->conn);//特殊字符义
29. if($buffer){
30. $this->result=mysql_query($sql,$this->conn) or exit('错误码：'.mysql_errno().'sql语句执行失败：'.mysql_error());
31. }else{
32. $this->result=mysql_unbuffered_query($sql,$this->conn) or exit('错误码：'.mysql_errno().'sql语句执行失败：'.mysql_error());
33. }
34. }
36. function getRecord(){
37. return mysql_fetch_array($this->result);
38. }
40. function close(){
41. mysql_free_result($this->result);
42. mysql_close($this->conn);
43. }

44. }

2、调用示例

3. //数据库

4. $db_host='localhost';
5. $db_user='root';
6. $db_pwd='root';
7. $db_name='news';
8. $charset='utf8';
9. $sql="select * from news_base";

10. $db=mySql::doNew();

11. $db->connect($db_host,$db_user,$db_pwd,$db_name,$charset='utf8');
12. $db->query($sql);
13. while($row=$db->getRecord()){
14. echo $row[1].'
    ';
15. }