Created
November 25, 2016 07:16
-
-
Save JosephTico/d2110061e5fe00eeeb9b4fa74dd55c3d to your computer and use it in GitHub Desktop.
Para este taller se ocupan los paquetes:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// Conexión a la base de datos | |
$mysqli = new mysqli('127.0.0.1', 'admin', 'adminadmin', 'paleteros'); | |
// Si la conexión falla | |
if ($mysqli->connect_errno) { | |
// Imprime el error | |
echo "Error: " . $mysqli->connect_error . "\n"; | |
} else { | |
if ($_POST['nombre'] && $_POST['edad']) { | |
$nombre = $mysqli->real_escape_string($_POST['nombre']); | |
$edad = $mysqli->real_escape_string($_POST['edad']); | |
$query = "INSERT INTO `empleados` VALUES ('$nombre', $edad)"; | |
$mysqli->query($query); | |
echo "Entrada añadida"; | |
} | |
$query = "SELECT nombre, edad FROM empleados"; | |
$result = $mysqli->query($query); | |
echo "<ul>"; | |
foreach($result as $data) { | |
echo "<li>"; | |
echo $data['nombre']; | |
echo " - "; | |
echo $data['edad']; | |
echo " años"; | |
echo "</li>"; | |
} | |
echo "</ul>"; | |
} | |
?> | |
<form method="POST"> | |
<input type="text" name="nombre" placeholder="Inserte el nombre" required/> | |
<input type="number" name="edad" placeholder="Edad " required/> | |
<input type="submit" value="Enviar" > | |
</form> | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment