Snipplr

(PHP) Utility PHP function to paginate SQL queries - cburyta

Thu, 20 Mar 2008 20:33:32 GMT

(PHP) PHP escape for SQL - wbowers

Sun, 09 Mar 2008 01:27:06 GMT

(PHP) PHP Symfony クリテリアサンプル - daisuke103

Tue, 19 Feb 2008 18:44:26 GMT

(PHP) Build Nested Array From SQL - tylerhall

Wed, 19 Dec 2007 15:15:51 GMT

During the time that I’ve been programming I’ve continually run into times when I needed to be able to store a multi-level list into a database and retrieve it. I’ve used this in a CMS system to allow uses to create and nest their own menu options or to allow users to create and nest categories of items. Saving it was never a problem, but retrieving it and building a PHP array with nested structure was a messy task. The problem was that you couldn’t easily enter a variable four levels deep into an array without knowing all of the parents of that item. This was okay if you retrieved the data in order of parents, but that meant if you wanted to sort the data by another column (such as name), you would have to do multiple passes through your data to continually reshuffle it.

(PHP) Prevent SQL Injection - engel

Wed, 28 Nov 2007 09:25:01 GMT

Pass a user-inputted variable to this function in order to prevent SQL injection. Example: mysql_query("INSERT INTO table VALUES('" . sql_sanitize($_POST["variable") . "')"); Instead of: mysql_query("INSERT INTO table VALUES('" . $_POST["variable"] . "'");

(PHP) clean user input data ( GET, POST, COOKIE ) - peteypablonz

Wed, 21 Nov 2007 03:57:32 GMT

Created for my own purposes, thought I'd share though ;) copy paste at the top of your file and it does the magic :)

(PHP) SQL_mysql - MartinY

Thu, 19 Jul 2007 05:13:12 GMT

Clase para generar SQL's complejas

(PHP) Get HTML list of Array Keys - drwitt

Thu, 08 Feb 2007 04:50:20 GMT

(PHP) PHP - Limpiar inyección sql - nicolaspar

Wed, 03 Jan 2007 11:03:13 GMT

(PHP) SELECT with conditional WHERE parts - assbach

Fri, 15 Dec 2006 09:02:45 GMT

Building a SELECT with conditional WHERE parts, given from form-get parameters.

(PHP) The Sterilizer - Vanish

Thu, 07 Dec 2006 11:58:00 GMT

This function is used to cleanse user input data before creating queries to prevent SQL Injection attacks. This should also work to prevent XSS attempts through user input as well.