Skip to content

Instantly share code, notes, and snippets.

@evilnapsis
Last active September 4, 2019 17:39
Show Gist options
  • Save evilnapsis/31b7ef5a3bc56b3e2a15a6540eb51303 to your computer and use it in GitHub Desktop.
Save evilnapsis/31b7ef5a3bc56b3e2a15a6540eb51303 to your computer and use it in GitHub Desktop.
Leer datos de una tabla MySQL con PHP y PDO
<?php
$user="root";
$password = "";
$con = new PDO("mysql:host=localhost;dbname=contacts",$user, $password);
$query = $con->query("select * from person;");
$result = $query->fetchAll(PDO::FETCH_OBJ);
echo "<h1>Todos los contactos</h1>";
echo "<a href=\"insertar.php\">Insertar</a><br><br>";
echo "<table border=1>";
foreach($result as $r){
echo "<tr>";
echo "<td>".$r->name."</td>";
echo "<td>".$r->lastname."</td>";
echo "<td>".$r->phone."</td>";
echo "<td>".$r->address."</td>";
echo "<td>".$r->email."</td>";
echo "<td><a href=\"actualizar.php?id=".$r->id."\">Actualizar</a></td>";
echo "<td><a href=\"eliminar.php?id=".$r->id."\">Eliminar</a></td>";
echo "</tr>";
}
echo "</table>";
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment