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
713
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
872
posted 15 years ago by miohtama
When you make a login remember to use CASE SENSITIVE on password and case insensitive on username
0
761
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
885
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
651
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
1061
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
900
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
876
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
934
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
655
posted 16 years ago by gbot
This is a simple class to encapsulate CURD functions. This class also includes some simple search methods.
1
812
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
765
posted 17 years ago by 1man
in javascript use, for example: myJsonObject["js007"].firstname + ' ' + myJsonObject["js007"].lastnamename
to return James Bond
1
711
posted 17 years ago by markireland