Posts

Laravel 8 REST API with Passport Authentication

Stap 1 : composer create-project --prefer-dist laravel/laravel blog composer require laravel/passport php artisan migrate php artisan passport:install Stap 2 : app/Models/User.php use Laravel\Passport\HasApiTokens; use HasApiTokens Stap 3 : config/auth.php      'guards'  => [          'web'  => [              'driver'  =>  'session' ,              'provider'  =>  'users' ,         ],          'api'  => [              'driver'  =>  'passport' ,              'provider'  =>  'users' ,        ...

Trigger Db

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ BEGIN          UPDATE   games_tips   SET            tmpGameTipsId =  new . id  , odds =  new . odds  , IsWin =  new . IsWin            WHERE   gameId =  new . gameId  AND  date = new . date ;            END ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ CREATE   TRIGGER   `Update Game Total Tips`   AFTER   INSERT   ON   `games_tips`   FOR   EACH   ROW   BEGIN        UPDATE   games   set   gameTotalTips  = ( SELECT   count ( 'gameId' )  FROM   `games_tips`        WHERE   `gameId` =  new . gameId     ...

File System windows , linux

Create   folder  :   mkdir   foldername Change   directory  : cd   foldername Create   file  :  type   nul  >  filename . php Edit   contant  : notpad   filename . php     or    code   filename . php Copy   file  : copy   filename . php   becup - filename . php Rename   file  : rename   becup - filename . php   becup1 - filename . php Delete   file  : del   becup1 - filename . php Folder   copy  : Xcopy   foldername   becup - foldername  / E  / H  / C  / I Remove   folder  : rmdir  / s   foldername

Google sheets import

 google-sheets-tips-update.json "google/apiclient" :  "^2.0" , Route :: get ( 'excelImport' ,  'Admin\AdminController@excelImport' ) -> name ( 'excelImport' ); {    "type" :  "service_account" ,    "project_id" :  "excel-sheet-demo" ,    "private_key_id" :  "f452ed9f9e2345fc3a6793737254e59efb7dad7ff" ,    "private_key" :  "-----BEGIN PRIVATE KEY-----END PRIVATE KEY-----\n" ,    "client_email" :  "demo-account-excel-sheet@excel-sheet.com" ,    "client_id" :  "105540755601386431894" ,    "auth_uri" :  "https://accounts.google.com/o/oauth2/auth" ,    "token_uri" :  "https://oauth2.googleapis.com/token" ,    "auth_provider_x509_cert_url" :  "https://www.googleapis.com/oauth2/v1/certs" ,    "client_x509_cert_url" :  "https://www.googleapis.com/.com...

Custom Login

  <?php namespace  App\Http\Controllers\Auth ; use App\Model\ UserLogin ; use Illuminate\Http\ Request ; use  Session ; use Illuminate\Support\Facades\ Auth ; use App\Model\ Users ; class   AdminLoginController   extends   LoginController {      /*     |--------------------------------------------------------------------------     | Admin Login Controller     |--------------------------------------------------------------------------     |     | This controller handles authenticating admin users for the application and     | redirecting them to your home screen. The controller uses a trait     | to conveniently provide its functionalit...