Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

PHPÁ¬½ÓMySQL

<?php
/**
* Mysql DB
*
* @author Administrator
* @package defaultPackage
*/
class MySqlDB{
private $_db;
private static $_instance;
private function __construct(&$db_type){
global $connectionstr;
$conn_db=$connectionstr[$db_type];
$this->_db=mysql_pconnect($conn_db["servername"],$conn_db["usernmae"],$conn_db["pwd"]);
if(!$this->_db){
die("'Could not connect: ".mysql_error());
}
mysql_select_db($conn_db["dbname"],$this->_db);
}
private function __clone(){

}
public static function getInstance(&$db_type){
if(!(self::$_instance instanceof self)){
self::$_instance=new self($db_type);
}
return self::$_instance;
}
function query($sql){
mysql_query("SET NAMES 'GBK'",$this->_db);
return mysql_query($sql,$this->_db);
}
function get_result_sql($sql){
return $this->query($sql);
}
/***¸ù¾Ýsql£¬·µ»ØÊý×éÊý¾Ý,ÓдíÎóÌáʾ***/
function getarray($sql){
$result_ay=array();
if($re=$this->query($sql)){
while ($row=mysql_fetch_array($re)) {
$result_ay[]=$row;
}
}
else {
js_msg("Êý¾Ý·ÃÎÊÓÐ´í£¡",-1);
}
return $result_ay;
}
/***¸ù¾Ýsql£¬·µ»ØÊý×éÊý¾Ý***/
function getarray_no_msg($sql){
$result_ay=array();
if($re=$this->query($sql)){
while ($row=mysql_fetch_array($re)) {
$result_ay[]=$row;
//mysql_fetch_array,mysql_fetch_row,
}
}
return $result_ay;
}
/***ÅúÁ¿²éѯ,×Ö¶ÎÏàͬ£¬·µ»ØÒ»Êý×é***/
function getarray_sqls($sql){
$result_ay=array();
if(is_array($sql)){
//print_r($sql);
foreach ($sql as $k=>$v){
if($re=$this->query($v)){
while ($row=mysql_fetch_array($re)) {
$result_ay[]=$row;
}
}
}
}
else {
$result_ay=$this->getarray_no_msg($sql);
}
return $result_ay;
}
/**
* »ñÈ¡¶à¸ö½á¹û¼¯
*
* @param array sqls
* @return array
*/
function getarrays_sqls($sql){
$result_ay=array();
if(is_array($sql)){
foreach ($sql as $k=>$v){
$temary=array();


Ïà¹ØÎĵµ£º

PHPÊÓÆµ½Ì³ÌÏÂÔØ£¨PHP100ϵÁÐÊÓÆµ½Ì³Ì£©

PHPÊÓÆµ½Ì³ÌÏÂÔØ£¨PHP100ϵÁÐÊÓÆµ½Ì³Ì£©
PHP100ÊÇÒ»¸öÕë¶ÔPHP³õѧÕßµÄPHPÊÓÆµ½ÌÑ§ÍøÕ¾£¬ÓÐÂù¸ßµÄÈËÆøºÍ»îÁ¦¡£Ä¿Ç°ÍøÉϵÄPHPµÄÊÓÆµ×ÊÔ´²¢²»¶à£¬¶àÊý¶¼ÊÇÔÚÓÅ¿áµÈÊÓÆµÍøÕ¾ÉϵĽ̳̣¬ÊÓÆµ²»ÇåÎú£¬¶øÇÒÒ²²»È«ÃæºÍϵͳ¡£¶øPHP100ÍøÕ¾ÉϵÄϵÁÐÊÓÆµ½Ì³Ì£¬ÅäÓпμþ£¬´ÓÈëÃŵ½¾«Í¨£¬ºÜ²»´í£¬»ù±¾±£³ÖÒ»ÖÜÒ»ÆÚµÄ¸üÐÂËÙ¶È¡£share it£ ......

PHP ¶à×Ö½Ú×Ö·û´®ºÍ×Ö·û¼¯

// ÎÒ¿´¹ýµÄÁ½±¾Êé PHP µÄÊéÖÐÌá¼°µ½ PHP6 µÄÐÂÌØÐÔ£¬ÆäÖÐÁ½¸öÊÇ namespace ºÍ unicode£¬
// ´Ó PHP5.3 ¿ªÊ¼£¬php ÒѾ­Ö§³Ö namespace ÁË; ¶ø Unicode ÔÚ PHP5.3 Öл¹Ã»Óз¢²¼¡£
//
// ¿´Êé¿´µ½ PHP µÄ¶à×Ö½Ú´¦Àí£¬Ï뵽ǰ¶Îʱ¼ä»¹»á×Ô¼º½ØÈ¡ ÖÐÓ¢»ìºÏµÄ×Ö·û´®£¬ÄÇʱºò»¨Á˺ܳ¤Ê±¼äÀ´¿´ utf£­8£¬
// gbk, gb2312, gb180 ......

[ת]UbuntuÏÂphp¿ª·¢»·¾³ÅäÖÃ(XAMPP)

UbuntuÎÞÒÉÊÇlinux³õѧÕßµÄÊ×Ñ¡°æ±¾£¬ÒòΪËüͼÐνçÃæÖ§³ÖµÄ·Ç³£ºÃ¡£
È»¶øxammpÊÇphp³õѧÕßµÄÊ×Ñ¡¡£
1.ʲôÊÇxammp?
XAMPP£¨Apache+MySQL+PHP+PERL£©ÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄ½¨Õ¾¼¯³ÉÈí¼þ°ü¡£Õâ¸öÈí¼þ°üÔ­À´µÄÃû×ÖÊÇLAMPP£¬µ«ÊÇΪÁ˱ÜÃâÎó½â£¬×îÐµļ¸¸ö°æ±¾¾Í¸ÄÃûΪ XAMPP ÁË¡£Ëü¿ÉÒÔÔÚWindows¡¢Linux¡¢SolarisÈýÖÖ²Ù×÷ϵͳϰ² ......

Mysql µ¼Èë .sqlÎļþÖÐÎÄÂÒÂ룿

 --default-character-set=utf8 ÓëÐÞ¸ÄsqlÎļþ¼ÓÈ룺SET NAMES 'utf8'; 
µ¼Èë½Å±¾Ê±£¬SET NAMES 'xxx' £¬xxxÓ¦¸ÃºÍsql½Å±¾ÎļþµÄʵ¼Ê±àÂëÒ»Ö£¬Èç¹ûÄãÉèÖõÄʱutf-8 £¬ÄÇôÇëÈ·ÈÏÄãµÄsql½Å±¾Îļþʱutf-8±£´æµÄ:
iconv -f UTF-8 xxx.sql
Èç¹ûÏÔʾÕý³££¬ÄÇôÕâÒ»²½¾ÍOKÁË
ÁíÍâ×¢ÒâÄãµÄ½Å±¾ÀÓÐûÓиø¿â±íÉèÖ ......

UbuntuÏÂmysqlÐÞ¸Ä×Ö·û¼¯

Ê×ÏÈÍ£Ö¹MySQL·þÎñ£ºsudo /etc/init.d/mysql stop
È»ºó±à¼­MySQLÅäÖÃÎļþ£ºsudo gedit /etc/mysql/my.cnf
ÔÚmy.cnfÎļþÖеÄ[client]¶ÎÏÂÃæ¼ÓÈë
default-character-set=utf8
[mysqld_safe]
default-character-set=utf8
[mysqld]
default-character-set=utf8
[mysql]
default-character-set=utf8
ÖØÐÂÆô¶¯MySQL·þÎñ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ