Posts Tagged ‘mysql’
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 [...]
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 [...]
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 [...]
