Welcome To Snipplr


Everyone's Recent Snippets Tagged mysql



2 1272 posted 18 years ago by hyperwhat
3 1670 posted 18 years ago by lmcdougall
2 1475 posted 18 years ago by micmath
0 1262 posted 18 years ago by micmath
Useful when your server runs out of disk space
1 1374 posted 18 years ago by benpjohnson
to use apostrophs in the field values i.e. st john's
0 1224 posted 18 years ago by valcartei
2 1478 posted 18 years ago by thebugslayer
Don't do it this way. This was written so long ago.
90 12567 posted 18 years ago by llbbl
1 1738 posted 18 years ago by llbbl
This class operates a range of mysql functions base on arrays. Example: Name: Description:
22 12143 posted 18 years ago by emuen
4 2929 posted 18 years ago by llbbl
Usage: $_POST = mysql_real_escape_array($_POST)
3 2781 posted 18 years ago by d4rk
13 2997 posted 19 years ago by johnself
Returns an array of values specified for an enumerated MySQL field
2 2063 posted 19 years ago by johnself
2 things here. currency (euro) with in a 2.00 format and select entries older than 4 weeks = 28 days
2 1815 posted 19 years ago by assbach
useful if a "valid until" should have an exact ( in this case far future ) value.
0 1324 posted 19 years ago by assbach
1 1682 posted 19 years ago by drwitt
Building a SELECT with conditional WHERE parts, given from form-get parameters.
1 1444 posted 19 years ago by assbach
1 1473 posted 19 years ago by Shpigford
This will return the number of seconds between now and when the time field was inserted.
0 2027 posted 19 years ago by wolfie
Simple but utilitarian function returns a numeric array of associative arrays containing an entire result set.
1 1879 posted 19 years ago by sorehead
This function first checks to see if PHP is set to automagically quote stuff. If it is, we first strip pre-quoted stuff, then (assuming our text isn't numeric), we properly quote everything. A good bit of room for improvement here, but at the very l...
1 1403 posted 19 years ago by sorehead
0 1231 posted 19 years ago by collin
1 1402 posted 19 years ago by gdonald