Low End Mac's Online Tech Journal

PHP and MySQL

An Ongoing Series

These articles trace the process we used to automate various aspects of the Low End Mac website.

Planning the Automation Project, 2002.04.23. The first step is deciding what it is you want to do.
Creating Your My SQL Database, 2002.04.24. Creating your MySQL database and defining the data fields you'll use.
Importing Data into Your MySQL Database, 2002.04.25. Massaging your existing data so you can import it into your MySQL database.
Using PHP to Display Your Data, 2002.04.26. Using PHP to display the information in your MySQL database.
Testing and Making Your PHP Work, 2002.04.29. Before you deploy it, make sure it works on your server.
Fixing a Small Scripting Problem, 2002.05.10. Finding and fixing a problem in our PHP script.
The Deal of the Day Database, 2002.05.13. We begin our use of the date field.
Adding Data with Your Browser, 2002.05.14. Adding data to your MySQL database with your browser.
Managing External Links, 2002.06.24. Using a database to handle external links - and then going a step beyond.
Displaying External Links with PHP, 2002.06.26. Using the if command to make sure records with empty fields are displayed properly.
Counting Clicks with PHP and MySQL, 2002.06.28. Using PHP and MySQL to track how often a link is clicked.
Managing Local Links with PHP and MySQL, 2002.07.03. How Low End Mac uses PHP and MySQL to track, sort, and display links to new site content.
Displaying Stock Quotes and Timestamps with PHP, 2002.07.16. Displaying the time of the most recent site update and current prices for Apple stock automatically.
Modified Date Display and Scheduled Content with PHP, 2002.07.24. Modifying the way the date is displayed and scheduling content for future release.
More Link Automation and PHP Frustration, 2002.07.31. A little more link automation - and frustrating problems with PHP.net documentation and the imap_open function.
Creating an RSS News Feed with PHP and MySQL, 2003.02.27. How we use our publishing database to automatically create the Low End Mac RSS newsfeed.

About LEM Support Usage Privacy Contact

Low End Mac is an independent publication and has not been authorized, sponsored, or otherwise approved by Apple Inc. Entire Low End Mac website copyright ©1997-2012 by Cobweb Publishing, Inc. unless otherwise noted. All rights reserved. Apple, the Apple logo, Macintosh, iPad iPhone, iMac, iPod, MacBook, MagSafe, Mac Pro, Apple TV, and AirPort are registered trademarks of Apple Inc. Additional company and product names may be trademarks or registered trademarks and are hereby acknowledged.
Advice is presented in good faith, but what works for one may not work for all. Please report errors to .
LINKS: We allow and encourage links to any public page as long as the linked page does not appear within a frame that prevents bookmarking it.
Email may be published at our discretion unless marked "not for publication"; email addresses will not be published without permission, and we will encrypt them in hopes of avoiding spammers. Letters may be edited for length, context, and to match house style.
PRIVACY: We don't collect personal information unless you explicitly provide it. For more details, see our Terms of Use.

Custom Search

Follow Low End Mac on Twitter
Join Low End Mac on Facebook

Low End Mac Reader Specials

TypeStyler 11 is now in the Mac App Store!! -- Special Introductory Price of $59.95!! -- To Buy From The Mac App Store Click Here Now!! Or buy direct from Strider Software.

Don't install Parallels to play poker online! Poker Mac will show you how to download and install a native Mac poker and Mac Casino applications in minutes.

Affiliates

Amazon.com
The Apple Store
The iTunes Store
PC Connection Express
GainSaver
Parallels Desktop for Mac
eBay