PHP / MySQL: Most Popular Articles
These articles are the most popular over the last month.
How To Redirect with PHP
Sample code for creating a PHP redirection script to transfer users from one web page URL on your site to a new page URL or web site
Sample code for creating a PHP redirection script to transfer users from one web page URL on your site to a new page URL or web site
Limit - MySQL Command
Limit the results of your MySQL query to results between a certain number range.
Limit the results of your MySQL query to results between a certain number range.
Ordering MySQL Data
How to sort your MySQL data using a SQL Order By statement
How to sort your MySQL data using a SQL Order By statement
PHP with HTML
How to embed php into HTML, or put HTML inside PHP so you can use both on the same page of your website.
How to embed php into HTML, or put HTML inside PHP so you can use both on the same page of your website.
PHP MySQL Tutorial
Run SQL commands from a PHP script, Connect to MySQL from PHP and retrieve data as shown in our PHP MySQL Tutorial
Run SQL commands from a PHP script, Connect to MySQL from PHP and retrieve data as shown in our PHP MySQL Tutorial
How to Change a Column Name in MySQL
How to change the name of a column in a MySQL database
How to change the name of a column in a MySQL database
Learn PHP
Learn PHP programing free with our easy to understand online tutorials. Learn to make a website using PHP code online.
Learn PHP programing free with our easy to understand online tutorials. Learn to make a website using PHP code online.
PHP Login Script
PHP code to create a login script - free code and tutorial to create a login script with PHP
PHP code to create a login script - free code and tutorial to create a login script with PHP
Basic PHP Sessions
Once you have set a variable in a PHP session, this tutorial tells you how to retrieve it.
Once you have set a variable in a PHP session, this tutorial tells you how to retrieve it.
What is Binary?
What are binary numbers, and how do you read them
What are binary numbers, and how do you read them
Execute PHP from a .html File
This tutorial explains how to execute php code in a file with a .html extention
This tutorial explains how to execute php code in a file with a .html extention
Create Links in PHP
How to create links in PHP
How to create links in PHP
Pagination of MySQL Query Results
Use Pagination to display results of your MySQL query over multiple pages in PHP
Use Pagination to display results of your MySQL query over multiple pages in PHP
What Version of PHP Am I Running?
Do you need to check what version of PHP your server is running? This simple tutorial shows you how.
Do you need to check what version of PHP your server is running? This simple tutorial shows you how.
Hello, World!
Every language has it... the basic "Hello, World!" script. It is a simple script that only displays the
Every language has it... the basic "Hello, World!" script. It is a simple script that only displays the
The Difference Between Cookies and Sessions
What is the difference between sessions and cookies in PHP?
What is the difference between sessions and cookies in PHP?
Uploading Files with PHP
Upload a file from your browser to your server using PHP
Upload a file from your browser to your server using PHP
Drop Column - MySQL Command
How to remove (drop) a column from a table using MySQL with your SQL database.
How to remove (drop) a column from a table using MySQL with your SQL database.
PHP Error Reporting
It is a lot easier to know what went wrong with your PHP script if you have a helpful error message instead of just a blank screen. This tutorial teaches you how to turn on error reporting.
It is a lot easier to know what went wrong with your PHP script if you have a helpful error message instead of just a blank screen. This tutorial teaches you how to turn on error reporting.
Simple Site Search
This free tutorial teaches you how to search your site using php and mysql to give the site users instant search results. PHP and SQL.
This free tutorial teaches you how to search your site using php and mysql to give the site users instant search results. PHP and SQL.
How and Why to Comment Your PHP Code
How and why to comment your code in PHP
How and why to comment your code in PHP
Simple PHP Calendar
Learn how to generate a simple PHP calendar using our PHP calendar tutorial - Learn PHP free
Learn how to generate a simple PHP calendar using our PHP calendar tutorial - Learn PHP free
Learn PHP - A Beginner's Guide to PHP Programing
Learn PHP from a simple web based tutorial. Explore basic PHP syntax, using variables, operators and operands, and the use of conditional statements.
Learn PHP from a simple web based tutorial. Explore basic PHP syntax, using variables, operators and operands, and the use of conditional statements.
Upload a File and write to MySQL
Upload a file from your website to your server, and write it's details to a MySQL database - Using PHP and SQL.
Upload a file from your website to your server, and write it's details to a MySQL database - Using PHP and SQL.
Print_r () PHP Function
Print_R is used to return an array in a human readable form in PHP
Print_R is used to return an array in a human readable form in PHP
Write to a file from PHP
Using PHP to create a file on your server and write data to it
Using PHP to create a file on your server and write data to it
Add Column - MySQL Command
How to add a column to MySQL using the add column SQL command
How to add a column to MySQL using the add column SQL command
MySQL Tutorial: Managing MySQL data
Update data in MySQL by using Update SQL command code as demonstrated in our tutorial
Update data in MySQL by using Update SQL command code as demonstrated in our tutorial
How To Template Your Site
Site templates for easy updating with include files headers and footers using PHP
Site templates for easy updating with include files headers and footers using PHP
Is_Numeric () PHP Function
The PHP function is_numeric is used to check if a variable is a number.
The PHP function is_numeric is used to check if a variable is a number.
Processing form data with PHP
Collect data from HTML forms to process with a PHP script as shown in our tutorial
Collect data from HTML forms to process with a PHP script as shown in our tutorial
Modify - MySQL Command
Change the size of a MySQL column by using the Modify SQL command
Change the size of a MySQL column by using the Modify SQL command
Using the MAIL function
Using the PHP MAIL function to send form data to an email from the web
Using the PHP MAIL function to send form data to an email from the web
MySQL Tutorial: Create SQL Tables
Create SQL database tables in MySQL using phpMyAdmin as shown in our tutorial
Create SQL database tables in MySQL using phpMyAdmin as shown in our tutorial
An Introduction to Loops in PHP
Learn PHP from a simple web based tutorial. Learn to use the three types of loops - WHILE, FOR, and FOREACH loops in PHP programing.
Learn PHP from a simple web based tutorial. Learn to use the three types of loops - WHILE, FOR, and FOREACH loops in PHP programing.
A Practical PHP Form to Mail
How to send an email from a form on a website to your email using PHP
How to send an email from a form on a website to your email using PHP
Learn PHP - All About PHP Functions
Learn PHP from a simple web based tutorial. How to use functions in PHP, use the date function, or write your own functions. Learn Date function formatting. Page 3.
Learn PHP from a simple web based tutorial. How to use functions in PHP, use the date function, or write your own functions. Learn Date function formatting. Page 3.
Show Tables SQL Command
The show tables SQL command is used to display all the tables in a MySQL database
The show tables SQL command is used to display all the tables in a MySQL database
Using Cookies with PHP
Cookies are used to store information about a user on their computer. We can set cookies using PHP to track visitors, as shown in our tutorial.
Cookies are used to store information about a user on their computer. We can set cookies using PHP to track visitors, as shown in our tutorial.
How To Create a Database in MySQL
How to create a new database in MySQL using SQL or phpmyadmin.
How to create a new database in MySQL using SQL or phpmyadmin.
Alter Table - MySQL Command
How to use the MySQL alter table command, and what to combine it with to do different things to your database.
How to use the MySQL alter table command, and what to combine it with to do different things to your database.
What is PHP Used For?
What is PHP Used For? Answers to this new programmer question.
What is PHP Used For? Answers to this new programmer question.
How to Install PHP on a Mac
How to install PHP onto your Mac OS X
How to install PHP onto your Mac OS X
Repairing a MySQL Database with phpMyAdmin
How to repair a MySQL table using phpMyAdmin if you are getting errors or having trouble accessing it.
How to repair a MySQL table using phpMyAdmin if you are getting errors or having trouble accessing it.
MySQL Connect Files in PHP
When you have many pages requiring access to your MySQL database, it is a good idea to keep your connection login in a separate file, and call it from each of these PHP pages.
When you have many pages requiring access to your MySQL database, it is a good idea to keep your connection login in a separate file, and call it from each of these PHP pages.
Backup and Restore MySQL Databases
Restore and upload your MySQL data using the backup you made and downloaded from a command prompt
Restore and upload your MySQL data using the backup you made and downloaded from a command prompt
Today's Date using PHP
An example of how to print the current date on a web page written in HTML using PHP
An example of how to print the current date on a web page written in HTML using PHP
Getting More Information From PHP
Use phpinfo to learn more about the version of PHP your server is running. PHPinfo command cans show you your PHP version, path, and specific settings.
Use phpinfo to learn more about the version of PHP your server is running. PHPinfo command cans show you your PHP version, path, and specific settings.
10 Cool Things To Do With PHP
Ten cool things you can do with PHP on your website, as well as tutorials of how to create these things.
Ten cool things you can do with PHP on your website, as well as tutorials of how to create these things.
Renaming PHP Uploads
How to rename files uploaded by users before saving them to the server.
How to rename files uploaded by users before saving them to the server.
Learn SQL (MySQL)
Just the basics you need to learn SQL code to use with your MySQL database. Free tutorial to learn MySQL.
Just the basics you need to learn SQL code to use with your MySQL database. Free tutorial to learn MySQL.
Using Notepad for PHP
How to use Notepad to create and save PHP files
How to use Notepad to create and save PHP files
My page has loaded all white, what did I do...
Common solutions to PHP problems - PHP page not loading, showing a blank or white screen
Common solutions to PHP problems - PHP page not loading, showing a blank or white screen
Storing User Submitted Data and Files in MySQL
Store user submitted upload files or form data in a MySQL database using our SQL Form tutorial.
Store user submitted upload files or form data in a MySQL database using our SQL Form tutorial.
How can report MySQL errors into PHP?
How to report an error into PHP from MySQL when your SQL code has errors
How to report an error into PHP from MySQL when your SQL code has errors
Str_replace () PHP Function
Str_replace is used to find and replace parts of a string in PHP
Str_replace is used to find and replace parts of a string in PHP
Using \$_SERVER in PHP
A free PHP tutorial explaining the difference between $_SERVER[’PHP_SELF’], $_SERVER[’SCRIPT_NAME’], and $_SERVER['REQUEST_URI']
A free PHP tutorial explaining the difference between $_SERVER[’PHP_SELF’], $_SERVER[’SCRIPT_NAME’], and $_SERVER['REQUEST_URI']
Read & Return Data From Files Into PHP
How to open an external file with PHP and download its contents to use within your PHP file.
How to open an external file with PHP and download its contents to use within your PHP file.
How To use mktime to create a countdown
Create a simple countdown clock ticker in PHP using the mktime function
Create a simple countdown clock ticker in PHP using the mktime function
GD Library - The Basics of Drawing with PHP
You can use the GD Library in PHP to dynamically create images
You can use the GD Library in PHP to dynamically create images
What Is My IP?
This is a very short easy to understand tutorial about how do create a 'What is my IP' style script, to look up the users IP address as they visit the site
This is a very short easy to understand tutorial about how do create a 'What is my IP' style script, to look up the users IP address as they visit the site
What are PHP and MySQL
This site explains what PHP and MySQL are as well as how to use them and how they can work together to create dynamic content for websites.
This site explains what PHP and MySQL are as well as how to use them and how they can work together to create dynamic content for websites.
Change MySQL Command
The change SQL command can be used to change a detail about a column in MySQL such as it's name.
The change SQL command can be used to change a detail about a column in MySQL such as it's name.
A Quick PHP Variable Reference
Everything you've ever wanted to know about PHP variables in an easy to understand, free tutorial.
Everything you've ever wanted to know about PHP variables in an easy to understand, free tutorial.
Including External Files in PHP
Include external files into a PHP file using the include or require commands
Include external files into a PHP file using the include or require commands
Session_start() PHP Function
The session_start() function is used at the beginning of all PHP pages utilizing sessions.
The session_start() function is used at the beginning of all PHP pages utilizing sessions.
Store PHP Code in a MySQL Database
Store your PHP code in a MySQL database and call it when needed
Store your PHP code in a MySQL database and call it when needed
How do I pass variables in the URL in PHP 5?
If you pass variables in the URL in PHP 4, the same scripts might not work in PHP 5 without some editing. Here is how to fix it.
If you pass variables in the URL in PHP 4, the same scripts might not work in PHP 5 without some editing. Here is how to fix it.
How To Generate a Unique ID
PHP code to generate a random unique user ID
PHP code to generate a random unique user ID
Describe SQL Command
The describe SQL command shows a tables fields and their formats
The describe SQL command shows a tables fields and their formats
Rand () PHP Function
Generating a random number in PHP with the rand () function, or generating a random number between two given parameters
Generating a random number in PHP with the rand () function, or generating a random number between two given parameters
Do I Have PHP?
How to determine if your hosting runs PHP
How to determine if your hosting runs PHP
Customizing phpBB's template
How to edit your phpBB template to have a custom look, or theme.
How to edit your phpBB template to have a custom look, or theme.
Learn PHP in 8 Weeks
In just a few minutes ever week, you can learn all the basics of PHP. This course is broken down into eight short lessons. In just eight weeks you will have a firm grasp of all the basic PHP concepts.
In just a few minutes ever week, you can learn all the basics of PHP. This course is broken down into eight short lessons. In just eight weeks you will have a firm grasp of all the basic PHP concepts.
Check Your PHP
How to troubleshoot and double check your PHP code for errors
How to troubleshoot and double check your PHP code for errors
Drop Database SQL Command
The drop database command in SQL will remove a database from the MySQL server
The drop database command in SQL will remove a database from the MySQL server
Introduction to Preg in PHP
Understanding the preg_replace function and how to use it on your PHP website
Understanding the preg_replace function and how to use it on your PHP website
How to change a column's size or type in MySQL
How to change a column's size or type in MySQL
How to change a column's size or type in MySQL
Create a Link from a Database
How to retrieve a URL and text from a database and create a link on your website using PHP.
How to retrieve a URL and text from a database and create a link on your website using PHP.
Show Databases SQL Command
Using the show databases SQL command to show all the databases on the MySQL server
Using the show databases SQL command to show all the databases on the MySQL server
Why Don't I See My Code When I View Source?
When you view source on your PHP files, why can't you see your code?
When you view source on your PHP files, why can't you see your code?
Getting started with PHP
An absolute beginner's guide to writing and understanding their first PHP program.
An absolute beginner's guide to writing and understanding their first PHP program.
Session_destroy () PHP Function
Session_destroy () is used to destroy all the data in a current session
Session_destroy () is used to destroy all the data in a current session
Count - MySQL Command
The SQL Count command is used to count the number of records held on a specific table in a MySQL database
The SQL Count command is used to count the number of records held on a specific table in a MySQL database
Automatic Copyright Dates
This script automatically updates the copyright date on your website every year so that you don't have to worry about it.
This script automatically updates the copyright date on your website every year so that you don't have to worry about it.
Web Page Hit Counter
Free web page hit counter code for your website, for a simple free web site hit counter written in PHP.
Free web page hit counter code for your website, for a simple free web site hit counter written in PHP.
PHP Code Showing Instead of Running
How to troubleshoot the problem of PHP code showing instead of running on your website.
How to troubleshoot the problem of PHP code showing instead of running on your website.
Add Unique - MySQL Command
Add a unique table column in MySQL to ensure you do not have any duplicates, but using 'Add Unique' in your SQL Code
Add a unique table column in MySQL to ensure you do not have any duplicates, but using 'Add Unique' in your SQL Code
Why Use PHP?
The top three reasons why to use PHP on your website.
The top three reasons why to use PHP on your website.
Installing MySQL on a Mac
How to install MySQL on your Apple computer
How to install MySQL on your Apple computer
Is_string () PHP Function
The is_string php function is used to check if the value is a string. It will return true or false.
The is_string php function is used to check if the value is a string. It will return true or false.
How Can I Fix A Database Connection Error?
Some common problems that can occur when trying to connect to a MySQL database, and give errors.
Some common problems that can occur when trying to connect to a MySQL database, and give errors.
Formatting Your PHP
How to make your PHP pages pretty with formatting
How to make your PHP pages pretty with formatting
A Simple Rating System in PHP
A script that allows you to give a 1-5 star ratings for things on your site
A script that allows you to give a 1-5 star ratings for things on your site
Rounding and Formatting Numbers
How to format a number in PHP - Free simple tutorial to using the number_format () function
How to format a number in PHP - Free simple tutorial to using the number_format () function
How To CHMOD from FTP
How the CHMOD a file to different permissions from your FTP program
How the CHMOD a file to different permissions from your FTP program
Using TextEdit for PHP
How to use TextEdit to create and save PHP on your Apple Macintosh (Mac) Computer.
How to use TextEdit to create and save PHP on your Apple Macintosh (Mac) Computer.
Using crypt () for Data Encryption
Using the crypt function in PHP to encrypt passwords and other data and keep them safe
Using the crypt function in PHP to encrypt passwords and other data and keep them safe
Select - MySQL Command
The SQL select statement is used to choose what data to pull from the mysql database
The SQL select statement is used to choose what data to pull from the mysql database
Simple PHP & MySQL Poll
This tutorial explains how to make a basic poll using PHP and MySQL, along with the GD Library to give a pie chart of the poll results.
This tutorial explains how to make a basic poll using PHP and MySQL, along with the GD Library to give a pie chart of the poll results.
Creating Thumbnails with PHP using the GD Library
Use PHP and the GD Library to create thumbnails of images on the fly in gif, jpg or png format.
Use PHP and the GD Library to create thumbnails of images on the fly in gif, jpg or png format.
How to Install phpBB on Your Website
How to install a phpBB web forum on your website - a tutorial for beginners
How to install a phpBB web forum on your website - a tutorial for beginners
The Mathematics of Time in PHP
More information about dealing with Time in PHP
More information about dealing with Time in PHP
Free PHP Script Directories
A listing of Free PHP Scripts and websites that provide them
A listing of Free PHP Scripts and websites that provide them
fopen () PHP Function
Use fopen() to open up a file from php
Use fopen() to open up a file from php
PHP File Upload Security Ideas
Allowing users to upload files to your website poses security risks. Here are some ideas to help protect yourself.
Allowing users to upload files to your website poses security risks. Here are some ideas to help protect yourself.
Substr () PHP Function
How to use the Stbstr PHP Function to return part of a string in PHP
How to use the Stbstr PHP Function to return part of a string in PHP
Understanding how SQL databases work
Learn MySQL from a simple web based tutorial. Learn and understand SQL code
Learn MySQL from a simple web based tutorial. Learn and understand SQL code
PHP CSS Switcher
Allow your users to change CSS style on your site, using PHP and Cookies
Allow your users to change CSS style on your site, using PHP and Cookies
Localhost doesn't work to connect to your MySQL...
How to troubleshoot localhost not working to connect to your mysql database via PHP.
How to troubleshoot localhost not working to connect to your mysql database via PHP.
What is a Plain Text Editor?
Text editors are useful tools for programers and web designers, we can tell you what a text editor is and how to use one.
Text editors are useful tools for programers and web designers, we can tell you what a text editor is and how to use one.
Session_unset () PHP Function
Session_unset() is used to clear all the variables in a session
Session_unset() is used to clear all the variables in a session
How can I learn PHP?
A guide to how to get started learning PHP
A guide to how to get started learning PHP
Connect to MySQL from PHP
How to connect to your MySQL database from a PHP document
How to connect to your MySQL database from a PHP document
Date & Time in PHP
How to create and format a timestamp in PHP for a current, past or future date.
How to create and format a timestamp in PHP for a current, past or future date.
Using SQL Joins
Use a SQL Join to combine two or more tables data in MySQL
Use a SQL Join to combine two or more tables data in MySQL
Integer
Integer is a mathematical term to define the set of whole numbers both positive and negative, as well as 0
Integer is a mathematical term to define the set of whole numbers both positive and negative, as well as 0
Building Variables In PHP
How to build variables on the fly with PHP.
How to build variables on the fly with PHP.
Show Columns - MySQL Command
The show columns command is used to display all the columns for a given table and their details.
The show columns command is used to display all the columns for a given table and their details.
Simple Address Book
Create an online address book using PHP
Create an online address book using PHP
Drop Table MySQL Command
Delete an entire table from a MySQL database using the drop table command
Delete an entire table from a MySQL database using the drop table command
Login to your MySQL Server from UNIX Shell
Login to your mysql server from unix shell
Login to your mysql server from unix shell
MySQL Quick Start Guide
Get a head start on learning MySQL before school starts!
Get a head start on learning MySQL before school starts!
Counting Outbound Clicks
This tutorial demonstrates how to use php and mysql to count which sites have the most click throughs on your site.
This tutorial demonstrates how to use php and mysql to count which sites have the most click throughs on your site.
PHP Flat File Counter
This tutorial shows you step by step how to create a flat file counter (no database) using PHP
This tutorial shows you step by step how to create a flat file counter (no database) using PHP
Random Numbers
How to generate a random number using PHP
How to generate a random number using PHP
Server Side Scripting
Server side scripting means that all of the code is executed on the server before the data is passed to the user's browser.
Server side scripting means that all of the code is executed on the server before the data is passed to the user's browser.
Feof PHP Function
The FEOF PHP function is used to test for the end of the file.
The FEOF PHP function is used to test for the end of the file.
Echo () PHP Function
Echo Function in PHP outputs (echos) the data to the page
Echo Function in PHP outputs (echos) the data to the page
Print () PHP Function
The print function in php is used to output (print) data.
The print function in php is used to output (print) data.
Finding the Document Root
Often when installing scripts you need to know the document root. This simple script can give you that information.
Often when installing scripts you need to know the document root. This simple script can give you that information.
Understanding Arrays in PHP
Understanding arrays in PHP and how we use them.
Understanding arrays in PHP and how we use them.
Stripslashes () PHP Function
Stripslashes is used to remove black slashes from data in php
Stripslashes is used to remove black slashes from data in php
Simple Banner Rotation
Generate random banners advertising on your web site with PHP, or have random graphic rotation.
Generate random banners advertising on your web site with PHP, or have random graphic rotation.
Calculating Area with PHP
How to create a PHP program to collect the length and width from the user and then calculate the area of the rectangle. A free PHP Tutorial.
How to create a PHP program to collect the length and width from the user and then calculate the area of the rectangle. A free PHP Tutorial.
Installing PHP on Linux
How to install Apache and PHP on your Linux computer
How to install Apache and PHP on your Linux computer
How to define an array in PHP
How to create an array in PHP
How to create an array in PHP
PHP Random Quote
This tutorial shows how to use switch () to display a random quote on your website - Free PHP Tutorial
This tutorial shows how to use switch () to display a random quote on your website - Free PHP Tutorial
Artificial Intelligence with PHP
Artificial intelligence is a responsive form of programing designed to simulate a human response. These sites give us more insight on how to do it with PHP.
Artificial intelligence is a responsive form of programing designed to simulate a human response. These sites give us more insight on how to do it with PHP.
What to do when your WordPress permalinks show...
I setup custom URLs (permalinks) for my WordPress blog (such as /date/day/title) and now all my pages are broken or showing as 404 errors, how can I fix it?
I setup custom URLs (permalinks) for my WordPress blog (such as /date/day/title) and now all my pages are broken or showing as 404 errors, how can I fix it?
Your PHP code can't be viewed by viewing the...
You can't see PHP code when you view a document source, you only see the HTML it outputs.
You can't see PHP code when you view a document source, you only see the HTML it outputs.
What is File Transfer Protocol (FTP)
FTP Clients are used to FTP into your site and transfer data to and from your site
FTP Clients are used to FTP into your site and transfer data to and from your site
Why aren't my cookies working?
Common problems you may encounter using PHP cookies on your site
Common problems you may encounter using PHP cookies on your site
Detect a User's IP Address
Record a user's IP address using this free PHP script.
Record a user's IP address using this free PHP script.
How To Check Your PHP Version
Hot to check your PHP Version
Hot to check your PHP Version
Converting Images to Grayscale using PHP and...
Turn a color photo to black and white (grayscale, greyscale) using the GD Library and PHP
Turn a color photo to black and white (grayscale, greyscale) using the GD Library and PHP
Your First PHP Script
A very basic walkthrough of everything you need to make your first PHP script, in simple straight forward terms.
A very basic walkthrough of everything you need to make your first PHP script, in simple straight forward terms.
Imagecreate () PHP Function
The imagecreate () function is used in PHP to create a new palette based image
The imagecreate () function is used in PHP to create a new palette based image
MySQL_Close () PHP Function
How to close a MySQL Connection from a PHP file
How to close a MySQL Connection from a PHP file
Software Development Stages
If you plan to release your scripts to the public, they usually go through several stages before they final release.
If you plan to release your scripts to the public, they usually go through several stages before they final release.