CSS: Responsive Navigation Menu for Beginners

Posted on
This very easy jQuery-based Responsive Navigation Menu.

How To Install Nginx+PHP-FPM+PHPMyAdmin on CentOS 6

Posted on
Hey Everybody. This is a tutorial that teaches the Nginx+PHP-FPM+PHPMyAdmin installation.

Step 1 - Install the Required Repositories

1. EPEL:
wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

This command will download the package into your home directory:
rpm -ivh epel-release*

Your installation now is aware of the EPEL repositories. Check this by typing:
yum repolist

jQuery Ajax+PHP Tutorial

Posted on

What About jQuery and AJAX?

The combination of jQuery and ajax provide powerfull functionality. With jquery ajax you can make request for text or html from your remote server. If data is large you can use json to receive them. After receiving Ajax response we can use them in our html page.
jQuery provides some powerful set of jQuery AJAX API's to handle AJAX requests. In good way of making AJAX calls using JavaScript is a little bit odd as you have to first create an XMLHttpRequest Object that depends on the browser and then make an AJAX call. Also sending a form data using AJAX is also bit difficult if we use normal JavaScript approach of calling AJAX.

10 Fresh jQuery Plugins

Posted on

1. Mixit Up

MixItUp is a light weight but great jQuery plugin that provides good animated sorting of categorized and ordered content.

2. Unslider : Responsive Slider without Fancy Effects

Unslider is the jQuery slider that just slides. It's less than 3kb. It's fluid, flexible minimal. If you want to, you can add keyboard arrow support. Not all slides are created equal, and Unslider knows it.

10 MySQL Best Practices for Optimization

Posted on

1. LIMIT 1 When Getting a Unique Row in your table

Sometimes when you are querying your tables, you already know you are looking for just one row. You might be fetching a unique record, or you might just be just checking the existence of any number of records that satisfy your WHERE clause.

In such cases, adding LIMIT 1 to your query can increase performance.
// do I have people from California? // NOT to Do!: $r = mysql_query("SELECT * FROM user WHERE state = 'California'"); if (mysql_num_rows($r) > 0) { // ... other code } // Good request $r = mysql_query("SELECT 1 FROM user WHERE state = 'California' LIMIT 1"); if (mysql_num_rows($r) > 0) { // ... other code }

Free Hit Counters