16
2011
Helpful MySQL Query Functions and Tips
In case you’re wondering, I don’t just spend a couple hours a week throwing random bits of code onto this blog- I spend anywhere between 60- 100 hours per week making code my bitch. But thousands of hours and millions of lines of code later, I’m still occasionally stuck trying to remember a query (but then again when you’ve got most of the MySQL manual embedded in your brain, the info becomes hard to sort […]
26
2011
301 Redirect Using .htaccess
A commonly overlooked factor in search engine optimization for websites is the “to www or not to www” question. Singularly speaking, search engines have no preference for your site to contain the “www” prefix, however failure to specify can negatively impact your search engine rankings. Do note that in order for the .htaccess file modification below to function properly, your webserver must allow mod_rewrite. Consider the following scenario. You submit your xml sitemap to google. […]
Recent Snippets
- htaccess : Only allow access to specific wordpress upload types if logged in
- MySQL : Query WordPress Database for Invalid Media Filenames
- PHP : Get Actual IP Address with PHP
- JavaScript : Allow Tab in Textarea
- PHP : Clean sanitized database contents on output
- htaccess : Force www. prefix in URIs
- PHP : Force File Download with Correct Content Type
- Wordpress : Disable upgrade notification