cuonghuynh

Pass data:

return redirect()->route('admin.article.index')->with('results', $results);

Get data:

session('results');

cuonghuynh

/**
 * Class CsvHelpers
 * @package App\Services\Common
 */
class CsvHelpers
{
    /**
     * @param $file
     * @return string
     */

cuonghuynh

Chunk data

If you have a large CSV file, you very likely can't store it all in an array in memory before you start inserting the data into the DB, so you need to be inserting the data in chunks as you read it from the CSV file.

Queue chunks

You would be lost the data if the process unfortinately broken.

Log errors

You should know why it is broken. :)

cuonghuynh

error-related-to-only-full-group-by-when-executing-a-query-in-mysq

As of MySQL 5.7.5, the default SQL mode includes ONLY_FULL_GROUP_BY which means when you are grouping rows and then selecting something out of that groups, you need to explicitly say which row should that selection be made from.

Fixing:

$ sudo vim /etc/mysql/my.cnf

Add them to bottom of file

cuonghuynh

Add MariaDB Repository

$ sudo apt-get install software-properties-common
$ sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
$ sudo add-apt-repository 'deb http://ftp.osuosl.org/pub/mariadb/repo/10.2/ubuntu trusty main'

Update Repository index

$ sudo apt-get update

cuonghuynh

$product->whereRaw("strftime('%Y-%m', created_at) = '2010-1'")->get();

cuonghuynh

First of all , Backup All your Database.

$ mysqldump --all-databases > all_databases.sql

Add the newer APT package repository from the MySQL APT repository page

$ wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb

$ sudo dpkg -i mysql-apt-config_0.8.1-1_all.deb

Choose version 5.7 -> OK

Update your package index

cuonghuynh

Template engine:

Usually, we place it in script section of footer.

<script type="application/json" data-from-backend>
    {
      "product_id": "{{ product.id }}",
      "user_address": "{{ userAddress }}"
    }
</script>

cuonghuynh

str = str.toLowerCase();      

str = str.replace(/(à|á|ạ|ả|ã|â|ầ|ấ|ậ|ẩ|ẫ|ă|ằ|ắ|ặ|ẳ|ẵ)/g, 'a');
str = str.replace(/(è|é|ẹ|ẻ|ẽ|ê|ề|ế|ệ|ể|ễ)/g, 'e');
str = str.replace(/(ì|í|ị|ỉ|ĩ)/g, 'i');
str = str.replace(/(ò|ó|ọ|ỏ|õ|ô|ồ|ố|ộ|ổ|ỗ|ơ|ờ|ớ|ợ|ở|ỡ)/g, 'o');
str = str.replace(/(ù|ú|ụ|ủ|ũ|ư|ừ|ứ|ự|ử|ữ)/g, 'u');
str = str.replace(/(ỳ|ý|ỵ|ỷ|ỹ)/g, 'y');
str = str.replace(/(đ)/g, 'd');

cuonghuynh

echo round((memory_get_usage() / 1024 / 1024, 2) . ' MB' . PHP_EOL;