GhazaliTajuddin.com

Another Kuantan Blogger

PHP

Laravel html helpers with Laravel Collective Packages

by Leave a Comment

We need to install http://laravelcollective.com.

HTML: HTML helpers for creating common HTML and form elements

Run

composer require "laravelcollective/html":"^5.2.0"

 

OR edit composer.json, Add

"require": {
"php": ">=5.5.9",
"laravel/framework": "5.1.*",
"laravelcollective/html": "5.1.*"
},

Run

composer update

Edit config/app.php.

Add to the provider array

App\Providers\RouteServiceProvider::class,
Collective\Html\HtmlServiceProvider::class,

Add to the aliases array

'View' => Illuminate\Support\Facades\View::class,
'Form' => Collective\Html\FormFacade::class,
'Html' => Collective\Html\HtmlFacade::class,

Usage

Normally our code like this.

<form action="contact">
<label>First name:</label>
<input type="text" name="firstname" value="Enter your first name">
<br />
<label>Last name:</label>
<input type="text" name="lastname" value="Enter your last name">
<br />
<input type="submit" value="Submit">
</form>

Using the HTML Package

{!! Form::open(array ('url' => 'contact')) !!}
{!! Form::label('First name') !!}
{!! Form::text('firstname', 'Enter your first name') !!}
<br />
{!! Form::label('Last name') !!}
{!! Form::text('lastname', 'Enter your last name') !!}
<br />
{!! Form::submit() !!}
{!! Form::close() !!}

SQL Laravel

by Leave a Comment

Change

.env
[php]
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=bebasrokok01
DB_USERNAME=root
DB_PASSWORD=
[/php]

config/database.php
[php]
‘mysql’ => [
‘driver’ => ‘mysql’,
‘host’ => env(‘DB_HOST’, ‘localhost’),
‘port’ => env(‘DB_PORT’, ‘3306’),
‘database’ => env(‘DB_DATABASE’, ‘bebasrokok01’),
‘username’ => env(‘DB_USERNAME’, ‘root’),
‘password’ => env(‘DB_PASSWORD’, ”),
‘charset’ => ‘utf8’,
‘collation’ => ‘utf8_unicode_ci’,
‘prefix’ => ”,
‘strict’ => false,
‘engine’ => null,
],
[/php]

create_users_table.php
[php]
<?php

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

class CreateUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(‘users’, function (Blueprint $table) {
$table->increments(‘id’);
$table->string(‘facebook_id’)->unique();
$table->string(‘name’);
$table->string(’email’)->unique();
$table->string(‘password’,60);
$table->rememberToken();
$table->timestamps();
});
}

/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop(‘users’);
}
}

[/php]

Simple Laravel 5.2 layout and view

by Leave a Comment

This simple layout using basic Bootstrap CDN (http://getbootstrap.com)

master.blade.php
[php]

<html>
<head>
<title> @yield(‘title’) </title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap-theme.min.css">

<script src="//code.jquery.com/jquery-1.11.3.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
</head>
<body>

@include(‘shared.navbar’)

@yield(‘content’)

</body>
</html>

[/php]

navbar.blade.php
[php]

<nav class="navbar navbar-default">
<div class="container-fluid">
<!– Brand and toggle get grouped for better mobile display –>
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Learning Laravel</a>
</div>

<!– Navbar Right –>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav navbar-right">
<li class="active"><a href="/">Home</a></li>
<li><a href="/about">About</a></li>
<li><a href="/contact">Contact</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false">Member <span class="caret"></span></a>
<ul class="dropdown-menu" role="menu">
<li><a href="/users/register">Register</a></li>
<li><a href="/users/login">Login</a></li>
</ul>
</li>
</ul>
</div>
</div>
</nav>

[/php]

home.blade.php

[php]
@extends(‘master’)
@section(‘title’, ‘Home’)

@section(‘content’)
<div class="container">
<div class="content">
<div class="title">Home Page</div>
<div class="quote">Our Home page!</div>
</div>
</div>
@endsection
[/php]

Laravel: Model

by Leave a Comment

Untuk create model dalam Laravel run command berikut

php artisan make:model Ticket

Note: a model name should be singular(Ticket), and a table name should be plural(tickets).

Selepas command berkenaan dilaksanakan, anda akan jumpa file model Ticket.php dalam direktori app/.

Laravel: Create Table

by Leave a Comment

MIGRATION

Untuk create table dalam Laravel. Kita akan menggunakan Migration.

Migration adalah satu features dalam Laravel yang memudahkan developer track database scheme.

Laravel menggunakan migration untuk apa perubahan yang telah kita lakukan pada database kita.

Kelebihannya, anda dengan mudah boleh buat kemaskini atau revert balik perubahan dengan sekadar command ringkas.

Cth:

php artisan migrate:reset

CREATE NEW MIGRATION FILE

Create file migration dengan nama create_tickets_table (atau nama lain pun boleh).

php artisan make:migration create_tickets_table

File migration akan dhasilkan dan ditempatkan dalam direktori database/migrations.

File migration akan mempunyai timestamp diawal nama file seperti berikut

2015_06_15_150120_create_tickets_table.php


use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateTicketsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
//
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
//
}
}

Bila anda buka file berkenaan ada 2 method penting:

  • Method Up: Utk add table, column kepada database
  • Method Down: Untuk reverse apa up buat

CREATE MIGRATION dengan opsyen ‘–CREATE’

Dengan menambah ‘–create’ diakhir command create migration, Laravel secara otomatis akan generate code tickect table untuk anda.

Cuba delete file migration create ticket table yang terdahulu

2015_06_15_150120_create_tickets_table.php

Kemudian cuba run command berikut

php artisan make:migration create_tickets_table --create=tickets

public function up()
{
Schema::create('tickets', function (Blueprint $table) {
$table->increments('id');
$table->timestamps();
});
}

Jika anda lihat method Up mempunyai

$table->increments(‘id’);

merupakan id column dan merupakan primary key pada table berkenaan

$table->timestamps();

merupakan method special dalam Laravel yang menghasilkan kolum created_at dan update_at. Laravel menggunakan kolum ini untuk mengetahui perubahan table berkenaan.

refer disini untuk maklumat penuh migration http://laravel.com/docs/master/migrations

CREATE TABLE SEBENAR

Ubahsuai generated code berkenaan



public function up()
{
Schema::create('tickets', function (Blueprint $table) {
$table->increments('id');
$table->string('title', 255);
$table->text('content');
$table->string('slug')->nullable();
$table->tinyInteger('status')->default(1);
$table->integer('user_id');
$table->timestamps();
});
}

Selepas berpuas hati run command berkenaan untuk create table dan kolum

php artisan migrate

Sepatutnya sekarang table database telah dicipta. Boleh semah pada phpmyadmin.

Jika ada error semasa migrate, sila semak user permission dan juga config file database dan file .ENV.