} } //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.
<?php // Require framework core require_once '../../system/Core.class.php'; // Init core \Eliya\Core::init(); // Init DB require_once '../vendors/EntityPHP/src/EntityPHP.php'; $sql = \Eliya\Config('main')->SQL; \EntityPHP\Core::connectToDB($sql['HOST'], $sql['USER'], $sql['PASSWORD'], $sql['DATABASE']); // Include all models files \Eliya\Core::requireDirContent('../models'); // Generate the dabatase based on our models \EntityPHP\Core::generateDatabase(); Model_Categories::add(new Model_Categories('Billet d\'humeur')); Model_Categories::add(new Model_Categories('Quoi d\'neuf Mario ?')); Model_Categories::add(new Model_Categories('Analyse de personnage')); Model_Categories::add(new Model_Categories('L\'entreprise Nintendo')); Model_Categories::add(new Model_Categories('Découverte de jeu')); Model_Categories::add(new Model_Categories('Anthologie musicale')); Model_Categories::add(new Model_Categories('Produits dérivés')); Model_Groups::add(new Model_Groups(['group_name' => 'Anonymes', 'can_manage_categories' => 0, 'can_manage_users' => 0, 'can_write_articles' => 0, 'can_edit_other_articles' => 0, 'can_publish_other_articles' => 0, 'can_read_unpublished_articles' => 0])); $group_redactors = Model_Groups::add(new Model_Groups(['group_name' => 'Rédacteurs', 'can_manage_categories' => 0, 'can_manage_users' => 0, 'can_write_articles' => 1, 'can_edit_other_articles' => 0, 'can_publish_other_articles' => 0, 'can_read_unpublished_articles' => 0])); Model_Groups::add(new Model_Groups(['group_name' => 'Rédacteurs en chef', 'can_manage_categories' => 1, 'can_manage_users' => 0, 'can_write_articles' => 1, 'can_edit_other_articles' => 0, 'can_publish_other_articles' => 1, 'can_read_unpublished_articles' => 1])); $group_admin = Model_Groups::add(new Model_Groups(['group_name' => 'Admins', 'can_manage_categories' => 1, 'can_manage_users' => 1, 'can_write_articles' => 1, 'can_edit_other_articles' => 1, 'can_publish_other_articles' => 1, 'can_read_unpublished_articles' => 1]));