//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);
}
