PHP / MySQL Programming

A typical web application facilitates business owners to engage with stakeholders in sharing important data and information. In other words be it employees, business partners, suppliers, investors...

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

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

This article will teach you the basics of using SQL Server's INSERT INTO command. Once you've got the syntax down it is really quite easy!

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