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
850
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
1018
posted 15 years ago by miohtama
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0
907
posted 16 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
1027
posted 16 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
787
posted 16 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
1207
posted 16 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
1038
posted 16 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
1013
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
1072
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
754
posted 16 years ago by gbot
This is a simple class to encapsulate CURD functions. This class also includes some simple search methods.
1
948
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
931
posted 17 years ago by 1man
in javascript use, for example: myJsonObject["js007"].firstname + ' ' + myJsonObject["js007"].lastnamename
to return James Bond
1
840
posted 17 years ago by markireland