Uploading, Saving and Downloading Binary Data in a MySQL Database PHP / Databases
This article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a MySQL database. This article is split into three pages: Setting up the database, Creating the 'upload' scripts, and Creating the 'download' script.
Building an Opt-in Email List PHP / Emailing
This helpful tutorial shows you how to build an opt-in email list in PHP. It covers validating email addresses, checking for duplicate email addresses, adding to a mailing list, and changing a strings case.
Creating a Mailing List Manager with PHP PHP / Emailing
This tutorial will guide you through building a complete mail list administration solution, capable of handling multiple lists. Suitable for small-medium sized lists (less than 500 names), flat files are used to store information for later retrieval. Many file access commands will be used and explained, and we'll cover how to send mail from a PHP script.
Simple PHP mailing list PHP / Emailing
The script bellow will create and add or remove emails from users to a file, so that databases are not required.
Are PHP and MySQL the Perfect Couple? PHP / Databases
This is ore of an introductory article on PHP and MySQL covering such topics as features of PHP and MySQL, and how to use PHP to interact with MySQL.
Generating Advanced Web Page Statistics using PHP PHP / Site Analysis
This tutorial is intended for the PHP programmer interested in gathering and analyzing Website statistics in a presentable format using mySQL and PHP.You will need a moderate understanding of PHP and a limited knowledge of mySQL, including how to create a mySQL table using the mySQL client.
Pagination with PHP and MySQL PHP / Databases
Pagination, as described in the video, is the process of breaking a bunch of results, from a MySQL Query, up into specific pages, which themselves list a set number of items each.
Acquiring PHP MySQL PHP / Installation
PHP and MySQL are already packaged in Linux and Mac OS X OSs. However, most PHP developer are actually using Windows when developing PHP applications. This is also true to myself. I have Mandrake Linux 10 but I'll just use it for testing purposes of my finished scripts. One reason is that Windows render an amazing web presence unlike any other OS's browsers. So this page will only cover the WAMP ( Windows, Apache, MySQL, PHP ). You will learn how to install Apache, PHP, and MySQL under Windows platform.
Creating a Simple Photo Album with PHP and MySQL (Part 1) PHP / Databases
Online photo albums are everywhere these days. Some of them are dedicated to landscapes, others are dedicated to celebrities, and the list goes on and on. This tutorial is the first in a series of tutorials that will teach you how to use PHP and MySQL to create a photo album that will allow you to upload new pictures, delete old pictures, and even update any information linked to your pictures.
PHP and Mysql: Part 1 PHP / Databases
Alot of people have written in saying that the Using MySQL with PHP tutorials they've found in the internet are difficult to follow. This tutorial is our attempt at solving the confusion and providing a straight-forward explanation of how you use PHP to interact with a MySQL database.
TD Subscribe Mail Script PHP / Emailing
Before I actually start mailing to anyone I need a script that I can link to inside every opt-in mail list email to allow subscribers to easily and automatically unsubscribe from the list. In some places, due to the rampant abuse of spammers, I believe there is legislation which requires such a link, so an ounce of prevention might be worth a pound of cure.
How to connect to MySQL database using PHP PHP / Databases
Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running.
Basic mySQL Queries And PHP PHP / Databases
This tutorial will help you get started in working with mySQL and PHP. It will assume that you have no prior experience in using mySQL with PHP before. After reading this tutorial, you should get an idea on what a database is, how to use it, and how to access it.
Using PHP to search a MySQL database and return paged results PHP / Searching
PHP, MySQL and a Web Server capable of parsing PHP pages, like Apache or IIS. This search script does not spider all your pages by crawling the links, so the content you want to be searchable must be within the database. Knowledge of PHP and MySQL is also necessary because this script is just the bones of a working solution.
Databases in PHP - MySQL in PHP PHP / Databases
Having studied database basics and taken a look at the Structured Query Language, it's time to dig in. Now we take a look at the use of MySQL in PHP.