How To Create MySQL Trigger

This article will explain how to create Trigger in mysql. A mysql trigger is a procedural code which is automatically executed after response to certain events on a particular table or view in a database. I am taking a real […]

Read More…

How to delete duplicate data from database table

Hi friend, today i am going to share How to delete duplicate data from database table. For preventing from duplicate entries in datatbase table you cna use PRIMARY KEY or UNIQUE Index on table with fields. Bellow example show how […]

Read More…

Responsive country,state,city dropdown using PHP

I got many request to Responsive country,state,city dropdown values from the database without refresh page using Ajax and PHP. In this article, I’ve put three drop down of country,state,city, drop downs without refreshing the page. All the country, state, city […]

Read More…

How To Install Linux, Apache, MySQL, PHP (LAMP) Server on Ubuntu

LAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. As a solution stack, LAMP is suitable for building dynamic web sites and web […]

Read More…

How to write multiple queries using MySQL Transaction

A transaction is a sequential group of database manipulation operations, which is performed as if it were one single work unit. These statements provide control over use of transactions: START TRANSACTION or BEGIN start a new transaction. COMMIT commits the […]

Read More…

Facebook style photo gallery with comments

Have you thought about own facebook-style photo gallry system with comments? I have and today I prepared it for you. In this post i explained the easy way to create your Facebook style photo gallery with comments application. I used […]

Read More…

Backup your Web Projects Database using MySQL Administrator

Keeping a back up of your database is one of the most important tasks you should be performing, the utmost care should be taken to ensure you have an up-to-date backup. It’s very easy to use and using this we […]

Read More…

How to create and use Mysql Trigger

Introduction to SQL Trigger A SQL trigger is a special type of stored procedure. It is special because it is not called directly like a stored procedure. The main difference between a trigger and a stored procedure is that a […]

Read More…

How to Integrate Paypal Payment Gateway in PHP

In this post I am explaining a easy steps to how to integrate Paypal Payment Gateway in PHP and work with Paypal Sandbox test accounts for payment gateway integration and sending arguments while click buy now button. In order to […]

Read More…

Dynamic bar chart in using PHP

This class creates a PNG image bar graph for inclusion in HTML pages. The graph can display one or more data sets in user defined colors. The font size, font color background color, spacing between sets of bars, labels, and […]

Read More…