Snipplr

(PHP) How to use "IN" Query in Laravel ? - interviewqueries

Sat, 14 Sep 2019 16:27:07 UTC

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();

(MySQL) Show the output of a query in a more readable vertical format - rm1984

Thu, 30 Jun 2016 18:33:28 UTC

Show the output of a query in a more readable vertical format

(CSS) CSS: Media Query - heathbo

Sat, 03 Oct 2015 03:01:44 UTC

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

(CSS) Sample Media Query in html Header - jefferis

Sat, 24 Jan 2015 09:39:57 UTC

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.

(ColdFusion) Query output into multiple columns - dreamstarter

Tue, 15 Jul 2014 23:01:10 UTC

coldfusion snippet to output a query recordset into multiple columns

(CSS) fast and easy way of parsing query strings in JavaScript - buda9

Tue, 13 May 2014 03:52:18 UTC

Now make a request to page.html?x=Hello: console.log(getQueryVariable('x'));

(CSS) Media Queries (for Responsive Web Design) - iroybot

Fri, 20 Sep 2013 07:05:56 UTC

A couple of useful media queries...

(Java) JPA NonFlushableQueryWrapper - pachaman

Thu, 12 Sep 2013 20:30:18 UTC

Wrapper over JPA query that avoid flush

(SQL) Viewing Trigger Order (First and Last) - edwinet

Tue, 23 Apr 2013 01:11:25 UTC

This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.

(SQL) PostgreSQL wildcard search for any of a list of words - alecolucci

Wed, 27 Mar 2013 01:58:53 UTC

PostgreSQL wildcard search for any of a list of words, returns true or false depending on whether its pattern matches the given string.

(SQL) Auditing SQL Server User and Role Permissions for Databases - edwinet

Fri, 08 Mar 2013 01:47:47 UTC

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 (no CREATE TABLE permissions or anything else at the database level)

(JavaScript) [JAVASCRIPT] Get Parameter from url query string - goo

Mon, 21 Jan 2013 05:20:32 UTC

Get Parameter from url query string

(CSS) CSS: Retina display media query - chrisaiv

Sat, 05 Jan 2013 04:51:41 UTC

I needed a quick way to target high-resolution graphics. Here was my final solution

(PHP) Get Whois Information. - o0110o

Fri, 26 Oct 2012 01:36:14 UTC

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.

(CSS) Theme media queries - vanseijen

Thu, 25 Oct 2012 19:27:11 UTC

Our theme's range of media queries

(HTML) Blank HTML template with hosted src, viewport & respond.js - jerryhdev

Fri, 12 Oct 2012 10:09:52 UTC

Blank HTML template with minimal hosted srcs and respond.js

(PHP) Query posts and cache the query - Mat_

Wed, 03 Oct 2012 19:56:43 UTC

Snippet to show a simple use of the transient API when querying posts.

(MySQL) MySQL - Simulate MySQL Queries - satie83

Thu, 20 Sep 2012 20:29:21 UTC

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).

(PHP) Prevent sql injection in LIKE queries - TimoZachi

Wed, 25 Jul 2012 08:37:04 UTC

Function to prevent sql injection in Like queries, where the characters '_' and '%' can be dangerous.

(PHP) Uri multiple parameters - MonsterDev

Sat, 14 Jul 2012 02:02:37 UTC

This function allow you ti have multiple parameters in your query string. Ex : id=12&name=Doe&id=42&nickname=Monster

(PHP) MySQL INSERT Query Generator w/ Strings - lemcoe9

Fri, 13 Jul 2012 02:39:08 UTC

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.

(PHP) db2 connect and query - zombree

Thu, 17 May 2012 01:52:16 UTC

Connect to and query a db2 database using php.

(C#) .NET - LINQ - C# - Basics - Examples - The Three Parts of a LINQ Query - denakitan

Thu, 19 Apr 2012 05:42:05 UTC

Snippet to illustrate the three actions that happen in all LINQ query operations.

(PHP) Run MySQL query - paul0078

Sun, 15 Apr 2012 20:16:34 UTC

(JavaScript) Get Query String Args Javascript - brownrl

Fri, 23 Sep 2011 17:33:12 UTC

This will get the arguments on the query string and put them into a handy array.

(SQL) if mysql_query is not empty - cesarkohl

Mon, 19 Sep 2011 22:49:26 UTC

(JavaScript) Pass variables into javascript via query strings - DenoteIt

Wed, 14 Sep 2011 22:01:08 UTC

Pass variables into javascript files using query strings, and return them using getJSvars() Example //HTML