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_
Ïà¹ØÎĵµ£º
PHP 5.3.1·¢²¼ÁË£¡´Ë´Î²¢Ã»ÓÐÔö¼Ó¶àÉÙÐÂÌØÐÔ£¬Ö÷ÒªÊǹ¦ÄܵĸĽøºÍbugµÄÐÞ¸´£º
ÐÂÔöÁËÒ»¸ömax_file_uploads²ÎÊý£¬ÓÃÓÚÏÔʾÿ¸öÇëÇóÉÏ´«ÎļþµÄ¸öÊý
ÐÂÔöÁËÔÙ´¦Àí¹ý³ÌÖеÄÍêÕûÐÔ¼ì²â
ÐÞ¸´ÁË´«µÝtempnam()º¯Êýʱsafe_modeÖеÄÎÊÌâ
ÐÞ¸´ÁË´«µÝposix_mkfifo()ʱopen_basedirÖеÄÎÊÌâ
ÐÞ¸´ÁËsafe_mode_include_dirÖеÄÎ ......
1 °²×°MySQL5
ÓÃÏÂÁÐÃüÁî°²×°MySQL£º
yum install mysql mysql-server
È»ºóÎÒÃÇΪMySQL´´½¨ÏµÍ³Æô¶¯Á´½Ó£¨ÕâÑùµÄ»°£¬MySQL¾Í»áËæ×ÅϵͳÆô¶¯¶øÆô¶¯£©£¬²¢Æô¶¯MySQL·þÎñÆ÷£º
chkconfig –levels 235 mysqld on
/etc/init.d/mysqld start
ÔËÐÐ
mysqladmin -u root password yourrootsqlpassword
À´ÎªrootÓû§ÉèÖà ......
ʲôÊÇSESSION£¿ °´ÕÕWIKIµÄ½âÊÍ£¬SESSIONÊÇ´æÔÚÓÚÁ½¸öͨÐÅÉ豸¼äµÄ½»»¥ÐÅÏ¢£¬ÔÚijһʱ¼ä½¨Á¢£¬¾¹ýÒ»¶¨µÄʱ¼äºóʧЧ¡£³£¼ûµÄSESSIONÓУºTCP SESSION¡¢WEB SESSION£¨HTTP SESSION£©¡¢LOGIN SESSIONµÈ¡£ ¸ù¾ÝOSIÄ£ÐÍÖУ¬»á»°ÊµÏÖµÄλÖò»Í¬£¬SESSIONÖ÷Òª·ÖΪ¼¸ÖÖ£¬Ò»ÖÖÊÇÓ¦Óòã»á»°£¬°üÀ¨WEB SESSION£¨HTTP SESSION£©ºÍtel ......
ǰÑÔ£º
¡¡¡¡FCKeidtorÊǸö¹úÍâµÄ¶àÓïÑÔ±à¼Æ÷£¬Äã¿ÉÒÔ¶ÔÆäÅäÖÃÎļþ½øÐмòµ¥ÐÞ¸Äʹ֧֮³ÖĿǰ³£ÓÃWeb¿ª·¢ÓïÑÔµÄÓ¦Óã¬ÏÂÃæÎҾͽ²½²FCKeditorµÄ×îа汾2.4.2ÔÚphpµÄ¾ßÌåÅäÖùý³Ì£¬Óв»×ãºÍ³ö´íµÄµØ·½£¬»¶ÓÖ¸Õý¡£
¾«¼ò£º
¡¡¡¡ÕýÒòΪÕâ¸ö±à¼Æ÷ÊÇÖ§³Ö¶àÓïÑԵģ¬ËùÒÔÊ×ÏÈÎÒÃÇÕë¶ÔʹÓÃ¶ÔÆä×öÏàÓ¦µÄÈßÓàÎļþɾ³ý¡£
¡¡¡ ......