<?php
    require_once 'conexion.php';

       if (isset($_POST['enviar_estudiante'])) {
        $ced = $_POST['cedula'];
        $nombre = $_POST['nombre'];

        echo  $ced . $nombre;



        $sql = "INSERT INTO pagos.estudiante(est_cedula, est_apellido)
            VALUES (" . "'" . $ced . "','" . $nombre . "'" . ")";
        $result = pg_query($dbconn, $sql);

        if(!$result){
            echo pg_last_error($dbconn);
        } else {
            echo "Updated successfully";
        }


    }


    if (isset($_POST['consultar'])) {
             $result = pg_query($dbconn, "SELECT * FROM pagos.estudiante");
        if (!$result) {
            echo "An error occurred.\n";
            exit;
        }

        echo "<table>\n";
while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
        echo "\t\t<td>$col_value</td>\n";
    }
    echo "\t</tr>\n";
}
echo "</table>\n";

// Liberando el conjunto de resultados
pg_free_result($result);



     }



  if (isset($_POST['actualizar'])) {
      $ced = $_POST['cedula'];
        $nombre = $_POST['nombre'];
        $sql = "update pagos.estudiante set est_nombre = " . "'" . $nombre . "'" . " where est_cedula = " . "'" . $ced . "'";

$result = pg_query($dbconn, $sql);
if(!$result){
  echo pg_last_error($dbconn);
} else {
  echo "Updated successfully.";
}
   }




     if (isset($_POST['eliminar'])) {
         $ced = $_POST['cedula'];
       $sql = "delete from pagos.estudiante  where est_cedula = " . "'" . $ced . "'";

 $result = pg_query($dbconn, $sql);
if(!$result){
  echo pg_last_error($dbconn);
} else {
  echo "Deleted successfully\n";
}

  }





// Close the connection
pg_close($dbconn);





?>