Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

brianellisrules

macrumors regular
Original poster
Howdy.

Using my new-found php/mysql skills, I'm modifying my counter to use a mysql database rather than a text file to track unique hits to my website.

The way it currently works is that it checks the IP of the user against a list of IPs in a text file. If the IP isn't there, increment the counter and add the IP to the list. Otherwise, do nothing.

I've modified it so it does all that using a mysql database (I EVEN WROTE A FUNCTION! WOOHOO!). Now I just need to transfer the data from the text file (over a thousand values) into the mysql database. If it was just a few lines, I'd do it manually via phpmyadmin, but that would take forever and a day for this case.

Thanks!
 
Hi,
I use Navicat for all my import/export data transfer in MySQL, you can get a 30 day trial, www.navicat.com

It's available for OSX and also Windows.

Essential application in my opinion!

Cheers,

Rick
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.