View ezsql_encoding.php
// When creating a new connection just set the fifth parameter to the encoding you desire | |
// and ezDB will run a 'SET NAMES' query with your preferred encoding. | |
$db = new ezSQL_mysqli( | |
'username', | |
'password', | |
'database', | |
'localhost', | |
'UTF-8' | |
); |
View plural.php
// see if a string ends in 's' and add aprostrophes accordingly | |
// optionally adds an 's' to the end of a string depending if $count is supplied | |
function plural($str,$count=null) { | |
if($count != null) { | |
if($count == 0 || $count > 1) { | |
if(substr($str,-1) == 's') { | |
return $count.' '.$str; | |
} else { | |
return $count.' '.$str.'s'; | |
} |
View ezsql_transaction.php
// begin the transaction | |
$db->query('BEGIN'); | |
// run all of your queries here... | |
// commit the queries | |
if($db->query('COMMIT') !== false) { | |
// transaction was successful | |
} else { | |
// transaction failed, rollback |
View alfred-new-blog-for-jekyll.sh
#!/bin/bash | |
# In Alfred, create a new Blank Workflow and add a Keyword Input (Argument Required/uncheck With Space), mine is "new blog:" (without the quotes) | |
# Add a Run Script Action and make sure /bin/bash is selected in the Language dropdown | |
# Copy this Gist into the Run Script action (replacing the default text) | |
# Connect the Keyword action to the Run Script action | |
# Open an Alfred prompt and enter "new blog:My New Blog" without the quotes | |
# Watch the magic happen... | |