I have decided first to use a tool name Agile Toolkit aka atk4, easy way to created working CRUD screens, but renounced after several attempts. Even though the tool seems very promising, it is far too similar to a true framework PHP like Symfony or Laravel so why don’t use directly a true framework, if you are able to do so. Then, I start to look-up for such resource especially in Laravel, that is considerably well documented and easy to handle for a non-developer like me.<\/b><\/p>\n
Like always the project obey to the 3 main legitimated criteria of our desperate and desacralized digital world : it has to be technical, “ROIstic” and “waiting-phobic” aka a person unable to wait, too impatient of getting a result as quick as possible with minimizing the effort of inquiry.<\/p>\n
Last but not least, I was forced to renounce to MAMP as it has taken me much more in configuration than in the real conception mostly because of PHP version or MySQL version.<\/p>\n
I bumped into this article, written by Povilas Korop and that was it. I had to test one of these tool, Navigator seems to be the perfect tool.<\/b><\/p>\n
Source : https:\/\/laravel-news.com\/13-laravel-admin-panel-generators<\/a><\/p>\n You may know CRUD, let me introduce you to BREAD. That is one of many core concepts inside the Navigator project.<\/p>\n BREAD is an acronym that stands for:<\/b><\/p>\n That was exactly what I was looking for : a turn-to-key and effective CRUD tool to manage whatever. In my case, manage journalists. Each journalist tightened to many articles.<\/b><\/p>\n Roughly, here is one of the screens that I made with Balsamiq. It is much better in this case to present a fully functional application.<\/b> First of all, I was force to install MySQL. I used to leverage on the version of MySQL delivered with MAMP but this time it does not fit, it creates annoying artificial errors due to MySQL version. I invite you to read this article if you need to do so. I did also the installation of Sequel Pro, a free soft, which provide a nice GUI to manage your MySQL databases. In my case, it was also a way to verify the validity of the migration files made by Laravel.<\/p>\n Source : https:\/\/coolestguidesontheplanet.com\/get-apache-mysql-php-and-phpmyadmin-working-on-macos-sierra\/<\/a><\/p>\n To install Laravel globally, I strongly advise you to use Composer. That supposes you have installed Composer, that is a piece of cake, just make a quick search on Google for “Composer”. Here is some command to install Laravel globally.<\/b><\/p>\n Install globally Laravel and add to your bash profile<\/b><\/p>\n Go to the path where you intend to dump your Laravel project. For me, it was historically the MAMP directory.<\/b><\/p>\n Create the new project<\/b><\/p>\n Go to the project<\/b><\/p>\n Install Voyager with the help of composer<\/b><\/p>\n Do not forget to change to make in .env, the credentials for the MySQL database, that you have previously created. After this operation, do not forget to start your MySQL server.<\/b><\/p>\n If you are still in the directory, you can launch the web application with the following command on the local server given by Laravel.<\/b><\/p>\n This is it! You can connect to Voyager via the local address: For those like me, who had the habit to use the MySQL from MAMP. Here the quick guide for the main commands in order to manage MySQL. You have to download the MySQL server and install it.<\/p>\n Source : https:\/\/coolestguidesontheplanet.com\/get-apache-mysql-php-and-phpmyadmin-working-on-macos-sierra\/<\/a><\/p>\n To connect to mysql<\/b><\/p>\n To change the password of the admin root<\/b><\/p>\n The command line to Start MySQL<\/b><\/p>\n The command line to Stop MySQL<\/b><\/p>\n To add the MySQL directory to your shell path<\/b><\/p>\n After the last command, you can connect to your MySQL server with your credentials root:root with this single line below.<\/p>\n This is where Navigator assists you as you may know what are the fields you want to expose for a future web application. For instance, you may want to expose Products, Shoes, Photos, Basket Players whatever… In my case, the idea was to handle journalists profile so I need to create a table with related information to the these journalists : address, email, photo, location, twitter account, preferred languages… etc and then another table that will store the posts for each journalist.<\/p>\n For simplicity purpose, I have drastically downgraded the information defining the journalist’s profile but the idea is here.<\/b><\/p>\n Do not forget to start the MySQL server<\/b> The database laravel_demo_1 will be the database that will back Voyager<\/b> This is it! You can connect to Voyager via the local address: Nice! The welcome screen of Navigator, it works!<\/b> If you forgot to start the MySQL server, you will get some errors.<\/b> In Navigator, you will access to the entire database that give you the chance to create any table wanted.<\/b> In each table creation, do no forget to add every time as the 2 last columns, 2 timestamps one named created_at, the other updated_at.<\/p>\n We create a table named “gonzoarticles” and at the same time the model for this table.<\/b> You are assisted in the all process of creation<\/b> Defining the fields for the table<\/b> You can now add the BREAD to your table<\/b> Do not forget to give the authorization to the users to browse, unless you will not be able to check you recent listing of journalists for instance.<\/b> The BREAD for table gonzoarticle<\/b> The BREAD for table gonzojournalist<\/b> Create a relationship between my 2 tables: gonzoarticles, gonzojournalists<\/b> Add some stuff to gonzojournalist<\/b> Add some stuff to gonzoarticle<\/b> Check the result in the MySQL database with Sequel pro for table gonzojournalist<\/b> Check the result in the MySQL database with Sequel pro for table gonzoarticle<\/b> Making Model<\/b> Usage of the compass<\/b> You can in Compass, search for artisan make:model for instance and let Navigator run the command for you.<\/b> The application errors log file<\/b> The guys behind Navigator has the sense of detail, that makes the difference between a great tool and a common one. Sound frivolous, pointless and futile but you can select the icon for each content. Very seducing and educational when you presenting the tool to your Product Owner.<\/b> Conclusion: The tool is great! It assists you in every step. A true time saver for a non-developer who wants to make the best presentation, sounds familiar to me \ud83d\ude42<\/b><\/p>\n The 2 tables for my project<\/b> Laravel and Voyager<\/b><\/p>\n Agile Toolkit<\/b><\/p>\n My purpose was to build-up a quick working administration interface to manage users listing. To be even more precise, journalists’ listing. At least, I had… <\/p>\nOne of the best concept in Navigator: BREAD<\/h4>\n
\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0000_screen_listing_journalists.png\")
<\/p>\nStop the crap: Install MySQL and Laravel globally<\/h4>\n
\r\ncomposer global require \"laravel\/installer\"\r\necho 'export PATH=\"$PATH:$HOME\/.composer\/vendor\/bin\"' >> ~\/.bash_profile\r\nsource ~\/.bash_profile\r\n<\/pre>\n
\r\n cd \/Applications\/MAMP\/htdocs\/admin_voyager_laravel_explained\/\r\n<\/pre>\n
\r\nlaravel new voyager_admin_test_1\r\n<\/pre>\n
\r\n cd \/voyager_admin_test_1\/\r\n<\/pre>\n
\r\ncomposer require tcg\/voyager\r\n<\/pre>\n
\r\nDB_CONNECTION=mysql\r\nDB_HOST=127.0.0.1\r\nDB_PORT=3306\r\nDB_DATABASE=laravel_demo_1\r\nDB_USERNAME=root\r\nDB_PASSWORD=root\r\n<\/pre>\n
\r\n php artisan serve\r\n<\/pre>\n
http:\/\/localhost:8000\/admin\/login<\/code>. The couple user and password is: admin@admin.com:admin<\/b><\/p>\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0014_serve_php.jpg\")
<\/p>\nInstalling MySQL<\/h4>\n
\r\n\/usr\/local\/mysql\/bin\/mysql -v -uroot -p\r\n<\/pre>\n
\r\nSET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');\r\n<\/pre>\n\r\nsudo \/usr\/local\/mysql\/support-files\/mysql.server start\r\n<\/pre>\n
\r\nsudo \/usr\/local\/mysql\/support-files\/mysql.server stop\r\n<\/pre>\n
\r\necho $PATH\r\necho 'export PATH=\"\/usr\/local\/mysql\/bin:$PATH\"' >> ~\/.bash_profile\r\nsource ~\/.bash_profile\r\n<\/pre>\n
\r\nmysql -u root -p;\r\n<\/pre>\n
“Hitting” some BREADs<\/h4>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0001_admin_voyager_laravel_explained_mysql_1.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0003_admin_voyager_laravel_explained_mysql_migrations.jpg\")
<\/p>\nhttp:\/\/localhost:8000\/admin\/login<\/code>. The couple user and password is: admin@admin.com:admin<\/b>
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0006_admin_login.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0004_admin_voyager_laravel_explained_dashboard.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0005_no_sql.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0007_listing_db.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0008_create_table_with_model.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0009_create_db_1.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0010_create_db_2.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0011_add_bread_1.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0013_edit_bread_1.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0016_add_gonzoarticle.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0017_add_gonzojournalist.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0015_db_relationship.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0020_dashboard_listing_Gonzojournalist.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0021_dashbaord_listing_Gonzoarticle.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0019_db_table_gonzojournalist.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0018_db_table_gonzoarticles.jpg\")
<\/p>\nSome other great features in Navigator<\/h4>\n
\nIn the “app” folder of Laravel, if you ask to create the model, you will get it. The equivalent of php artisan make:model Gonzoarticle<\/code> or php artisan make:model Gonzojournalist<\/code><\/b>
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0022_files_controler.jpg\")
<\/p>\n
\nIf you are looking for application log, extra resources or you want to run some commands in tour Laravel project.
\nHave a look to the Compass. It is a section where you can run a bunch of Laravel command. It is sometime very handy because as you want to focus on you web application creation and are not often using command-line, you will not to have to jump to the console. Compass will be there to assist you in passing the command line, right through your browser. <\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0023_dashboard_compass_command_line.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0024_dashboard_compass_logs.jpg\")
<\/p>\n
\n![\"Laravel,](\"https:\/\/flaven.fr\/wp-content\/uploads\/2017\/11\/0012_choose_icon.jpg\"){kind=icon}
<\/p>\n
\nA quick and dirty description of my 2 tables used in the project.<\/p>\n\r\n--- TABLE gonzojournalists\r\n--- description Gonzo Journalism\r\nportrait -- varchar(191)\r\ndisplayName -- varchar(180)\r\naddressCity -- longblob\r\n--- PEOPLE\r\n-- Guy de Maupassant\r\n-- Buffalo Roam\r\n-- Hunter S Thompson\r\n-- Tom Wolf\r\n-- Guido Gansoda\r\n\r\n--- TABLE gonzoarticles \r\n--- description Gonzo articles\r\nid -- integer\r\nauthor_id -- integer (that make the relationship)\r\ntitle -- varchar(191)\r\nexcerpt -- text 65535\r\nbody -- text 65535\r\nimage -- varchar(191)\r\ncreated_at -- timestamp\r\nupdated_at -- timestamp\r\n\r\n\r\n--- DESCRIPTION\r\n-- Style of journalism outrageously personal, opposed to the dogmas of subjective neutrality of the profession.\r\n--- EXTENSION\r\n-- Also refers to a type of pornography where the actor holds the camera at the same time as he interprets the scene.\r\n--- ORIGINE\r\n-- gonzo: silly, credulous, dupe in Italian or ganso: goose in Spanish\r\n-- At the origin of gonzesse (chick), gorgonzola (cheese)... No just kidding, cheesy sense of humor :)\r\n\r\n<\/pre>\n
Read more<\/h2>\n
\n
https:\/\/laravelvoyager.com\/<\/a><\/li>\n
http:\/\/www.thecontrolgroup.com\/<\/a><\/li>\n
http:\/\/laraadmin.com\/<\/a><\/li>\n
https:\/\/www.youtube.com\/watch?v=M2gUAwok-KI<\/a><\/li>\n
https:\/\/www.youtube.com\/watch?v=9D4Yp5H25KQ<\/a><\/li>\n
https:\/\/www.youtube.com\/watch?v=F7ZJNi5LEw4<\/a><\/li>\n
https:\/\/www.youtube.com\/watch?v=ML_lS-rmTfk<\/a><\/li>\n
https:\/\/www.youtube.com\/watch?v=Jbt5bEgv_QM<\/a><\/li>\n
https:\/\/www.youtube.com\/channel\/UCTuplgOBi6tJIlesIboymGA<\/a><\/li>\n
https:\/\/quickadminpanel.com\/<\/a><\/li>\n
http:\/\/laraveldaily.com\/packages\/quickadmin\/#basicusage<\/a><\/li>\n
https:\/\/scotch.io\/tutorials\/simple-laravel-crud-with-resource-controllers<\/a><\/li>\n
https:\/\/www.youtube.com\/watch?v=eyeZhwP1LP4<\/a><\/li>\n
https:\/\/www.youtube.com\/watch?v=LQYAeYS1RT8<\/a><\/li>\n
https:\/\/www.youtube.com\/watch?v=sSRaYpoJFHk<\/a><\/li>\n
https:\/\/github.com\/atk4<\/a><\/li>\n
http:\/\/agile-data.readthedocs.io\/en\/develop\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"