headfirst-mvc-laravel

brainstorming.md

Brainstorming

Headfirst MVC

• Targets : leaning and investigate MVC and Relation DB Design with Laravel(php) and MySQL

Sample project

Jim is a lecturer at a community college, and he wants an application to help him to keep track of the students he is advising. He wants to know which students register for which courses in which semester and what grade they got in those courses. He also wants the application to be password protected, with each user having a different login and password, and it must keep track of user lo gins/outs. Your job as a database developer is to design a database that will serve as the back-end of either a web-based or client-server based application. This database must capture and store all the relevant persistent data that will be used by the application

Todo

First step

1. Install PHP lastest version
2. Setup Empty Laravel Project
3. Setup Dev Enviroment for laravel and Learn the basic elements
4. Design Relational DB
5. Setup Test Enviroment and design test strategies
6. Design

Second step

1. CRUD forms
2. Layout and templates ( bootstrap )
3. Modified CRUD forms with new UI
4. Simple Authentication : Login
5. Migration : Data seed
6. CRUD Users

Third step

1. Service: mailer
2. Ion Authentication: login,reset password

Analyzing

Jim is a lecturer at a community college, and he wants an application to help him to keep track of the students he is advising. He wants to know which students register for which courses in which semester and what grade they got in those courses. He also wants the application to be password protected, with each user having a different login and password, and it must keep track of user lo gins/outs. Your job as a database developer is to design a database that will serve as the back-end of either a web-based or client-server based application. This database must capture and store all the relevant persistent data that will be used by the application

Keywords:

• lecturer
• advising
• students
• register
• courses
• semester
• grade
• application
• password protected
• logins/logouts
• web-based : web server
• client-server : api service
• database
• capture, store
• relevant persistent data

Entity

• user ( lecturer )
• student
• course
• student course ( courseid,studentid, semester, grade )

Domain

• Track of the students whom the lecturer advise
• Lecturer wants to know which students register for which courses in which semester and what grade they got in those courses
• The application must be password protected
• The system must keep track of user logins/logouts

Generating migrations

php artisan make:migration create_users_table # already exists, so need to modified
php artisan make:migration create_students_table
php artisan make:migration create_course_table
php artisan make:migration create_studentcourses_table

Some useful tips

• email length : https://stackoverflow.com/questions/386294/what-is-the-maximum-length-of-a-valid-email-address/44317754 (suggested 320)

Focus on the heart of software. The heart of software is solving the user's domains.

• http://ryantablada.com/post/two-design-patterns-that-will-make-your-applications-better
• https://viblo.asia/p/the-repository-design-pattern-AeJ1vONQGkby
• https://shawnmc.cool/2015-01-08_the-repository-pattern
• https://heera.it/laravel-repository-pattern
• http://slashnode.com/the-repository-pattern/
• https://itnext.io/repository-design-pattern-done-right-in-laravel-d177b5fa75d4

example.md

example.md

Constraint

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateStudentcoursesConstraint extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('studentcourses', function (Blueprint $table) {
            $table->foreign('studentid')
                    ->references('id')
                    ->on('students')
                    ->onDelete('cascade');
            $table->foreign('courseid')
                    ->references('id')
                    ->on('courses')
                    ->onDelete('cascade');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('studentcourses', function (Blueprint $table) {
            $table->dropForeign(['studentid']);
            $table->dropForeign(['courseid']);
        });
    }
}

headfirst-mvc-laravel.md

Headfirst MVC with Laravel

Installation

Install PHP

sudo apt-cache show php
sudo apt-get install software-properties-common -y
sudo apt-get install python-software-properties -y
sudo add-apt-repository ppa:ondrej/php -y
sudo apt-get update && sudo apt-get upgrade -y

Common package

php7.2

sudo apt-get install php7.2 -y

This command will install additional packages:

• libapache2-mod-php7.2
• libargon2-0
• libsodium23
• libssl1.1
• php7.2-cli
• php7.2-common
• php7.2-json
• php7.2-opcache
• php7.2-readline

Common modules

sudo apt-get install php-pear php7.2-curl php7.2-dev php7.2-gd php7.2-mbstring php7.2-zip php7.2-mysql php7.2-xml zip unzip -y

FPM

sudo apt-get install php7.2-fpm -y

Upgrade packages

sudo apt-get upgrade -y

Nginx serve static files

sudo netstat -plnt
sudo apt-get install nginx -y

Apache2 + PHP FPM serve backend

a2dissite 000-default

Create symlink

ubuntu@php:~/shared$ sudo rm /etc/apache2/sites-enabled/000-default.conf
ubuntu@php:~/shared$ sudo ln -s /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-enabled/000-default.conf
sudo cp -rf ~/shared/apache2/* /etc/apache2
sudo systemctl restart apache2
a2ensite php-local
sudo a2enmod actions

PHP FPM Configuration

sudo service php7.2-fpm status
sudo systemctl status php7.2-fpm
a2enmod actions fastcgi alias proxy_fcgi
sudo systemctl restart apache2

Composer

• https://getcomposer.org/download/
• https://getcomposer.org/doc/00-intro.md#globally

laravel

• https://askubuntu.com/questions/925072/unable-to-execute-the-laravel-command-laravel-new-myapp

composer global require laravel/installer
nano ~/.bashrc
export PATH=$HOME/.composer/vendor/bin:$PATH
source ~/.bashrc
laravel new [src] --force

Init project

New app

mkdir headfirst-mvc-laravel
laravel new headfirst-mvc-laravel -f

New composer script

"scripts": {
    "hello": [
        "@php -r \"echo('hello world');\""
    ],
...

composer hello

Generating migrations

php artisan make:migration create_users_table

• Schema : https://laravel.com/docs/5.0/schema

Dev tools

Visual Code

• https://marketplace.visualstudio.com/items?itemName=onecentlin.laravel-extension-pack

Ref

• Support versions : http://php.net/supported-versions.php
• Install : https://tecadmin.net/install-php5-on-ubuntu/
• Configuration : https://gist.github.com/GhazanfarMir/03bd1f1f770a3834d47274586d46ea62
• Best practice : https://gflclan.com/guides/how-to-set-up-nginx-php-71-fpm-on-ubuntu-1604-server-r4/
• https://serversforhackers.com/c/php-fpm-configuration-the-listen-directive

Funny things

1. DB Migration Error

php artisan migrate

database setting is not correct: error 1071: specified key was too long; max key length is 767 bytes

• https://laravel-news.com/laravel-5-4-key-too-long-error

• https://laravel.com/docs/master/migrations#creating-indexes

use Illuminate\Support\Facades\Schema;

/**
 * Bootstrap any application services.
 *
 * @return void
 */
public function boot()
{
    Schema::defaultStringLength(191);
}

Testing

• https://phpunit.de/getting-started/phpunit-8.html
• https://laravel.com/docs/5.8/testing https://laravel.com/docs/5.8/database-testing
• https://emcorrales.com/blog/laravel-testing-models

Dev Notes

1. MYSQL Fundamentals

Ref

• https://www.tutorialrepublic.com/sql-reference

Datatypes

• https://www.tutorialrepublic.com/sql-reference/mysql-data-types.php

2.Migration

• Ref: Migrations
• Sample

php artisan make:migration create_examples_table

Laravel Apache Config

<Directory "C:\workplace\www">
    AllowOverride All
    Options None
    Require all granted
</Directory>

# Default
<VirtualHost *:80>
    DocumentRoot "C:\workplace\www\localhost"
	ServerName localhost
    LogLevel warn
    ErrorLog "C:\workplace\www\logs\localhost_error.log"
    CustomLog "C:\workplace\www\logs\localhost_access.log" combined
</VirtualHost>

# Default
<VirtualHost *:80>
    DocumentRoot "C:\workplace\www\phpguru\hello.phpguru.net\public"
	ServerName hello-phpguru-net.local
    LogLevel warn
    ErrorLog "C:\workplace\www\logs\hello-phpguru-net_error.log"
    CustomLog "C:\workplace\www\logs\hello-phpguru-net_access.log" combined
	
    <Directory "C:\workplace\www\phpguru\hello.phpguru.net">
    Options Indexes MultiViews FollowSymLinks
    AllowOverride All
    Require all granted
    </Directory>
</VirtualHost>

XDebug Config

[xdebug]
zend_extension=xdebug
xdebug.remote_enable=1
xdebug.remote_host=127.0.0.1
xdebug.client_port=9000

Laravel Jetbrain Debug Config

PHP JetBrains Config

CLI

Version