Always wondered how SQL Injection works? Check out the following demo video.
Technorati Tags: sql injection, sql, hacking, database, application security
Continue reading SQL Injection Demo
I have been reading articles on how to optimise MySQL databases and queries and here are a few tips I have learnt and would like to share with you:
Proper use of indexes improve performance
Do not perform calculations on an index (eg: if you have an index for a column called salary, do not perform calculation [...]
Continue reading 15 tips on optimising MySQL databases and MySQL queries
I am using WordPress as a CMS for one of my websites. For that website, instead of having a default category page, I wanted to have a customised category page which lists titles of all posts under that category. And I also wanted to display a category image if it exists in /wp-content/uploads/images [...]
Continue reading Customising category.php in WordPress
Use LEFT JOIN when you want to return all rows from left table regardless of whether they have any associated rows on right table.
Use RIGHT JOIN when you want to return all rows from right table regardless of whether they have any associated rows on left table.
SELECT
users.`firstname`,
pets.`nickname`
FROM [...]
Continue reading LEFT JOIN and RIGHT JOIN in mysql
A while ago, I wrote eZ Publish extensions for Flickr and YouTube. Basically, you pass a keyword/tag you’d like to search to template operator and it will return a list of photos (and videos if you are using YouTube template operator) matching the criteria. You can also set total number of results to [...]
Continue reading eZ Publish extensions for Flickr and YouTube
Flickr, YouTube, and Google Search Mashup
Do you like my little mashup? Written in PHP and Javascript using Flickr, YouTube and Google Search APIs.
Any suggestion on how I can put it into a good use?
Technorati Tags: youtube, google, flickr, api, mashup, web, web 2.0, [...]
Continue reading Flickr, YouTube, and Google Search Mashup
How OO is PHP?
How “object-oriented” is PHP? Your answer to that question probably depends on your particular litmus tests for object-orientedness. In this sidebar, we offer a whirlwind tour of features that typically show up in OOP languages and briefly discuss the extent to which PHP supports them. Some of these issues are explored more [...]
Continue reading How Object Oriented is PHP?
Hello! Welcome to Web development blog! My name is Ei Sabai and on this blog, I write about web development, mobile app development, latest web technologies and the likes. Read more 
