public static function edit($fields, $id) { ///clean all fields so they are not harmful to the database $fields = Model::cleanData($fields); //construct sql query to update username $sql = 'UPDATE posts SET title = "' . $fields['title'] . '", text = "' . $fields['text'] . '" WHERE id = ' . $id; $results = Model::update($sql); //return results to controller return $results; }
public static function login($fields) { $fields = Model::cleanData($fields); //construct your SQL query-- select all the data about one blogger by id $password = md5($fields['password'], false); $sql = 'SELECT * FROM bloggers WHERE username = "******" and password = "******" LIMIT 1'; //send that query to the Model class that Bloggers extends $results = Model::select($sql); //return results to controller if ($results) { return $results[0]; } else { return false; } }