Category Archives: Database

How to import csv file data into mysql database table example

Hello guys, in this article i will let you know how to import csv file data into mysql database table with an example. We can import csv file directoly through phpmyadmin but there are some restriction of max file upload size we can not upload large file through the import feature of phpmyadmin. We can also increase max_upload_size… Read More »

MYSQL how to create read only database user with example

Database for an application is most important thing and for some security reasons we can not give database details to all the developers who are working on the application. So here we will learn hot to create read only database user in MYSQL. As we can not rely on all developers for database access. So we will create… Read More »

PHP Laravel database seeder example with some sample user data insertion

Before jumping to anything, the first thing that may come to your mind “what is seeder” and “how can we use it in our laravel application”. Here in this article we are going to learn PHP Laravel database seeder example with some sample user data insertion and learn how to use database seeder in laravel. As a developer, while… Read More »

How to disable MYSQL strict mode

Sometimes while working on an application we got an error like “In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column ‘column_name’; this is incompatible with sql_mode=only_full_group_by”. It means this is an issue of mysql strict mode. In the newest version of mysql, it is defaulted on in mysql. So here in this article… Read More »

How to import csv file data into mysql database in php

Hello friends, In this tutorial i am going to tell your to import csv file  data into mysql database using PHP. First you should to know that in which situation you need to implement this code. Let’s assume you are developing an application in which users have some data in csv file and want to upload this csv… Read More »

How to export data in csv file using php and mysql

Hello friends, Sometimes we need data which are showing on the website in excel or csv format to manipulate manually. So it is a easiest to get data into csv format with export feature. In the PHP we can write a script to export data into csv format. I am going to tell you a simple and easiest… Read More »