Category: My SQL

What is PHP? PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML. The best way we learn anything is by practice and exercise questions. We have started this section for those (beginner to intermediate) who are…

Description PHP has a number of functions for handling as well as reporting errors. Besides, you can define your own way of handling and reporting errors. In this and subsequent pages we are going to discuss installation, runtime configuration, predefined constants and functions relating to PHP error handling and reporting. Installation and configuration In PHP…

What is a cookie Cookies are used to store the information of a web page in a remote browser, so that when the same user comes back to that page, that information can be retrieved from the browser itself. In this tutorial, we will discuss how to use Cookies in PHP. We have several examples…

Description In this page, we will discuss how file uploading is performed using PHP. For uploading files using PHP, we need to perform following tasks – 1. Set up an html page with a form using which we will upload the file.2. Setup a PHP script to upload the file to the server as well…

Description The mail() function is used to send a mail. Version: (PHP 4 and above) Syntax:mail(to, subject, message, extra headers, additional parameters) Parameter: Name Description Required /Optional Type to Mail address to which you want to send mail  Required String subject Subject of the mail  Required String message Message to be sent with the mail.…

Learn and practice PHP Array Functions Learn and practice PHP Calendar Functions Learn and practice PHP Date and Time Functions Learn and practice PHP Directory Functions Learn and practice PHP FTP Functions Learn and practice PHP Math Functions Learn and practice PHP String Functions Learn and practice PHP Variable Handling PHP MySQLi Functions tutorials

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…