duanhunlou7051 2014-08-11 06:18
浏览 34

Codeigniter更新动态数据库名称错误

I have some problems when I update my table with Ci Update. Here is my Code

$db = $this->input->post('db');        
$tbl = $this->input->post('tbl');       
$name = $this->input->post('name');
$col = $this->input->post('col_name');    
$id =  $this->input->post('id');   
$array = array($col => $name);   
$this->db->where('id',$id);  
$this->db->update("`$db`.`$tbl`", $array); 

Problem is database name. Database name can possible include "." sign. eg( db3.9 )
So Ci is produce update query like this

UPDATE `db3`.`9`.`mytbl` SET `name` = 'myname' WHERE `id` = 1

So anyone can tell me how can i solve this CI update auto escape solution.
PS. removing database name from this query is not what i want.
because database,table and columns are dynamic.So i can't define globally what database,table and columns.

  • 写回答

2条回答 默认 最新

  • dpw70180 2014-08-11 06:32
    关注

    use the escape character in defining the dbname??? LIKE $db = "db3/.9"

    评论

报告相同问题?

悬赏问题

  • ¥15 opencv图像处理,需要四个处理结果图
  • ¥15 无线移动边缘计算系统中的系统模型
  • ¥15 深度学习中的画图问题
  • ¥15 java报错:使用mybatis plus查询一个只返回一条数据的sql,却报错返回了1000多条
  • ¥15 Python报错怎么解决
  • ¥15 simulink如何调用DLL文件
  • ¥15 关于用pyqt6的项目开发该怎么把前段后端和业务层分离
  • ¥30 线性代数的问题,我真的忘了线代的知识了
  • ¥15 有谁能够把华为matebook e 高通骁龙850刷成安卓系统,或者安装安卓系统
  • ¥188 需要修改一个工具,懂得汇编的人来。