Welcome To Snipplr
Everyone's Recent Snippets Tagged query
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
$quote -- name of function
post_type=page -- remove to query posts
orderby=rand -- random order
showposts=1 -- limit to 1 post
effect -- displays 1 random custom excerpt outside of the loop
1
2157
posted 17 years ago by davebowker
Split and manipulate URLs easily with this module. It has similar interface to Python's urlparse library. This is patched and modified version from Denis's orignal implementation.
1
2368
posted 17 years ago by miohtama
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0
2265
posted 17 years ago by ginoplusio
Allows you preserve and update a query string and it's existing values easily, instead of constantly appending the new value to the end of the query string
1
2167
posted 18 years ago by simplistik
It's easy to find the categories used on one item, but find all categories NOT used on current item?
This snippet stores a "NOT IN" query.
This is used with PHP & mySQL. The query can be written differently on other databases, but this seems to w...
0
2011
posted 18 years ago by stavelin
Nothing amazing here, just an efficient way to get the first row.
Be sure to set your ORDER BY clause properly.
0
2636
posted 18 years ago by stews
Replace all mysql_query() calls in your project to debug_mysql_query() to see all mysql queries in Firebug console.
1
2233
posted 18 years ago by stancell
Properly escapes the query string, according to http://code.google.com/apis/searchappliance/documentation/46/xml_reference.html#appendix_url_escaping
3
2282
posted 18 years ago by AndrewVos
I often find something like this lurking at the end of my base templates - it'll show you which queries were run while generating the current page, but they'll start out hidden so as not to be a pain.
Of course, before this works, you'll need to s...
1
2490
posted 18 years ago by jonhenshaw
I modified some code created by Macromedia Dreamweaver into a flexible function to rebuild the query string. The function is very useful for pagination or passing variables from one page to another.In this version it's possible to add more than one v...
1
1984
posted 18 years ago by gbot
This is a simple class to encapsulate CURD functions. This class also includes some simple search methods.
1
2556
posted 18 years ago by ecavazos
This function extracts a value from a url. Very useful for tracking codes. For example, you have a url http://your.url/?source=666999, and you need the source number to be placed into a variable. Use the code below.
2
2226
posted 19 years ago by 1man
in javascript use, for example: myJsonObject["js007"].firstname + ' ' + myJsonObject["js007"].lastnamename
to return James Bond
1
2110
posted 19 years ago by markireland