Welcome To Snipplr

Everyone's Recent PHP Snippets Tagged database

0 319 posted 11 years ago by chrismendis
0 385 posted 12 years ago by jose_506
0 451 posted 12 years ago by saturnxxi
Takes a .sql file and runs trough that, each line as an update_sql. Very usefull to track and migrate your blocks/views/cck etc changes.
0 362 posted 12 years ago by berkes
0 299 posted 12 years ago by iloveitaly
This is a long over due update to my db insert building function. Please not that the function is the important part the code below is just prove that it works... l:-)
1 307 posted 12 years ago by brownrl
1 397 posted 12 years ago by StrawMan
Use to get all database results on a SQL query
0 327 posted 12 years ago by erichelgesen
Use this function to print out all the rows in a table. Specify columns to show using the columnstring parameter: tablulardata(tablename, columnstring); ie: tabluardata("users","username=Username|fname=First Name|lname=Last Name");
1 351 posted 12 years ago by kilrizzy
Use this function to pull all columns from a single database field. getrowdata(tablename,rowid,prefix); You would call this function like: getrowdata("users",$_SESSION['user'],"user_"); The prefix is the prefix you want for the array names,...
1 373 posted 12 years ago by kilrizzy
For a client I needed a bit of code that could split one file (html, editable through wysiwyg editor) to multiple files, since all files would by default become very long. This code splits one file by the <h1> tag. Easy for end-users to set. Use CSS...
0 392 posted 12 years ago by axtg
This will create a Navigation from a MySQL database table names. It removes the table name "includes" by default so you can see how to remove any certain tables you wish to not use as a site section. Just plug in your MySQL database details and co...
3 386 posted 12 years ago by jiggyhat
8 393 posted 12 years ago by michaelfox
2 392 posted 12 years ago by iTony
paste it in wp-config.php and make sure the prefixes are right (wp_* is default) also the blogs must be installed on the same database with different prefixes. For example, you might have a primary blog with the table prefix wp_ on the database...
0 289 posted 12 years ago by philiph
Useful for taking incorrectly-formatted UTF-8 strings containing HTML data, and converting them to correctly-formatted UTF-8 plain text. A handy tool for displaying HTML stored in a database.
4 1165 posted 13 years ago by X3Maverick
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 500 posted 13 years ago by jonhenshaw
1 437 posted 13 years ago by ghwilson4456
I always forget how to do this...
2 326 posted 13 years ago by davidsword
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 504 posted 13 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 692 posted 13 years ago by dom111
0 357 posted 13 years ago by mikegreen
I deleted the old one by accident trying to edit it.
9 636 posted 13 years ago by mattkenefick
1 340 posted 13 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 424 posted 13 years ago by donkawechico