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
2652
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
970
posted 11 years ago by satie83
I want to extract the numbers from a string that contains numbers and letters like
0
1287
posted 11 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
802
posted 11 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
876
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
755
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
1002
posted 12 years ago by satie83