visualizzare record mysql in tabella html

[php76]

Salve, sto creando un db, e sto creando le funzioni select, delet e ricerca record, nel visualizzare i dati pero' mi da errore la connection.

<?php
?><table border="1" align="center"><tr><td align="center">firstname</td><td align="center">lastname</td><td align="center">email</td></tr><?php$servername = "localhost";$username = "root";$password = "";$dbname = "my_db";
// Create connection$conn = new mysqli($servername, $username, $password, $dbname);// Check connectionif (isset($conn->connect_error)) {    die("Connection failed: " . $conn->connect_error);} 
$sql = "INSERT INTO Mytable (firstname, lastname, email)VALUES ('John', 'Doe','john@example.com')";$sql = "INSERT INTO Mytable (firstname, lastname, email)VALUES('Giampiero','Pagliara','giampieropagliara@gmail.com')";$sql = "INSERT INTO Mytable (firstname, lastname, email)VALUES('Alessandro','Magni','alessandromagni@gmail.com')";$sql = "INSERT INTO Mytable (firstname, lastname, email)VALUES('Giovanni','Conti','giovanniconti@gmail.com')";$sql = "INSERT INTO Mytable (firstname, lastname, email)VALUES('Ambra','Turchi','ambraturchi@gmail.com')";$sql = "INSERT INTO Mytable (firstname, lastname, email)VALUES('Giovanni','Conti','giovanniconti@gmail.com')";if ($conn->query($sql) === TRUE) {    echo "New record created successfully";} else {    echo "Error: " . $sql . "<br>" . $conn->error;}
$conn->close();?><?php$db_connection= mysql_connect($servername, $username, $password, $dbname);$db_selection = mysql_select_db('my_db',$db_connection);
$query = mysql_query("SELECT distinct firstname, lastname, email FROM Mytable WHERE id ");while($foreach = mysql_fetch_array($query)){ 
    echo "     <tr>    <td>".$foreach['firstname']."</td><td>".$foreach['lastname']."</td><td>".$foreach['email']."</td>    </tr>";    }    ?></table>

e questa e la tabella:

<table>        <tr>                <td>FIRSTNAME</td>                <td> - </td>                 <td>LASTNAME</td>                <td> - </td>               <td>EMAIL</td>                <td> - </td>                 <td></td>                <td> - </td>                 <td></td>                <td> - </td>                 <td></td>                <td> - </td>                 <td></td>                <td> - </td>                 <td></td>        </tr><?php$db_connection= mysql_connect('my_db','root','');$db_selection = mysql_select_db('Mytable',$db_connection);
$query = mysql_query("SELECT * FROM Mytable");while($cicle=mysql_fetch_row($query)){    echo "          <tr>                <td>".$cicle['firstname']."</td>                <td> - </td>                 <td>".$cicle['lastname']."</td>                 <td> - </td>               <td>".$cicle['email']."</td>                <td> - </td>                 <td>".$cicle['']."</td>                 <td> - </td>                 <td>".$cicle['']."</td>                <td> - </td>                 <td>".$cicle['']."</td>                <td> - </td>                 <td>".$cicle['']."</td>                 <td> - </td>                 <td>".$cicle['']."</td>          </tr>";         }?></table>