Insert dummy data into MYSQL using PHP

Every project requires some initial data for testing. Either it’s a user profile information or product description; we need data to test the proper flow of application.

But where we can get dummy data?

Every time, we should ask the client to send us some dummy data so we can start project development?

Or we should add some dummy data into database and show to the client for testing purpose?

Answer is, it depends on the project scope. If you are working on corporate website then you may get company profiles, about us text, company’s portfolio, image gallery and contact us page text. But if you are developing a shopping cart or a content management system (CMS) then you require more data which client may not send you.

So in this post I am going to show you how to insert dummy data into mysql using PHP Faker Library. I already covered PHP Faker configuration and its basic use in my previous post.

What we are going to do:

We are going to create a database as my_cart. Then we will create 2 tables i.e. users and products. Then we will add data into both tables. Now lets’ start.

Create Database:

Create Tables:

Users Table:

Products Table:

Now we have created 2 tables it’s time to start PHP coding. So first we need to download faker library from github.

Faker Github Link:

You can also see my post my previous post How to use Faker – PHP Library that generates Fake Data


In this file we will insert data into users table.

First we load the autoload.php file and then create the object using $faker variable. $conn is the database connection and then we start loop that is running 11 times and insert row in users table. You can below image every iteration of for will create different data.

insert dummy data into mysql using php users


In this file we will insert data in products table.

In products.php file first we load the autoload.php file then we create instance having $faker name. After that we created database connection and then add for loop which is running 10 times. $productName holds the 2 word name of product, $productDesc has 500 character text in it, $productShortDesc has 1 paragraph, $productImgUrl holds the image with 640 width and 480 height and $productSku generate random number in between 1000 to 5000. After running above code 11 records are inserted into products table.

insert dummy data into mysql using php products


Posted in PHP

Author: Ahsan Zameer

I am a web developer and love to search new stuff on web. Trying different approaches and ideas to make web developing more interesting and enjoyable.