: This article describes how to use PDO extension to connect to the PostgreSQL object relational database in php. For more information about PHP tutorials, see. Php uses PDO extension to connect to PostgreSQL object relational database
$ Pdo = NULL; if (Version_compare(PHP_VERSION, '5. 3.6 ',' <') {$ pdo = new \ PDO ('pgsql: host = 127.0.0.1; port = 5432; dbname = mongodb1', 'mongos', "123456 ", array (\ PDO: MYSQL_ATTR_INIT_COMMAND => 'set NAMES \ 'utf8 \ '');} else {$ pdo = new \ PDO ('pgsql: host = 127.0.0.1; port = 5432; dbname = mongodb1. 'postgres', "123456") ;}try {$ pdo-> beginTransaction (); $ tableName = 'user '; if ($ fetch = true) {$ myPDOStatement = $ pdo-> prepare ("SELECT * FROM ". $ tableName . "WHERE id =: id"); if (! $ MyPDOStatement) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]) ;}$ id = 1; $ myPDOStatement-> bindParam (": id", $ id); $ myPDOStatement-> execute (); if ($ myPDOStatement-> errorCode ()> 0) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]);} $ item = $ myPDOStatement-> fetch (); print_r ($ item) ;}$ insertedId = 0; if ($ insert = true) {$ myPDOStatement = $ pdo-> prepare ("insert ". $ tableName. "(username, password, status) VALUES (: username,: password,: status)"); if (! $ MyPDOStatement) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]) ;}$ timestamp = time (); $ data = array ('username' => 'usernamex ', 'password' => 'passwordx ', 'status' => '1',); $ myPDOStatement-> bindParam (": username", $ data ['username']); $ myPDOStatement-> bindParam (": password ", $ data ['password']); $ myPDOStatement-> bindParam (": status ", $ data ['status']); $ myPDOStatement-> execute (); if ($ myPDOStatement-> errorCode ()> 0) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]);} $ affectRowCount = $ myPDOStatement-> rowCount (); if ($ affectRowCount> 0) {$ insertedId = $ pdo-> lastInsertId ();} print_r ('$ insertedId = '. $ insertedId); // PostgreSQL does not support print_r ('$ affectRowCount = '. $ affectRowCount);} if ($ update = true) {$ myPDOStatement = $ pdo-> prepare ("UPDATE ". $ tableName. "SET username =: username, status =: status WHERE id =: id"); if (! $ MyPDOStatement) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]) ;}$ id = 1; $ username = 'username update'; $ status = 0; $ myPDOStatement-> bindParam (": id ", $ id); $ myPDOStatement-> bindParam (": username", $ username); $ myPDOStatement-> bindParam (": status", $ status ); $ myPDOStatement-> execute (); if ($ myPDOStatement-> errorCode ()> 0) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]);} $ affectRowCount = $ myPDOStatement-> rowCount (); print_r ('$ affectRowCount = '. $ affectRowCount);} if ($ fetchAll = true) {$ myPDOStatement = $ pdo-> prepare ("SELECT * FROM ". $ tableName. "WHERE id>: id"); if (! $ MyPDOStatement) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]) ;}$ id = 0; $ myPDOStatement-> bindParam (": id", $ id); $ myPDOStatement-> execute (); if ($ myPDOStatement-> errorCode ()> 0) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]);} $ list = $ myPDOStatement-> fetchAll (); print_r ($ list);} if ($ update = true) {$ myPDOStatement = $ pdo-> prepare ("delete from ". $ tableName. "WHERE id =: id"); if (! $ MyPDOStatement) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]);} // $ insertedId = 10; $ myPDOStatement-> bindParam (": id", $ insertedId); $ myPDOStatement-> execute (); if ($ myPDOStatement-> errorCode ()> 0) {$ errorInfo = $ myPDOStatement-> errorInfo (); throw new \Exception($ ErrorInfo [0]. '###'. $ errorInfo [1]. '###'. $ errorInfo [2]);} $ affectRowCount = $ myPDOStatement-> rowCount (); print_r ('$ affectRowCount = '. $ affectRowCount);} $ pdo-> commit ();} catch (\Exception$ E) {$ pdo-> rollBack (); // print_r ($ e);} $ pdo = null;
The above describes how to use PDO extension to connect to the PostgreSQL object relational database in php, including version_compare and Exception, and hope to be helpful to PHP tutorials.