PHPµÄCRUDÀà
ÒòΪÏîÄ¿ÐèÒª£¬ËùÒÔ×Ô¼ºÐ´ÁËÒ»¸öCRUDÀà
ËäÈ»»¹±È½Ï¼òµ¥£¬²»¹ý¸Ð¾õºÜʵÓá£
×¢£ºcls_databaseÊÇÒ»¸öÊý¾Ý¿â²Ù×÷Àà
¼û£ºhttp://code.google.com/p/cyy0523xc/source/browse/trunk/php/cls_crud.php
<?php
/**
* ×Ô¶¯»¯Êý¾Ý±í²Ù×÷Àà
* @author С²Ì <cyy0523xc@gmail.com>
* @version 1.0
*/
class cls_crud extends cls_database
{
/**
* Êý¾Ý±íÃû
* @var string
*/
private $table = '';
/**
* ¹¹Ô캯Êý
* @param array $config ÅäÖñäÁ¿
*/
public function __construct($config)
{
if(!empty($config))
{
foreach($config as $cf => $val)
{
$this->$cf = $val;
}
}
parent::__construct();
}
/**
* ÉèÖÃÊý¾Ý±í(ÀýÈ磺ÔÚ²Ù×÷µÄ¹ý³ÌÖÐÐèÒª¸Ä±äÊý¾Ý±í£¬¾Í¿ÉÒÔʹÓô˷½·¨)
* @param string $table
*/
public function set_table($table)
{
$this->table = $table;
}
/**
* ¶ÁȡһÌõ¼Ç¼
* @param string $id Ö÷¼ü
* @param string $fields »ñÈ¡×Ö¶Î
* @return array
*/
public function read($id, $fields='*')
{
$sql = "SELECT {$fields} from `{$this->table}` WHERE `id`='{$id}'";
$this->query($sql);
return $this->fetch_one();
}
/**
* ²åÈëÒ»Ìõ¼Ç¼
* @param array $array Êý×é
* @return bool
*/
public function insert($array)
{
$fields = array();
$values = array();
foreach($array as $f => $v)
{
$fields[] = "`{$f}`";
$values[] = "'".mysql_real_escape_string($v)."'";
}
$fields = implode(',', $fields);
$values = implode(',', $values);
$sql = "INSERT INTO `{$this->table}`({$fields}) VALUES({$values})";
return $this->query($sql);
}
/**
* ¸üÐÂÒ»Ìõ¼Ç¼
* @param int $id Ö÷¼ü
* @param array $array Êý¾ÝÊý×é
Ïà¹ØÎĵµ£º
½ñÌì»Ø¹ËÁËÏÂÕýÔòµÄ»ù±¾ÖªÊ¶¡£ ×ÜÈÝÒ×Íü£¬ÌؼÇÓÚ´Ë¡£
ÓÃÓÚÃèÊö×Ö·ûÅÅÁÐºÍÆ¥ÅäģʽµÄÒ»ÖÖÓï·¨¹æÔò¡£ËüÖ÷ÒªÓÃÓÚ×Ö·û´®µÄģʽ·Ö¸î¡¢Æ¥Åä¡¢²éÕÒ¼°Ìæ»»²Ù×÷¡£
PHPÖеÄÕýÔòº¯Êý£º
PHPÖÐÓÐÁ½Ì×ÕýÔòº¯Êý£¬Á½Õß¹¦Äܲ¶à£¬·Ö±ðΪ£º
Ò»Ì×ÊÇÓÉPCRE£¨Perl Compatible Regular Expression£©¿âÌṩµÄ¡£Ê¹ÓÓpreg_” ......
Õâ¾ÍÒª´ÓË«ÒýºÅºÍµ¥ÒýºÅµÄ×÷Óý²Æð£º
Ë«ÒýºÅÀïÃæµÄ×ֶλᾹý±àÒëÆ÷½âÊÍÈ»ºóÔÙµ±×÷HTML´úÂëÊä³ö£¬µ«Êǵ¥ÒýºÅÀïÃæµÄ²»ÐèÒª½âÊÍ£¬Ö±½ÓÊä³ö¡£ÀýÈ磺
$abc='I love u';
echo $abc //½á¹ûÊÇ:I love u
echo '$abc' //½á¹ûÊ ......
ÎÒÃÇÔÚдÓû§ÑéÖ¤Ò³Ãæ£¬Èç×¢²á£¬µÇ¼µÄʱºò£¬ÎªÁ˼ÓÇ¿Óû§µÇ¼µÄ°²È«ÐÔ£¬Ìí¼ÓÑéÖ¤ÂëÑéÖ¤¡£
ÑéÖ¤Âëͨ¹ýGDÉú³ÉPNGͼƬ£¬²¢°Ñ$randvalËæ»úÊý×Ö¸³¸ø$_SESSION['login_check_num']£¬ÔÚͨ¹ýÓû§ÊäÈëµÄ$_POST½øÐбȽϣ¬À´ÅжÏÊÇ·ñÕýÈ·¡£´ïµ½ÐèҪʵÏֵŦÄÜ£¬ÐèÒªÐÞ¸Äphp.iniÎļþ£¬Ê¹phpÖ§³ÖGD¿â¡£
<?php
//µ÷ÓôËÒ³Ãæ£¬Èç¹ûÏ ......
¶¨ÒåºÍÓ÷¨
filter_var() º¯Êýͨ¹ýÖ¸¶¨µÄ¹ýÂËÆ÷¹ýÂ˱äÁ¿¡£
Èç¹û³É¹¦£¬Ôò·µ»ØÒѹýÂ˵ÄÊý¾Ý£¬Èç¹ûʧ°Ü£¬Ôò·µ»Ø false¡£
Óï·¨
filter_var(variable, filter, options)
²ÎÊýÃèÊö
variable
±ØÐè¡£¹æ¶¨Òª¹ýÂ˵ıäÁ¿¡£
filter
¿ÉÑ¡¡£¹æ¶¨ÒªÊ¹ÓõĹýÂËÆ÷µÄ ID¡£
options
¹æ¶¨°üº¬±êÖ¾/Ñ¡ÏîµÄÊý×é¡£¼ì²éÿ¸ö¹ýÂËÆ÷¿ÉÄܵı ......