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.

(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

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

(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

(PHP) PHP - Function endswith - satie83

Sat, 31 Mar 2012 20:32:35 UTC

This function checks if the $stringComplete variable ends with the string $endString.

(PHP) PHP - Sorting of a key on a multi-dimensional array - satie83

Fri, 30 Mar 2012 22:54:52 UTC

A nice way to do sorting of a key on a multi-dimensional array - DavidG

(PHP) PHP - Convert an object to an associative array - satie83

Thu, 22 Mar 2012 22:25:56 UTC

Converts a php object to an associative array