Creating Quick Scrapers Using Xpather, Snoopy & PHP

I’ve been working on a bunch of review sites, and because of this I’ve had to gather some data from websites – mostly stuff that’s not included in the data feeds that I’m using and wanted to compliment my information with some additional specifications for my users to check out items this coming holiday season, with ease, and hopefully make them click happy for purchasing J I started out reading a bunch of tutorials on using Curl and PHP to scrape and even built a little scraper that worked fucking awesome for the page I created it for, it had 21 regex’s, and used a bunch of curl lines to connect and grab the information I needed....

October 14, 2009 · 7 min · 1380 words · Matt G

Free GUI For Link Manager. Easy Affiliate Link Management.

The other day you may have read my post about creating a tool to easily replace all our affiliate links across multiple sites with one easy to use database. While this program does rock your socks off, it didn’t have a GUI so it was a little more difficult for people to use. But that’s okay. I’ve created a backend for the application that works using Flexigrid and Jquery to provide a super easy way to update your database from a backend, and flip out your links instantly....

October 5, 2009 · 3 min · 540 words · Matt G

Free Script: Redundant Automatic Link Updating Across Your Sites

Today I was spending time updating some of the links across my sites that were setup in htaccess files, or in the virtual host files for redirects to my affiliate links. I was getting super bored, and a little bit pissed off. Then I thought to myself, why am I not automating this so I only have to go to one place to update all the links across my sites....

October 2, 2009 · 6 min · 1133 words · Matt G

Dirty way to get Zip Code from a visitors IP, City and State using MaxMind GeoIP

As we mentioned in our previous post, the MaxMind geoip database doesn’t do too well with getting the zip code of users that visit your sites. We had a use today to grab the zipcode and popular an area of our site with it, and we’re going to show you how to do it as well. This assumes you already have GEOIP working, and are using the standard free database, and our zipcode database tutorial....

August 27, 2009 · 3 min · 464 words · Matt G

Need a way to convert .csv files into .sql insert statements? Look no furthur!

Today we had a need to convert the City and State returned from the MaxMind GEOIP1 database into a ZipCode. Which, as they mention on their site is not entirely accurate using their own database and recommend to go with the iBegin Free ZIPCode database[2] to compare the GEOIP results with to find our zipcode. Fancy. Since we had to import the ZipCode’s into a MySQL database from a CSV file we had to figure out how to do this, and we’re archiving it here for you and for our own purposes....

August 27, 2009 · 2 min · 354 words · Matt G