How to write multiple queries using MySQL Transaction

Prem Tiwari - - Mysql, Oracle


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

Prem Tiwari - - JavaScript, Mysql, PHP Tutorial, Web Technologies


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)

Prem Tiwari - - JavaScript, Mysql, PHP Tutorial


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

Prem Tiwari - - Mysql, Oracle


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

Prem Tiwari - - JavaScript, Mysql, PHP Tutorial


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

Prem Tiwari - - Mysql, Oracle


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

Prem Tiwari - - Mysql, PHP Tutorial


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

Prem Tiwari - - Mysql, PHP Tutorial, Web Technologies


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

Prem Tiwari - - Freebies, Mysql, PHP Tutorial


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

Prem Tiwari - - Mysql


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

Prem Tiwari - - Mysql, Oracle


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 )

Prem Tiwari - - Mysql, Oracle


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

Prem Tiwari - - JSP, Mysql


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

Prem Tiwari - - Mysql


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 …

Mysql Query Syntax Example

Prem Tiwari - - Mysql


Hi friends how are you? Hope you are doing good, today i am going to share a very important and useful things with you. If you are beginners in mysql, then this tutorial is best …