Profile
Achievement
satie83's Recent Snippets
- All /
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...
0
2246
posted 9 years ago by satie83
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 Ber...
1
787
posted 10 years ago by satie83
I want to extract the numbers from a string that contains numbers and letters like
0
1017
posted 10 years ago by satie83
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.
1
624
posted 10 years ago by satie83
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.
0
690
posted 11 years ago by satie83
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
0
576
posted 11 years ago by satie83
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
807
posted 11 years ago by satie83