Content added Content deleted

Inline

Revision as of 09:41, 20 September 2017

Installation

sudo apt install composer

Creating a project named 'code':

composer create-project --prefer-dist laravel/laravel hello
cp .env.example .env
php artisan key:generate
sudo chmod -R 777 storage/

Testing output:

php artisan serve --host 0.0.0.0 --port 8082

Edit hosts file:

sudo nano /etc/hosts
192.168.1.35	hello.dev

Create a new apache conf file:

sudo nano /etc/apache2/sites-available/laravel.conf

<VirtualHost *:80>
    ServerName hello.dev

    ServerAdmin webmaster@localhost
    DocumentRoot /var/www/html/hello/public

    <Directory /var/www/html/hello/public>
        AllowOverride All
    </Directory>

    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

sudo nano /etc/apache2/ports.conf
Listen 80

sudo a2ensite laravel.conf
sudo service apache2 restart

The site should be available now at:

http://hello.dev/

Auth

Enable Authentication

php artisan make:auth

Site Creation

ROUTES

cd routes/
sudo nano web.php

Route::get('contact', function () {
    return 'Hello from Aman';
});

Route::get('contact/{category}', function ($category) {
    return 'Hello from '.$category. ' Aman';
});

Check resulting pages:

http://192.168.1.35/hello/public/contact/
http://192.168.1.35/hello/public/contact/Test

VIEWS

Create a new View file:

cd ../resources/views/
sudo touch master.blade.php
sudo nano master.blade.php

Paste below contents:

<!DOCTYPE html>
<html lang="en">
<head>

	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE-edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<title>HELLO</title>

</head>
<body>

	<nav class="navbar navbar-inverse">
	<div class="container-fluid">

	 <div class="navbar-header">
		<a class="navbar-brand" href="{{url('/home')}}">Home</a>
	 </div>

	 <div>
		<ul class="nav navbar-nav">
		<li><a href="{{url('/view')}}">View All</a></li>
		<li><a href="{{url('/new')}}">Add New</a></li>
		<li><a href="{{url('/edit')}}">Edit/Delete</a></li>
		</ul>
	 </div>

	</div>
	</nav>
<!-- Online Links -->
	<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
	<script src="//cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.1/js/bootstrap.min.js"></script>
	<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css" >

	<div class="container">
	  @yield('content')
	</div>


</body>
</html>

Edit Routes for this file:

cd ../../routes/
sudo nano web.php

Route::get('/home', function () {
    return view('home');
});

Route::get('/view', function () {
    return view('view');
});

Route::get('/new', function () {
    return view('new');
});

Route::get('/edit', function () {
    return view('edit');
});

Create above defined VIEW page:

cd ../resources/views/
sudo touch view.blade.php 
sudo nano view.blade.php

Paste below contents:

@extends('master')

@section('content')

VIEW all content goes here

@endsection

Similarly create HOME page:

sudo nano home.blade.php

@extends('master')

@section('content')

HOME all content goes here

@endsection

Similarly create NEW page:

sudo nano new.blade.php

@extends('master')

@section('content')

NEW all content goes here

@endsection

Similarly create EDIT page:

sudo nano edit.blade.php

@extends('master')

@section('content')

EDIT all content goes here

@endsection

Test above page:

http://192.168.1.35/hello/public/home

CONTROLLERS

Routes page can call URLs but this is for small applications only.
For industrial applications, use Controllers.

Create a Controller:

sudo php artisan make:controller RecordController

Edit the above generated file:

cd app/Http/Controllers/
sudo nano RecordController.php

Append below contents:

class RecordController extends Controller
{
  public function showAll()
        {
                return view('view');
        }

  public function showNew()
        {
                return view('new');
        }

  public function showEdit()
        {
                return view('edit');
        }
}

Update the Routes file to use above controllers:

cd ../../routes/
sudo nano web.php

Append below content:

Route::get('/view', 'RecordController@showAll');

Route::get('/new', 'RecordController@showNew');

Route::get('/edit', 'RecordController@showEdit');

DATABASE

Easy to create & manage tables with Migrations in large environments.

Create a new DB 'hello' using phpmyadmin or below SQL Query:

create database hello;
grant all privileges on hello.* to aman@localhost identified by 'pwd@123';

Update the ENV file with this information:

sudo nano .env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=hello
DB_USERNAME=aman
DB_PASSWORD=pwd@123

Create a DB table using Artisan:

sudo php artisan make:migration create_records_table
Created Migration: 2017_09_19_190352_create_records_table

File is created under below location:

cd database/migrations/ && ls
2017_09_19_190352_create_records_table.php

Edit this file with below DB Table information:

sudo nano 2017_09_19_190352_create_records_table.php

    public function up()
    {
        Schema::create('records', function (Blueprint $table) {
            $table->increments('id');
            $table->string('country');
            $table->string('city');
            $table->string('date');
            $table->string('no_of_aliens');
            $table->string('color_of_aliens');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('records');
    }

Create the Tables:

sudo php artisan migrate

You can confirm the Tables created in phpmyadmin.

ELOQUENT

sudo php artisan make:model Record

cd app/

sudo nano Record.php

class Record extends Model {

   protected $table='records';
   protected $fillable=['id','country','city','date','no_of_aliens','color_of_aliens'];

}

Feed test data using Seeding:

create seed file:

sudo php artisan make:seeder RecordsTableSeeder

cd database/seeds/ aman@ubuntu:/var/www/html/hello/database/seeds$ sudo nano RecordsTableSeeder.php

use App\Record; //to import records.php file

class RecordsTableSeeder extends Seeder {

 public function run()
   {
      for ($i=0; $i<20; $i++)
       {
          Record::create
           (
               [
                  'country' => "country$i",
                  'city' => "city$i",
                  'date' => "date$i",
                  'no_of_aliens' => "no_of_aliens$i",
                  'color_of_aliens' => "color_of_aliens$i"
               ]
           );
       }
   }

}

sudo nano DatabaseSeeder.php

use App\Record;

class DatabaseSeeder extends Seeder {

   public function run()
   {
       $this->call('RecordsTableSeeder');
   }

}

aman@ubuntu:/var/www/html/hello$ sudo php artisan db:seed

Seeding: RecordsTableSeeder