Planning the Automation Project
Website Automation with PHP and MySQL, Part 1
Low End Mac Reader Specials
Memory To Go Special: MacPro 8 Core Memory 4GB kit $154 / 2GB kit $94, New 2008 iMac 2GB $46. MacBook Pro / MacMini / iMac Intel Core2 DUO 2GB $44 / 1GB $23--Free shipping available.
Download Typestyler, still the Ultimate Styling Tool for Internet, Print and Video Graphics. Works great in Classic with a Native OS X Version on the way. Free Tryout: www.typestyler.com
LA Computer Company: Specials on AppleCare, iMac's, Apple Batteries and Apple A/C Adapters. Also Great prices on Used Apple Computers. Call 1-800-941-7654 Click Here.
OWC: NewerTech miniStack FireWire/USB 2.0 HD & Hub Up to 1.0TB of Performance Storage + FW/USB2 Powered Hubs - convenient & sleek 6.5" x 6.5" x 1.5" Featured: 500GB $169.99; 750GB $209.99; 1.0TB $339.99
Mac users can finally play Party Poker for Mac. Not only that, they can also learn how to play PokerStars for Mac.
Laptop Hardware Provided by TechRestore - Overnight Mac & iPod Repairs.
Compare products like desktop computers, laptops, and LCD TVs side by side! All the information and reviews to make the best purchasing decision for a new cell phone GPS products or MP3 players. The Ciao network makes searching products easy for you.
New MacPro Memory 800Mhz With Apple Spec Heat Sink 2GB $88 / 4GB $138 / 8GB $274 - Click to Maximize your Macs...
Dan Knight - 2002.04.23
I've been saying it for months, but I finally sat down and started to do it. We're automating site updates.
Yes, I've been doing all the updates manually for over last five years. I've simplified parts of the process using Server Side Includes and Cascading Style Sheets, but until last Friday, all of the content on Low End Mac has been put there manually.
The Plan
I have several projects to work on and a good idea of the order I want to do them in. All involve a fair bit of programming and should be feasible using PHP, one of the hottest programming languages on the Internet:
- Automate new links on home page and other indexes.
- Overhaul our mailing lists.
- Create a system where writers can submit articles online - maybe even write and edit.
There may be other projects, but these are the ones that are most important to Low End Mac. I've been giving a lot of thought to them; preplanning is an important part of programming.
Automatic Content
Right now we have our Mac of the day, email list of the day, and deal of the day. I manually added these Monday through Friday. Right now the Mac of the day and email list of the day are automated. I've created a database for each, and the server automatically updates them every morning (at 4:00 a.m. Eastern time). That's the first project, and I still have to set things up for the deal of the day.
The second project will be automating the new LEM content links and the "recent" section that appears with our editorial content. It shouldn't be too hard, but I want to go beyond that and eventually have the program track how many times each link is clicked - and then sort links according to date and popularity. This will be a bit more of a challenge. We may also ask for feedback later on.
The third project in automating the home page will handle the "Around the Web" section. This should be easier than the second project, but it's not as high a priority. I'd like to eventually expand this section so other LEM staffers could add links, then set up a cookie-based system where subscribers could choose which kind of links they do and don't wish to see. Eventually I'd like to track clicks and feedback, which could help us decide on precedence of new links based on their author and the site publishing them.
The Email Lists
I'm very grateful to Maclaunch.com for hosting our 30+ email lists, but the current system has some limitations. Once I've automated home page and link updates on the site, I want to address these limitations by creating a program to run the lists. Here's my brief feature list:
- A single subscriber database. You have no idea how many times I receive "unsubscribe" or "please switch me to digest" messages with no indication of which list(s) the subscriber receives. A unified subscriber database would solve this. It could even store a subscriber preference for single message mode vs. digest as well as alternate versions of email addresses.
- More secure archives. I want to make sure that if/when spiders search the archives they won't be able to harvest email addresses.
- Better threading. Each posting on each list will be numbered, making it easier to figure out which specific message someone is replying to.
- More user friendly. Right now we block HTML email, but PHP includes a command that can automatically strip HTML. Instead of sending such messages back as unacceptable, the server could clean them up. We could also clean up so-called smart quotes and other symbols that aren't strict ASCII.
- Better filtering. Not only would such a program be able to filter based on words or phrases, it could also be set to remove things like the automatic footers some email services append to messages.
- Online management. Each subscriber would be mailed a password and allowed to change their subscriptions using a Web browser or turn vacation mode on and off.
Overall, I'm very excited at the prospect of having a lot more control over the way the lists operate.
Resources
My biggest resources are probably my two middle sons, both of whom are already doing a lot of programming in PHP. I'll also be borrowing their PHP 4 Bible and PHP (from the Visual "Read Less, Learn More" series).
I'll share what I learn as we go along.
Online Resources
- PHP Builder
- PHP-Scripts.com
- PHP >start here, WebDesigns1
- PHP: Learning a new language, Robelle
Recent Online Tech Journal Columns
- Apple's AAUI ethernet connector, 09.04. From 1991 through 1995, Apple used a proprietary ethernet connection. Why they created AAUI and where to find adapters.
- PowerPC G5: Apple's last fling with PowerPC architecture, 05.24. Teaming up with IBM, Apple adopted the PowerPC G5 in 2003 - and phased out the last G5 Power Mac three years later.
- The PowerPC G4: From 350 MHz to 2.0 GHz, 05.24. AltiVec and dual processor support made the G4 a big improvement over the earlier G3 processor.
- The PowerPC G3 story: From 233 MHz to 1.1 GHz, 05.24. The history of the PowerPC 750 family and its use in Apple computers from 1997 through 2004.
- More in the Online Tech Journal index.
Links for the Day
- Mac of the Day: PowerBook 170, Oct. 1991 - At 25 MHz, the PB 170 was at the top of the original PowerBook line.
- List of the Day: The iPhone List Low End Mac's forum for discussing and supporting Apple's iPhone.
- August 30 in LEM history: 99: The truth about USB speed - 00: Could Eazel kill the Mac? - Mac OS 8.1 on a IIci and LC III - 01: Beyond MHz and GHz - Getting a handle on email - Thanks for the IBM PC, Dad - Apple's anniversaries - 02: Mac OS X v10.2 - iBook video out - 04: Things that freak out my students - 06: Nvu and SeaMonkey can't replace Home Page - 07: DVD-RAM support
Recent Content on Low End Mac
- Looking for a Content Management System That's as Easy as Mac, Dan Knight, Mac Musings, 08.29. Low End Mac needs to move to a content management system, but the few we've tried just don't cut it for people used to the simple elegance of the Mac.
- First 3 Million Mac Quarter, Skinny on Mac mini Pricing, Mac-like gOS, and More, Mac News Review, 08.29. More plan to buy Apple products than ever before, complete reset can fix MobileMac synch problems, Apple boosting computer and smartphone share, and more.
- New 'Books Likely in September, 17" PowerBook Display Fault Site, SSD Security, and More, The 'Book Review, 08.29. Also 6 ways to speed up your MacBook, next generation MacBook Air CPU, MacBook Air Update, LapStrap carrying solution, rise and fall of ultraportables, bargains from $220 to $2,699, and more.
- iPhone 3G Reception 'Completely Normal', AT&T International Data Plans for iPhone, and More, iNews Review, 08.29. Also longer life for iPod earbuds, an alternative to MobileMe, new cases and apps for iPhone, AppStoreGems website launched, and more.
- Best Power Mac G4 Deals, Low End Mac Deals, 08.29. Used 450 MHz AGP, $75; 500, $99; 800 QS, $199; 1.25 GHz MDD, $375; 450 MHz dual, $179; 867 dual, $300; 1 GHz dual, $395; 1.42 dual, $575.
- Best iBook G3 Deals, Low End Mac Deals, 08.29. Used 300 MHz clamshell, $150; 500 CD, $150; 800, $200; 600 CD-RW, $240; 900 Combo, $300; 14" 600, $360; 900, $400.
- Best iPod nano Deals, Low End Mac Deals, 08.29. Used 2 GB iPod nano, $89; refurb 3G 4 GB, $99; new, $140; refurb 8 GB, $149; new, $179.
- 10 Mac Browsers Compared, Simon Royal, Mac Spectrum, 08.28. A look at Internet Explorer, Radon, Opera, Safari, Shiira, iCab, Firefox, Netscape Navigator, Flock, and Camino running in Leopard.
- Clone and Boot: Another Advantage of the Mac OS, Kev Kitchens, Kitchens Sync, 08.28. Unlike Windows, Apple makes it possible to clone a bootable drive (Classic Mac OS or OS X) and use it with another supported Mac.
- Best MacBook Deals, Low End Mac Deals, 08.28. Used 1.83 GHz, $799; 2.0 black, $875; refurb 2.1 GHz, $899; 2.4, $1,099; black, $1,299; new 2.1, $1,019 after rebate; 22, $1,094; 2.4, $1,219 a/r; black, $1,394 a/r.
- Best iMac G5 Deals, Low End Mac Deals, 08.28. Used 17" 1.6 GHz Combo, $499; 1.8 SuperDrive, $530; 2.0, $600; 1.9 iSight, $625; 20" 1.8 GHz, $580; 2.0, $650; 2.1 iSight, $700.
- Best classic Mac OS Deals, Low End Mac Deals, 08.28. System 6, $10; 7.1, $12; 7.5.1, $4; Mac OS 7.6, $13; 8.0, $13; 8.1, $48; 8.5, $25; 8.6, $20; 9.0, $20; 9.2.2, $20; more.
- CrossOver Strikes Out, Frank Fox, Stop the Noiz, 08.27. Running Windows apps on a Mac without paying for Windows is great in theory, but actually getting Windows software working is another story.
- MacDrought: 4 Months with No New Macs, Dan Knight, Mac Musings, 08.27. The most recent Mac update was over four months ago, and the Mac mini has been unchanged for over a year.
- Resurrecting a Dead Pismo, Spotlight Search Tip, and EasyFind a Good File Finder, Charles W. Moore, Miscellaneous Ramblings, 08.27. Lots of tips on bringing a comatose Pismo back to life, a Spotlight file name search tip, and EasyFind as an alternative to Spotlight.
- Best Intel iMac Deals, Low End Mac Deals, 08.27. Used 17" 1.83 GHz, $625; 20", $599; 2.16, $749; 24", $950; refurb 20" 2.4, $999; 2.66, $1,299; 24" 2.4, $1,299; 2.8, $1,549; new 3.06, $2,094 after rebate; more.
- Best 15" PowerBook G4 Deals, Low End Mac Deals, 08.27. Used 1.25 GHz Combo, $600; SuperDrive, $650; 1.33 Combo, $640; 1.5, $680; SD, $725; 1.67, $730; hi-res, $800.
- Best Time Capsule and AirPort Deals, Low End Mac Deals, 08.27. 500 GB Time Capsule, $294; 1 TB, $468; AirPort Extreme Card, $39; 802.11n Base Station, $166; 802.11g AirPort Express, $60; 802.11n, $98.
- More links in our archive.
Go to the Online Tech Journal index.
About LEM | Support | Usage | Privacy | Contacts
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
