• 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.