Posts

Showing posts from February, 2021

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     ...
Post a Comment
Read more

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
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more

layout

 <!DOCTYPE html> <html lang="en">     <head>         @include('common.head')     </head>         <body>             @include('common.header')             @yield('content')             @include('common.footer')         </body> </html>     @if (count($errors) > 0)         <div class="alert alert-danger alertdisapper">             <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>             <ul>                 @foreach ($errors->all() as $error)                     <li>{{ $error }}</li>           ...
Post a Comment
Read more