a digital blog

Category: MySql

Page 1/2

MySql-difference-between-Drop,-Truncate-and-Delete

MySql, Tricks

MySql difference between DROP, TRUNCATE and DELETE

In MySql the difference between DROP, TRUNCATE and DELETE is one of the most common interview question. Thus I have to  explain the differences between DROP, TRUNCATE and DELETE statements of MySQL. DROP:-  Drop command will remove entire table from the database. Drop opration can not be rolled back. TRUNCATE :- TRUNCATE is a DML command TRUNCATE removes all rows from a table [...]

Read More »
Dynamically Add or Remove input fields in PHP JQuery

AJAX, Java Script, JQuery, MySql, PHP, Tutorial

Dynamically Add or Remove input fields in PHP with JQuery

This post explains you about how to Dynamically Add or Remove input fields in PHP with JQuery. With ADD MORE button we are added input box and with REMOVE button, we delete it. All the input box represent to array called name. On click to submit button ajax request goes to addName.php here first of [...]

Read More »
Animated Ajax Record Deletion Using jQuery PHP

AJAX, JQuery, MySql, PHP, Tutorial

Animated Ajax Record Deletion Using jQuery PHP

This post explains you about how to create Animated Ajax Record Deletion Using jQuery PHP. In this post on the basis of random number we are using 2 type of animated effect.   Download Link   Demo Link   Sample database design for table name contact. This table contains  id (primary key),tutorial and link. CREATE TABLE IF [...]

Read More »
PHP Ajax Dynamic Tab

AJAX, JQuery, MySql, PHP, Tutorial

PHP Ajax Dynamic Tab

This post explains you about how to create PHP Ajax Dynamic Tab Script. For this you need jquery library and  jquery-ui-tab.js     Download Link   Demo Link   Sample database design for table name contact. This table contains id (primary key), name and age. CREATE TABLE IF NOT EXISTS `tab_cat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cat_name` varchar(250) [...]

Read More »
PHP Cookie Ajax Based Poll Script

AJAX, JQuery, MySql, PHP, Tutorial

PHP Cookie Ajax Based Poll Script

This post explains you about how to create PHP Cookie Ajax Based Poll Script. This script is a complete ajax poll script and it is based on next previous buttons.In this script if a user submit a poll, we saved create a cookie with the current poll, so he can’t poll again. Download Link   Demo [...]

Read More »
Live Username Availability Check with Ajax and PHP

AJAX, Java Script, JQuery, MySql, PHP, Tutorial

Live Username Availability Check with Ajax and PHP

This post explains you about how to implement Live Username Availability Check with Ajax and PHP and textbox background color change if you enter used username.     Download Link   Demo Link Sample database design for table name contact. This table contains id (primary key), name and age. CREATE TABLE IF NOT EXISTS `user` ( `id` [...]

Read More »
PHP Ajax Pagination Tutorial

AJAX, Java Script, JQuery, MySql, PHP, Tutorial

PHP Ajax Pagination Tutorial

This post explains you about how to implement PHP Ajax Pagination. It is better to have Ajax Pagination on Your Webpage as Ajax Pagination will load only the specific part rather than whole page, but at the same time it will affect your SEO.   Download Link   Demo Link   Sample database design for table name contact. This table contains id (primary [...]

Read More »
PHP Cookie Ajax Based Rating Script

AJAX, HTML, Java Script, JQuery, MySql, PHP, Tutorial

PHP Cookie Ajax Based Rating Script

This post explains you about how to implement php cookie ajax based rating script. Cookie is a small file that stores on the user’s computer.Cookies is a mechanism for storing data in the remote browser and thus tracking or identifying return users. In this script I am using cookie for user tracking.   Download Link   [...]

Read More »
How To Create Facebook App with PHP 2

MySql, PHP

How to Create Facebook Application Using PHP and Retrieve User Information

This post explains you about How to Create Facebook Application Using PHP and Retrieve User Information.   Download Link   Demo Link   So here are the simple steps to Create Facebook Application Using PHP and Retrieve User Information. Go to https://developers.facebook.com/apps Click to Create New App button Enter App Name and App Namespace, and leave web hosting checkbox Enter [...]

Read More »

Copyright © 91 Web Lessons - a digital blog