eseguire_query_php.php

<?php
echo"<a href=homepage.html>home</a>";
$con=new mysqli("localhost","root","","esempio");
if(mysqli_connect_errno()){
echo("connesione_non_effetuata:".mysqli_connect_errno()."<BR>");
exit();
}
$sql ="SELECT * FROM registrazione ";
$ris = $con->query($sql) or die ("Query fallita!");
echo "<TABLE>
<TR><TH>email<TH>password</TR>";
foreach($ris as $riga)
{
echo "<TR>";
echo "<TD>".$riga["email"];
echo "<TD>".$riga["password"];
echo "</TR>";
}
$con->close();
?>