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 2985 posted 3 years ago by interviewqueries
Show the output of a query in a more readable vertical format
0 727 posted 6 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 679 posted 7 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 729 posted 8 years ago by jefferis
coldfusion snippet to output a query recordset into multiple columns
1 833 posted 8 years ago by dreamstarter
Now make a request to page.html?x=Hello: console.log(getQueryVariable('x'));
0 559 posted 8 years ago by buda9
A couple of useful media queries...
1 653 posted 9 years ago by iroybot
Wrapper over JPA query that avoid flush
0 537 posted 9 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 557 posted 9 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 615 posted 10 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 635 posted 10 years ago by edwinet
Get Parameter from url query string
0 724 posted 10 years ago by goo
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 569 posted 10 years ago by o0110o
Our theme's range of media queries
0 505 posted 10 years ago by vanseijen
Blank HTML template with minimal hosted srcs and respond.js
0 734 posted 10 years ago by jerryhdev
Snippet to show a simple use of the transient API when querying posts.
0 488 posted 10 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 602 posted 10 years ago by satie83
Function to prevent sql injection in Like queries, where the characters '_' and '%' can be dangerous.
0 668 posted 10 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 533 posted 10 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 621 posted 10 years ago by lemcoe9
Connect to and query a db2 database using php.
0 509 posted 10 years ago by zombree
Snippet to illustrate the three actions that happen in all LINQ query operations.
0 631 posted 10 years ago by denakitan
1 600 posted 10 years ago by paul0078
This will get the arguments on the query string and put them into a handy array.
0 592 posted 11 years ago by brownrl
0 538 posted 11 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 515 posted 11 years ago by DenoteIt
0 611 posted 11 years ago by nickaranz
Gets random data from a table. Modify as required.
0 768 posted 11 years ago by stwsimon
« Prev 1 2 3 4 5