# MySQLdb needs to be installed
import MySQLdb

# Connect to a database
db = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database')

# Create a cursor
cursor = db.cursor()

# Perform a query (returns the amount of rows affected/found)
num_rows = cursor.execute(query)

# Work with the results

# Close the connection
db.close()

If you do a SELECT-query, you can either retrieve one row or loop through all of them. Here’s an example of both:

# Fetch only one row (mostly used for e.g. "SELECT COUNT(*)")
data = cursor.fetchone()

# Loop through all rows
data = cursor.fetchall()
for row in data:
    # ...

All rows are represented as an array, without keys:

['First column', 'Another column', 'Etc...']

It contains handy snippets for reference while making awesome WordPress themes.

Any suggestions/modifications are welcome! =)

$.ajax({
    url: url,
    type: 'POST',
    dataType: 'json',
    data: data,
    success: callback
});

But you can also add a 4th parameter to $.post(). See this example:

$.post(url, data, callback, 'json');

This will do the same trick.

You can see that the color in the animation makes a weird shift to dark. This happens if the background is set to transparent.

Here’s the problem fixed (background set): http://jsfiddle.net/mzk3X/1/

Here’s a fiddle. If you move any list item so that a droppable item moves, you will still be able to drop to that specific element from its old position, not from the new one. I needed to refresh the droppable area position. I searched and ended up in tearing the jQuery UI source. Suddenly I found this inside the draggable:

//If you have a highly dynamic page, you might try this option. It renders positions every time you move the mouse.
if(draggable.options.refreshPositions) $.ui.ddmanager.prepareOffsets(draggable, event);

The problem was solved by adding the option refreshPositions for the sortable:

$('#sortable').sortable({
    refreshPositions: true
});

With refreshPositions set to true the positions will be updated every time the mouse is moved.

No authentication is needed. Remember to add your own API key.

$api_key = '';
$username = 'codeclown';
$limit = 3;

/* Construct the url */
$url = 'http://ws.audioscrobbler.com/2.0/?method=user.getrecenttracks&user='.$username.'&api_key='.$api_key.'&limit='.$limit;

/* Make a cURL-request (cURL is prefered over e.g. `file_get_contents`) */
$curl = curl_init();
curl_setopt($curl,CURLOPT_HEADER, 0);
curl_setopt($curl,CURLOPT_URL,$url);
curl_setopt($curl,CURLOPT_RETURNTRANSFER,true);
$result = curl_exec($curl);
curl_close($curl);

/* Process the results with `SimpleXMLElement` */
$xml = new SimpleXMLElement($result);
foreach($xml->recenttracks->track as $track) {

    /* Data in variables */
    $artist = $track->artist;
    $name = $track->name;
    $album = $track->album;
    $lastfm_url = $track->url;

    /* This does not exist, if the track is being currently played */
    $date = $track->date;

    /* An array that contains 4 different sizes */
    $albumart = $track->image;

    /* Nowplaying is embedded in attributes */
    $nowplaying = (bool) $track->attributes()->nowplaying;

    /* Use the data here */
    echo $artist.' - '.$name.'<hr />';

}

$title = preg_replace('/(.*)\s([^\s]+)/', '$1 $2', $original_title);

If you don’t have an idea what I’m talking about, see this fiddle.

$test = new Test();
$test->name = 'This is my name!';
$test->name = 500; // name can't be an int!

This can be easily accomplished by using the magic methods __get() and __set() of an object. In the code below, the properties of the class that extend Base can be accessed if a getter or setter method has been declared for that property. The getter or setter is simply a method with the same name as the property, prefixed with get or set.

This way you can restrict the values being assigned to these properties, and alter the values being returned by the getters.

The full example:

class Base {

    public function __get($name) {
        $method = "get$name";

        $this->checkPropertyAccess($method, $name);
        return $this->$method();
    }

    public function __set($name, $value) {
        $method = "set$name";

        $this->checkPropertyAccess($method, $name);
        return $this->$method($value);
    }

    private function checkPropertyAccess($method, $property) {
        if (!method_exists($this, $method)) {
            throw new Exception("Property '$property' not accessible");
        }
    }
}

class Test extends Base {

    private $_name;

    public function getName() {
        return $this->_name;
    }

    public function setName($name) {
        if (is_string($name)) {
            $this->_name = $name;
        }
    }
}

$test = new Test();
$test->name = 'This is my name!';
$test->name = 500;

echo $test->name;

First, make sure your menu is registered and included in the page:

register_nav_menus(array(
    'main-menu' => __('Main Navigation')
));

wp_nav_menu(array(
    'theme_location' => 'main-menu',
    'menu_id' => 'main-menu'
));

Next we’re going to add a filter:

add_filter('wp_nav_menu_items', 'custom_nav_menu_items', 10, 2);

The filter is executed for each menu on the page. The first argument is the name of the filter, the second the name of our function that will add the menu item. The third is the priority, ten by default, and the final one is the number of arguments our custom function expects.

The custom_nav_menu_items function is implemented like this:

function custom_nav_menu_items($items, $args) {
    if ($args->theme_location == 'main-menu') {
        $home = '<li><a href="' . home_url() . '">Home</a></li>';
        return $home . $items;
    }
    return $items;
}

We’re expecting two arguments: $items is the HTML for the other menu items, and $args contains information about the menu. $args->theme_location is used to make sure the item is added to a specific menu on the page. Note how $home is prepended to $items, if it were appended it would show as the last option in the menu.

That’s it! Now refresh the page and you’ll see the ‘Home’ option appearing.

$('#element').bind('mouseover',function(){
    $(this).animate({
        width: 200
    },500);
}).bind('mouseout',function(){
    $(this).animate({
        width: 50
    },500);
});

Click here for a living example. Move your mouse over the element rapidly back and forth to see, how even after you’ve stopped hovering the element, the animation continues.

One function is needed to fix this issue, stop(). Usage is very simple. See this code:

$('#element').bind('mouseover',function(){
    $(this).stop(true,false).animate({
        width: 200
    },500);
}).bind('mouseout',function(){
    $(this).stop(true,false).animate({
        width: 50
    },500);
});

See here for a demonstration. The animation stops when the mouse is moved off the element.

The first parameter, which is set to true, defines if we want to clear the queue. In this particular piece of code it doesn’t really make any difference.

The second parameter defines, if we want to jump to the end of the current animation. This may be needed on occasion, here’s how it looks. Try moving your mouse over the element and quickly (before the first animation is complete) moving it out. You can see the first animation is “completed” instantly.

See the official documentation for more detailed usage.