Snipplr

(PHP) Drupal function to return contents of a databasetable (for Debugging) - berkes

Fri, 01 Aug 2008 12:02:21 GMT

Drupal helper function to debug a table. Returns the contents and some explanation of a database table in a rendered format (HTML table). **NOTE** You REALLY do not want to put this function behind any kind of menu_callback and/or on other pages. Use it for debugging only: Because we return any contents, regardless of permissions and so forth, you potentially open up your site to data mining and or session hijacking!

(PHP) PHP - Lightweight Database and Rowset class, ActiveRecord style functions - dom111

Wed, 23 Jul 2008 18:59:13 GMT

Been wanting to made one of these for a while and finally I got round to it. For some examples please visit the post: http://www.dom111.co.uk/blog/coding/db/8 Any comments suggestions appreciated. CreativeCommons ShareAlike

(PHP) database class - ishkur

Tue, 22 Jul 2008 03:09:45 GMT

it's still a work in progress. There are a lot of things I would like to do with it, but I think how I have it set up now is pretty good for how i need it. It's essentially the backbone of a CMS project I have going (PaamayimCMS). One major feature that I would LOVE to add to it is chainability. I've been looking at the P4A project, and they claim to have a database wrapper that functions in a similar way to jQuery in regards to that. In due time i suppose.

(PHP) PEAR::DB MySQL Functions - mikegreen

Thu, 22 May 2008 11:26:26 GMT

(PHP) PHP Class: MySQL DB Class - mattkenefick

Thu, 22 May 2008 10:25:37 GMT

I deleted the old one by accident trying to edit it.

(PHP) PHP MySQL Connect - mikegreen

Wed, 21 May 2008 10:33:15 GMT

(PHP) Simple PHP ViewObject generator - donkawechico

Mon, 28 Apr 2008 18:54:13 GMT

Any time I make PHP applications that interact with a database, I use this script. It generates one or more self-populating "View Objects" (a class that represents a single record from a DB). For example, rather than access a MySQL record-set by array indices (e.g. $row[1]), you can populate an object with the record's values, and reference them like properties in an object (e.g. $productVO->price). To use: 1. Create a ".vo" file. For example, if you have a Products table, make "products.vo". 2. In this file, you will map column names to some string of your choice. This string will be used to name the getter/setter functions in the generated class. "get" and "set" will be pre-pended to these mapped names automatically, so don't include them. Like so: [column 1 name]:[desired function name] [column 2 name]:[desired function name] ... e.g. file "product.vo": id:Id price:Price desc:Description This will generate a class with functions "getId()", "getPrice()", and "getDescription()", returning the appropriate attribute. 3. Edit the folder names in the python source below to match your setup 4. Run ./voGenerator.py -a This will generate views for all ".vo" files in the directory specified in the python script as well as an "AllViews.php" file which, when included in your PHP code, imports all view files. View files take the form [filename]VO.php as in ProductVO.php To populate these objects, use the following snippit: function getAllProducts() { $products = array(); $row = array(); $result = query("SELECT * FROM products"); while ($row = mysql_fetch_assoc($result)) { $pVO = new ProductsVO; $pVO->populate($row); array_push($products, $pVO); } return $products; }

(PHP) PHP connecting and query MySQL DB - mswallace

Tue, 18 Mar 2008 23:13:05 GMT

(PHP) Remove Duplicate Rows - Abe

Tue, 29 Jan 2008 12:10:40 GMT

$duplicates checks and groups duplicated rows with the same field1 and field2 (like comments maybe) and $limit counts how many times a row is duplicated.

(PHP) MySQL Class Cheat Sheet - Abe

Mon, 28 Jan 2008 11:59:58 GMT

Cheat sheet for the MySQL Databse Class

(PHP) Usefull functions to work with MySQL under PHP5 - LoRd1990

Tue, 15 Jan 2008 09:55:45 GMT

(PHP) MYSQL Database Class - emuen

Sun, 27 May 2007 06:25:38 GMT

This class operates a range of mysql functions base on arrays. Example: Name: Description:

(PHP) MySQL Database Class - llbbl

Fri, 25 May 2007 15:03:58 GMT

(PHP) Get HTML list of Array Keys - drwitt

Thu, 08 Feb 2007 04:50:20 GMT

(PHP) ArticleHandler.class usage example - pietervp

Mon, 11 Dec 2006 10:02:29 GMT

This is an example of how to use the articleHandler.class.php , this class can be found @ pietervp.com -> downloads

(PHP) PHP - InversoMoltiplicativo - whitetiger

Thu, 09 Nov 2006 23:55:10 GMT

(PHP) Get Dropdown Options From Database - tylerhall

Thu, 12 Oct 2006 13:59:09 GMT

(PHP) Database Class - Corhol

Wed, 19 Jul 2006 23:42:21 GMT

(PHP) sanitizeTags, version 1.0 (Daniel Mota aka IceBeat) - alvaroisorna

Tue, 04 Jul 2006 06:37:57 GMT

Taken from Daniel Mota at http://icebeat.bitacoras.com/archivo/199/

(PHP) MySQL List Database Tables - neogeek

Sat, 01 Jul 2006 10:05:35 GMT

Fetch a list of tables in a specific database.