Using IP Geolocation and Radius Searching with PHP/MySQL

Posted on December 15, 2008 by snipe in Featured, PHP/mySQL, Web Development

Delivering content relative to the physical location of your users is an excellent (and fairly easy) way to fine-tune the content you’re delivering to be most relevent to the people visiting your site. Two simple ways of doing this are to use an IP-based geolocation lookup, or to do a manual radius search (like a [...]

Identify and Fix SQL Injection Vulnerabilities in Web Applications

Posted on July 1, 2008 by snipe in Featured, PHP/mySQL, Web Development, Windows Downloads

Scrawlr is a free software for scanning SQL injection vulnerabilities on your web applications, developed by HP Web Security Research Group in coordination with Microsoft Security Response Center.

Creating a Multi-Level Listbox in PHP/mySQL

Posted on June 19, 2006 by snipe in PHP/mySQL

This lets you create a nested multi-level category menu through PHP and mySQL. Using a recursive function, we can display an unlimited number of nested categories, for a drop down box that might look like this:
Fruit
– Apples
—->Red Delicious
—->Granny Smith

Dynamic thumbnailing with PHP and Imagemagick

Posted on June 27, 2004 by snipe in PHP/mySQL

This code formatting is a little off, since the WYSIWG editor seems to have eaten part of it. Sorry.
<?php
/* ———————————————- */
/* ———— BEGIN PHP SNIPPET —————-*/
/* ———————————————- */
// specify your file details
$current_file = “image.jpg”;
$max_width = “150″;
// get the current info on the file
$current_size = getimagesize($current_file);
$current_img_width = $current_size[0];
$current_img_height = $current_size[1];
$image_base = explode(“.”, $current_file);
// this part gets [...]

Google Style Page Numbering (with x per page and y page numbers displayed)

Posted on June 27, 2002 by snipe in Featured, PHP/mySQL

With just a few modifications, we can create a piece of code that will not only give you x results per page with page numbers, but it will also allow you to specify how many page numbers should appear on the page at any time, much like Google.  (For example, if you have hundreds of [...]

Page Numbering (with x results per page)

Posted on June 27, 2002 by snipe in PHP/mySQL

Although there are several examples of this type of code to be found online, I had never found one that easily did what I needed and was flexible enough that we only had to change a few things to use it again – so I wrote my own.
It links each page number (except for the [...]

Alternating Row Colors in PHP/mySQL

Posted on June 19, 2002 by snipe in PHP/mySQL

Using alternating row colors in a PHP database application is a nice way to give the user some visual differentiation between multiple rows of results – and the best part is that it’s so damn easy.  I’m going to assume that you’re using CSS for formatting, but if you are still using HTML to set [...]

PHP/mySQL Breadcrumb Trail

Posted on June 19, 2002 by snipe in Featured, PHP/mySQL

This lets you automatically create a breadcrumb trail navigation through PHP and mySQL, that would look something like:

Home >> Parrots >> Red Parrots

This type of dynamic breadcrumb trail is only possible when you are storing the menu items (or categories) in a table, that contains at least a name, a category id number and [...]