如何测试我的MySQL更新查询是否成功在代码Igniter？ [英] How do I test if my MySQL update query was successful in Code Igniter?

问题描述

  //更新用户的第一个用户，如果成功返回true，否则返回false。 
 public function updateFirstName（$ userId，$ newFirstName）{
 $ this-> db-> query（UPDATE users SET firstName ='$ newFirstName'WHERE id = $ userId）; 
 return //请求是否成功？ 
} 
  

如何返回一个布尔值以确保ID $ userId 已更新？例如，如果没有找到ID $ userId 的用户，则应返回false。

解决方案

如已评论，您是否尝试过 $ this-> db-> affected_rows（）？

这将告诉您已更新的行数。

I have a model function that updates a user in my Code Igniter application:

// updates first of a user, return true if successful, false if not.
public function updateFirstName($userId, $newFirstName) {
    $this->db->query("UPDATE users SET firstName='$newFirstName' WHERE id=$userId");
    return // whether request was successful?
}

How do I return a boolean value that ensures the user of ID $userId has been updated? For instance, it should return false if no user was found with ID $userId.

解决方案

As commented, have you tried $this->db->affected_rows()?

That will tell you how many rows were updated.

这篇关于如何测试我的MySQL更新查询是否成功在代码Igniter？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！