* @return bool Returns True if user exists and false otherwise
*/
private function user_exists($username, $email){
- if ($this->db->query("SELECT id FROM users WHERE username=? OR email='?'",
+ if ($this->db->query("SELECT id FROM users WHERE username='?' OR email='?'",
$username, $email)->count()>0)
return true;
else
* @return integer|bool User id if successful or false
*/
public function get_id($username){
- $result = $this->db->query("SELECT id FROM users WHERE username=?", $username);
+ $result = $this->db->query("SELECT id FROM users WHERE username='?'", $username);
if ($result->count()>0)
return $result[0]->id;
else
// hash password
$password = $this->hash($password);
- if ($this->db->query("SELECT id FROM users WHERE username = ? AND password = ?",
+ if ($this->db->query("SELECT id FROM users WHERE username='?' AND password='?'",
$username, $password)->count()>0)
return true;
else