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
Follow Low End Mac on Twitter
Join Low End Mac on Facebook
Favorite Sites
MacSurfer
Cult of Mac
Shrine of Apple
MacInTouch
MyAppleMenu
InfoMac
The Mac Observer
Accelerate Your Mac
RetroMacCast
The Vintage Mac Museum
Deal Brothers
DealMac
Mac2Sell
Mac Driver Museum
JAG's House
System 6 Heaven
System 7 Today
the pickle's Low-End Mac FAQ
Affiliates
Amazon.com
The iTunes Store
PC Connection Express
Macgo Blu-ray Player
Parallels Desktop for Mac
eBay