php×ÔÓÃÊý¾Ý»º´æÀà
¸Õ»»ÁËÒ»¸ö¹¤×÷£¬ÏÖÔÚûʲôÊÂ×ö£¬Ð´ÁËÒ»¸öÊý¾Ý»º´æµÄÀà¡£
¿ÉÒÔ»º´æÊý×飬×Ö·û£¬¶ÔÏóµÈ£¬Ö´ÐÐЧÂÊ»¹Ã»ÓвâÊÔ£¬ÏȷųöÀ´°É¡£
ʵÀýÈçÏ£º
* @example
* require 'MyCache.class.php';
* $mc = new MyCache("./test/cache");
* $a = "hello world111";
* $mc->set("ss", $a);
* $mc->set("dd", $mc);
* $mc->set("2s", $a);
* echo $mc->get("ss");
* $mc->delete("2s");
* $mc->edit("ss", "hello");
* echo $mc->get_type("dd");
* echo "<pre>";
* print_r($c);
<?php
/**
* ×ÔÓõÄphp »º´æÀà
* ¹¦ÄÜ,½«±äÁ¿£¬Êý×é дÈë Îļþ
* ÎļþÃû¼´Îª»º´æ±äÁ¿Ãû
* @example
* require 'MyCache.class.php';
* $mc = new MyCache("./test/cache");
* $a = "hello world111";
* $mc->set("ss", $a);
* $mc->set("dd", $mc);
* $mc->set("2s", $a);
* echo $mc->get("ss");
* echo $mc->get_type("dd");
* $c = $mc->get_all();
* echo "<pre>";
* print_r($c);
* @author: bruce wang 2010 - 03 - 08
* @name: MyCache.class.php
*/
class MyCache {
private $cachePath;//»º´æÄ¿Â¼
private $lifeTime;//»º´æÓÐЧʱ¼ä
private $pathSeq;//µ±Ç°ÏµÍ³µÄ·Ö¸ô·û
/**
* ¹¹Ô캯Êý£¬³õʼ»¯
* @param : string 'cachePath', 'lifeTime'
* @return null
*/
function MyCache($cachePath = "dataCache", $lifeTime = 0){
//Åжϻº´æÎļþ¼ÐÊÇ·ñ´æÔÚ£¬·ñÔò´´½¨
$this->create_dirs($cachePath);
$this->pathSeq = DIRECTORY_SEPARATOR;
$this->lifeTime = $lifeTime;
$this->cachePath = realpath($cachePath);
}
/**
* ´´½¨»º´æÎļþ²¢Ð´ÈëÊý¾Ý
* @param:string $var ±äÁ¿Ãû
* @param: mixed $data ±äÁ¿Êý¾Ý
* @return null
*/
function set($var, $data){
$fileFullName = $this->get_full_name($var);
if(!file_exists($fileFullName)){
$this->write_cache_file($var, $data);
}
else{
if(!$this->is_file_live($var)){//²»ÔÚÓÐЧÆÚ
unlink($fileFullName);//ɾ³ý²»ÔÚÓÐЧÆÚµÄ»º´æÎļþ
$this->write_cache_file($var, $data);
Ïà¹ØÎĵµ£º
1 MYSQLÖеÄ×Ö·û¼¯¸ÅÄî
MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ"Character set£¨×Ö·û¼¯£©"£¬ÁíÒ»¸öÊÇ"Collations"¡£
1.1 Collations
Collations·³ÉÖÐÎÄÊÇ"УÑé"£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬 ASCII×Ö·û¼¯ÀCol ......
Á¬½Óµ½Êý¾Ý¿âÖ®ºó£¬¼´¿ÉÔÚÊý¾Ý¿âÖд´½¨ËùÐèÒªµÄ±í¡£ÔÚÊý¾Ý¿âÖд´½¨±í£¬¿ÉÒÔͨ¹ýÊÇÓÃPHPµÄMSSQL¿âº¯ÊýÖеÄmssql_query()º¯ÊýÖ´ÐÐÏàÓ¦µÄ½¨±íSQLÓï¾äÀ´ÊµÏÖ¡£º¯Êýmssql_query()ÊÇרÃÅÓÃÓÚÖ´ÐÐSQLÓï¾äµÄº¯Êý£¬¸Ãº¯Êý´úÂë¸ñʽ£º
mixed mssql_query(string query[,resource link_identifier[,int batch_size]])
¸Ãº¯Êý²ÎÊ ......
Òªä¯ÀÀ±íÖеļǼÐèÒªÖ´ÐÐÒÔϼ¸²½²Ù×÷£º
(1) Ö´ÐÐÒÔÏÂSQLÓï¾ä£º
select field1,field2,field3,...from $table_name
ÆäÖÐfield1,field2,field3±íʾµÄÊÇÐèÒª´Ó±íÖвéѯµÄ×Ö¶ÎÃû³Æ£º$table_nameΪ±íµÄÃû³Æ¡£
(2)ʹÓÃPHP MSSQLÀà¿âÖеÄmssql_fetch_array()º¯Êý¶ÁȡִÐÐSQLÓï¾äËù·µ»ØµÄ½á¹û¼¯¡£¸Ãº¯ÊýµÄÓï·¨¸ñʽÈçÏ´úÂ룺 ......