User Tools

Site Tools


Sidebar

Dan's Wiki

DokuWiki Instructions (local) DokuWiki Manual
Site Checker (Orphans Wanted)

Edit Sidebar

projects:cantata:start

This is an old revision of the document!


Cantata - Song Database and List Creation

Cantata 3 Development

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

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

Database Setup

Database Namequizkidn_cantata3
User Namequizkidn_can3
  • 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;

Database Table Setup

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.
projects/cantata/start.1470447404.txt.gz · Last modified: 2016/08/06 01:36 by dwheele