Laravel Connection Establishment Database

1. Frame setting

first we need to set the Laravel framework, open the application/config/application.php file, we will first set the file key parameter to any 32-bit string:

1. ' Key ' = ' yoursecretkeygoeshere! ',

This string will be used to encrypt our password. Then we set up the database information in application/config/database.php, where we built it beforehand, and you can name it arbitrarily:

2. ' MySQL ' =>array (
4. ' Driver ' = ' mysql ',
6. ' Host ' = ' localhost ',
8. ' Database ' = ' database ',
10. ' Username ' = ' root ',
12. ' Password ' = ' 123456 ',
14. ' CharSet ' = ' utf8 ',
16. ' Prefix ' = ',
18. ),
20. 2. Create a database

21. Then we will use the artisan and migrations tools to build the database, you can simply understand it as a database tool, before using it we need to initialize it. First, add your PHP directory to the environment variable of the system, and then open the CMD tool CD to the root of the Web to run the command:

    1. PHP Artisan Migrate:install

    This is when we entered the database and found a table named Laravel_migrations, which records the data migrate needs. Then we run the following two commands:

    1. PHP Artisan Migrate:make create_admin_table
    2. PHP Artisan Migrate:make create_docs_table

    After a successful run we can see two files named Date _creat_admin_table.php and date _creat_docs_table.php in the Application/migrations directory.

    First open the creat_admin_table.php file and add the code in the Up and down methods:

    2. Publicfunctionup ()
    4. {
    6. Schema::create (' admin ', function ($table)
    8. {
    10. $table->increments (' id ');
    12. $table->string (' email ', 64);
    14. $table->string (' password ', 64);
    16. });
    18. Db::table (' admin ')->insert (Array (
    20. ' Email ' = ' your email ',
    22. ' Password ' =>hash::make (' Your password '),
    24. ));
    26. }
    28. Publicfunctiondown ()
    30. {
    32. Schema::d rop (' admin ');
    34. }

    Re-edit the creat_docs_table.php file:

    2. Publicfunctionup ()
    4. {
    6. Schema::create (' Docs ', function ($table)
    8. {
    10. $table->increments (' id ');
    12. $table->string (' title ', 64);
    14. $table->text (' content ');
    16. $table->string (' Create_date ', 12);
    18. $table->string (' Last_change ', 12);
    20. });
    22. Db::table (' docs ')->insert (Array (
    24. ' Title ' = ' Test ',
    26. ' Content ' = ' Just a test! ',
    30. ' create_date ' =>time (),
    32. ' last_change ' and ' = '
    34. ));
    36. }
    38. Publicfunctiondown ()
    40. {
    42. Schema::d rop (' docs ');
    44. }

    After saving, we continue to run the command:PHP artisan Migrate

    48. Database Setup Complete

    50. 
        

Laravel Connection Establishment Database