Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. $host = env('DB_HOST', 'localhost');
  2. $database = env('DB_DATABASE', 'aaa');
  3. $user = env('DB_USERNAME', '22222');
  4. $pass = env('DB_PASSWORD', '11111');
  5. $table = 'table';
  6. $column = 'json';
  7. $connection = pg_connect("host=$host dbname=$database user=$user password=$pass");
  8. $result = pg_fetch_all(pg_query($connection, "SELECT $column->>'name' FROM "$table" "));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement