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

Posted by Prem Tiwari | Updated on | in Freebies, Mysql. Updated on


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 …

How to write multiple queries using MySQL Transaction

Posted by Prem Tiwari | Updated on | in Mysql, Oracle. Updated on


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 …

Facebook style photo gallery with comments

Posted by Prem Tiwari | Updated on | in JavaScript, Mysql, PHP Tutorial, Web Technologies. Updated on


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 …

Delete a Record with animation effect using jQuery and Ajax (Updated)

Posted by Prem Tiwari | Updated on | in JavaScript, Mysql, PHP Tutorial. Updated on


In this tutorials i will explain the easy steps to Delete a Record with animation effect using jQuery and Ajax. I like Twitter API very much, it’s clean and faster. So i prepared this jQuery …

Backup your Web Projects Database using MySQL Administrator

Posted by Prem Tiwari | Updated on | in Mysql, Oracle. Updated on


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 …

Check username availability using jquery and Ajax

Posted by Prem Tiwari | Updated on | in JavaScript, Mysql, PHP Tutorial. Updated on


Is that what you are looking for? Well, read this article, then you would have the brightest idea about Check username availability using jquery and Ajax. AJAX is also helpful when you retrieve data using …

How to create and use Mysql Trigger

Posted by Prem Tiwari | Updated on | in Mysql, Oracle. Updated on


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 …

How to Integrate Paypal Payment Gateway in PHP

Posted by Prem Tiwari | Updated on | in Mysql, PHP Tutorial. Updated on


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 …

Dynamic bar chart in using PHP

Posted by Prem Tiwari | Updated on | in Mysql, PHP Tutorial, Web Technologies. Updated on


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 …

Drag-and-drop menu with MySQL

Posted by Prem Tiwari | Updated on | in Freebies, Mysql, PHP Tutorial. Updated on


In this post i will explain to how to create a Drag and Drop Menus in your web application using php and mysql. This script allows you to manage your menu using drag and drop …

MySQL Server Administration Using Workbench

Posted by Prem Tiwari | Updated on | in Mysql. Updated on


In this article, I will explain the MySQL Workbench for administrative functions of Mysql Server. Mysql bench could be a visual information configuration equipment that mixes SQL advancement, organization, information defined, creation and support into …

Generating HTML Reports from SQL*Plus

Posted by Prem Tiwari | Updated on | in Mysql, Oracle. Updated on


This post explains how to generate a HTML reports from your Sql *plus query results. You can produce HTML output in AN interactive SQL*Plus session victimization the SET MARKUP command. you\’ll be able to embrace …

create and call procedure in mysql ( Updated 2016 )

Posted by Prem Tiwari | Updated on | in Mysql, Oracle. Updated on


In this post i will explain how to create store procedure in mysql and how to call store procedure in PHP for select, insert, update and delete data from mysql table. A stored procedure has …

Create login page using jsp

Posted by Prem Tiwari | Updated on | in JSP, Mysql. Updated on


In this article you will learn how you may design a simple Login form using JSP. We use the session for storing the users information. Login.jsp page take input from user and submitted to server …

How to Create View in Mysql

Posted by Prem Tiwari | Updated on | in Mysql. Updated on


A view is a virtual table or mapping of data from one or more tables. Views do not contain any data – it is just a stored query in the database that can be executed …