Categories
Tips Tutorials

Handling a Keyword Search with PHP/MySQL (MATCH/AGAINST MySQL Function)

For the longest time I used the MySQL ‘LIKE’ statement style for searching by keywords, which it is probably the most reliable and fastest option. But today I’m going to talk about another option you have to create a more effective keyword search and get the result from MySQL order by keywords relevance. For this […]

Categories
Tutorials

Data Injection

Database Injection alert has become a pain in the back lately, after the resent SQL injection against MySQL main website, I start researching about Data Injection myself and I found a lot information that might be helpful for many my fellow designers and coders. What’s A Data Injection? If it’s the first time you heard about […]

Categories
Tutorials

RegExp Filter For URL’s

I was trying to get a nice short Regular Expression to filter and validate the url’s entered by an user in an form, and finally I come up with one that you can use as your first pass filter that its been working fine for me. It’s not a perfect one, but at least filter […]

Categories
Tips

Display Consideration

When designing a website there many considerations to make, the most important one, I think, is the display resolution. As a graphic designer and as web developer I noticing that many designs breaks apart when you see them in other displays for many reasons: The resolution is different from the one you test it on […]