Advanced Search

Welcome To Snipplr

Everyone's Recent PHP Snippets Tagged mysql

Simple way to escape string for LIKE statements, useful for searches.
3 587 posted 15 years ago by robv
1 674 posted 15 years ago by apro2000
Export entire database schema to local xml file.
1 675 posted 15 years ago by jonniespratley
2 737 posted 15 years ago by iTony
Database backup function that you can call whenever you want — including nightly CRONs.
6 873 posted 15 years ago by fackz
0 577 posted 15 years ago by jonniespratley
I am currently still working on this, and will make changes.
1 729 posted 15 years ago by jonniespratley
I needed to have a cron job that did some MySQL work iterating through a long list of items based on the content of a table in MySQL. I wanted each item in the table to be iterated over roughly once every 5 minutes, but building up the in-memory lis...
0 578 posted 15 years ago by cori
0 559 posted 15 years ago by stavelin
# Export MySQL Data as CSV This code takes a `mysql_query()` resource and outputs its rows into CSV spreadsheet format. Edit the `header('Content-Disposition...` declaration to tell the user's browser to either display the data as plain text or do...
6 837 posted 15 years ago by mikegreen
1 669 posted 15 years ago by iTony
Simple but useful function for getting a single piece of data from a database and placing it straight into a variable. Example: $variable = one_result("SELECT columnOne FROM table WHERE columnTwo=whatever"); This would insert the value of colu...
1 467 posted 15 years ago by iridium
Quick little snippet for changing the ordering of a field in a MYSQL database.
1 850 posted 15 years ago by Zync
This will create a list grouped by the sorted field, which is an inner join on a category field.
0 509 posted 15 years ago by fostersolutions
2 569 posted 15 years ago by czapata
0 561 posted 15 years ago by iTony
Here is a working example on how to sort data in a grid.
1 707 posted 15 years ago by assaado
1 500 posted 15 years ago by assaado
make a query and retrieve the first record, if error occurs show it and the query.
0 454 posted 15 years ago by ginoplusio
retrieve only one value from the query
0 596 posted 15 years ago by ginoplusio
0 633 posted 15 years ago by sebus
1 791 posted 15 years ago by ghwilson4456
Replace all mysql_query() calls in your project to debug_mysql_query() to see all mysql queries in Firebug console.
1 860 posted 15 years ago by stancell
3 662 posted 15 years ago by antpaw
Simplified form to extract data through MySQL
0 522 posted 15 years ago by LondonWeb
1 488 posted 15 years ago by LondonWeb
14 926 posted 15 years ago by iTony
3 725 posted 15 years ago by benphelps
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 1201 posted 15 years ago by dom111