Build a guestbook application with Laravel 5


Following along with @rachidlaasri excellent tutorial on scotch.io: Build a Guestbook with Laravel and Vue.js

tl;dr - source code is here: https://github.com/connor11528/guestbook

Generate the application

Use this script to quickly scaffold a Laravel 5 app.

./create_laravel_app.sh guestbook
cd guestbook
php artisan serve
npm run watch

Add a database

Add sqlite database:

touch database/database.sqlite 

The only line you want in the .env file related to the db is: DB_CONNECTION=sqlite, get rid of the host, port, username business.

Sqlite is great for development but you probably wouldn't use it for a production app. You could go with MySQL. If you're interested in hooking up Laravel 5 to MySQL check this tutorial:

Laravel 5 Initial Database Setup and Seeding



In the tutorial we set up a model factory for generating Signatures in our database and use tinker to generate the records. Another approach is to use database seeders. Database seeders populate our database by running php artisan db:seed. This calls database/seeds/DatabaseSeeder.php. That file has a class that extends the Seeder class. In there is a run function that calls a seeder for generating Signatures:

public function run()

Generate that seeder by running php artisan make:seeder SignaturesTableSeeder and include a call to the model factory that's outlined in the scotch tutorial.

public function run()
    factory(App\Signature::class, 100)->create();

To check and make sure it worked we could view the db in a GUI such as Sequel Pro or use tinker like:

php artisan tinker
> \DB::table('signatures')->count(); // view # of records
> \DB::table('signatures')->get(); // view all records

Routes and Controllers

In this section we set up controllers for reporting signatures, displaying them, adding them and displaying an individual resource. We're building this as an API so I thought it was cool that the author namespaced the controllers into an Api folder when creating them. That was as simple as php artisan make:controller Api/SignatureController. Additionally, we use a Laravel resource controller but specify that we do not want ALL the routes, only a few:

Route::resource('signatures', 'Api\SignatureController')->only(['index', 'store', 'show']);

Most interestingly, in our controller we make calls to and return instances of SignatureResource, which we haven't defined yet.

There's also a nifty call to get the latest Signatures and ignore all signatures that have been flagged:

$signatures = Signature::latest()

The ignoreFlagged method call is a custom query scope that we define with the convention of “scopeMethodNameInCamelCase”. We defined the custom query scope in the Signature model:

public function scopeIgnoreFlagged($query)
    return $query->where('flagged_at', null);

The calls to latest() and paginate() are default parts of the Eloquent ORM.

If you're new to Laravel it is also worth checking out the route model binding included in the reporting signature route and controller.

The route looks like:

Route::put('signatures/{signature}/report', 'Api\ReportSignature@update');

Including the signature like this actually gives us access to the individual signature in our controller. So in the update method we pass in the database instance of the signature that we want to flag:

public function update(Signature $signature)

    return $signature;

Flag is a custom method we define in the Signature model.

The Signature Resource

Eloquent Resources (docs) are new in Laravel 5.5. Resources are a middle layer between your database and the JSON responses you send out to end users. In our case we're going to modify the data so we don't send out people's email addresses and send an avatar for their image.

Jeffery Way posted a Laracast about API Resources: What's New in Laravel 5.5: API Resources

In order to define a custom avatar attribute for signature instances we use the synatax “getAttributNameAttribute” syntax for out function:

public function getAvatarAttribute()
    return sprintf('https://www.gravatar.com/avatar/%s?s=100', md5($this->email));

sprintf returns a formatted string in PHP and md5 creates a hash. Gravatar is a service that grabs a photo for the user based on their email address.

Vue.js frontend

@rachidlaasri builds out an awesome Vue.js frontend and takes advantage of a vue-paginate prebuilt component (avail here). The pagination logic is especially interesting in the Signatures vue component. Reporting a signature and then removing it from the UI with lodash is pretty neat also:

report(id) {
    if(confirm('Are you sure you want to report this signature?')) {
        .then(response => this.removeSignature(id));

removeSignature(id) {
    this.signatures = _.remove(this.signatures, function (signature) {
        return signature.id !== id;

Here we take advantage of lodash remove method.

On our SignatureForm.vue there is a success message that displays conditionally when our signature is submitted:

<div class="alert alert-success" v-if="saved">
    <strong>Success!</strong> Your signature has been saved successfully.


Overall very good tutorial about building an API with Laravel 5.5 that hooks up to a Vue 2 frontend. We used a lot of Laravel configuration concepts to extend our models and even built a resource layer to modify the JSON that we return to Vue.

Make sure to check out the full tutorial on Scotch.io

comments powered by Disqus