Importing Data into Your MySQL Database

Website Automation with PHP and MySQL, Part 3

Low End Mac Reader Specials

Memory To Go Special: MacPro 8 Core Memory 4GB kit $192 / 2GB kit $109. 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: LA Computer Company: Specials on AppleCare, Apple Displays, MacBooks, iMac's, MacBook Pros, Laptop and iPod accessories and more. Apple A/C Adapters for laptops starting at $25.00 Call 1-800-941-7654 or Click Here.

Other World Computing: OWC Mercury Elite FW800/FW400/USB2/eSATA TOP-RATED Solutions offer High Performance, Reliable storage for all your data storage needs. Industry leading 2yr limited + up to 5yr HD Mechanism Warranty too! Up to 2.0TB(2000GB), 500GB specials from $199.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.

MacPro Memory 667Mhz With Apple Spec Heat Sink 2GB Kit $ 90 / 4GB Kit $140 / 8GB Kit $278 Click to Maximize your Macs...

Dan Knight - 2002.04.25

Last time we created our database with four fields: id, link, model, and text. Now we need to fill the database.

Again, there are two ways to do things. The hard way is to use Telnet and manually enter all of your data. The easy way, assuming you have the data in a file, is to import your information.

Filling the Mac of the Day Database

Call me lazy, but I simply don't want to spend a lot of time rekeying this information or doing the cut-and-paste thing. Three fields time nearly 100 Macs would take a long time.

Besides, I already had everything in HTML format. Here's the line for the Mac Plus as an example:

<A HREF="/compact/macintosh-plus.html">Mac Plus</A> (1/86-10/90). First Mac with SCSI, memory expansion. Longest model life - over 4 years.

I wanted to break this down to three fields: link, model, and text, as follows:

link: compact/plus.shtml
model: Mac Plus
text: (1/86-10/90). First Mac with SCSI, memory expansion. Longest model life - over 4 years.

I'd add the id field manually, since it didn't exist in my HTML file.

The first step was to take the raw HTML from my file and copy it into TextSoap, a powerful program for cleaning up text with manual line breaks, extra spaces, and other problems. Running the scrub command reconnected the HTML lines that Home Page had nicely broken into pieces.

Then we copied that code to BBEdit Lite, where our next step was to eliminate the extra space between lines of code. Search for \r\r (two returns) and replace with \r. Then save the file to the desktop.

As Brian < http://brkn.net/> explained to me, before you go any further you need to "escape" things like quote marks. So we did a global search for the quote mark and replaced it with \" - the backslash is used to indicate that the next character is literal instead of punctuation. We did the same with parentheses.

Our Mac Plus description now looked like this:

<A HREF="/compact/macintosh-plus.html">Mac Plus</A> $1/86-10/90$. First Mac with SCSI, memory expansion. Longest model life - over 4 years.

We also stripped out the unnecessary HTML code such as <A HREF="/ and "> and </A> . Because MySQL likes to work with comma delimited files, we replaced "> with ", " and also replaced </A> with ", ". Now it looked like this:

compact/plus.shtml", "Mac Plus", "$1/86-10/90$. First Mac with SCSI, memory expansion. Longest model life - over 4 years.

That had us most of the way there, but we still needed to add quote marks at the start and end of each line, so we had BBEdit search for \r and replace it with "\r". Three fields down; one to go.

"compact/plus.shtml", "Mac Plus", "$1/86-10/90$. First Mac with SCSI, memory expansion. Longest model life - over 4 years."

Next we manually numbered every line in our database. The Mac Plus is the 27th in our list, so the entry now looked like this:

"27", "compact/plus.shtml", "Mac Plus", "$1/86-10/90$. First Mac with SCSI, memory expansion. Longest model life - over 4 years."

Brian and I had created 89 records that were just about ready to be imported into the MySQL database we'd created. Just a couple more steps. We needed to preface each line with INSERT INTO mod (id,link,model,text) VALUES( and append ); to the end of the line. Again, we did a search for the return (\r in BBEdit) and replaced it with );\rINSERT INTO mod (id,link,model,text) VALUES( - resulting in the following

INSERT INTO mod (id,link,model,text) VALUES("27", "compact/plus.shtml", "Mac Plus", "$1/86-10/90$. First Mac with SCSI, memory expansion. Longest model life - over 4 years.");

It probably takes longer to explain the steps than it took to do them. Then it was time to import the whole text file into MySQL using PHPMyAdmin. It failed the first two or three times because I'd accidentally given two lines the same number.

Once the import was successful, we were done. The database had been created. Now all we needed to do was use the data to create Mac of the Day entries.

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.
More in the Online Tech Journal index.

Recent Content on Low End Mac

Apple's eMate still a great tool in the classroom, Tommy Thomas, Welcome to Macintosh, 05.09. How one teacher equipped his classroom with eMates with his own money - and plans to keep using them as long as possible.
$199 iPhone coming?, iPod not a Walkman, crosswalk danger, iPods taking over cars, and more, iNews Review, 05.09. Also the iPhone is a second-rate phone, iPhone 2.0 may introduce handwriting recognition, Kensington battery pack and chargers, new iPhone apps, and more.
Best Power Mac G4 deals, Low End Mac Deals, 05.09. Used Cube, $479; 400 MHz PCI, $70; 450 AGP, $105; 733 DA, $150; 867 QS, $200; 1 GHz, $250; 450 dual, $295; 1 GHz dual, $400; 1.42, $600; more.
Best 15" MacBook Pro deals, Low End Mac Deals, 05.09. Used 1.83 GHz Core Duo, $1,100; 2.16, $1,295; refurb, 2.2 Core2, $1,449; 2.4 Penryn, $1,699; 2.5, $2,149; new 2.2, $1,525 after rebate; 2.4, $1,685 a/r; more.
MacBook sales explode, MacBook Air reviews, several new hard drives, and more, The 'Book Review, 05.09. Also silver-zinc batteries may outlast lithium-ion, Bell Aliant bundling MacBook with Internet access, notebook drives benchmarked, bargain 'Books from $150 to $2,699, and more.
Best iPod touch deals, Low End Mac Deals, 05.09. Refurb 8 GB '08, $249; 16 GB '07, $329; '08, $349; new 8 GB '07. $269; '08, $280; 16 GB '07, $330; '08, $369; 32 GB, $475.
More G4 upgrade advice, secure disk wipes, 500 MHz iMacs with Tiger in action, and more, Dan Knight, Low End Mac Mailbag, 05.09. The importance of securely clearing your hard drive before you pass on your Mac, Pismo and closed lid mode, G3 iMacs in the classroom, and more thoughts on upgrading G4 Power Macs.
Apple tops in tech support, Penryn iMacs and Psystar Open Computer reviewed, and more, Mac News Review, 05.09. Also the iMac philosophy, OpenOffice 3.0 going Mac, MozyHome backup comes to Macs, weather in the Dock, and more.
140 million copies of Vista sold (yawn), Frank Fox, Stop the Noiz, 05.09. It sounds like a lot, but over 85% of Windows users are staying away from Vista. 20% of Mac users have embraced Leopard in one-third the time.
Mac of the Day: Macintosh LC, Oct. 1990 - only 3" tall, the LC was the least expensive color Mac in 1990.
List of the Day: Jaguar List is for anyone using Mac OS X 10.2.x.
May 12 in LEM history: 99: Is Apple missing the boat? - 00: PowerBook history - Frankenstein Power Mac - 03: Beige Power Mac G3 - Is a 5400 worth buying? - Upgrades for the tray-loading iMac - Quiet computing - 04: Windows stability: Nothing changes - Broadband Internet access: Picking the right speed - 06: The future of PowerPC Macs in the Intel era - Setting up a 68040-based Mac media center - Mac mini Core Duo upgrades
Why one Mac user chose BlackBerry over iPhone, Andrew J Fishkin, Best Tools for the Job, 05.08. The advantages of OS X, Safari, Mail, and iSync don't outweigh the familiarity of BlackBerry, its excellent software, easily replaceable batteries, and a camera-free option.
500 MHz iMac with Panther great for Internet, watching video, and more, Carl Nygren, My Turn, 05.08. At $65 with upgraded RAM and a bigger hard drive, it was too good to pass up, and it works very nicely with Mac OS X 10.3.
Boomerang: The Blue and White Power Mac G3 that kept coming back, Charles Webb, The Webb Chronicles, 05.08. Over its nine-year lifespan, this Power Mac had at least five owners before it finally gave up the ghost.
Best Intel iMac deals, Low End Mac Deals, 05.08. Used 17" 1.83 GHz, $699; 20" 2.16 Core2, $885; refurb 20" 2.16, $949; 2.4, $1,099; 24" 2.16, $1,199; 2.4, $1,399; 2.8, $1,599; Penryn from $1,049 after rebate.
Best 17" PowerBook G4 deals, Low End Mac Deals, 05.08. Used 17" 1 GHz, $790; 1.33 GHz, $850; 1.5 GHz, $859; 1.67 GHz, $889.
Best Mac OS X 10.5 'Leopard' deals, Low End Mac Deals, 05.08. Mac OS X 10.5.1 single user, $99; 5 users, $139; 10.5 Server, 10 users, $450; unlimited, $899.
More links in our archive.

Go to the Online Tech Journal index.

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.