Wordpress plugins, examples on PHP, MySQL, JavaScript, MooTools and CSS

  • SlideItMoo Wordpress Plugin
  • MooTools Fancy Animated Tabs
  • Wordpress YouTube playlist plugin
  • MooTooltips – easy to make good looking tooltips
  • SlideItMoo – image slider

Who can access your admin page?

June 16th, 2007 in Security | no comments

Normally, the answer to that question would be: the administrator of the website. Well… not always. By now you all heard of mysql injection. At this moment, I have knowledge of at least 5 websites developed by WEB COMPANIES (yes, you read it well, those companies that have on the index page of their website the words: WE ARE PROFESSIONALS) that have breaches in the security. …view full post

show rows in category with minimal execution time

May 18th, 2007 in MySQL | no comments

You’ve all seen or made by now an e-commerce shop. If you look at big shops, they use to show right next to the category name the number of products available in that category – ie: Computers (190). Wel, once again you can do that in more that one way.

First way (and the wrong one if you ask me) is when you select the categories from your database to count the number of products from the database that belong to that category. But the problem with this is that you use much too much resources and when your database grows, you script will slow, sometimes even die. As I said before, this might look easy but is wrong. …view full post

mysql_num_rows vs mysql native count()

May 18th, 2007 in MySQL | no comments

The big question regarding this issue is: what is fater?

Let’s assume you need to build a pagination script. In order to find the total number of rows that will help you determine the number of total pages, you have to use either mysql_num_rows() or simply make your request using mysql’s count(). …view full post

A little about SQL injection

April 14th, 2007 in Security | 3 comments

I read some time ago on a website the following line: May the best of your past be the worst of your future. Amen to that brother!

Over the time I’ve seen good applications and bad applications and not so good application. The question that must be answered here is simple: How do we create a fairly safe PHP application? …view full post