php

function coneccion()
    {
        $conn = pg_connect("host=localhost port=5432 dbname=cakephp user=postgres password=root");
        //$conn = pg_connect(MEG_DBSERVER,MEG_DBUSER,MEG_DBPASSWORD,MEG_DBPORT);
        if (!$conn)
        {
            die('Error al conectar con MySQL:'.pg_last_error());
        }
        //pg_select_db(MEG_DBNAME,$conn);
        return  $conn;
    }

        function ingresaPersona($nombre,$apaterno,$amaterno,$fnacimiento)
        {
            $conn = coneccion();
            $sql = "INSERT INTO prueba.persona (nombre,apaterno,amaterno,fnacimiento) values ('$nombre','$apaterno','$amaterno','$fnacimiento')";
            //echo $sql;
            $result = pg_query($conn,$sql)or die(pg_last_error());
            if($result){
                return true;
            }else{
                return false;
            }
        }

        function obtienePersonas()
        {
            $conn = coneccion();
            $sql = "SELECT * from prueba.persona";
            //echo $sql;
            $result = pg_query($conn,$sql)or die(pg_last_error());
            $personas=array();
            while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC))
            {
                $personasTemp=array();
                $personasTemp["id"]= $row["id"];
                $personasTemp["nombre"]=$row["nombre"];
                $personasTemp["apaterno"]=$row["apaterno"];
                $personasTemp["amaterno"]=$row["amaterno"];
                $personasTemp["fnacimiento"]=$row["fnacimiento"];
                $personas[]=$personasTemp;
            }
            return $personas;
        }


<div class="container-fluid col-sm-8 col-sm-offset-2">
                <table class="table table-hover">
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>Nombre</th>
                        <th>Apellido Paterno</th>
                        <th>Apellido Materno</th>
                        <th>Fecha Nacimiento</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                        $personas = obtienePersonas();
                        foreach ($personas as $per):  ?>

                             <tr>
                                <td><?= $per["id"]; ?></td>
                                <td><?= $per["nombre"]; ?></td>
                                <td><?= $per["apaterno"]; ?></td>
                                <td><?= $per["amaterno"]; ?></td>
                                <td><?= date("d-m-Y", strtotime($per["fnacimiento"])); ?></td>
                             </tr>

                        <?php   endforeach; ?>

                </tbody>
                </table>
            </div>

//CONFIG

<?php
      define( "MEG_DBSERVER",   'localhost' );
      define( "MEG_DBPORT",     "5432" );
      define( "MEG_DBNAME",     "repaso" );
      define( "MEG_DBUSER",     "postgres" );
      define( "MEG_DBPASSWORD", "root" );
?>