PHP mysqli

Connect to database (once!)

$db = new mysqli('localhost', 'username', 'password', 'world');

Create & execute a query statement

$statement = $db->prepare('select Code,Name from Country where Population > 100000000');

$statement->execute();

$statement->bind_result($code, $name);

while ($statement->fetch())
    echo "$code $name <br>\n";

$statement->close();

Adding new entries to a table

$statement = $db->prepare('insert into Country (Code, Name, Continent, Region, LocalName, GovernmentForm)
           values ("FRE", "Freedonia", "Europe", "Unknown", "Freedonia", "Anarchy")');

$statement->execute();

$statement->close();

Changing existing data

$statement = $db->prepare('update City set Population=10 where Name="Buffalo"');

$statement->execute();

$statement->close();

World database: http://gamera.caset.buffalo.edu/world.sql

PHPMyAdmin: http://gamera.caset.buffalo.edu/phpMyAdmin

Download database
Import it via PHPMyAdmin
Create a script that lists all languages spoken in Albania
Create a script that finds the city with the largest population in China
Create a script that adds a new country, and a new city in that country
Create a script that makes Spanish the official language of the United States

This document is by Dave Pape, and is released under a Creative Commons License.