Snipplr

(PHP) PHP - Doctrine - Left join ON condition AND other condition syntax in Doctrine - satie83

Fri, 20 Mar 2015 00:36:12 UTC

In SQL I can get this by adding AND to the join LEFT JOIN installations i ON a.id = i.app AND i.page = :page This way I get the installation info for an app that has an installation on the page, but I get null values on the columns for app's that have installations on other pages or not at all. Is there a way to do this in Doctrine or am I better off just getting all the installations for each application and then checking against the found page with php? ########################################################################## See function leftJoin in doc: http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/query-builder.html#high-level-api-methods

(PHP) PHP - Calculate Weekends and Holidays in PHP - satie83

Fri, 16 Aug 2013 00:49:22 UTC

Der folgende Codeschnipsel enthÃ¤lt keinerlei ÃœberprÃ¼fungen der Ã¼bergebenen Parameter, diese sollten fÃ¼r den produktiven Einsatz noch nachgepflegt werden. Wie man sieht, ist die Berechnung von Wochendenden und Feiertagen recht einfach. Diese Berechnung kann man sicherlich auch schnell in anderen Programmiersprachen abbilden.

(JavaScript) Javascript - Validate number of days in a given month - satie83

Fri, 12 Jul 2013 19:08:59 UTC

How would you validate the number of days in a given month?

(PHP) PHP - Extract numbers from a string - satie83

Fri, 28 Jun 2013 00:52:31 UTC

I want to extract the numbers from a string that contains numbers and letters like

(Bash) GIT - Get the commits that occured between two dates - satie83

Wed, 26 Jun 2013 02:04:03 UTC

How to obtain all the commits that occurred between two dates

(jQuery) jQuery - Function on toggleClass complete - satie83

Fri, 14 Jun 2013 23:51:13 UTC

How can I do a function once a toggleClass has completed? The .toggleClass method along with all other animation methods return a deferred object that you can access using .promise(). At that point, you can bind to it's done method.

(JavaScript) Javascript - How to know if an object is Empty - satie83

Thu, 13 Jun 2013 02:24:27 UTC

Assuming that by empty means "has no properties of its own"

(Bash) GIT - Restore a deleted file in a Git repo - satie83

Thu, 18 Apr 2013 01:26:12 UTC

Say I'm in a Git repository. I delete a file and commit that change. I continue working and make some more commits. Then, I find I need to restore that file.

(CSS) CSS - Spacing between thead and tbody - satie83

Thu, 11 Apr 2013 23:09:00 UTC

Spacing between thead and tbody

(JavaScript) JavaScript - Get Cookies - satie83

Wed, 16 Jan 2013 22:10:22 UTC

The following function loads all browser-cookies into an associative array with the cookie name as the index and the cookie value as the value

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

(CSS) CSS - Add a drop cap - satie83

Sun, 12 Aug 2012 10:10:47 UTC

(CSS) CSS - Using transparency â€“ opacity - satie83

Sun, 12 Aug 2012 10:10:40 UTC

(CSS) CSS - Rotating an image or text â€“ transform - satie83

Sun, 12 Aug 2012 10:10:37 UTC

(CSS) CSS - Resize your background image - satie83

Sun, 12 Aug 2012 10:10:28 UTC

(CSS) CSS - Replacing the title text with a logo â€“ text-indent â€“ text-indent - satie83

Sun, 12 Aug 2012 10:10:20 UTC

(CSS) CSS - Quickly create pull-quotes - satie83

Sun, 12 Aug 2012 10:10:14 UTC

(CSS) CSS - Having multiple columns - satie83

Sun, 12 Aug 2012 10:09:57 UTC

(CSS) CSS - Giving your footer a fixed position â€“ position:fixed - satie83

Sun, 12 Aug 2012 10:09:53 UTC

(CSS) CSS - Flipping an image â€“ transform - satie83

Sun, 12 Aug 2012 10:09:49 UTC

(CSS) CSS - File format-dependent link styles - satie83

Sun, 12 Aug 2012 10:09:44 UTC

(CSS) CSS - Eric Meyers CSS reset - satie83

Sun, 12 Aug 2012 10:09:39 UTC

(CSS) CSS - Changing the size of your content area - satie83

Sun, 12 Aug 2012 10:09:31 UTC

(CSS) CSS - Center your website horizontally - satie83

Sun, 12 Aug 2012 10:09:30 UTC

(CSS) CSS - Center certain content vertically - satie83

Sun, 12 Aug 2012 10:09:29 UTC

(CSS) CSS - Basic Link Rollover as CSS Sprite - satie83

Sun, 12 Aug 2012 10:09:28 UTC

(CSS) CSS - Bulletproof @fontface - satie83

Sun, 12 Aug 2012 10:09:28 UTC

(CSS) CSS - Adding shadow to text â€“ text-shadow - satie83

Sun, 12 Aug 2012 10:09:26 UTC

(CSS) CSS - Adding shadow to borders and images â€“ box-shadow - satie83

Sun, 12 Aug 2012 10:09:24 UTC

(CSS) CSS - Adding rounded corners â€“ border-radius - satie83

Sun, 12 Aug 2012 10:09:20 UTC

(CSS) CSS - Adding print page breaks â€“ page-break - satie83

Sun, 12 Aug 2012 10:09:15 UTC

(CSS) CSS - Adding Google fonts - satie83

Sun, 12 Aug 2012 10:09:12 UTC

(CSS) CSS - Adding an image-based border â€“ border-image - satie83

Sun, 12 Aug 2012 10:09:09 UTC

(CSS) CSS - Adding a gradient â€“ linear-gradient - satie83

Sun, 12 Aug 2012 10:09:07 UTC

(CSS) CSS - Add a â€œloading imageâ€ to, well, loading images - satie83

Sun, 12 Aug 2012 10:09:04 UTC

(CSS) CSS - Reset all colors and change link color - satie83

Sun, 12 Aug 2012 10:07:35 UTC

(CSS) CSS - Adding shadow to text â€“ text-shadow - satie83

Sun, 12 Aug 2012 09:43:36 UTC

Helps make your text stand out from the rest

(Bash) GIT - How to get just one file from another branch - satie83

Thu, 26 Jul 2012 22:39:35 UTC

I am using git and working on master branch. This branch has a file called app.js . I have an experiment branch in which I made a bunch of changes and tons of commit. Now I want to bring all the changes done only to app.js from experiment to master branch.

(Bash) GIT - Search trough all commits in the repository - satie83

Mon, 23 Jul 2012 19:30:34 UTC

I have a Git repository with few branches and dangling commits. I would like to search all such commits in repository for a specific string.

(PHP) PHP - Remove all non-numeric characters - satie83

Fri, 20 Jul 2012 22:17:59 UTC

Sometimes itâ€™s helpful to ONLY get numeric characters. Phone numbers, age â€” whatever your little PHP heart desires.

(PHP) PHP - How to check if string contains substring PHP - satie83

Wed, 18 Jul 2012 20:48:04 UTC

Once in a while we need to check whether a string contains substring, some other string or characters or a value. Checking for existence of a string (or substring) inside another string is easier than it might seem. The following article describes how to check for whether a string contains string in PHP, or simply said how to find string within string in PHP.

(Bash) GIT - List of stale remote-tracking branches - satie83

Mon, 16 Jul 2012 22:20:47 UTC

Youâ€™ll receive a list of your stale remote-tracking branches. If you run it without â€“dry-run option, it will remove them for you.

(JavaScript) Javascript - Debugging Javascript as PHP / Function var_dump - satie83

Mon, 09 Jul 2012 23:46:45 UTC

In javascript there is no function for printing variables like you have PHP, I use print_r and var_dump a lot in PHP for dumping variables so I wanted to create a simular function in javascript.

(Bash) GIT - Editing an incorrect commit message - satie83

Thu, 05 Jul 2012 01:57:55 UTC

It's necessary that the commit hasn't pushed by anyone

(Bash) GIT - Find out which is the remote branch, which is tracked by a local branch - satie83

Wed, 27 Jun 2012 20:47:05 UTC

This shows the local and remote branches along with the most recent commit for each branch.

(Bash) GIT - List all the files for a commit (or various commits) in git - satie83

Thu, 21 Jun 2012 02:11:14 UTC

Hash of the commit which you want to show a303aa90779efdd2f6b9d90693e2cbbbe4613c1d

(PHP) PHP - Getting Yesterday\'s Date in PHP - satie83

Tue, 12 Jun 2012 20:46:33 UTC

Example calculate yesterday, but if you multiply by some number you can get in an easy way, weeks, months or years

(jQuery) jQuery: Numbering an Unordered List - satie83

Thu, 17 May 2012 22:37:41 UTC

Hereâ€™s a very simple script which adds numbers sequentially to an unordered list using jQuery

(C#) IsPageRefresh in ASP .NET - Preventing previously submitted - satie83

Thu, 17 May 2012 22:35:19 UTC

How do I prevent previously submitted form data from being reinserted into the database when the user presses the browser's Refresh button? Although it is not possible due to unique key constraint available in tables but it is unnecessary go to other layer (data access, business layer).

(Objective C) Image resize with CI - satie83

Thu, 17 May 2012 22:18:42 UTC

Core Image provides a lot of filter to apply to images. Here there is a snippet to modify the size of the image using the Lanczos algorithm. You have to give the image URL and the ratio of the scale. If the ratio is smaller than 1 it reduce, otherwise it enlarges the image.

Snipplr

(PHP) PHP - Doctrine - Left join ON condition AND other condition syntax in Doctrine - satie83

(PHP) PHP - Calculate Weekends and Holidays in PHP - satie83

(JavaScript) Javascript - Validate number of days in a given month - satie83

(PHP) PHP - Extract numbers from a string - satie83

(Bash) GIT - Get the commits that occured between two dates - satie83

(jQuery) jQuery - Function on toggleClass complete - satie83

(JavaScript) Javascript - How to know if an object is Empty - satie83

(Bash) GIT - Restore a deleted file in a Git repo - satie83

(CSS) CSS - Spacing between thead and tbody - satie83

(JavaScript) JavaScript - Get Cookies - satie83

(MySQL) MySQL - Simulate MySQL Queries - satie83

(CSS) CSS - Add a drop cap - satie83

(CSS) CSS - Using transparency â€“ opacity - satie83

(CSS) CSS - Rotating an image or text â€“ transform - satie83

(CSS) CSS - Resize your background image - satie83

(CSS) CSS - Replacing the title text with a logo â€“ text-indent â€“ text-indent - satie83

(CSS) CSS - Quickly create pull-quotes - satie83

(CSS) CSS - Having multiple columns - satie83

(CSS) CSS - Giving your footer a fixed position â€“ position:fixed - satie83

(CSS) CSS - Flipping an image â€“ transform - satie83

(CSS) CSS - File format-dependent link styles - satie83

(CSS) CSS - Eric Meyers CSS reset - satie83

(CSS) CSS - Changing the size of your content area - satie83

(CSS) CSS - Center your website horizontally - satie83

(CSS) CSS - Center certain content vertically - satie83

(CSS) CSS - Basic Link Rollover as CSS Sprite - satie83

(CSS) CSS - Bulletproof @fontface - satie83

(CSS) CSS - Adding shadow to text â€“ text-shadow - satie83

(CSS) CSS - Adding shadow to borders and images â€“ box-shadow - satie83

(CSS) CSS - Adding rounded corners â€“ border-radius - satie83

(CSS) CSS - Adding print page breaks â€“ page-break - satie83

(CSS) CSS - Adding Google fonts - satie83

(CSS) CSS - Adding an image-based border â€“ border-image - satie83

(CSS) CSS - Adding a gradient â€“ linear-gradient - satie83

(CSS) CSS - Add a â€œloading imageâ€ to, well, loading images - satie83

(CSS) CSS - Reset all colors and change link color - satie83

(CSS) CSS - Adding shadow to text â€“ text-shadow - satie83

(Bash) GIT - How to get just one file from another branch - satie83

(Bash) GIT - Search trough all commits in the repository - satie83

(PHP) PHP - Remove all non-numeric characters - satie83

(PHP) PHP - How to check if string contains substring PHP - satie83

(Bash) GIT - List of stale remote-tracking branches - satie83

(JavaScript) Javascript - Debugging Javascript as PHP / Function var_dump - satie83

(Bash) GIT - Editing an incorrect commit message - satie83

(Bash) GIT - Find out which is the remote branch, which is tracked by a local branch - satie83

(Bash) GIT - List all the files for a commit (or various commits) in git - satie83

(PHP) PHP - Getting Yesterday\'s Date in PHP - satie83

(jQuery) jQuery: Numbering an Unordered List - satie83

(C#) IsPageRefresh in ASP .NET - Preventing previously submitted - satie83

(Objective C) Image resize with CI - satie83

(CSS) CSS - Add a â€œloading imageâ€ to, well, loading images - satie83