jQuery Ajax+PHP Tutorial

Posted on Jun 25, 2013

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 Jul 2, 2013

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 Jun 26, 2013

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
}


© Twiwoo 2020 Cookie Policy