Laravel Training

composer create-project --prefer-dist laravel/laravel blog

composer require encore/laravel-admin

php artisan vendor:publish --provider="Encore\Admin\AdminServiceProvider"

After run command you can find config file in config/admin.php, in this file you can change the install directory,db connection or table names.

At last run following command to finish install.

php artisan admin:install

Open http://localhost/admin/ in browser,use username admin and password admin to login.

MIDDLEWARE
php artisan make:model MdlUser -m

php artisan admin:make UserController --model=App\User
php artisan admin:make MdlUserController --model=App\MdlUser

<?php        require_once (‘MysqliDb.php’);
        /**main db */        $db = new MysqliDb (‘127.0.0.1’, ‘root’, ”, ‘moodledb2’);
        /**slave db */
        $db->addConnection(‘slave’, Array (            ‘host’ => ‘127.0.0.1’,            ‘username’ => ‘root’,            ‘password’ => ”,            ‘db’=> ‘moodlelaravel’,            ‘port’ => 3306,            ‘prefix’ => ‘my_’,            ‘charset’ => ‘utf8’)        );
        $menu = $db->connection(‘slave’)->get(‘admin_menu’);        $users = $db->get(‘mdl_user’);
                foreach($users as $user){            $data = array (                         ‘mdl_user_id’ => $user[‘id’],                         ‘idnumber’ => $user[‘idnumber’],                         ‘department’ => $user[‘department’],                         ‘institution’ => $user[‘institution’],                         ‘username’ => $user[‘username’],                         ‘password’ => $user[‘password’],                         ‘firstname’ => $user[‘firstname’],                         ‘lastname’ => $user[‘lastname’],                         ’email’ => $user[’email’],                         ‘phone1’ => $user[‘phone1’],                         ‘skype’ => $user[‘skype’],                         ‘address’ => $user[‘address’],                         ‘city’ => $user[‘city’],                         ‘country’ => $user[‘country’]                         // ‘created_at’ => date(‘d M Y H:i:s Z’,$user[‘timecreated’]),                         // ‘updated_at’ => date(‘d M Y H:i:s Z’,$user[‘timecreated’])                         );                         $updateColumns = array(“idnumber”,”department”,”institution”,”firstname”,”lastname”,”email”);                         $lastInsertId = “mdl_user_id”;                         $db->onDuplicate($updateColumns, $lastInsertId);                         $id = $db->connection(‘slave’)->insert(‘mdl_users’,$data);                         if($id) echo “data inserted..id: “.$id;                         else echo “data not inserted”.$db->getLastError();         }

?>
<pre><?phpprint_r($menu);?></pre><br><pre><?phpprint_r($users);?></pre>