(PHP)CRUDÀ༰·ÖÒ³Àà
֮ǰдµÄcrudÀàʵÔڱȽϼòµ¥£¨http://blog.csdn.net/yycai/archive/2009/12/15/5012353.aspx£©£¬ÖØÐ·â×°ÁËһϣº
<?php
/**
* ×Ô¶¯»¯Êý¾Ý±í²Ù×÷Àà
* @example
* <code>
* $db = cls_crud::factory(array('table'=>'article'));
* $data = $db->get_block_list(array('category_id' => 3), 9);
*
* $data = $db->get_list(array('title', 'id', 'time'), array('category_id'=>$cid), 'time', 1, $_GET['page'], 2, 1);
* $page_html = $db->page->get_html("?action=list&cid={$cid}", 'ylmf-page');
*
* </code>
* @author С²Ì <cyy0523xc@gmail.com>
* @version 1.2
*/
class cls_crud
{
private static $_instance = null;
/**
* Êý¾Ý±íÃû
* @var string
*/
private $table = '';
private $link;
private $query_id;
/**
* ·ÖÒ³¶ÔÏó
* @var array
*/
public $page = null;
/**
* ˽Óй¹Ô캯Êý£¨µ¥Àýģʽ£©
* @param
*/
private function __construct()
{
}
/**
* ÅäÖÃ
* @param array $config ÅäÖñäÁ¿
*/
private function config($config)
{
if(!empty($config))
{
foreach($config as $cf => $val)
{
$this->$cf = $val;
}
}
}
/**
* ¹¤³§º¯Êý
* @param array $config ÅäÖñäÁ¿£¨×î»ù±¾ÒªÅäÖÃÊý¾Ý±íÃû£©
* @param array $database Êý¾Ý¿âÁ´½Ó²ÎÊý
*/
public static function factory($config, $database=array())
{
if (null === self::$_instance)
{
self::$_instance = new self();
self::$_instance->connect($database);
self::$_instance->page = new cls_page();
}
self::$_instance->config($config);
return self::$_instance;
}
/**
* ÉèÖÃÊý¾Ý±í(ÀýÈ磺ÔÚ²Ù×÷µÄ¹ý³ÌÖÐÐèÒª¸Ä±äÊý¾Ý±í£¬¾Í¿ÉÒÔʹÓô˷½·¨)
* @param string $table
*/
public function set_table($table)
{
$this->table =
Ïà¹ØÎĵµ£º
½ñÌì»Ø¹ËÁËÏÂÕýÔòµÄ»ù±¾ÖªÊ¶¡£ ×ÜÈÝÒ×Íü£¬ÌؼÇÓÚ´Ë¡£
ÓÃÓÚÃèÊö×Ö·ûÅÅÁÐºÍÆ¥ÅäģʽµÄÒ»ÖÖÓï·¨¹æÔò¡£ËüÖ÷ÒªÓÃÓÚ×Ö·û´®µÄģʽ·Ö¸î¡¢Æ¥Åä¡¢²éÕÒ¼°Ìæ»»²Ù×÷¡£
PHPÖеÄÕýÔòº¯Êý£º
PHPÖÐÓÐÁ½Ì×ÕýÔòº¯Êý£¬Á½Õß¹¦Äܲ¶à£¬·Ö±ðΪ£º
Ò»Ì×ÊÇÓÉPCRE£¨Perl Compatible Regular Expression£©¿âÌṩµÄ¡£Ê¹ÓÓpreg_” ......
»ù±¾¸ÅÄî
Ò»¸öÕýÔò±í´ïʽͨ³£±»³ÆÎªÒ»¸öģʽ (pattern)£¬ÎªÓÃÀ´ÃèÊö»òÕ߯¥ÅäһϵÁзûºÏij¸ö¾ä·¨¹æÔòµÄ×Ö·û´®¡£ÀýÈ磺Handel¡¢Händel ºÍ Haendel ÕâÈý¸ö×Ö·û´®£¬¶¼¿ÉÒÔÓÉ“H(a|ä|ae)ndel”Õâ¸öģʽÀ´ÃèÊö¡£´ó²¿·ÖÕýÔò±í´ïʽµÄÐÎʽ¶¼ÓÐÈçϵĽṹ£º
Ñ¡Ôñ| ÊúÖ±·Ö¸ô·û´ú±íÑ¡Ôñ¡£ÀýÈç“gray|grey&rd ......
1.°Ñ½âѹµÄphp-5.2.6-Win32.zipÖØÃüÃûΪphp5¡£²¢¸´ÖƵ½DÅÌĿ¼Ï¡£¼´°²×°Â·¾¶Îª D:\php5
2.ÕÒµ½phpĿ¼Ï嵀 php.ini-dist»ò php.ini.recommendedÎļþ£¬ÖØÃüÃûΪ php.ini
3.ÔÙ°ÑphpĿ¼ÏµÄphp5ts.dll,libmysql.dll¸´ÖƵ½Ä¿Â¼ c:\windows\system32Ï¡£
4.°Ñphp5\extĿ¼ÏµÄphp_gd2.dll,php_mysql.dll,php_mbstring.dllÎ ......
1¡¢·Ö±ð°²×°Èý¸ö»·¾³£¬²¢ÉèÖò»Í¬¶Ë¿Ú
PHP:80
JSP:8080
ASP:8081
2¡¢ÉèÖÃ/Apache2/conf/httpd.conf
È¥µôÒÔÏÂÈýÐÐǰµÄ×¢ÊÍ£º
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule proxy_http_module modules/mod_proxy_http.so
¼ÓÈëÒÔϼ¸ÐУº ......
1£¬¶¨Òåheader()Í·²¿Êä³ö¸ñʽ
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:finlename=php.xls");
vnd.ms-excel -----¶¨ÒåÊä³öÎļþ¸ñ
php.xls ---------¶¨ÒåÊä³öµÄÎļþÃû
2£¬Êä³ö±à ......