Board logo

標題: PHP 透過 PDO 操作 pgsql [打印本頁]
作者: ray    時間: 2020-6-13 10:46     標題: PHP 透過 PDO 操作 pgsql

本帖最後由 ray 於 2020-6-13 11:35 編輯

https://www.postgresqltutorial.com/postgresql-php/

Connect:
$conStr = "pgsql:host=[host];port=5432;dbname=[db];user=[user];password=[password]";
$pdo = new \PDO($conStr);
$pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);

Insert:
$sql = 'INSERT INTO usertb(uname,pass) VALUES(:uname,:pass)';
$stmt = $pdo->prepare($sql);

// pass values to the statement
$stmt->bindValue(':uname', "hello");
$stmt->bindValue(':pass', "hello");

// execute the insert statement
$stmt->execute();

// return generated id
echo $pdo->lastInsertId();

Select:
$stmt = $pdo->query('SELECT uname, pass FROM usertb');
while ($row = $stmt->fetch(\PDO::FETCH_ASSOC))
    echo $row['uname'].",".$row['pass']."<br>";
作者: ray    時間: 2020-6-13 11:54

  1. <!DOCTYPE html>
  2. <html lang="en">

  4. <head>
  5.     <meta charset="utf-8">
  6.     <title>test</title>
  7. </head>

  9. <body>
  10. This is firt test<br>
  11. <?php
  12. $conStr = "pgsql:host=ec2-34-198-243-120.compute-1.amazonaws.com;port=5432;dbname=d33tv102tftng6;user=zdnbsjhbujtaca;password=4e00d5400a3b2f211a31dae4b7b679212d0e7c72763659cd5337b6e8b1f4227e";
  13. $pdo = new \PDO($conStr);
  14. $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);

  16. if(isset($_POST["uname"]) && isset($_POST["password"]) && $_POST["uname"] != "" && $_POST["password"] != "")
  17. {
  18.         $sql = 'INSERT INTO usertb(uname,pass) VALUES(:uname,:pass)';
  19.         $stmt = $pdo->prepare($sql);

  21.         // pass values to the statement
  22.         $stmt->bindValue(':uname', $_POST["uname"]);
  23.         $stmt->bindValue(':pass', $_POST["password"] );

  25.         // execute the insert statement
  26.         $stmt->execute();

  28.         // return generated id
  29.         //echo $pdo->lastInsertId();
  30. }
  31. $stmt = $pdo->query('SELECT uname, pass FROM usertb');
  32. while ($row = $stmt->fetch(\PDO::FETCH_ASSOC))
  33.     echo $row['uname'].",".$row['pass']."<br>";
  34. ?>
  35. <form action="" method="post">
  36. Account:<input type=text name=uname><br>
  37. Password:<input type=password name=password><br>
  38. <input type=submit value='insert'>
  39. </form>
  40. </body>
  41. </html>
複製代碼




歡迎光臨 種子論壇 | 高雄市資訊培育協會學員討論區 (http://seed.istak.org.tw/) Powered by Discuz! 7.2