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.
Codice PHP:
<?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:
Codice PHP:
<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>
Rispondi quotando
