SALVE, VOLEVO SAPERE, COME POTER ELIMINARE I RECORD DUPLICATI DA QUESTA TABELLA, HO PROVATO CON CICLE, CON FOREACH, CON ARRAY UNIQUE, MA NIENTE, DOVE SBAGLIO?
GRAZIE
[PHP]
<table border="1">
<tr>
<td>firstname</td><td>lastname</td><td>email</td>
</tr>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "my_db";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO Mytable (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@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 firstname, lastname, email FROM mytable");
while($foreach=mysql_fetch_array($query)){
echo "
<tr>
<td>".$foreach['firstname']."</td><td>".$foreach['lastname']."</td><td>".$foreach['email']."</td>
</tr>";
}
?>
</table>
[PHP]
Rispondi quotando
Originariamente inviata da optime
