PHP / MySQL Programming

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...

PHP is a web server programming language used to create dynamic web pages. This language can read user input, SQL databases and individual server files. Determining the file types of user inputted...

PHP is a programming language used for designing dynamic Web pages. It is a server-run language that creates an HTML-based page viewed in the Web browser. It is often used to access SQL databases...

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...

To prevent your Web page from refusing to load due to a file error, you should code some verification to see if a file exists in the first place. The PHP library has a function called...

This article will demonstrate a full table select, column specific full table select, and column specific filtered table select. It will also show simply how you can expect a most Database...

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...

Typically SQL is used to write queries to select specific data from a database, yet SQL is a versatile programming language featuring iteration, variables and arithmetic operations. SQL, in fact,...

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...

WampServer is a free utility that allows you to run Apache, PHP, and MySQL on Microsoft Windows. This article demonstrates how to download, install, and configure WampServer on a Windows PC that...

While the Notepad program that comes installed with Windows Vista can open many PHP files for in-line editing, a free application called Notepad2 adds flexibility and compatibility. Notepad2 also...

A PHP calendar is very easy to set up in just a few minutes. Use the calendar on your website to display the current month and date. You can also scroll through previous and coming months. With 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.

Log-in pages are used in websites as initial screens to get access to confidential information. Log-in pages require at minimum a username and password. Sometimes you are allowed to select an...

Writing a file in PHP usually involves writing a text file. What the text file is used for is up to the developer. Most text files that are created by PHP contain configuration information for...

If you want your website to keep track of data such as user profiles, purchasing transactions, or other information worth storing, you need to add a database. This article shows the easiest way...

Whether you are going to create a whole website dedicated to classified ads or just add a classified ad section to an existing site, the process is the same. You will either need to write a...

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...

There are many reasons that you may need an page that lets people upload to your site. Whether it is for creating a business database, creating your own social networking site, photos and...

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...

The PHP programming language comes with the functionality to change or add extensions to the language. Developers primarily look to changing or writing extensions in order to increase the speed of...

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...

I am a php programmer and one of the functions that i use the most is var_dump. This will help you to output the contents and information of any variable in your php script. I have found it to be...

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...