Framework

BadMethodCallException Method Illuminate\Database\Eloquent\Collection::roles does not exist.

July 27, 2023 by ghazalitajuddin Leave a Comment

ERROR

BadMethodCallException Method Illuminate\Database\Eloquent\Collection::roles does not exist.

BadMethodCallException Method Illuminate\Database\Eloquent\Collection::permissions does not exist.

The hint here is ‘Collection‘…

If somehow you got this error while you have check all code is ok, relationship is ok, then try to check either you use first() or get() method.

Supposedly you use first() instead of get() method as get() method will return a collection() while first() just return a record.

Tinker

$r = App\Models\Role::where('slug','super-admin')->first()
= App\Models\Role {#7268
    id: 1,
    name: "Super Admin",
    slug: "super-admin",
    created_at: "2023-07-27 01:11:24",
    updated_at: "2023-07-27 01:11:24",
  }

 $u = App\Models\User::where('name','Ghazali Tajuddin')->first()
= App\Models\User {#7278
    id: 1,
    name: "Ghazali Tajuddin",
    email: "ghazali.tajuddin@gmail.com",
    email_verified_at: "2023-07-27 01:11:24",
    #password: "",
    #remember_token: null,
    created_at: "2023-07-27 01:11:24",
    updated_at: null,
  }

Adding Country & State Drop Down List In Laravel

April 18, 2016 by ghazalitajuddin 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

April 18, 2016 by ghazalitajuddin 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

April 17, 2016 by ghazalitajuddin 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

April 17, 2016 by ghazalitajuddin 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

April 16, 2016 by ghazalitajuddin 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">

@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]