求mysql pdo封装类,不用写sql那种 求mysql pdo封装类,不用写sql那种不知道可不可以 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 php 中的 pdo 扩展 ORM ?不过都是模拟的,不敢恭维http://www.google.com.hk/search?sugexp=chrome,mod=8&client=aff-cs-360chromium&ie=UTF-8&q=phporm 建议你自己写一个AR类.等你用习惯AR类,要是新手估计连原生的SQL语句都忘光了 class ModBase extends SdkDbBase{ function __construct($db='domain') { parent::__construct($db); } protected function exec($sql) { if($this->dbo->exec($sql)!==false) { return TRUE; } return FALSE; } protected function select($sql,$one=FALSE,$clumn=FALSE) { $dbh=$this->dbo->query($sql); $dbh->setFetchMode(PDO::FETCH_ASSOC); if($clumn) { return $dbh->fetchColumn(); } if($one) { return $dbh->fetch(); } return $dbh->fetchAll(); } protected function insertBase($sql) { if($this->dbo->exec($sql)!=false) { return $this->dbo->lastInsertId(); } return false; } protected function getListBase($table,$where,$fields='*') { if($where==false || empty($where)) { return false; } $sql='select '.$fields.' from '.$table; if($where) { $sql.=' '.$where; } return self::select($sql); } protected function getCountBase($table,$where) { $sql='select count(*) from '.$table; if($where) { $sql.=' '.$where; } return self::select($sql,true,true); } protected function getOneBase($table,$where,$fields='*') { return self::select('select '.$fields.' from '.$table .' '.$where,true); } protected function deleteBase($table,$where) { if(!$where || empty($where)) { return false; } return self::exec('delete from '.$table .' '.$where); } protected function setBase($table,$set,$where) { if(!$set || !$where) { return false; } return self::exec('update '.$table.' set '.$set.' '.$where); }} /** * 返回WHERE语句 * @param array $data */ protected static function getWhereSql($data) { $where=''; $whereData=isset($data['where'])?$data['where']:''; if(is_array($whereData) && $whereData) { $i=0; foreach ($whereData as $key=>$value) { $i++; $fuhao='='; $one=substr($value,0,1); if($one=='<' || $one=='>' || $one=='!') { $fuhao=(stripos($value,$one.'=')!==FALSE) ?$one.'=' :$one; $value=str_replace($fuhao,'',$value); } $where.=$key.$fuhao."'".$value."'"; if($i<count($whereData)) { $where.=" and "; } } } else { $where=$whereData; } $where=$where ?' where '.$where :''; $like=''; if(isset($data['like'])) { if(is_array($data['like']) && $data['like']) { $k=1; foreach ($data['like'] as $key=>$value) { $like.=" ".$key." like '%".$value."%' "; if($k < count($data['like'])) { $like.=' and '; } $k++; } $where=$where ?$where.' and '.$like :' where '.$like; } } $in=''; if(isset($data['in'])) { if(is_array($data['in']) && $data['in']) { $k=1; foreach ($data['in'] as $key=>$value) { $in.=' '.$key.' in ('.$value.') '; if($k < count($data['in'])) { $in.=' and '; } $k++; } $where=$where ?$where.' and '.$in :' where '.$in; } } if(isset($data['group'])) { $where.=" group by ".$data['group']; } if(isset($data['order'])) { $where.=" order by ".$data['order']; } if(isset($data['limit'])) { $where.=" limit ".$data['limit']; } return $where; } php mysql 千万数据库 怎么优化? 上传几个文件的时候,怎么判断上传了几个文件? Extjs htmleditor控件粘贴World文档内容问题,后台PHP过虑 有没有人能帮我把这个PHP函数转换为java代码啊 求救.Apache2.0不能跨网络访问 PHP 数组合并的问题 如何将数据类型转换为Long型,settype(var,"long"),出错? 初学者请教,请各位大侠不要不屑于回答! header的问题. PHP如何修改上传文件到指定路径 关于session的小问题 在中图片植入代码
不过都是模拟的,不敢恭维
http://www.google.com.hk/search?sugexp=chrome,mod=8&client=aff-cs-360chromium&ie=UTF-8&q=phporm
{
function __construct($db='domain')
{
parent::__construct($db);
}
protected function exec($sql)
{
if($this->dbo->exec($sql)!==false)
{
return TRUE;
}
return FALSE;
}
protected function select($sql,$one=FALSE,$clumn=FALSE)
{
$dbh=$this->dbo->query($sql);
$dbh->setFetchMode(PDO::FETCH_ASSOC);
if($clumn)
{
return $dbh->fetchColumn();
}
if($one)
{
return $dbh->fetch();
}
return $dbh->fetchAll();
}
protected function insertBase($sql)
{
if($this->dbo->exec($sql)!=false)
{
return $this->dbo->lastInsertId();
}
return false;
}
protected function getListBase($table,$where,$fields='*')
{
if($where==false || empty($where))
{
return false;
}
$sql='select '.$fields.' from '.$table;
if($where)
{
$sql.=' '.$where;
}
return self::select($sql);
}
protected function getCountBase($table,$where)
{
$sql='select count(*) from '.$table;
if($where)
{
$sql.=' '.$where;
}
return self::select($sql,true,true);
}
protected function getOneBase($table,$where,$fields='*')
{
return self::select('select '.$fields.' from '.$table .' '.$where,true);
}
protected function deleteBase($table,$where)
{
if(!$where || empty($where))
{
return false;
}
return self::exec('delete from '.$table .' '.$where);
}
protected function setBase($table,$set,$where)
{
if(!$set || !$where)
{
return false;
}
return self::exec('update '.$table.' set '.$set.' '.$where);
}
}
* 返回WHERE语句
* @param array $data
*/
protected static function getWhereSql($data)
{
$where='';
$whereData=isset($data['where'])?$data['where']:'';
if(is_array($whereData) && $whereData)
{
$i=0;
foreach ($whereData as $key=>$value)
{
$i++;
$fuhao='=';
$one=substr($value,0,1);
if($one=='<' || $one=='>' || $one=='!')
{
$fuhao=(stripos($value,$one.'=')!==FALSE) ?$one.'=' :$one;
$value=str_replace($fuhao,'',$value);
}
$where.=$key.$fuhao."'".$value."'";
if($i<count($whereData))
{
$where.=" and ";
}
}
}
else
{
$where=$whereData;
}
$where=$where ?' where '.$where :'';
$like='';
if(isset($data['like']))
{
if(is_array($data['like']) && $data['like'])
{
$k=1;
foreach ($data['like'] as $key=>$value)
{
$like.=" ".$key." like '%".$value."%' ";
if($k < count($data['like']))
{
$like.=' and ';
}
$k++;
}
$where=$where ?$where.' and '.$like :' where '.$like;
}
}
$in='';
if(isset($data['in']))
{
if(is_array($data['in']) && $data['in'])
{
$k=1;
foreach ($data['in'] as $key=>$value)
{
$in.=' '.$key.' in ('.$value.') ';
if($k < count($data['in']))
{
$in.=' and ';
}
$k++;
}
$where=$where ?$where.' and '.$in :' where '.$in;
}
}
if(isset($data['group']))
{
$where.=" group by ".$data['group'];
}
if(isset($data['order']))
{
$where.=" order by ".$data['order'];
}
if(isset($data['limit']))
{
$where.=" limit ".$data['limit'];
}
return $where;
}