$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 = $value\n";
}
}
mysqli_free_result($result);
mysqli_close($mysqli);
?>