Welcome To Snipplr
Everyone's Recent PHP Snippets Tagged database
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
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
1245
posted 16 years ago by berkes
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
1019
posted 16 years ago by brownrl
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
1330
posted 16 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
1501
posted 16 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
1282
posted 16 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
1560
posted 16 years ago by jiggyhat
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
989
posted 16 years ago by philiph
PHP
Convert incorrectly-formatted UTF-8 strings of HTML into correctly-formatted UTF-8 strings of plain text.
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
2647
posted 16 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
2066
posted 17 years ago by jonhenshaw
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
2266
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
2589
posted 17 years ago by dom111
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
1471
posted 17 years ago by donkawechico