Welcome To Snipplr

Everyone's Recent Snippets Tagged query

« Prev 1 2 3 4 5
In Laravel you can use "IN" query as Using Eloquent $data = YourModel::whereIn('id', array(1, 2, 3))->get(); Using DB Query builder $data = DB::table('your_table')->whereIn('id', array(1, 2, 3))->get();
0 875 posted 1 year ago by interviewqueries
Show the output of a query in a more readable vertical format
0 308 posted 4 years ago by rm1984
This is code you put in a CSS file. It queries the size of the screen using the parameters passed in. If its true, it then applies the CSS
0 304 posted 5 years ago by heathbo
Unlike linked style sheets, it is necessary to enclose CSS in Headers in a "style type". This example media query is for screens under 1024 (tablets and phones) to make sure the images do not extend beyond the layout.
0 301 posted 6 years ago by jefferis
coldfusion snippet to output a query recordset into multiple columns
1 344 posted 6 years ago by dreamstarter
Now make a request to page.html?x=Hello: console.log(getQueryVariable('x'));
0 212 posted 6 years ago by buda9
A couple of useful media queries...
1 279 posted 7 years ago by iroybot
Wrapper over JPA query that avoid flush
0 242 posted 7 years ago by pachaman
This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.
0 239 posted 7 years ago by edwinet
PostgreSQL wildcard search for any of a list of words, returns true or false depending on whether its pattern matches the given string.
0 242 posted 7 years ago by alecolucci
The sysprotects system table reports all of the permissions granted or denied in a given database. We'll need to join it with sysusers and sysobjects to get all the information we need. Here's an example query that only pulls information on objects (...
0 270 posted 7 years ago by edwinet
Get Parameter from url query string
0 288 posted 8 years ago by goo
I needed a quick way to target high-resolution graphics. Here was my final solution
0 237 posted 8 years ago by chrisaiv
If you need to get the whois information for a specific domain, why not using PHP to do it? The following function take a domain name as a parameter, and then display the whois info related to the domain.
1 258 posted 8 years ago by o0110o
Our theme's range of media queries
0 224 posted 8 years ago by vanseijen
Blank HTML template with minimal hosted srcs and respond.js
0 313 posted 8 years ago by jerryhdev
Snippet to show a simple use of the transient API when querying posts.
0 207 posted 8 years ago by Mat_
You could start a transaction before running your queries and then rollback after running them. Note that to do this you'll require InnoDB or XtraDb tables (won't work on MyISAM).
0 264 posted 8 years ago by satie83
Function to prevent sql injection in Like queries, where the characters '_' and '%' can be dangerous.
0 282 posted 8 years ago by TimoZachi
This function allow you ti have multiple parameters in your query string. Ex : id=12&name=Doe&id=42&nickname=Monster
0 211 posted 8 years ago by MonsterDev
Takes your table name and key=>value array of values and returns the text for inserting into a MySQL database. Automatically surrounds strings with single quotes.
1 242 posted 8 years ago by lemcoe9
Connect to and query a db2 database using php.
0 204 posted 8 years ago by zombree
Snippet to illustrate the three actions that happen in all LINQ query operations.
0 251 posted 8 years ago by denakitan
1 244 posted 8 years ago by paul0078
This will get the arguments on the query string and put them into a handy array.
0 258 posted 9 years ago by brownrl
0 212 posted 9 years ago by cesarkohl
Pass variables into javascript files using query strings, and return them using getJSvars() Example //HTML <script> //return the value of "foo" getJSvars('filename.js', 'foo');
0 217 posted 9 years ago by DenoteIt
0 249 posted 9 years ago by nickaranz
« Prev 1 2 3 4 5