ä¸htmlæ å
³
é¢å对象ç®åç讲就ä¸æ常ç¨ç代ç å°é为classï¼æ¹ä¾¿ä½¿ç¨ã
以æ°æ®åºè¿æ¥ä¸ºä¾ï¼
å¹³æ¶ä½ åºæ¯è¿æ ·åç
<?php
$conn = @mysql_connect('192.168.1.180', 'admin', '123456') or die('è¿æ¥å¤±è´¥');
mysql_select_db('ecshop', $conn);
$query = mysql_query("SELECT * FROM ecs_admin_user");
while ($row = mysql_fetch_assoc($query)) {
echo $row['user_name'];
}
//以ä¸ä»£ç å±é¢åè¿ç¨ï¼ç°å¨å¯ä»¥ç¨é¢å对象æ¹å¼å®ç°
//以ä¸æ¯é¢å对象å®ç°
class DB {
private $conn;
public $dbhost = '127.0.0.1'; //对象å±æ§,é»è®¤ä¸»æºå°å
public $dbuser = 'root'; //对象å±æ§,é»è®¤æ°æ®åºç¨æ·å
public $dbpass = ''; //对象å±æ§,é»è®¤å¯ç
public $dbname = ''; //对象å±æ§,æ°æ®åºå
public function __construct($dbhost = '', $dbuser = '', $dbpass = '', $dbname = '') {
$this->dbhost = !empty($dbhost) ? $dbhost : $this->dbhost;
$this->dbuser = !empty($dbuser) ? $dbuser : $this->dbuser;
$this->dbpass = !empty($dbpass) ? $dbpass : $this->dbpass;
$this->dbname = !empty($dbname) ? $dbname : $this->dbname;
}
//对象æ¹æ³ï¼è¿æ¥
public function connect() {
$this->conn = @mysql_connect($this->dbhost, $this->dbuser, $this->dbpass) or die('è¿æ¥å¤±è´¥');
mysql_select_db($this->dbname, $this->conn);
}
//对象æ¹æ³ï¼è¯¢æ¥æ¹æ³ï¼æ¥è¯¢å¹¶è¿åæ°ç»ç»æ
public function query($sql) {
$query = mysql_query($sql);
$data = array();
while ($row = mysql_fetch_assoc($query)) {
$data[] = $row;
}
return $data;
}
//对象æ¹æ³ï¼å
³éè¿æ¥
public function close() {
mysql_close($this->conn);
}
}
//è¿å°±ä¸ä¸ä¸ªç®åçæ°æ®è¿æ¥åæ¥è¯¢ç±»ï¼ä½ å¯ä»¥ä¿åå°ä¸phpæ件ï¼ä»¥åå¼å
¥å®å°±ç¨å¯ä»¥ç¨äºï¼ä¸é¢å®ä¾å
//å®ä¾1
$db = new DB('192.168.1.180', 'admin', '123456', 'ecshop');
$db->connect();
$result = $db->query("SELECT * FROM ecs_admin_user");
foreach ($result as $rs) {
echo $rs['user_name'], '<br>';
}
//å®ä¾2
$db = new DB();
$db->dbhost = '192.168.1.180';
$db->dbuser = 'admin';
$db->dbpass = '123456';
$db->dbname = 'ecshop';
$result = $db->query("SELECT * FROM ecs_admin_user");
foreach ($result as $rs) {
echo $rs['user_name'], '<br>';
}
//å®ä¾3
$db = new DB('192.168.1.180', 'admin', '123456', 'ecshop');
$db->connect();
$result = $db->query("SELECT * FROM ecs_admin_user");
foreach ($result as $rs) {
echo $rs['user_name'], '<br>';
}
$db->close();
//åæ¢æ°æ®è¿æ¥
$db->dbname = 'wordpress';
$db->connect();
$result = $db->query("SELECT * FROM wp_users");
foreach ($result as $rs) {
echo $rs['user_login'], '<br>';
}
?>
温馨提示:内容为网友见解,仅供参考