• Troubleshooting
• Cantata Version 1
• Cantata Version 2
• Cantata Version 3

Intending to create a version 3, with a more full implementation. Perhaps using a PHP Framework will help, although concerned that the complex sensitive AJAX interactions may make this not work for everything.

5/5/2016: Initially trying CakePhp 3.2.8: cakephp.org

• http://book.cakephp.org/3.0/en/installation.html

5/30/2016 Deciding to move to Laravel, partially at Michael Hanes recommendation, also because I read that CakePhp is now old and not being supported much.

• https://laravel.com
• Laravel Notes
• Database Notes for Cantata 3
• Cantata 3 Requirements

Also downloaded Vagrant, which allows a dynamic configuration of the Virtual Box.

Downloaded PhpStorm 30-day eval, which integrates nicely with Vagrant/Virtual Box. To start it, run:

• JetBrains PhpStorm 2016.2.1

• create database quizkidn_cantata3;
• create user 'quizkidn_can3'@'%' identified by 'cantatapass3';
• grant all on quizkidn_cantata3.* to 'quizkidn_can3'@'%';
• FLUSH PRIVILEGES;
• select user from mysql.user;

Laravel uses an ORM, which allows a class to equal a database table. The “-m” creates a migration file. It will create the Song.php file also, and modifications don't need to be made to Song.php unless there are relationships between Song.php and another Model.

php artisan make:model Song -m

-> Model created successfully.

• https://laravel.com/docs/5.3/authentication

I set up default Laravel security by running this:

php artisan make:auth
php artisan migrate
http://cantata3/register

I logged in (establishing an initial login) with quizkid:<usual password>

Want to get started fast? Just run php artisan make:auth and php artisan migrate in a fresh Laravel application. Then, navigate your browser to http://your-app.dev/register or any other URL that is assigned to your application. These two commands will take care of scaffolding your entire authentication system!

Looking here:

https://almsaeedstudio.com/themes/AdminLTE/documentation/index.html

This is an open source theme. It has a lot of features, including a source-code LESS-required version. Starting for now with the “Ready” version.

http://almsaeedstudio.com/download/AdminLTE-dist

This uses “Bootstrap” which is a complete set of CSS and Javascript templating. While looking at AdminLTE, it seems that I should just use Bootstrap for a good look-and-feel framework.

Keeping items here that need to be done.

• If a file is in the directory and it has an invalid character (such as Calon Lan, with an accented “a”), need to change the directory name before importing into the database. For now, I'm manually changing it. 12/22/2016