Category: Database
Firebase Integration With Laravel 6.x (Ubuntu 18.04)
Below are the steps to integrate Firebase with Laravel 6.x Step 1 To integrate Firebase with Laravel we first need a Laravel project. Create a new Laravel project using the given composer command. composer create-project –prefer-dist laravel/laravel firebase Step 2
Advanced SQL – Indexes and Triggers
Introduction The SQL database provides a lot of commands and functions. With the help of them, we can manage a huge amount of data easily in the database. Following are some of the examples: INDEX: In the SQL database Index
MySQL: only_full_group_by issue on joins
Issue #1055 – Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxx which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by After upgrading ubuntu 14.04 to
PHP: mysqli_multi_query stops the execution of further MySQL queries.
The mysqli_query statement Generally, we use mysqli_query to execute Mysql queries in PHP. We can use multiple mysqli_query statements to execute multiple operations like insert, update, and select. Sometimes, we store records in more than one table during save operation
MongoDB Driver Not Found
Problem – Getting “Class ‘MongoDB\Driver\Manager’ not found” error while inserting some data in the collection (Laravel) Check the following three points in order to resolve the MongoDB driver issue in Laravel: 1. PHP Module 2. MongoDB Extension 3. MongoDB Library
Migrate MySql to MariaDB in Ubuntu 18.04
How to Migrate MySql to MariaDB in Ubuntu 18.04 We need to perform few steps to migrate the MySql database to Maria database, I have mentioned the steps below: Log in to your MySql server with root password. $ mysql
How to Detect Mobile devices in php
Detect mobile device php code We often need to detect if site visitor is using an iPad, a smartphone or any other mobile device in order to change website appearance and even make it faster by reducing data load. Normally
Class ‘App\Controller\Aws\S3\S3Client’ not found error in CakePHP 3.*
How to resolve “Class ‘App\Controller\Aws\S3\S3Client’ not found” error in CakePHP 3.* Problem: Class ‘App\Controller\Aws\S3\S3Client’ not found error occurs when we are trying to create S3Client class object with given code (code copied from github): $s3 = new Aws\S3\S3Client ( [
Class ‘App\Controller\Aws\S3\S3Client’ not found error in CakePHP 3.*
How to resolve “Class ‘App\Controller\Aws\S3\S3Client’ not found” error in CakePHP 3.* Problem: Class ‘App\Controller\Aws\S3\S3Client’ not found error occurs when we are trying to create S3Client class object with given code (code copied from github): $s3 = new Aws\S3\S3Client ( [