Welcome To Snipplr
Everyone's Recent Snippets Tagged query
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
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
5319
posted 5 years ago by interviewqueries
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
1096
posted 9 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
1208
posted 9 years ago by jefferis
coldfusion snippet to output a query recordset into multiple columns
1
1321
posted 10 years ago by dreamstarter
Now make a request to page.html?x=Hello:
console.log(getQueryVariable('x'));
0
941
posted 10 years ago by buda9
This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.
0
931
posted 11 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
1029
posted 11 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
1030
posted 11 years ago by edwinet
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
933
posted 12 years ago by o0110o
Snippet to show a simple use of the transient API when querying posts.
0
875
posted 12 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
1013
posted 12 years ago by satie83
Function to prevent sql injection in Like queries, where the characters '_' and '%' can be dangerous.
0
1118
posted 12 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
875
posted 12 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
1095
posted 12 years ago by lemcoe9
Snippet to illustrate the three actions that happen in all LINQ query operations.
0
1012
posted 12 years ago by denakitan
This will get the arguments on the query string and put them into a handy array.
0
996
posted 13 years ago by brownrl
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
891
posted 13 years ago by DenoteIt