Another Kuantan Blogger
Buka Terminal dan execute command berikut
curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composerSet permission utk directori .composer/ dalam home
drwxr-xr-x 3 root staff 102 Oct 1 10:50 .composerGuna command berikut
sudo chown -R $USER $HOME/.composerInstall Laravel
composer global require "laravel/installer=~1.1"
Run command berikut
php artisan make:migration tukar_field_type_table_parcel
Edit file migration TukarFieldTypeTableParcel.php seperti berikut
Function Up()
public function up()
{
//
Schema::table('parcels', function(Blueprint $table)
{
$table->integer('courier')->unsigned()->change();
$table->foreign('courier')->references('id')->on('couriers');
$table->integer('distributor')->unsigned()->change();
$table->foreign('distributor')->references('id')->on('distributors');
});
}
Function Down()
public function down()
{
//
Schema::table('parcels', function(Blueprint $table)
{
$table->dropForeign('parcels_courier_foreign');
$table->dropForeign('parcels_distributor_foreign');
});
}
*Unsigned() – Bertujuan memastikan nilai integer berkenaan bukan negative
*Sila pastikan type untuk setiap foreginer field dan reference field adalah sama.
“Foreign key constraint is incorrectly formed mysql”
Berlaku apabila foreign key column dan reference colum tak sama type!
Kadangkala kita perlu panggil beberapa model dalam satu page
First kena panggil model sebelum class controller seperti berikut
use App\Parcel;
use App\Distributor;
use App\Courier;
class ParcelsController extends Controller
{
...
Kemudian panggil seperti berikut dalam class controller. Disini kita pass lebih daripada satu variable (array).
public function create()
{
//
$distributors = Distributor::all();
$couriers = Courier::all();
return view('parcels.create',compact('couriers','distributors'));
}
Contoh pada view seperti berikut
<div class="form-group">
<label for="couriers" class="col-lg-2 control-label">Couriers</label>
<div class="col-lg-10">
<select class="form-control" id="courier" name="courier">
@foreach($couriers as $courier)
<option value="{{$courier->id}}">
{{ $courier->nama }}
</option>
@endforeach
</select>
</div>
</div>
Bila kita request untuk submit form, kita boleh tetapkan rules bagi validate field yang telah diisi.
Kebiasannya begini
public function rules()
{
return [
//
'nama' => 'required|min:3',
];
}
Kita juga boleh buat begini
switch($this->method())
{
case 'GET':
case 'DELETE':
{
return [];
}
case 'POST':
{
return [
//
'nama' => 'required|min:3',
'kod' => 'required|min:3',
];
}
case 'PUT':
case 'PATCH':
{
return [
//
'nama' => 'required|min:3',
'kod' => 'required|min:3',
];
}
default:break;
}
Biasa ler buat silap. Mana ada orang tak buat silap? 😛
Setiap kali buat perubahan pada table run command berikut
php artisan make:migration rename_nama_table_silap
Edit file migration dalam database/migrations/
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class RenameCourierTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
//
Schema::rename('courier', 'couriers');
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
//
Schema::rename('couriers', 'courier');
}
}