Grazie
Codice: Seleziona tutto
<?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 connection
if (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 ('gian', 'piero','gianpiero@example.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('localhost','root','');
$db_selection = mysql_select_db('my_db',$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>