KLIF Media v2

Since Asia Expat requested a very similar design to KLIF Media v1, I had to design/develop a new theme for KLIF Media. This was the result. Mainly a redesign with quite abit of code refactoring.

Software: Photoshop, NetBeans
Languages/Frameworks: WordPress, HTML5, CSS3, jQuery, jQuery UI, PHP, MySQL

Live Site

Hi-res

Google Web Fonts V2

New, improved, bigger, better, etc.

(Source: decodering, via gregbabula)

TumblrThemr

decodering:

Creating themes for Tumblr sucks.

It’s a testament to the passion developers and designers feel for Tumblr that so many great themes exist – despite the complete lack of tools. No matter how you tackle it, developing a theme involves a time-consuming mess of manual copying and pasting, saving, testing, and copying and pasting again.

TumblrThemr solves this problem, letting you develop navigable themes locally using real data from your Tumblr blog.

How it works

1. You install our special Tumblr theme that outputs your blog’s data into machine-friendly XML.
2. We have a web service which converts and escapes that XML into a JSON data source for client-side templating.
3. We interpret your custom tumblr file and render it using your data.
4. Then we hijack your theme’s links to reload different pages locally.
5. Voila, local Tumblr theme development!

I can’t wait to try this out!

Quick Tip: Debugging MySQL with MySQL’s General Log

Sometimes when developing in PHP esp with Frameworks like Doctrine, I don’t know what SQL is executed so when I get an error like

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1

I don’t know whats the SQL, the error just says “near ‘ASC’” but I don’t know whats before and after that.

I found that enabling MySQL General Query Log will help things

I can’t seem to enable it via CLI

> mysqld --general_log=1 --general_log_file="/path/to/log"

But I got it working within MySQL

> set global general_log = 'ON';

As you run your app, you can see what queries are run in your log eg “mysql data dir/host.log”

110101 11:18:02    26 Connect   root@localhost on tickle
       26 Query SELECT l0_.id AS id0, l0_.name AS name1, l0_.seq AS seq2, l0_.owner_id AS owner_id3, l0_.project_id AS project_id4 FROM lists l0_ WHERE l0_.id = 1
       26 Query SELECT t0.id AS id1, t0.name AS name2, t0.seq AS seq3, t0.owner_id AS owner_id4, t0.assigned_id AS assigned_id5, t0.list_id AS list_id6 FROM tasks t0 WHERE list_id = '1' ORDER BY t0.seq ASC, t0.id DESC
       26 Query SELECT t0.id AS id1, t0.due AS due2, t0.completed AS completed3, t0.task_id AS task_id4, t0.stage_id AS stage_id5 FROM task_progress t0 WHERE task_id = '2'
       26 Query SELECT t0.id AS id1, t0.due AS due2, t0.completed AS completed3, t0.task_id AS task_id4, t0.stage_id AS stage_id5 FROM task_progress t0 WHERE task_id = '1'
       26 Query SELECT t0.id AS id1, t0.seq AS seq2, t0.name AS name3, t0.list_id AS list_id4 FROM stages t0 WHERE t0.id = '1'
       26 Query SELECT t0.id AS id1, t0.seq AS seq2, t0.name AS name3, t0.list_id AS list_id4 FROM stages t0 WHERE t0.id = '2'
       26 Query SELECT t0.id AS id1, t0.seq AS seq2, t0.name AS name3, t0.list_id AS list_id4 FROM stages t0 WHERE t0.id = '3'
       26 Query SELECT t0.id AS id1, t0.seq AS seq2, t0.name AS name3, t0.list_id AS list_id4 FROM stages t0 WHERE list_id = '1' ORDER BY t0.seq ASC
       26 Query SELECT t0.id AS id1, t0.due AS due2, t0.completed AS completed3, t0.task_id AS task_id4, t0.stage_id AS stage_id5 FROM task_progress t0 WHERE stage_id = '1'
       26 Query SELECT t0.id AS id1, t0.due AS due2, t0.completed AS completed3, t0.task_id AS task_id4, t0.stage_id AS stage_id5 FROM task_progress t0 WHERE stage_id = '2'
       26 Query SELECT t0.id AS id1, t0.due AS due2, t0.completed AS completed3, t0.task_id AS task_id4, t0.stage_id AS stage_id5 FROM task_progress t0 WHERE stage_id = '3'
       26 Query SELECT t0.id AS id1, t0.due AS due2, t0.completed AS completed3, t0.task_id AS task_id4, t0.stage_id AS stage_id5 FROM task_progress t0 WHERE stage_id = '4'
       26 Query START TRANSACTION
       26 Query INSERT INTO stages (list_id, seq, name) VALUES (1, 1, 'New')
       26 Query INSERT INTO task_progress (task_id, stage_id, due, completed) VALUES (1, 21, NULL, '2011-01-02 00:00:00')
       26 Query DELETE FROM task_progress WHERE id = '9'
       26 Query DELETE FROM task_progress WHERE id = '10'
       26 Query DELETE FROM task_progress WHERE id = '11'
       26 Query DELETE FROM stages WHERE id = '1'
       26 Query DELETE FROM stages WHERE id = '2'
       26 Query DELETE FROM stages WHERE id = '3'
       26 Query DELETE FROM stages WHERE id = '4'
       26 Query COMMIT
       26 Quit  

Hi-res

I sometimes want to get the script name, or some other attribute of $_SERVER but am not sure which should I use, so I made this screen capture summarizing what values I get for each attribute of $_SERVER when I request for http://localhost/php/sql-injection.php?var1=2&var3=baz & http://localhost.com/php/sql-injection.php?var1=2&var3=baz

HTTP_HOST vs SERVER_NAME

via StackOverflow

HTTP_HOST is obtained from the HTTP request header … SERVER_NAME is definied in server config … the one is a client-controlled value which may thus not be reliable and the other is a server-controlled value which is more reliable. You however need to ensure that the webserver in question has the SERVER_NAME correctly configured … SERVER_NAME is more reliable, but you’re dependent on the server config

You need to set UseCanonicalName directive to on in the <VirtualHost> entry in httpd.conf

 <VirtualHost *>
     ServerName example.com
     UseCanonicalName on
 </VirtualHost> 

SCRIPT_NAME vs PHP_SELF

via Phly, boy, phly

SCRIPT_NAME is defined in the CGI 1.1 specification … However, not all web servers actually implement it, and thus it isn’t necessarily portable … PHP_SELF, on the other hand, is implemented directly by PHP, and as long as you’re programming in PHP, will always be present

Hi-res

decodering:

How to Build a Kick-Butt CSS3 Mega Drop-Down Menu

Often used on e-commerce or large scale websites, mega menus are becoming more and more popular, as they offer an effective solution to displaying a lot of content while keeping a clean layout. In this tutorial, we’ll learn how to build a cross-browser, awesome CSS-only drop-down mega menu, using nice CSS3 features.

(demo)