Blog Website

Tell us features of your blog, and we will tell you the database tables you need :)

Let me give you an example

1. One of the feature is to add/delete/update posts - for this you need posts table

2. Another features is to support tags - for this, Many To Many tags with posts

3. Images - one table called images

And at the end you will find answers in your question :)

What about, Likes and Comments. Can you please explain how can I create these two things. I mean the tables and the relationships.

// likes
$table->increments('id');
$table->unsignedInteger('post_id');
$table->unsignedInteger('user_id');

It has post_id and user_id

// comments
$table->increments('id');
$table->unsignedInteger('post_id');
$table->unsignedInteger('user_id');
$table->text('comment');

post_id - comment related to it, user_id - user which posted comment and comment - comment itself.

Ahaan... Nice. What about the Views. I mean to say the no. of times page is visited. How to do that? @sergiu17

@NOMGUY I find it strange when you gave so many good answers in a short time you asking these questions since with a bit of knowledge you could get real far.

Anyways https://laracasts.com/series/lets-build-a-forum-with-laravel covers some of these things.

// create_posts_table.php migration
$table->integer('views');


// controller
public function show($id)
{
    $post = Post::findOrFail($id);

    $post->increment('views');

    return view('posts.show', compact('post');
}

You could do this in many different ways.

Redis is another option

@NOMGUY Seems like a bit of exp farming you are doing here.

Haha... i know @Cruory .. But I am creating my own website, so I thought it could be a good way to have some tips. It's never too late to learn things.. ;)

Thanks @Sergiu17

Sometimes an example is also good.

Such a saviour... :D @bestmomo