PHP / MySQL Programming

PHP is a versatile computer programming language that integrates efficiently with websites to create complex and powerful applications. A chat room is one example of online software that PHP can...

The contents of a file can be place sent in an email by using the "fread" and "mail" functions. The "fread" function is used to place the contents of the file into a variable. The file must be...

The UNIX Timestamp is the time in seconds between January 1, 1970, and any date. The PHP "strtotime" function can be used to convert a date specified as a string into the UNIX Timestamp for that...

The PHP "explode" function allows you to separate the data and the delimiter in a delimited file such as a Comma Separated Value (CSV) file. The "explode" function takes two parameters, the...

The "fread" function can be used to read the text inside a file. The text can then be placed in a variable that can be printed to the screen or be used by other PHP functions. The file must first...

The PHP unlink function is used to delete files. The function is called "unlink" because when a file is deleted, it is essentially unlinked from the file system. The unlink function only takes...

SQL, or Structured Query Language, is an industry-standard computer language used in conjunction with relational database management systems (RDBMS). It is used to manipulate and query data in a...

How to Bridge Joomla and PHPBB for Dual login purposes. How Registration and login to forum/site is Aquired

MySQL is a relational database that is available for all operating systems. It is often used in conjunction with web servers to create dynamic web pages. When a database administrator creates a...

One of the most powerful features of Perl is its ability to process, parse, manipulate and format text and data, making it an ideal language for developing database applications. The Perl Database...

There are few ways to check your PHP website. 1. Either on Localhost 2. Directly on webhosting. Getting webhosting and trying it everytime is wastage of money if your website will take time.Thus...

The .PHP file extension is used in the PHP (Hypertext Preprocessor) programming language for developing PHP-based Web applications and websites. Many modern websites use PHP to drive their services.

MySQL Injection is act of inserting MySQL statement into a database without the knowledge of the owner of the database. It is generally done by exploiting user input fields that are not protected...

MySQL is a free open source relational database management system (RDBMS). Setting up and installing MySQL on Windows can be a challenging task for a first-time user; however, the possibilities...

Creating a login form for your website can be done several ways, but there are two basic concepts, each preferable for achieving certain goals. The first method is through an .htaccess file. This...

PHP, a server-side programming language, is one of the most complicated ingredients to use when creating a powerful, dynamic website. It's difficult to learn and even harder to master, which means...

Structured Query Language is a database language that retrieves information from databases and displays it to the user. Its replace keyword function can search a string for one or several...

A PHP file is a text document containing a specific code that is ran and executed by a program called an interpreter. These programs can have a very wide variety of purposes. PHP (PHP: Hypertext...

Web developers and those who use VMWare server need to have IIS installed on their computers in order to develop ASP, PHP web pages or to utilize VMWare Server. Here is how to easily install IIS...

Many people who know some basic html are deterred from the idea of a header because that requires PHP and the whole thing just seems infinitely complicated. Well, guess what? It's not! In fact,...

I have recently faced an issue in the query editor in SQL Developer. I opened up my session and found that both the backspace and the delete keys were not responding in the query editor. This is a...

Using Google Maps or other online sites to get the distance between two points will work for most everyday situations, but if you have to calculate the distances of multiple (sometimes thousands)...

Using the timestamp in SQL is an easy way to store the current date and time, however some instances, having the time as part of the data will give you unwanted results. This is how to remove the...

The JOIN statement in MySQL is used to combine data from two or more tables into a common set. The tables are combined through a common column in each table. The columns do not have to have the...

The MySQL "Count" function allows you to find the number of rows that meet a certain criteria within a "Select" statement without returning the data within those rows. The "Count" function can be...

Combining the open source MySQL database, PHP scripting language and Apache Web Server allows you to create dynamic web sites for free. This software application is the basis for the popular LAMP...

A foreign key is a column in one table that points to the primary key column of another table. Using a foreign key ensures that the integrity of the data across tables is maintained as the values...

The MySQL reference manual separates commands into "administrative commands" and "statements." The administrative commands are ones that the MySQL client interprets. Statements are commands...

MySQL provides asynchronous replication in which a master database server is replicated to one or more slave server. You can configure the replication to include all or select databases or only...

Subqueries are queries nested within another query. Subqueries allow you to separate each part of the statement and provide a more readable alternative to performing operations that would require...

MySQL is a relational database system that organizes data into tables. Once you create your MySQL database, there are advanced functions and techniques you can utilize to make your queries run...

The MySQL SUM() statement is an aggregate or group function that operates on a set of values. The SUM() statement only works on numeric values and totals a specific column in a group. It can...

Like an index in a book, a MySQL index allows you to find data more efficiently. The index only contains the fields you are interested in sorting on, rather than the entire record. All data...

You can use PHP to send queries to a MySQL database. PHP must be configured to use the MySQL client libraries during the installation process. If your web servers support PHP, it most likely has...

Typing SQL statements at the MySQL prompt is time-consuming and error-prone. If you have a long sequence of statements, or statements that you execute on a regular basis, it is better to create a...

Two of the most common administration tasks for the MySQL server are creating and managing user accounts and monitoring system logs. User accounts are assigned from within the MySQL server and...

MySQL provides permissions (privileges) based on the level of operation of the user. Administrative privileges manage the operation of the server. Database privileges are specific to the...

MySQL is an open source database. SQL, or Structured Query Language, is the language used to create, query and manipulate MySQL databases. The server-side scripting language, PHP, in conjunction...

MySQL uses the "INSERT" and "LOAD DATA" statements to insert records into a database table. The "INSERT" statement loads one record at a time, while the "LOAD DATA" statement imports data from...

When you first start the MySQL server, you must create a blank database and fill it with tables. Before setting up the database and the tables, you should know how you want to structure your...

MySQL is an enterprise-ready, open source database used by individual web developers as well as companies such as Yahoo!, Google and YouTube. It is the database portion of the LAMP (Linux,...

MySQL and PHP are part of the LAMP (Linux, Apache, MySQL, PHP) software stack. Combining PHP and MySQL allows you to create dynamic web pages and store user data such as login information or...

A hit counter is a script that counts the number of times a web page has been accessed. This allows both the owner of the page and visitors to know how popular the page is. A simple hit counter...

So you've made your SQL Server backup and now something has happened and you need to restore your backup. This tutorial walks through using the Microsoft SQL Server Management Studio interface to...

SQL Server 2005 makes it easy to backup your databases. This article discusses using the user interface provided by Microsoft SQL Server Management Studio to do a one-time backup of a SQL Server...

If you are going to develop a website then you will more than likely have a "contact us" page. One part of your "contact us" page will more than likely require a form where...

PEAR (PHP Extension and Application Repository) provides a structured library of open-source code for PHP. It also provides a system for package maintenance and code distribution. The...

Arrays are an important part of every programming language and PHP is no different. They allow you to store multiple values into a single variable. This is accomplished by being able to index...

PHP, as with all other programming languages has a function where you can obtain the length of a string. This comes in handy when you are validating data such as making sure a user has entered...

We here the term all the time called "cookie". In reference to the web a "cookie" is when a website stores information on a person's computer to be used at a later time. That...