A small example of using MySQLi extension in PHP5

/**
* mysqli extension example
* by bbs.it-home.org
*/
    $mysqli = mysqli_connect("localhost", "root", "","mydatabase", 3306);
    $result = mysqli_query($mysqli, "SELECT * FROM mytable");
    while($row = mysqli_fetch_array($result)) {
        foreach($row as $key => $value) {
            echo "$key = $valuen";
        }
    }
    mysqli_free_result($result);
    mysqli_close($mysqli);
?>