Author: admin

Description This tutorial discusses PHP form handling/processing. You will learn how to collect user-supplied form data using POST and GET method from various from controls like text, select, radio, checkbox and textarea. This tutorial helps you a lot for learning Form Validation. Typical structure of an HTML form Typical structure of an HTML form intended to…

Introduction Due to its simplicity and ease of use, PHP is a widely-used open source general-purpose scripting language. PHP is used for creating interactive and dynamic web pages quickly and can access a wide range of relational database management systems such as MySQL, PostgreSQL, and SQLite. Many of us already access MySQL databases by using…

Backup and Restore In this page, we are going to discuss how to take backups of MySQL databases and restoring them. Take backup by copying table files You can simple copy the table files of a MySQL database to a separate location and accomplish a backup. Later, when necessary, you simply copy them back to the original location to…

Installing and Configuring Import and export data between MySQL and Excel has become much easier in Excel 2007 than it’s previous versions. To explore the feature, you need to install MySQL For Excel. You can install the MySQL For Excel component while installing MySQL Community Server 6. Or you may install it as an add-on upon…

DROP TABLE In MySQL, DROP TABLE command removes one or more tables from an existing database. The user who is using the DROP command, must have DROP privilege for each table(s) he wants to drop. The command removes all the data and table definition from the database. Syntax:DROP [TEMPORARY] TABLE [IF EXISTS] table_name [, table_name]…

SHOW COMMANDS There are various forms of MySQL SHOW commands, which provides information about databases, tables, columns, or status information about the commands. See the following section: Version: MySQL 5.6 Table of contents MySQL SHOW RELAYLOG EVENTS MySQL SHOW BINARY LOGS MySQL SHOW ERRORS MySQL SHOW SLAVE HOSTS MySQL SHOW BINLOG EVENTS MySQL SHOW EVENTS…

Security Database security entails allowing or disallowing user actions on the database and the objects within it. When you will create an database application, the security policy is the first step. An application security policy is a list of application security requirements and rules that regulate user access to database objects. This chapter discusses aspects…

Views View is a data object which does not contain any data. Contents of the view are the resultant of a base table. They are operated just like base table but they don’t contain any data of their own. The difference between a view and a table is that views are definitions built on top…

Introduction on Transaction A transaction is a logical unit of work that contains one or more SQL statements. Transactions are atomic units of work that can be committed or rolled back. When a transaction makes multiple changes to the database, either all the changes succeed when the transaction is committed, or all the changes are undone when…

Introduction on Triggers A trigger is a set of actions that are run automatically when a specified change operation (SQL INSERT, UPDATE, or DELETE statement) is performed on a specified table. Triggers are useful for tasks such as enforcing business rules, validating input data, and keeping an audit trail. Contents: Uses for triggers: Benefits of…