duanfu3884 2015-11-17 15:04
浏览 49
已采纳

使用Codeigniter在mysql数据库中更新

I have been trying to do the update the record in my database but i am getting the echo that the action have not being updated all i want is to update balance field in the database! The following is the code in the controller where i take value that i have passed from ajax and i am passing the email and data to model. Controller.

 public function transfer_amount(){


    $email  =  $this->input->post('view');



    $data = array(

            'balance' => $this->input->post('amount'),

    );

    $this->load->model('user_model');


    if($this->user_model->transfer_amount($data,$email)){


        echo'unsuccessfull';


    }
    else
    {

        $this->load->view('layer_service/success',$data);

    }



}

The Model which is supposed to update the field of the database is as following.

   function transfer_amount($data,$email){



    $this->db->where('email', $email);

    $this->db->update('tbl_users', $data);

        // Code here after successful insert
     // to the controller

    return true;


}
  • 写回答

1条回答 默认 最新

  • doudiemei2013 2015-11-17 16:06
    关注

    Based on your above comment you need to trim the whitespace from the email.

    function transfer_amount($data, $email) {
    
      $this->db->update('tbl_users', $data, array(
        'email' => trim($email),
      ));
    
      // Code here after successful insert
      // to the controller
    
      return true;
    }
    

    Also in your controller you will want to replace this line

    if($this->user_model->transfer_amount($data,$email)){
    

    with

    if( ! $this->user_model->transfer_amount($data,$email)) {
    

    As your model returns TRUE on success but your controller is expecting FALSE on success.

    You can also check that your update was successful and did actually change some rows in the database using a simple if statement such as

    if(0 >= $this->db->affected_rows()) {
      // update unsuccessful
    }
    

    Update

    How to add to the current balance in MySQL. You can simply add to the value which is already in the database.

    $data = array(
      'balance' => 'balance + ' . $this->input->post('amount'),
    );
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 如何在配置使用Prettier的VSCode中通过Better Align插件来对齐等式?(相关搜索:格式化)
  • ¥15 C#字典调用时报错,有关文件加载
  • ¥100 在连接内网VPN时,如何同时保持互联网连接
  • ¥15 MATLAB中使用parfor,矩阵Removal的有效索引在parfor循环中受限制
  • ¥20 Win 10 LTSC 1809版本如何无损提升到20H1版本
  • ¥50 win10 LTSC 虚拟键盘不弹出
  • ¥30 关于PHP中POST获取数据的问题
  • ¥30 微信小程序请求失败,网页能正常带锁访问
  • ¥15 Python实现hog特征图可视化
  • ¥30 德飞莱51单片机实现C4炸弹