//Create a class representation of the table "Articles" class Articles extends \EntityPHP\Entity { protected $title; protected $content; protected $author; //__structure() method is mandatory and must return an array public static function __structure() { return array('title' => 'VARCHAR(255)', 'content' => 'TEXT', 'author' => 'Authors'); } } //Init connection to the database \EntityPHP\Core::connectToDB('localhost', 'entityphp', '3n7i7iPHP', 'entityphp'); //Generate the database (this method should be execute only once) \EntityPHP\Core::generateDatabase(); //Create a new author $author = new Authors(array('firstname' => 'Jean', 'lastname' => 'Peplu')); //And store it to our table! Authors::add($author); //Create a new article $article = new Articles(array('title' => 'It should work!', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Ab assumenda dicta doloribus eaque earum, ex inventore libero odio perferendis possimus quaerat quidem quo ullam?', 'author' => $author)); //And store it to our table! Articles::add($article); //Create a second article $article = new Articles(array('title' => 'It should work again!', 'content' => 'Ex inventore libero odio perferendis possimus quaerat quidem quo ullam? Lorem ipsum dolor sit amet, consectetur adipisicing elit. Ab assumenda dicta doloribus eaque earum...', 'author' => $author)); //And store it to our table!
require_once 'application/vendors/EntityPHP/src/EntityPHP.php'; $sql = \Eliya\Config('main')->SQL; //Handle received request $request = new \Eliya\Request($_SERVER['REQUEST_URI']); $current_url = $request->getProtocol() . '://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; define('BASE_URL', $request->getBaseURL()); define('STATIC_URL', \Eliya\Config('main')->STATIC_URL); define('PUBLIC_FOLDER_PATH', __DIR__ . DIRECTORY_SEPARATOR . 'public' . DIRECTORY_SEPARATOR); if (substr($current_url, -1) !== '/') { $current_url .= '/'; } $page_description = 'Un site réalisé par des fans pour les fans de Nintendo. '; $page_description .= 'Retrouvez des articles en rapport avec Nintendo, que ce soit sur '; $page_description .= 'l\'actualité, des découvertes de jeux ou des dossiers sur divers sujets.'; \Eliya\Tpl::set(['page_title' => 'Le Chomp Enchainé', 'page_description' => $page_description, 'base_url' => BASE_URL, 'static_url' => STATIC_URL, 'current_url' => $current_url]); $response = $request->response(); try { if (!empty($sql)) { \EntityPHP\Core::connectToDB($sql['HOST'], $sql['USER'], $sql['PASSWORD'], $sql['DATABASE']); } else { throw new Exception('Impossible de se connecter à la base de données'); } $request->exec(); } catch (Exception $e) { ob_clean(); $response->set(null)->error($e->getMessage(), 500); } $response->render(); if ($response->isError()) { error_log("Error - " . $response->status() . " - Request: " . $_SERVER['REQUEST_URI'], 4); }