/*
*
*
*
*/
// require("configdb.php");
//mysql database connection
$host = "localhost";
$user = "root";
$pass = "me590124";
$db = "dbdocentejuan";
$port = "4406";
$con = mysqli_connect($host, $user, $pass, $db, $port) or die("Error " . mysqli_error($con));
//mysqli_set_charset ($con, "utf8" );
if (mysqli_connect_errno())
{
echo "Conexión Fallida a MySQL: " . mysqli_connect_error();
} else {
//echo "Conexión más que magnifica, pefecta ..!";
}
/*
$v1 = $_POST['nombre'] = "alfonsina";
$v2 = $_POST['email'] = "abigail@yahoo.com";
$v3 = $_POST['face'] = "facebook.com/pedro";
$v4 = $_POST['whats'] = "5539789531";
*/
//print_r($_POST);
$tbl = "alumnos";
if($_POST['action']=="Agregar"){
$names = "id, nombre, email, face, whats";
//$values = "'0','$v1','$v2','$v3','$v4'";
$values = "'0', '". $_POST['nombre'] ."', '".$_POST['email']."', '".$_POST['face']."', '".$_POST['whats']."'";
$sql = "INSERT INTO $tbl ($names) VALUES ($values);";
if (mysqli_query($con, $sql) === TRUE) {
//echo "Nuevo registro fue creado satisfactoreamente";
header("location: index.php");
} else {
echo "Error: " . $sql . "
" . mysqli_error($con);
}
mysqli_close($con);
}
if($_POST['action']=="Eliminar"){
// sql para eliminar un registro
$sql = "DELETE FROM $tbl WHERE id='" .$_POST['id']."'";
if (mysqli_query($con, $sql)) {
//echo "Registro Eliminado";
header("location: index.php");
} else {
echo "Error deleting record: " . mysqli_error($con);
}
mysqli_close($con);
}
if($_POST['action']=="Actualizar"){
//print __LINE__;
//print_r($_POST);
// sql para eliminar un registro
$columnas = "nombre='". $_POST['nombre'] ."', email='". $_POST['email']."', face='". $_POST['face']."', whats= '".$_POST['whats']."'";
$sql = "UPDATE $tbl SET $columnas WHERE id='" .$_POST['id']."'";
if (mysqli_query($con, $sql)) {
//echo "Registro Actualizado";
header("location: index.php");
} else {
echo "Error deleting record: " . mysqli_error($con);
}
mysqli_close($con);
}
//------------------------------------------------------------------
// #################################################################
?>
CONTROL DE ALUMNOS