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 | Contacts

Entire Low End Mac website copyright ©1997-2008 by Cobweb Publishing, Inc., unless otherwise noted. All rights reserved. Advice 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.
  Access our RSS news feed at http://lowendmac.com/feed.xml.
  Email may be published at our discretion; email addresses will not be published without permission, and we will encrypt them in hopes of avoiding spammers. If you prefer your message not be published, mark it "not for publication." 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.
  Low End Mac is an independent publication and has not been authorized, sponsored, or otherwise approved by Apple Inc. Apple, the Apple logo, Macintosh, iBook, iMac, eMac, iPod, PowerBook, MacBook, 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.

Have a question?
Ask an expert!

Navigation

Used Mac Dealers
Apple History
Best Used Macs
Video Cards
Email Lists
InfoMac's Low
End Mac Forum

Favorite Sites

MacSurfer
MacMinute
MacInTouch
MyAppleMenu
InfoMac
Macs Only!
The Mac Observer
Accelerate Your Mac
RetroMacCast
PB Central
MacWindows
The Vintage Mac
   Museum
DealMac
DealsOnTheWeb
Mac2Sell
ramseeker
Mac Driver Museum
JAG's House
System 6 Heaven
System 7 Today
the pickle's Low-End
   Mac FAQ
Abandonware
   Petition
Mac vs. PC Info

Affiliates

The Apple Store
Mac Connection
MacMall
TechRestore
MacResQ
ExperCom
Crucial Memory
batteries.com

Advertise

All of our advertising is handled by BackBeat Media. For price quotes and advertising information, please contact at BackBeat Media (646-546-5194). This number is for advertising only.

Problems viewing this page with Internet Explorer 5.5 or 6? It works fine in other browsers, including IE 7. We recommend Firefox for those using Windows, as it is standards based and more secure than IE 6 (and earlier). More LEM visitors use Firefox than any other browser.