3D movies have recently seen a resurgence in the movie theater. Due to new 3D theater technologies, several 3D version of movies have hit the theaters and a few of those have made it to home theater formats in both standard DVD and Blu-ray. 3D movies have been around in theaters since the early 1950s when they were very popular. Many of these movies used a stereoscopic … [Read more...]
Using the MySQL LIMIT Clause for Paging with PHP
One of the first questions that comes up when someone starts using PHP and the very powerful MySQL database is: How do I page through the results of a query like I see with search results on many web sites? This is pretty easy to accomplish if you know how to use the MySQL LIMIT clause. The LIMIT clause allows you to select a numeric range of results from a recordset that … [Read more...]
Creating a States Table in MySQL
It is common to add a drop-down select box that is populated with USA states or Canadian provinces to PHP applications. There are basically three ways to do this. You can hard-code all of the Select box selections into your application, you can add the states to a MySQL database manually, or you can use the handy code on this page to create a States table in MySQL in just a few … [Read more...]
PHP Shopping Carts Worth Looking At
A shopping cart is an essential component of every e-commerce site. Although there are literally hundreds of shopping carts to choose from, only a few stand out. PHP is the preferred shopping cart language because it is the most popular web development language on the Internet. When combined with the MySQL database, PHP is unbeatable for cost effectiveness. The selection of … [Read more...]
Populating a Select Box With PHP and MySQL - PHP Tutorial
This is a simple PHP script that takes data from a MySQL table and uses it to generate a drop-down select box for an HTML form. This can be used for a list of states on a credit card or user data form, or for a category selection or something where you need to pull the selections from a MySQL table. The script uses PHP to generate the HTML that is sent to the user's … [Read more...]
How to Use the PHP Ternary Operator
The ternary operator is a shortcut comparison operator that replaces an if-else statement in a PHP script. If you use a lot of comparison statements in your scripts, this can greatly reduce the number of lines of code. The ternary operator is really very simple to use, but it does tend to confuse newbie PHP programmers. The ternary operator is only used for assignment of … [Read more...]
Preventing SQL Injection with MySQL and PHP
Most new web developers have heard of SQL injection attacks, but not very many know that it is fairly easy to prevent an attacker from gaining access to your data by filtering out the vulnerabilities using MySQL extensions found in PHP. An SQL injection attack occurs when a hacker or cracker (a malicious hacker) attempts to dump the data in a database table in a … [Read more...]
Simple PHP Banner Ad Rotator Script
Banner ad rotators can range in complexity from simple systems that randomly display banner or sidebar ads, to very complex systems that track every click on each ad and display different ads based upon preset percentages for each ad display. This snippet of PHP code is the simple version. As many ads as you want can be loaded into an array and the code will randomly select … [Read more...]