Snipplr

(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.

(Other) listValues function - Meestercor

Thu, 22 May 2008 08:21:46 GMT

(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; }

(Visual Basic) Excel spreadsheet to MySQL Table inserts - jeffreality

Thu, 24 Apr 2008 17:41:39 GMT

(SQL) Storing an IP address in a database table - zingo

Wed, 09 Apr 2008 20:31:52 GMT

You can store an IP address in an INT UNSIGNED (4 bytes) which is of course much more efficient and faster than a CHAR(15). MySQL has two built-in functions: INET_ATON() and INET_NTOA(). These two functions are used allover the place in any TCP/IP stack implementation or even application. The INET_ATON() function converts Internet addresses from the numbers-and-dots notation into a 32-bit unsigned integer, and INET_NTOA() does the opposite.

(PHP) PHP connecting and query MySQL DB - mswallace

Tue, 18 Mar 2008 23:13:05 GMT

(SQL) TSQL to Reset a Tables Primary Key Autonumber - rengber

Sun, 17 Feb 2008 20:42:49 GMT

(Other) YAML Symfony database.ymlの初期設定 - daisuke103

Wed, 13 Feb 2008 00:43:41 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

(C#) xml handler - zvasanth

Sat, 29 Dec 2007 02:02:52 GMT

Everything is either true or untrue, or both true and untrue, or neither true nor untrue

(R) typo3 open database connection - jpdamen

Fri, 21 Dec 2007 18:32:18 GMT

(Ruby) Ruby One-liner for Restoring One Table from a Huge SQL Dump - ches

Tue, 27 Nov 2007 10:55:45 GMT

Courtesy of Jesse.

(SQL) MySQL LOAD DATA INFILE with WHERE - bassnode

Thu, 15 Nov 2007 15:22:18 GMT

(SQL) Ordering multiple SELECT statements in a UNION - andyhartleeds

Tue, 06 Nov 2007 08:43:28 GMT

(SQL) Generate Simple Bar Charts From a MySQL Prompt - zingo

Fri, 19 Oct 2007 00:40:13 GMT

You can generate a simple bar chart of the values by executing this command...

(SQL) List all Stored Procedures in an Oracle Database - rengber

Mon, 24 Sep 2007 15:31:54 GMT