/** * generate form for table * @param $table string table * @param $action string action * @param string $method method form (default = POST) * @return \SFramework\Form\Form * @throws TableNotFoundDatabaseException */ public static function generate($table, $action, $method = 'POST') { $sql = 'SHOW FIELDS ' . 'FROM ' . $table; $res = DatabaseProvider::connection()->query($sql); if (empty($res)) { throw new TableNotFoundDatabaseException($table); } $form = new Form($action, $method); $form->setClass('pure-form pure-form-aligned centered'); foreach ($res as $value) { if (self::getType($value['Type']) == 'text') { $field = self::getTextArea($value); } elseif (self::getType($value['Type']) == 'datetime') { $field = self::getInput($value); $field->addAttribute('class', 'datepicker'); $field->addAttribute('placeholder', '01/01/2014'); } else { $field = self::getInput($value); } $form->addField($field); } $submit = new InputField('submit'); $submit->addAttribute('type', 'submit'); $submit->addAttribute('value', 'Envoyer'); $submit->addAttribute('class', 'pure-button pure-button-primary'); $form->addField($submit); return $form; }
public function deleteImage($userID, $imageID) { $query = 'DELETE FROM `users-images` WHERE imageid = ? AND userid = ?'; DatabaseProvider::connection()->execute($query, [$userID, $imageID]); $query = 'DELETE FROM images WHERE idimage = ?'; DatabaseProvider::connection()->execute($query, [$imageID]); }
public function getMasterKey($username) { $query = 'SELECT master_key FROM users WHERE username = ?'; return DatabaseProvider::connection()->query($query, [$username]); }
public function getGroups() { $query = 'SELECT ANNEE, GROUPE FROM GROUPE ORDER BY ANNEE, GROUPE '; return DatabaseProvider::connection()->query($query); }
public function getWeeks() { $query = 'SELECT ID, TITRE FROM SEMAINE'; return DatabaseProvider::connection()->query($query); }