PHP Tutorial Laravel 4 Framework (Authentication) - users table

Laravel 4

1. Installing on Ubuntu - local
2. Installing on a Shared host
3. Installing on Windows
4. Creating users table
5. Home page with controller and blade
6. Blade Templating
7. Database connection and sending emails
8. Creating user account I - GET
9. Creating user account II - POST
10. Creating user account III - Error checking & redirecting input
11. Creating user account IV - User::create()
12. Activating user account I - Mail::send()
13. Activating user account II - Update user's status
14. User account sign-in I - Route and link
15. User account sign-in II - Validation
16. User account sign-in III - Login Authentication
17. Singing out
18. Remember the user
19. Changing Password I
20. Changing Password II
21. Recovering forgotten password I
22. Recovering forgotten password II
23. User Profile
24. Database Migration using artisan

This tutorial is the continuation from Installing Laravel on Windows. While we implement authentication, we'll learn how to use Laravel. In this chapter, we'll fill in the data we may need to use Eloquent ORM.

In later chapters, we'll work on logout (or sign out) from an account, we may get an error related to remember_token. Since the Laravel version4.1.26, we need additional column for a table (see Upgrading To 4.1.26 From <= 4.1.25) for security reason.

So, we need 10 columns instead of 9 columns in the following sections. (see also my sign out tutorial, Sign out, for more information regarding the new table).

We'll create our table users using phpMyAdmin. Actually, data model name we'll be using is user without 's', a singular form unlike the table name which is plural.

Click 'Go' and let's fill the table:

Then, save.

I think there are some conflicts when we install phpMyAdmin in htdocs or ..../public/. So, I installed phpMyAdmin in a directory that's not in the path to DocumentRoot: under C:/Apache2.

To make it work, we need to add the following lines to C:\Apache2\conf\httpd.conf file:

Alias /pma "C:/Apache2/phpMyAdmin"

<Directory "C:/Apache2/phpMyAdmin">
    Options FollowSymLinks
    AllowOverride None
    Order allow,deny
    Allow from all
</Directory>

After restarting, we get:

Laravel 4

1. Installing on Ubuntu - local
2. Installing on a Shared host
3. Installing on Windows
4. Creating users table
5. Home page with controller and blade
6. Blade Templating
7. Database connection and sending emails
8. Creating user account I - GET
9. Creating user account II - POST
10. Creating user account III - Error checking & redirecting input
11. Creating user account IV - User::create()
12. Activating user account I - Mail::send()
13. Activating user account II - Update user's status
14. User account sign-in I - Route and link
15. User account sign-in II - Validation
16. User account sign-in III - Login Authentication
17. Singing out
18. Remember the user
19. Changing Password I
20. Changing Password II
21. Recovering forgotten password I
22. Recovering forgotten password II
23. User Profile
24. Database Migration using artisan