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 Êý¾ÝÊý×é
Ïà¹ØÎĵµ£º
»ù±¾¸ÅÄî
Ò»¸öÕýÔò±í´ïʽͨ³£±»³ÆÎªÒ»¸öģʽ (pattern)£¬ÎªÓÃÀ´ÃèÊö»òÕ߯¥ÅäһϵÁзûºÏij¸ö¾ä·¨¹æÔòµÄ×Ö·û´®¡£ÀýÈ磺Handel¡¢Händel ºÍ Haendel ÕâÈý¸ö×Ö·û´®£¬¶¼¿ÉÒÔÓÉ“H(a|ä|ae)ndel”Õâ¸öģʽÀ´ÃèÊö¡£´ó²¿·ÖÕýÔò±í´ïʽµÄÐÎʽ¶¼ÓÐÈçϵĽṹ£º
Ñ¡Ôñ| ÊúÖ±·Ö¸ô·û´ú±íÑ¡Ôñ¡£ÀýÈç“gray|grey&rd ......
×ªÔØ£ºhttp://www.phpjs.cn/article_90.html
php³£ÓÃÀàÕûÀí
ʱ¼ä£º2009-12-19 20:45 À´Ô´£ºÈËÁ¦·½ ×÷Õߣºsyuanq µã»÷£º236
ÔÚʵ¼Ê¿ª·¢¹ý³Ì»á¾³£»áÓöµ½Ò»Ð©Öظ´µÄ²Ù×÷£¬Èç¹ûÿ´Î¶¼Òª×Ô¼ºÈ¥ÊµÏÖÕâÎÞÒɼÓÖØÁË×Ô¼ºµÄ¹¤×÷Á¿£¬ÏÂÃæ¶ÔһЩ¿ÉÄܾ³£Óõ½µÄÀà×ö¸öÕûÀí£º
ͼ±í¿â
ÏÂÃæµÄÀà¿â¿ÉÒÔÈÃÄãºÜ¼òµ¥¾ÍÄÜ´´½ ......
֮ǰ²Î¼ÓѧУµÄÌôÕ½±£¬×öÁËÒ»¸öСµÄÊÖ»úÍøÕ¾ÏîÄ¿£¬ÆäÖÐҪʵÏֵǽѧУУÄÚÓÊÏ䣬¿¼Âǵ½ÊÖ»úÓû§¶ËûÓа취ֱ½Ó·ÃÎÊÑ§Ð£ÍøÒ³¡£ÓÚÊÇÏëµ½ÁËʹÓÃphpʵÏÖÄ£ÄâµÇ½£¬ÓÐЩÐíµÄÐĵá£Ë³±ã¼Ç¼һÏ¡£
ÔÚÎÒÃÇѧУµÄÓÊÏäµÇÂ½Ò³ÃæµÄµÇ½±íµ¥µÄÄÚÈÝÓÐÓû§ÃûºÍÃÜÂ룬ûÓÐÑéÖ¤Âë»úÖÆ£¬ÕâÑù±È½ÏºÃ°ì¡£´ÓÔ´ÎļþÀï¼ÇÏÂ±íµ¥ÀïÓÐusernameºÍpas ......
¡¡¡¡ÕâÊÇÒ»¸ö¾³£±»Ìá³öµÄÎÊÌ⣬²¢ÇÒËüºÜÈÝÒ×°ÑÈËÃÇ´øÈëÕùÂÛLinux»¹ÊÇWindowsµÄÆç;¡£ÕâÑùµÄÕùÂÛÊÂʵÉÏ·´Ó³³öÁ˶ÔÓÚÏ໥¾ºÕùµÄWeb¿ª·¢¼¼ÊõÒª½øÐв¢ÐзÖÎöÊǶàôÀ§ÄѵÄÒ»¼þÊÂÇ飬¶øÕâÒ»ÄѶÈͬʱÒòΪ¿ª·¢ÈËÔ±¶ÔÈκοɱȽϲÙ×÷ϵͳµÄ²»Í¬Òâ¼û¶ø´ó´óÔö¼Ó¡£
¡¡¡¡ËùÒÔÓëÆä¼ÌÐø²ÎÓëµ½ÕâÑùµÄÕùÂÛÖУ¬ÎÒÃÇ»¹²»ÈçÀ´¿´¿´Ã¿Ò»Ïî¼¼Êõ¶Ô ......
function checkFileType($fileName){
$file = fopen($fileName, "rb");
$bin = fread($file, 2); //Ö»¶Á2×Ö½Ú
&n ......