Welcome To Snipplr


Everyone's Recent Snippets Tagged database



This is a simple but powerful tweak to the wp-config.php file that will make it easy to run multiple websites using one database and codebase. Simply change "yourdomain.com" with your domain and that's it. Repeat that line for new domains.
2 2225 posted 17 years ago by jonhenshaw
1 2555 posted 17 years ago by ghwilson4456
0 4381 posted 17 years ago by webonomic
I always forget how to do this...
2 1509 posted 17 years ago by davidsword
Active Record ORM implementation in ActionScript 3 for AIR's SQLite DB
0 1008 posted 17 years ago by bendalton
0 1264 posted 17 years ago by DaveChild
This script should be run from the "master" database. It will destroy the dev copy of a database and restore from the live copy. Code slightly modified from original (linked).
0 1192 posted 17 years ago by DaveChild
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....
1 2467 posted 17 years ago by berkes
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
3 2750 posted 17 years ago by dom111
0 1374 posted 17 years ago by mikegreen
I deleted the old one by accident trying to edit it.
9 3039 posted 17 years ago by mattkenefick
0 1028 posted 17 years ago by Meestercor
1 1369 posted 17 years ago by mikegreen
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 arra...
1 1596 posted 17 years ago by donkawechico
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 s...
0 1805 posted 17 years ago by zingo
0 1358 posted 17 years ago by jpdamen
Courtesy of Jesse.
2 1794 posted 18 years ago by ches
1 1281 posted 18 years ago by bassnode
You can generate a simple bar chart of the values by executing this command...
0 1430 posted 18 years ago by zingo
Gets an mp3 player to play mp3s which contain all the phrases given as arguments. Locate is much faster than xmms' library, usually in split a second. This is very handy, when you install a command-line into the wm panel. Creates files /locate.0, /...
1 1415 posted 18 years ago by Adek336
This class operates a range of mysql functions base on arrays. Example: Name: Description:
22 10149 posted 18 years ago by emuen