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
700
posted 15 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
851
posted 15 years ago by miohtama
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0
745
posted 15 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
868
posted 15 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
625
posted 15 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
1029
posted 15 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
878
posted 15 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
853
posted 16 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
900
posted 16 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
635
posted 16 years ago by gbot
This is a simple class to encapsulate CURD functions. This class also includes some simple search methods.
1
792
posted 16 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
753
posted 17 years ago by 1man
in javascript use, for example: myJsonObject["js007"].firstname + ' ' + myJsonObject["js007"].lastnamename
to return James Bond
1
702
posted 17 years ago by markireland