Tag Archives: PHP

Used Car Database

For quite some time now I have needed and wanted to make a database listing of Used Cars by Year, Make and Model.

I finally have the used car database complete. The result is a database that should help any programmer needing the same information for their used car project.

The Used Car Database currently has over 5,200 cars listed by Year, Make and Model, from 1989-2009.

The data matches what is listed in the Kelley Blue Book which has been the nation’s number-one-selling automotive book, I did this to have a good reference point for data validity.

The file download includes 2 file formats of the database. A CSV file and a MySQL export file. Between these 2 formats, most programmers should be able to incorporate this data into a project easily.

Here is a random sampling of the data.

2002 Saturn SC2
2009 Chevrolet Colorado
1992 Mercury Sable
1994 Dodge Viper
2007 Chevrolet Equinox
1994 Suzuki Samurai
1999 Lexus LS 400
1999 Dodge Durango
2001 Ford Mustang
1992 Buick Riviera

Buy Now

Add to Cart

WordPress Threaded Comments

I have been needing to change my comments to Threaded Comments for some time. I finally took the time to do this, and thought I would share these simple steps to accomplish Threaded Comments using the latest standard WordPress system without any plugins.

The one thing you need before you start is a copy of WordPress 2.7+ so you can copy some code. Just a little side tip here. Even though most of my sites and clients have one button install of WordPress, I keep a copy of each version that is released on a thumb drive with my other web stuff so I always have it handy. I also sync that thumb drive up to a hard drive in my office for backup!

Here are the steps to take to convert your comments to threaded comments as they appear here on my site.

  • Copy \wp-content\themes\default\comments.php from WordPress 2.7+
  • Copy \wp-content\themes\default\comments-popup.php from WordPress 2.7+
  • Copy code from \wp-content\themes\default\header.php, and place in your header file.  <?php if ( is_singular() ) wp_enqueue_script( ‘comment-reply’ ); ?>
  • Copy the Updated styling code from this great article by Chris Harrison
I modified 2 lines of code in the stlyesheet once I copied it over from Chris Harrisons’ Example. I did not like the word “says” showing up, so I turned it off, and I changed the meta link to the comment to match the rest of the site.

Turn off  “says” :

  • From : ol.commentlist li div.vcard span.says {}
  • To: ol.commentlist li div.vcard span.says {display:none;}
Change Meta link color:
  • From: ol.commentlist li div.comment-meta a { color:#ccc; }
  • To: ol.commentlist li div.comment-meta a { color:#003366; }

That’s it, about a 5 minute process to convert to WP Threaded Comments on a WordPress blog. Pretty painless too. Big thanks to Chris Harrison for his excellent post on styling Threaded comments!

PHP Help

Thought I would share a few of my favorite resources for PHP Help, no real secrets here, just some good links.

PHP Freaks

W3Schools PHP Tutorials

PHP Net

PHP Classes

The thing I liked about getting into PHP Programming was the amount of help and sample code out there is unbelievable, and if you work in WordPress you have a great place to test PHP stuff.

I would recommend setting up a dummy WordPress site, just to try things out, it is an excellent way to learn from the ground up.

If you ever need to just ask a simple question, give Twitter a try, there is always someone willing to help.

Web Programming

Years ago I started programming in ASP (Active Server Pages). This was a great language and was fairly easy to migrate into. However, the “cost of inclusion” was rather high as it is a Microsoft language and required (of course) that you be hosted on a Microsoft platform server. Then Microsoft decided to upgrade ASP to ASP.net.

At that point they lost me. With the advent of Linux and the world of open source it just did not make any sense to stick with something that required so much overhead. Another key downside was the database programming required either SQL Server or MS Access. One was too expensive and the other not robust enough.

I switched to PHP and MySQL and I have never been happier. It is easy to find a hosting company that supports these languages and there is a wide realm of support and samples for both. If you like web programming PHP is a must to check out.

And of course the ever popular WordPress platform is PHP based.


WordPress Love and Hate

I am a big WordPress fan, of course some of that comes from me liking to do PHP coding and WordPress is a very open platform to work with leaving lots of room for coding creativity.

But if you watch this WordPress Twitter Search it seems every so often someone has a little spat with their WordPress installation. Like WordPress is picking on them personally or something, lol.