{"id":4363,"date":"2014-11-06T09:36:18","date_gmt":"2014-11-06T08:36:18","guid":{"rendered":"https:\/\/www.creativejuiz.fr\/blog\/?p=4363"},"modified":"2023-02-10T10:21:48","modified_gmt":"2023-02-10T09:21:48","slug":"generer-back-end-complet-depuis-base-mysql-crud-admin-generator","status":"publish","type":"post","link":"https:\/\/www.creativejuiz.fr\/blog\/veille-technologique\/generer-back-end-complet-depuis-base-mysql-crud-admin-generator","title":{"rendered":"CRUD Admin Generator : G\u00e9n\u00e9rer un back-end complet depuis une base MySQL"},"content":{"rendered":"<p>Vous restez bloqu\u00e9s quand vous voyez l&rsquo;interface d&rsquo;un PHPmyAdmin\u00a0? Vous souhaiteriez quelque chose de plus sympa pour consulter vos bases de donn\u00e9es SQL\u00a0? Essayez cette solution Open Source et gratuite bas\u00e9e sur le langage PHP.<!--more--><\/p>\n<h2>\u00ab\u00a0Je s&rsquo;appelle CRUD\u00a0\u00bb<a title=\"Voir l'explication\" href=\"#reference1\">*<\/a><\/h2>\n<p id=\"backref1\">Le projet <a href=\"http:\/\/crud-admin-generator.com\/\">CRUD Admin Generator<\/a> d\u00e9velopp\u00e9 par <a href=\"https:\/\/github.com\/jonseg\">Jon Segador<\/a> est un script Open Source permettant de li\u00e9 l&rsquo;utilit\u00e9 d&rsquo;un affichage graphique de ses tables SQL \u00e0 l&rsquo;agr\u00e9able apparence d&rsquo;un graphisme un peu plus travaill\u00e9 et moins fourni que celui de PHPmyAdmin par exemple.<\/p>\n<p>Les avantages de cet outil :<\/p>\n<ul>\n<li>Il est Open Source et pr\u00e9sent sur <a href=\"https:\/\/github.com\/jonseg\/crud-admin-generator\">GitHub<\/a><\/li>\n<li>Il est cod\u00e9 en PHP (framework Silex)<\/li>\n<li>Il est simple d&rsquo;utilisation (il respecte le principe C.R.U.D., <em lang=\"en\">Create<\/em>, <em lang=\"en\">Read<\/em>, <em lang=\"en\">Update<\/em>, <em lang=\"en\">Delete<\/em>)<\/li>\n<li>Il se \u00ab\u00a0branche\u00a0\u00bb sur n&rsquo;importe quelle base de donn\u00e9es SQL existante<\/li>\n<li>Il est facile \u00e0 modifier (c&rsquo;est du PHP :p)<\/li>\n<li>Il est responsive<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-4372\" src=\"https:\/\/www.creativejuiz.fr\/blog\/wp-content\/uploads\/2014\/11\/crud-back-end-generator-.png\" alt=\"\" width=\"800\" height=\"320\" srcset=\"https:\/\/www.creativejuiz.fr\/blog\/wp-content\/uploads\/2014\/11\/crud-back-end-generator-.png 800w, https:\/\/www.creativejuiz.fr\/blog\/wp-content\/uploads\/2014\/11\/crud-back-end-generator--300x120.png 300w, https:\/\/www.creativejuiz.fr\/blog\/wp-content\/uploads\/2014\/11\/crud-back-end-generator--600x240.png 600w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h2>Comment l&rsquo;utiliser CRUD Admin Generator ?<\/h2>\n<p>Le plus simple est encore d&rsquo;aller lire les \u00e9tapes d&rsquo;<a href=\"http:\/\/crud-admin-generator.com\/#installation\">installation de l&rsquo;outil<\/a> sur le site web officiel.<br \/>\nAutrement, rapidement, pour l&rsquo;installation :<\/p>\n<ol>\n<li><a href=\"https:\/\/github.com\/jonseg\/crud-admin-generator\/archive\/master.zip\">T\u00e9l\u00e9chargez l&rsquo;archive<\/a> et d\u00e9zippez la dans le dossier de destination de l&rsquo;outil (\u00e0 vous de choisir), ou clonez le repo git tout simplement.<\/li>\n<li>lancez une invite de commande, et une fois dans le bon dossier (<code>cd<\/code> est votre ami) lancez la commande suivante\n<pre class=\"code\"><code class=\"php boc-nocontrols boc-nogutter\">php composer.phar install<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p>(il faut que <a href=\"https:\/\/getcomposer.org\/\">Composer<\/a> soit install\u00e9)<\/li>\n<\/ol>\n<p>Puis pour la g\u00e9n\u00e9ration de l&rsquo;admin :<\/p>\n<ol>\n<li>entrez les infos de votre base de donn\u00e9es dans le fichier <code>\/src\/app.php<\/code>\n<pre class=\"code\"><code class=\"php boc-nocontrols boc-nogutter\">$app-&gt;register(new Silex\\Provider\\DoctrineServiceProvider(), array(\r\n    'dbs.options' =&gt; array(\r\n        'db' =&gt; array(\r\n            'driver'   =&gt; 'pdo_mysql',\r\n            'dbname'   =&gt; 'DATABASE_NAME',\r\n            'host'     =&gt; 'localhost',\r\n            'user'     =&gt; 'DATABASE_USER',\r\n            'password' =&gt; 'DATABASE_PASS',\r\n            'charset'  =&gt; 'utf8',\r\n        ),\r\n    )\r\n));<\/code><\/pre>\n<\/li>\n<li>Puis lancez la commande\n<pre class=\"code\"><code class=\"php boc-nocontrols boc-nogutter\">php console generate:admin<\/code><\/pre>\n<\/li>\n<\/ol>\n<p>Elle est maintenant pr\u00eate \u00e0 \u00eatre utilis\u00e9e\u00a0!<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-4374 size-full\" src=\"https:\/\/www.creativejuiz.fr\/blog\/wp-content\/uploads\/2014\/11\/crud-screens.png\" alt=\"CRUD Admin Generator recouvrant notre bonne vieille interface de phpMyAdmin\" width=\"870\" height=\"600\" srcset=\"https:\/\/www.creativejuiz.fr\/blog\/wp-content\/uploads\/2014\/11\/crud-screens.png 870w, https:\/\/www.creativejuiz.fr\/blog\/wp-content\/uploads\/2014\/11\/crud-screens-300x206.png 300w, https:\/\/www.creativejuiz.fr\/blog\/wp-content\/uploads\/2014\/11\/crud-screens-600x413.png 600w\" sizes=\"(max-width: 870px) 100vw, 870px\" \/><\/p>\n<p>C&rsquo;est un bon moyen de rendre plus agr\u00e9ables les longues p\u00e9riodes de travail sur vos bases de donn\u00e9es, que ce soit pour corriger des erreurs \u00e0 la main ou effectuer des tests pour un d\u00e9veloppement particulier.<\/p>\n<p>Et vous, avez-vous des outils pour rendre l&rsquo;inspection des bases de donn\u00e9es plus agr\u00e9able\u00a0?<\/p>\n<h2>Debugger l&rsquo;installation de CRUD Admin Generator<\/h2>\n<p>Cet article commence \u00e0 dater, si jamais vous rencontrez des erreurs d&rsquo;installation, pensez ) toujours v\u00e9rifier les derni\u00e8res mises \u00e0 jour de l&rsquo;outil et suivre <a href=\"https:\/\/github.com\/jonseg\/crud-admin-generator\">leur Readme<\/a>.<\/p>\n<p id=\"reference1\">* Jeu de mots tir\u00e9 du <a href=\"https:\/\/www.youtube.com\/watch?v=93y35TxY6uA\">film d&rsquo;animation de Marvel<\/a> (<a href=\"#backref1\">retour<\/a>)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vous restez bloqu\u00e9s quand vous voyez l&rsquo;interface d&rsquo;un PHPmyAdmin\u00a0? Vous souhaiteriez quelque chose de plus sympa pour consulter vos bases de donn\u00e9es SQL\u00a0? Essayez cette solution Open Source et gratuite bas\u00e9e sur le langage PHP.<\/p>\n","protected":false},"author":4,"featured_media":8385,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_bluesky_dont_syndicate":"","_bluesky_syndication_accounts":"","_bluesky_syndication_text":"","footnotes":""},"categories":[50,12],"tags":[607,494,233,431,554],"coauthors":[597],"class_list":["post-4363","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ressources-telechargements","category-veille-technologique","tag-backend","tag-mysql","tag-php","tag-sql","tag-ui"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/posts\/4363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/comments?post=4363"}],"version-history":[{"count":2,"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/posts\/4363\/revisions"}],"predecessor-version":[{"id":8387,"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/posts\/4363\/revisions\/8387"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/media\/8385"}],"wp:attachment":[{"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/media?parent=4363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/categories?post=4363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/tags?post=4363"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.creativejuiz.fr\/blog\/wp-json\/wp\/v2\/coauthors?post=4363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}