<?php
    $host = "localhost";
    $port = "5432";
    $dbname = "istda";
    $user = "postgres";
    $password = "postgres";
    $pg_options = "--client_encoding=UTF8";

    $connection_string = "host={$host} port={$port} dbname={$dbname} user={$user} password={$password} options='{$pg_options}'";
    $dbconn = pg_connect($connection_string);


    if($dbconn){
        echo "Connected to ". pg_host($dbconn);
    }else{
        echo "Error in connecting to database.";
    }

    echo "<br />";


?>


--------------------------------------------------
    require_once 'conexion.php';

   if (isset($_POST['consultar'])) {
        $result = pg_query($dbconn, "");
        if (!$result) {
            echo "Error.\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['_guardar'])) {



        $sql = "INSERT INTO pagos.estudiante(est_cedula, est_apellido, est_nombre, est_direccion, est_telefono, est_email)
            VALUES (" . "'" . $ced . "','" . $apellido . "','" . $nombre . "','" . $direccion .  "','" .  $telefono .  "','" .  $email . "'" . ")";

        $result = pg_query($dbconn, $sql);

        if(!$result){
            echo pg_last_error($dbconn);
        } else {
            echo "Se insertó registro exitosamente...";
        }


    }

----------------------------------------------------------------

if (isset($_POST['_actualizar'])) {
      $cedula = $_POST['_cedula'];
      $direccion = $_POST['_direccion'];
      $sql = "update pagos.estudiante set est_direccion = " . "'" . $direccion . "'" . " where est_cedula = " . "'" . $cedula . "'";

    $result = pg_query($dbconn, $sql);
    if(!$result){
         echo pg_last_error($dbconn);
    } else {
        echo "Registro actualizado exitosamente...";
    }
  }



  ---------------------------

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

        $result = pg_query($dbconn, $sql);

        if(!$result){
             echo pg_last_error($dbconn);
        } else {
             echo "Registro eliminado";
    }

  }