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 Michael Hanes recommendation, also because I read that CakePhp is now old and not being supported much.

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

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.

Security

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!

Theme Design

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

Bootstrap

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.

Bootstrap Downloadhttp://getbootstrap.com/
Glyphs (icons)http://getbootstrap.com/components/
Tutorial, Learn Bootstrap in one video (about an hour), complete and to the pointhttps://www.youtube.com/watch?v=gqOEoUR5RHg
Bootstrap Amazon Bookhttp://amzn.to/1RHdfPr
Bootstrap Cheat Sheethttp://goo.gl/M5G7wj
projects/cantata/start.1481250397.txt.gz · Last modified: 2016/12/09 02:26 by dwheele