Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Test</title>
- </head>
- <body bgcolor="white">
- <?php
- $connection_string="dbname=postgres port=5432 user=postgres password=admin"
- $link = pg_connect(string $connection_string[,int PGSQL_CONNECT_FORCE_NEW]);
- //$link = pg_connect("dbname=postgres user=postgres password=admin"[,int ]);
- $result = pg_exec($link, "select * from customers");
- $numrows = pg_numrows($result);
- echo "<p>link = $link<br>
- result = $result<br>
- numrows = $numrows</p>
- ";
- ?>
- <table border="1">
- <tr>
- <th>Last name</th>
- <th>First name</th>
- <th>ID</th>
- </tr>
- <?php
- for($ri = 0; $ri < $numrows; $ri++) {
- echo "<tr>n";
- $row = pg_fetch_array($result, $ri);
- echo " <td>", $row["fname"], "</td>
- <td>", $row["lname"], "</td>
- <td>", $row["id"], "</td>
- </tr>
- ";
- }
- pg_close($link);
- ?>
- </table>
- $db = new PDO('pgsql:dbname=mydb;host=localhost;user=myuser;password=mypass');
- $res = $db->query("SELECT * FROM sometable")->fetchAll(PDO::FETCH_ASSOC);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement