Example #1
0
 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;
 }
Example #2
0
 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;
     }
 }