4:49 pm Sunday May 20 2012

About.com PHP / MySQL: Most Popular Articles

PHP Redirection

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

Limit the results of your MySQL query to results between a certain number range.



PHP Login Script

PHP code to create a login script - free code and tutorial to create a login script with PHP



Uploading Files with PHP

Upload a file from your browser to your server using PHP



Basic PHP Sessions

Once you have set a variable in a PHP session, this tutorial tells you how to retrieve it.



PHP from a .html File

This tutorial explains how to execute php code in a file with a .html extention



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.



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



Ordering MySQL Data

How to sort your MySQL data using a SQL Order By statement



Pagination of Results

Use Pagination to display results of your MySQL query over multiple pages in PHP



Using the MAIL function

Using the PHP MAIL function to send form data to an email from the web



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.



Learn PHP

Learn PHP programing free with our easy to understand online tutorials. Learn to make a website using PHP code online.



Form Mail

How to send an email from a form on a website to your email using PHP



Cookies and Sessions

What is the difference between sessions and cookies in PHP?



What is Binary?

What are binary numbers, and how do you read them



Print_r () PHP Function

Print_R is used to return an array in a human readable form in PHP



Drop Column

How to remove (drop) a column from a table using MySQL with your SQL database.



Hello, World!

Every language has it... the basic "Hello, World!" script. It is a simple script that only displays the



Change a Column Name

How to change the name of a column in a MySQL database



Comment Your PHP Code

How and why to comment your code in PHP



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.



Processing Froms with PHP

Collect data from HTML forms to process with a PHP script as shown in our tutorial



Create a Database in MySQL

How to create a new database in MySQL using SQL or phpmyadmin.



Simple PHP Calendar

Learn how to generate a simple PHP calendar using our PHP calendar tutorial - Learn PHP free



Upload and SQL

Upload a file from your website to your server, and write it's details to a MySQL database - Using PHP and SQL.



Alter Table

How to use the MySQL alter table command, and what to combine it with to do different things to your database.



MySQL Data

Update data in MySQL by using Update SQL command code as demonstrated in our tutorial



Add Column

How to add a column to MySQL using the add column SQL command



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.



Accessing File Data

How to open an external file with PHP and download its contents to use within your PHP file.



Backup & Restore MySQL

Restore and upload your MySQL data using the backup you made and downloaded from a command prompt



Write to a file

Using PHP to create a file on your server and write data to it



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.



Using Loops

Learn PHP from a simple web based tutorial. Learn to use the three types of loops - WHILE, FOR, and FOREACH loops in PHP programing.



PHP Version

Do you need to check what version of PHP your server is running? This simple tutorial shows you how.



Creating MySQL Tables

Create SQL database tables in MySQL using phpMyAdmin as shown in our tutorial



Create Links in PHP

How to create links in PHP



Forms to MySQL

Store user submitted upload files or form data in a MySQL database using our SQL Form tutorial.



Is_Numeric ()

The PHP function is_numeric is used to check if a variable is a number.



Template Your Site

Site templates for easy updating with include files headers and footers using PHP



Rand ()

Generating a random number in PHP with the rand () function, or generating a random number between two given parameters



Modify

Change the size of a MySQL column by using the Modify SQL command



Show Tables

The show tables SQL command is used to display all the tables in a MySQL database



Today's Date

An example of how to print the current date on a web page written in HTML using PHP



Renaming PHP Uploads

How to rename files uploaded by users before saving them to the server.



Using \$_SERVER in PHP

A free PHP tutorial explaining the difference between $_SERVER[’PHP_SELF’], $_SERVER[’SCRIPT_NAME’], and $_SERVER['REQUEST_URI']



PHP Information

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.



MySQL Connect from 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.



Install PHP on a Mac

How to install PHP onto your Mac OS X



Learn SQL (MySQL)

Just the basics you need to learn SQL code to use with your MySQL database. Free tutorial to learn MySQL.



Str_replace

Str_replace is used to find and replace parts of a string in PHP



GD Library Basics

You can use the GD Library in PHP to dynamically create images



Generate a Unique ID

PHP code to generate a random unique user ID



Repair MySQL Table

How to repair a MySQL table using phpMyAdmin if you are getting errors or having trouble accessing it.



MySQL Error Messages

How to report an error into PHP from MySQL when your SQL code has errors



10 Cool PHP Things

Ten cool things you can do with PHP on your website, as well as tutorials of how to create these things.



Change

The change SQL command can be used to change a detail about a column in MySQL such as it's name.



PHP file includes

Include external files into a PHP file using the include or require commands



Page Not Loading

Common solutions to PHP problems - PHP page not loading, showing a blank or white screen



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.



Session_start()

The session_start() function is used at the beginning of all PHP pages utilizing sessions.



PHP in MySQL

Store your PHP code in a MySQL database and call it when needed



Drop Database

The drop database command in SQL will remove a database from the MySQL server



Rounding and Formatting

How to format a number in PHP - Free simple tutorial to using the number_format () function



Simple Rating System

A script that allows you to give a 1-5 star ratings for things on your site



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



Describe

The describe SQL command shows a tables fields and their formats



Countdown Timer with mktime

Create a simple countdown clock ticker in PHP using the mktime function



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.



Session_destory ()

Session_destroy () is used to destroy all the data in a current session



Count

The SQL Count command is used to count the number of records held on a specific table in a MySQL database



Using crypt () for Encryption

Using the crypt function in PHP to encrypt passwords and other data and keep them safe



Using Notepad for PHP

How to use Notepad to create and save PHP files



What is PHP Used For?

What is PHP Used For? Answers to this new programmer question.



Address Book

Create an online address book using PHP



MySQL Login

Login to your mysql server from unix shell



Veiwing the Source

When you view source on your PHP files, why can't you see your code?



Introduction to Preg

Understanding the preg_replace function and how to use it on your PHP website



Text Editors

Text editors are useful tools for programers and web designers, we can tell you what a text editor is and how to use one.



Drop Table

Delete an entire table from a MySQL database using the drop table command



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



Show Databases

Using the show databases SQL command to show all the databases on the MySQL server



phpBB Templates

How to edit your phpBB template to have a custom look, or theme.



PHP Code Showing

How to troubleshoot the problem of PHP code showing instead of running on your website.



Session_unset ()

Session_unset() is used to clear all the variables in a session



Add Unique

Add a unique table column in MySQL to ensure you do not have any duplicates, but using 'Add Unique' in your SQL Code



PHP Upload Security

Allowing users to upload files to your website poses security risks. Here are some ideas to help protect yourself.



Time Math

More information about dealing with Time in PHP



Changing Column Size

How to change a column's size or type in MySQL



Instaling phpBB

How to install a phpBB web forum on your website - a tutorial for beginners



Copyright Dates

This script automatically updates the copyright date on your website every year so that you don't have to worry about it.



Is_string ()

The is_string php function is used to check if the value is a string. It will return true or false.



Learn MySQL

Learn MySQL from a simple web based tutorial. Learn and understand SQL code



Extracting the File Extension

How to extract the extension (.jpg), (.gif), (.png), etc from the file name. This is useful if you are renaming the file.



Backup phpBB

This tutorial shows you how to easily backup your phpbb forum, to restore your site if it should crash or be lost.



Database Connection Errors

Some common problems that can occur when trying to connect to a MySQL database, and give errors.



SQL Joins

Use a SQL Join to combine two or more tables data in MySQL



PHP Variable Reference

Everything you've ever wanted to know about PHP variables in an easy to understand, free tutorial.



Building Variables

How to build variables on the fly with PHP.



Creating Thumbnails with PHP

Use PHP and the GD Library to create thumbnails of images on the fly in gif, jpg or png format.



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 CHMOD from FTP

How the CHMOD a file to different permissions from your FTP program



fopen

Use fopen() to open up a file from php



Show Columns

The show columns command is used to display all the columns for a given table and their details.



Do I Have PHP?

How to determine if your hosting runs PHP



Formatting PHP

How to make your PHP pages pretty with formatting



File ()

The PHP Function File () pulls data from an outside file and puts it into an array to be included in the program as demonstrated in our tutorial.



Hit Counter

Free web page hit counter code for your website, for a simple free web site hit counter written in PHP.



Using TextEdit for PHP

How to use TextEdit to create and save PHP on your Apple Macintosh (Mac) Computer.



Feof () PHP Function

The FEOF PHP function is used to test for the end of the file.



Echo ()

Echo Function in PHP outputs (echos) the data to the page



PHP CSS Switcher

Allow your users to change CSS style on your site, using PHP and Cookies



Connect to MySQL from PHP

How to connect to your MySQL database from a PHP document



Stripslashes ()

Stripslashes is used to remove black slashes from data in php



MySQL_Close ()

How to close a MySQL Connection from a PHP file



Day of the Week

This script shows you how to find out what day of the week a specific date falls on by using PHP and the mktime function.



Pow ()

How to use exponents in PHP to raise a number to the power of another number.



Unset ()

Unset is used to destroy specified variables in PHP



PHP AI Bots

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.



Converting Images to Grayscale

Turn a color photo to black and white (grayscale, greyscale) using the GD Library and PHP



All About Arrays

Information about how to set up arrays in PHP programming.



Your First PHP Script

A very basic walkthrough of everything you need to make your first PHP script, in simple straight forward terms.



Print ()

The print function in php is used to output (print) data.



HTTP_REFERER

How to find a page's referrer using HTTP_REFERER in PHP.



Check Your PHP

How to troubleshoot and double check your PHP code for errors



Substr ()

How to use the Stbstr PHP Function to return part of a string in PHP



Getting started with PHP

An absolute beginner's guide to writing and understanding their first PHP program.



GoTo

How tutorial of how to use GoTo in PHP to skip over code.



Detect a User's IP Address

Record a user's IP address using this free PHP script.



Fgets ()

Fgets is a PHP function that gets data from an external file line by line.



Elseif ()

Elseif () is used in conditional statements to make choices.



PHP Cookies Help

Common problems you may encounter using PHP cookies on your site



Floor

Using FLOOR in SQL to round a number down when pulled from your MySQL database



Finding the Document Root

Often when installing scripts you need to know the document root. This simple script can give you that information.



Session_set_cookie_params ()

Session_set_cookie_params () is used to set the duration of a session cookie, as well as other optional cookie information



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.



Use

Use the USE Command in MySQL to switch databases



Installing phpBB Mods

Once you have installed phpBB, you may want to add in additional features to customize your board. These are called mods or addons, and are easy to install.



Rotate an Image

How to rotate an image using PHP with the GD Library



Counting Outbound Clicks

This tutorial demonstrates how to use php and mysql to count which sites have the most click throughs on your site.



Getenv ()

Free tutorial about how to use the getenv() command in PHP to get such things as the document root, or the user's IP address.



Mktime ()

Use the mktime function in PHP to get the timestamp for a specific date so you can create a countdown on your site.



Max ()

The Max () php function returns the largest number in an array or group of numbers



PHP and Flat File

How to use PHP commands to interact with flat file text (txt) documents.



PHP Math Functions

A list of commonly used math functions in PHP, and what they do.



PHP Hex Color Chart

This simple PHP script lets you generate a chart of hex (hexadecimal) colors for use in web design



Ceiling

Using CEIL or CEILING in SQL to round a number up when pulled from your MySQL database



File_Get_Contents ()

File_get_contents reads the data from a file and returns it to the PHP file as a string as demonstrated in our tutorial.



Eval ()

Eval () is used to evaluate its input string as PHP and then process it as such



Why Use PHP?

The top three reasons why to use PHP on your website.



Your Last Visit

How to make a PHP script that welcomes the user and tells them when they last visited.



How can I learn PHP

A guide to how to get started learning PHP



Abs () PHP Function

How to use the ABS () function in PHP to return the absolute value of a number



Cal_days_in_month ()

This PHP function tells you how many days are in a given month in a given year.



PHP Flat File Counter

This tutorial shows you step by step how to create a flat file counter (no database) using PHP



Fread ()

Fread is a php function used to read the contents of a file and report the data back to the php file as demonstrated with our tutorial.



Review of vBulletin

Review of the vBulletin message board system



Imagecreate ()

The imagecreate () function is used in PHP to create a new palette based image



What is FTP

FTP Clients are used to FTP into your site and transfer data to and from your site



Basic Regular Expressions

The three most simple regular expressions that you will use with PHP



phpMyAdmin

A basic overview of what you can do to your database with phpMyAdmin.



Coding with Quotes

Should you use single quotes or double quotes in your PHP code?



Calendars and Time

PHP functions and scripts related to the use and creation of calendars, or dates in PHP.



Random Numbers

How to generate a random number using PHP



Banner Rotation

Generate random banners advertising on your web site with PHP, or have random graphic rotation.



Boolean Logic

Boolean logic is a type of decision making utilized by computers to decide if a statement is true or false.



PHP Random Quote

This tutorial shows how to use switch () to display a random quote on your website - Free PHP Tutorial



Switch ()

The PHP switch () function is used in replace of multiple if or elseif statements.



fwrite ()

fwrite is a binary safe file write used to write to an external file from PHP



Select

The SQL select statement is used to choose what data to pull from the mysql database



Day Based Website Changes

How to use PHP to change the background color of your website based on the day of the week. This same concept than be applied to changing any website variables based on the day of the week.



Form to phpBB Forum

How to post from a form (or application) to a phpBB forum



Addslashes ()

How to used the PHP function addslashes to add slashes into form data



hypotenuse

How to calculate the Hypotenuse of a right triangle using PHP and the hypot function



Magic Quotes

Magic Quotes adds slashes in PHP to all data submitted via form and can be changed by setting magic_quotes_gpc on or off.



GD Library

Using the GD Library in PHP to create, resize, grayscale, rotate, draw, manipulate and edit images.



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.



Strtolower () PHP Function

How to change a string to all lower case letters using PHP