Javascript execute twice

iframe

 

SQL Statements to get daily Report

 

jQuery Datatable reload()

Example:

Reference:

  1. https://datatables.net/reference/api/ajax.reload()
  2. https://stackoverflow.com/questions/42905454/datatables-ajax-reload-loses-page

Transaction and lock tables in Laravel

Example

Reference:

  1. https://stackoverflow.com/questions/53522444/how-to-lock-table-with-laravel
  2. https://www.mysql.tw/2018/06/mysql-lock-table-lockrow-lock.html
  3. https://xyz.cinc.biz/2013/04/mysql-lock-tables.html
  4. https://laravel.com/docs/6.x/queries#pessimistic-locking

Laravel Storage Extension Issue

Script

Get correct MIME Type

Reference:

  1. https://laracasts.com/discuss/channels/requests/putfile-method-stores-mp3-files-as-bin-in-laravel?page=0
  2. https://laracasts.com/discuss/channels/laravel/laravel-54-uploadedfilegetmimetype-returns-incorrect-mimetype

Read CSV File

Don’t use phpspreadsheet to read .csv file because there could be some bugs and get incorrect result.

Reference:

  1. https://www.php.net/manual/zh/function.fgetcsv

PHP to handle 0 zero value

 

Order Box Layout in Modal

HTML

SCSS

 

iCheck

Official

https://github.com/fronteed/icheck

HTML