Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host='127.0.0.1';
- $db = 'mi_base_datos';
- $username = 'postgres';
- $password = '1706';
- ?>
- <?php
- require_once 'dbconfig_postgres.php';
- $dsn = "pgsql:host=$host;port=5432;dbname=$db;user=$username;password=$password";
- try{
- $base_postgres = new PDO($dsn);
- $base_postgres->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- //echo "<div class='conectado_bd bg_verde'><div>PostGres</div><div>ON</div></div></div>";
- }catch (PDOException $e){
- echo "BD fuera de servicio";
- }
- ?>
- $registros=$base_postgres->prepare('Select id,nombre,correo From "mi_esquema"."mi_tabla"');
- $registros->execute(array());
- //Por si quieres saber cuantos registros arrojo la consulta
- $total_registros = $registros_niscap->rowCount();
- $registros = $registros->fetchAll( PDO::FETCH_OBJ );
Add Comment
Please, Sign In to add comment