PHP / MySQL: Most Popular Articles
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
Ten cool things you can do with PHP on your website, as well as tutorials of how to create these things.
Limit the results of your MySQL query to results between a certain number range.
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 access stored data from a MySQL database using PHP
PHP code to create a login script - free code and tutorial to create a login script with PHP
Do you need to check what version of PHP your server is running? This simple tutorial shows you how.
How to change the name of a column in a MySQL database
Sometimes when you have a really long, unfriendly URL you want something shorter and easier to remember. We show you how to do this using a PHP redirect.
How to sort your MySQL data using a SQL Order By statement
What is the difference between sessions and cookies in PHP?
Once you have set a variable in a PHP session, this tutorial tells you how to retrieve it.
Creating a link with PHP uses the same code as it dose in HTML, depending on where we are getting our information, and where in our file it is.
Learn PHP programing free with our easy to understand online tutorials. Learn to make a website using PHP code online.
How and why to comment your code in PHP
This tutorial explains how to execute php code in a file with a .html extention
Upload a file from your browser to your server using PHP in this step-by-step tutorial.
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.
Print_R is used to return an array in a human readable form in PHP
How to insert data from a form into a MySQL database using PHP
$_SERVER['HTTP_USER_AGENT'] is used to retrieve information about the users browser and computer operating system, using PHP. Learn how with our tutorial.
How to write a. PHP / MySQL.
Learn PHP from a simple web based tutorial. Learn to use the three types of loops - WHILE, FOR, and FOREACH loops in PHP programing. Page 3.
Use Pagination to display results of your MySQL query over multiple pages in PHP
What are binary numbers, and how do you read them
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. Page 3.
Upload a file from your website to your server, and write it's details to a MySQL database - Using PHP and SQL.
Learn PHP from a simple web based tutorial. Explore basic PHP syntax, using variables, operators and operands, and the use of conditional statements.
How to remove (drop) a column from a table using MySQL with your SQL database.
Learn how to generate a simple PHP calendar using our PHP calendar tutorial.
The PHP function is_numeric is used to check if a variable is a number.
A free PHP tutorial explaining the difference between $_SERVER[PHP_SELF], $_SERVER[SCRIPT_NAME], and $_SERVER['REQUEST_URI']
How to create a MySQL database table using phpMyAdmin
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.
How to repair a MySQL table using phpMyAdmin if you are getting errors or having trouble accessing it.
The show tables SQL command is used to display all the tables in a MySQL database
Common solutions to PHP problems - PHP page not loading, showing a blank or white screen
Restore and upload your MySQL data using the backup you made and downloaded from a command prompt
How to use Notepad to create and save PHP files
Using PHP to create a file on your server and write data to it
What is PHP Used For? Answers to this new programmer question.
Site templates for easy updating with include files headers and footers using PHP
Collect data from HTML forms to process with a PHP script as shown in our tutorial
How to rename files uploaded by users to your website before saving them to your server.
Understanding the preg_match PHP function and how to use it on your PHP website. Page 2.
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.
Everything you've ever wanted to know about PHP variables in an easy to understand, free tutorial.
Using the PHP MAIL function to send form data to an email from the web.
How to install PHP onto your Mac OS X
How to add a column to MySQL using the add column SQL command
Just the basics you need to learn SQL code to use with your MySQL database. Free tutorial to learn MySQL.
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.
The session_start() function is used at the beginning of all PHP pages utilizing sessions.
Add data to MySQL by using Insert Into SQL code as demonstrated in our tutorial
How to determine if your hosting runs PHP
How to send an email from a form on a website to your email using PHP
Include external files into a PHP file using the include or require commands
How to use the MySQL alter table command, and what to combine it with to do different things to your database.
Create a simple countdown clock ticker in PHP using the mktime function.
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.
How to skip over a section of code in PHP using goto.
PHP code to generate a random unique user ID
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.
An absolute beginner's guide to writing and understanding their first PHP program.
How to connect to your MySQL database from a PHP document
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
Just because you made a MySQL column one type or size doesn't mean that it has to stay that way. Learn how to change each column in MySQL.
Change the size of a MySQL column by using the Modify SQL command
Using the show databases SQL command to show all the databases on the MySQL server
Store your PHP code in a MySQL database and call it when needed
Free web page hit counter code for your website, for a simple free web site hit counter written in PHP.
TextEdit comes standard on an Apple Macintosh computer. By following these simple steps you can use this program to create and save PHP files.
How to create a new database in MySQL using SQL or phpmyadmin.
An example of how to print the current date on a web page written in HTML using PHP
Generating a random number in PHP with the rand () function, or generating a random number between two given parameters
You can use the GD Library in PHP to dynamically create images
Some common problems that can occur when trying to connect to a MySQL database, and give errors.
Str_replace is used to find and replace parts of a string in PHP
How to install MySQL on your Apple computer
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.
The is_string php function is used to check if the value is a string. It will return true or false.
How to retrieve a URL and text from a database and create a link on your website using PHP.
Session_destroy () is used to destroy all the data in a current session
Add a unique table column in MySQL to ensure you do not have any duplicates, but using 'Add Unique' in your SQL Code
A PHP script that allows you to give a 1-5 star ratings for items on your website.
How to report an error into PHP from MySQL when your SQL code has errors
The top three reasons why to use PHP on your website.
How to edit your phpBB template to have a custom look, or theme.
Create an online address book using PHP
How to use the Stbstr PHP Function to return part of a string in PHP
How to make your PHP pages pretty with formatting
The describe SQL command is used to list all of the fields in a table and the data format of each field. It is phrased as: describe ;
The drop database command in MySQL will remove a database from the MySQL server.
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.
While there are multiple methods of storing local data in an iOS app, sometimes the data already exists in one of your databases
How to find a user's IP address using PHP
How to format a number in PHP - Free simple tutorial to using the number_format () function. Page 4.
How to open an external file with PHP and download its contents to use within your PHP file.
How to connect your Android app to a MySQL database
How to create and format a timestamp in PHP for a current, past or future date.
You can't see PHP code when you view a document source, you only see the HTML it outputs.
Session_unset() is used to clear all the variables in a PHP session
How to install Apache and PHP on your Linux computer
In this tutorial we explore how to do this using imagecopyresized () and use imagecopyresampled. We also cover calling the image from the PHP file.
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.
This tutorial shows you step by step how to create a flat file counter (no database) using PHP
PHP can generate a random number over a very large range, or pick randomly between only two or three choices. Here's how to do both.
Learn MySQL from a simple web based tutorial. Learn and understand SQL code
How to use loops in your PHP code to repeat a section of code over and over until a condition is met.
A guide to how to get started learning PHP
How can I make multiple variables into one? The problem is, you put them together, you go to call the variable, but instead it acts like text.
When you view source on your PHP files, why can't you see your code?
Text editors are useful tools for programers and web designers, we can tell you what a text editor is and how to use one.
The show columns command is used to display all the columns for a given table and their details.
PHP is a server side language, this means that all calculation are preformed on the server and not seen by the end user.
Record a user's IP address using this free PHP script.
How to install a phpBB web forum on your website - a tutorial for beginners
How to connect to your MySQL database from a PHP file
Often when installing scripts you need to know the document root. This simple script can give you that information.
If you are running PHP on a web server, make sure you have a host who is setup to run PHP. Mac and Windows require more steps.
Echo Function in PHP outputs (echos) the data to the page
Use fopen() to open up a file from php
Unset is used to destroy specified variables in PHP
How to show the date a file was last modified using PHP and filemtime. This is great for automatically dating time sensitive data on your website.
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?
A simple password style redirect that sends a user to the word they enter plus .html as a way of hiding pages
Hot to check your PHP Version. PHP / MySQL.
Using the crypt function in PHP to encrypt passwords and other data and keep them safe
Eval () is used to evaluate its input string as PHP and then process it as such
Answers to some of your most frequently asked PHP beginner questions.
Allow your users to change CSS style on your site, using PHP and Cookies
A basic overview of what you can do to your database with phpMyAdmin.
Ideas to protect your website when you allow users to upload to your server.
File_get_contents reads the data from a file and returns it to the PHP file as a string as demonstrated in our tutorial.
Review of the vBulletin message board system
Convert Temperature - Convert Fahrenheit to Celsius Temperature using a free php script. Page 2.
The SQL select statement is used to choose what data to pull from the mysql database
How to troubleshoot and double check your PHP code for errors
Use the USE Command in MySQL to switch databases
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.
fwrite is a binary safe file write used to write to an external file from PHP
An avatar is used to represent you online.
How to troubleshoot localhost not working to connect to your mysql database via PHP.
How to use PHP commands to interact with flat file text (txt) documents.
How to rotate an image using PHP
This tutorial demonstrates how to use php and mysql to count which sites have the most click throughs on your site.
A listing of Free PHP Scripts and websites that provide them
Generate random banners advertising on your web site with PHP, or have random graphic rotation.
Check if magic quotes is turned on or off in your php configuration.
The imagecreate () function is used in PHP to create a new palette based image