增删改查
来源:互联网 发布:xp 1433端口怎么打开 编辑:程序博客网 时间:2024/04/30 05:29
<?php
class Commen_model extends CI_Model {
//表名字
public $table_name;
//表字段
public $table_val;
//根据id或条件单条查询
public function find($qaram=null){
if(is_int($qaram)){
$fields=$this->fields();
$this->db->where($fields[0].'='.$qaram);
}else{
$this->db->where($qaram);
}
return $this->db->get($this->table_name)->row_array();
}
//根据条件多条查询
public function select($qaram){
if(is_array($qaram)){
foreach ($qaram as $key => $value) {
$this->db->where($key.'="'.$value.'"');
}
}else if(!empty($qaram)){
$this->db->where($qaram);
}
return $this->db->get($this->table_name)->result_array();
}
//单条插入
public function add($param){
$this->filter($param);
$this->db->insert($this->table_name,$this->table_val);
return $this->db->insert_id();
}
//插入多条数据
public function alladd($param){
foreach ($param as $key => $value) {
$this->filter($value);
$data[]=$this->table_val;
}
//入库
foreach ($data as $key => $value) {
$this->db->insert($table_name,$value);
$ids[]=$this->db->insert_id();
}
return $ids;
}
//根据主键id修改
public function save($param){
$this->filter($param);
$field=$this->fields();
return $this->db->where($field[0].'='.$this->table_val[$field[0]])->update($this->table_name,$this->table_val);
}
//根据主键id删除
public function del($id){
$field=$this->fields();
return $this->db->where($field[0].' in ('.$id.')')->delete($this->table_name);
}
//获取数据表字段
public function fields(){
return $this->db->get($this->table_name)->list_fields();
}
//过滤多余数据
public function filter($param){
$table_val=array();
$fields=$this->fields();
foreach ($param as $key => $value) {
if(in_array($key,$fields)){
$this->table_val[$key]=$value;
}
}
}
}
class Commen_model extends CI_Model {
//表名字
public $table_name;
//表字段
public $table_val;
//根据id或条件单条查询
public function find($qaram=null){
if(is_int($qaram)){
$fields=$this->fields();
$this->db->where($fields[0].'='.$qaram);
}else{
$this->db->where($qaram);
}
return $this->db->get($this->table_name)->row_array();
}
//根据条件多条查询
public function select($qaram){
if(is_array($qaram)){
foreach ($qaram as $key => $value) {
$this->db->where($key.'="'.$value.'"');
}
}else if(!empty($qaram)){
$this->db->where($qaram);
}
return $this->db->get($this->table_name)->result_array();
}
//单条插入
public function add($param){
$this->filter($param);
$this->db->insert($this->table_name,$this->table_val);
return $this->db->insert_id();
}
//插入多条数据
public function alladd($param){
foreach ($param as $key => $value) {
$this->filter($value);
$data[]=$this->table_val;
}
//入库
foreach ($data as $key => $value) {
$this->db->insert($table_name,$value);
$ids[]=$this->db->insert_id();
}
return $ids;
}
//根据主键id修改
public function save($param){
$this->filter($param);
$field=$this->fields();
return $this->db->where($field[0].'='.$this->table_val[$field[0]])->update($this->table_name,$this->table_val);
}
//根据主键id删除
public function del($id){
$field=$this->fields();
return $this->db->where($field[0].' in ('.$id.')')->delete($this->table_name);
}
//获取数据表字段
public function fields(){
return $this->db->get($this->table_name)->list_fields();
}
//过滤多余数据
public function filter($param){
$table_val=array();
$fields=$this->fields();
foreach ($param as $key => $value) {
if(in_array($key,$fields)){
$this->table_val[$key]=$value;
}
}
}
}
阅读全文
0 0
- hibernate增删查改
- XML 增删查改
- ldap 增删改查
- mysql增删改查
- 动态增删改查
- jdom增删改查
- 集合增删查改
- XML 增删改查
- xml增删改查
- lucene增删改查
- 增删改查
- ldap增删改查
- MySQLz增删改查
- 生成增删改查
- Mybatis 增删改查
- 表格增删查改
- Jdbc 增删改查
- xml增删查改
- SpringMVC常用获取传递参数的方法
- 动态规划(6)
- Redis遍历所有key的两个命令 -- KEYS 和 SCAN
- 由于实体类文件位置错误 导致tomcat 报 entity class not found
- Spring 常用注解
- 增删改查
- Java解析Json数据
- 动态规划(7)
- iframe中的fixed解决方案
- 0072 在Tomcat 8上布置drools workbench
- 在HTML页面中如何实现多个文件同时下载
- 学习Vue.js 基础第一节
- jquery增加,移除,修改一个html标签的class类名
- mysql别名的使用