普通网友 2018-01-29 14:03
浏览 66
已采纳

mysql中的where子句不起作用

I am working on a project using php codeigniter,i am using mysql select query to fetch all data from database where isactive field is equal to 1.but i am unable to do it.below is the function where i have writtten the query.

Code:

public function displayinfo3()
        {
            $user_id = $this->session->userdata('user_id');
            if($user_id)
            {
                $this->load->library('datatables');
                $this->datatables
                                    ->select("user_type.user_type as user_type,user.user_name as user_name,user.first_name as first_name,user.middle_name as middle_name,user.last_name as last_name,user.user_id as Actions")
                            ->from("user")
                            ->where('isactive'==1)
                                                    ->join("user_type","user_type.user_type_id=user.user_type_id","left")
                            ->edit_column("Actions", 
                                                            "<center><div class='visible-md visible-lg hidden-sm hidden-xs'><div align='center'><div class='col-md-2'><form action='".base_url()."index.php/Registrationc/editpatient3' method='post'><input type='hidden' id='editp3' name='editp3' value='$1'><button title='EDIT PATIENT' class='tip btn btn-primary btn-xs' type='submit' value='Submit' ><i class='fa fa-edit'></i></button></form></div><div class='col-md-2'><a class=\"tip btn btn-danger btn-xs\" title='DELETE PATIENT' href='#' onclick=\"delete_patient('$1')\" ><i class=\"fa fa-trash-o\"></i></a></div></div></div></center>", "Actions");
                                                    // $this->datatables->unset_column('Sno.patient_id');<form action=""><div class='btn-group'>
                                       //<a class=\"tip btn btn-primary btn-xs\" onclick=\"edit_patient('$1')\" title='EDIT MAPPING' href='#' return false;\"><i class=\"fa fa-edit\"></i></a>                         
                            echo $this->datatables->generate();
             }
            else
            {
                redirect(base_url('Registrationc/extra1'));
            }  


}
  • 写回答

2条回答 默认 最新

  • doubinei1457 2018-01-29 14:08
    关注

    Replace ->where('isactive'==1) with ->where('isactive = 1')

    The first passes the result of the comparison of 'isactive' with 1 to the function. As 'isactive' is not equal to 1 you just pass a false value to your where statement.

    The second call passes the correct query string to be put in the where statement of the query.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 三电平逆变器中点电位平衡问题
  • ¥20 这怎么写啊 java课设
  • ¥15 用C语言完成一个复杂的游戏
  • ¥15 如何批量更改很多个文件夹里的文件名中包含文件夹名?
  • ¥50 MTK手机模拟HID鼠标出现卡顿
  • ¥20 求下下面这个数据结构代码
  • ¥20 前端 二进制文件流图片转化异常
  • ¥15 github上的这个C语言项目如何跑起来
  • ¥15 java 判断某个数 区间是否存在
  • ¥15 appium控制多个雷电模拟器问题