PHP²»±äµÄһЩ¾­µäÀà

 MYSQL,·ÖÒ³ÀàÊÇдPHP´úÂë×î³£Óõļ¸¸öÀà¡£
½ñÌì¿´PHP100µÄÊÓƵ£¬Ô½ÓÃÔ½·¢ÏÖÀïÃæÁ½¸öÀàºÃÇ¿´ó£¬ËäÈ»¸Ð¾õ»¹ÊÇÓоÖÏÞÐÔ£¬µ«ÊÇËüµÄд·¨ÒѾ­ºÜ³ÉÊìÁË¡£
Ò»¸öÊÇMYSQL£¬Ò»¸öÊÇ·ÖÒ³Àà¡£
MYSQL£º
<?php
class mysql {
private $db_host; //Êý¾Ý¿âÖ÷»ú
private $db_user; //Êý¾Ý¿âÓû§Ãû
private $db_pwd; //Êý¾Ý¿âÓû§ÃûÃÜÂë
private $db_database; //Êý¾Ý¿âÃû
private $conn; //Êý¾Ý¿âÁ¬½Ó±êʶ;
private $result; //Ö´ÐÐqueryÃüÁîµÄ½á¹û×ÊÔ´±êʶ
private $sql; //sqlÖ´ÐÐÓï¾ä
private $row; //·µ»ØµÄÌõÄ¿Êý
private $coding; //Êý¾Ý¿â±àÂ룬GBK,UTF8,gb2312
private $bulletin = true; //ÊÇ·ñ¿ªÆô´íÎó¼Ç¼
private $show_error = true; //²âÊԽ׶Σ¬ÏÔʾËùÓдíÎó,¾ßÓа²È«Òþ»¼,ĬÈϹرÕ
private $is_error = false; //·¢ÏÖ´íÎóÊÇ·ñÁ¢¼´ÖÕÖ¹,ĬÈÏtrue,½¨Òé²»ÆôÓã¬ÒòΪµ±ÓÐÎÊÌâʱÓû§Ê²Ã´Ò²¿´²»µ½ÊǺܿàÄÕµÄ
/*¹¹Ô캯Êý*/
public function __construct($db_host, $db_user, $db_pwd, $db_database, $conn, $coding) {
$this->db_host = $db_host;
$this->db_user = $db_user;
$this->db_pwd = $db_pwd;
$this->db_database = $db_database;
$this->conn = $conn;
$this->coding = $coding;
$this->connect();
}
/*Êý¾Ý¿âÁ¬½Ó*/
public function connect() {
if ($this->conn == "pconn") {
//ÓÀ¾ÃÁ´½Ó
$this->conn = mysql_pconnect($this->db_host, $this->db_user, $this->db_pwd);
} else {
//¼´Ê¹Á´½Ó
$this->conn = mysql_connect($this->db_host, $this->db_user, $this->db_pwd);
}
if (!mysql_select_db($this->db_database, $this->conn)) {
if ($this->show_error) {
$this->show_error("Êý¾Ý¿â²»¿ÉÓãº", $this->db_database);
}
}
mysql_query("SET NAMES $this->coding");
}
/*Êý¾Ý¿âÖ´ÐÐÓï¾ä£¬¿ÉÖ´ÐвéѯÌí¼ÓÐÞ¸Äɾ³ýµÈÈκÎsqlÓï¾ä*/
public function query($sql) {
if ($sql == "") {
$this->show_error("SQLÓï¾ä´íÎó£º", "SQL²éѯÓï¾äΪ¿Õ");
}
$this->sql = $sql;
$result = mysql_query($this->sql, $this->conn);
if (!$result) {
//µ÷ÊÔÖÐʹÓã¬sqlÓï¾ä³ö´íʱ»á×Ô¶¯´òÓ¡³öÀ´
if ($this->show_