GhazaliTajuddin.com

Another Kuantan Blogger

model

Kelebihan Laravel Relationship Eloquent

by Leave a Comment

Antara sebab aku nak belajar sangat menggunakan framework ni adalah disebabkan oleh ia menyediakan teknik query atau capaian data yang memudahkan sesetengah kerja yang remeh temeh:

Cth

Table

Filem(id, title, content, status_id )
Status(id, nama)

Dalam coding biasa, bila nak papar maklumat filem dan juga status, kita terpaksa buat  query seperti berikut:

select title, content, status
from filem
join status
   on filem.status_id = status.id

Mudah sahaja, tetapi, dalam laravel kita boleh skip, dan menjadikan coding kita lebih kemas. Cuma kena setup dulu relationship between model (belongsTo(), hasMany(), hasOne(), dll).

Lihat sample dibawah.

Model class Filem

public function getStatus()
{
return $this->belongsTo('App\Status', 'status_id');
}
Model class Status

public function Filem()
{
return $this->hasMany('App\Status', 'status_id');
}

Dalam view hanya masukkan kod berikut untuk dapatkan status

{{$parcel->getDistributor->nama}}

 

Adding Country & State Drop Down List In Laravel

by Leave a Comment

Download at http://www.cssscript.com/generic-country-state-dropdown-list-countries-js/

Create public/js directory and put all the .js file inside.

Create public/css directory and put all the .css file inside.

Add to the master blade head tags

<script type="text/javascript" src="{{ asset('js/countries.js') }}"></script>

Add to the bottom of master body tags area

<script language="javascript">
populateCountries("country", "state"); // first parameter is id of country drop-down and second parameter is id of state drop-down
</script>

 

Adding Jquery Datepicker in Laravel Form

by Leave a Comment

Add jquery css in your header (view)

<link rel="stylesheet" href="//code.jquery.com/ui/1.11.2/themes/smoothness/jquery-ui.css">

Add jquery js in yoyr footer (view – body tags)

<script>
$(function() {
$( "#datepicker" ).datepicker();
});
</script>

Edit your forms

{!! Form::text('date', '', array('id' => 'datepicker','class' => 'form-control')) !!}

 

Reference: Laracast

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]