Answer:
<?php
$mysqli = new mysqli("127.0.0.1:3307", "myUser", "myPass", "databasename");
$query = "SELECT * FROM users ORDER BY name";
if($result = $mysqli->query($query))
{
echo '<ul>';
while ($obj = $result->fetch_object())
{
echo '<li>'.$obj->name.'</li>';
}
$result->free();
echo '</ul>';
}
else
{
die("nothing found");
}
$mysqli->Close();
?>
Explanation:
This should get you started.
