Resource pg_execute (, string $stmtname, array $params ) This submits a request to create a prepared statement with the given parameters and waits for completion. Resource pg_prepare (, string $stmtname, string $query ) This routine returns the name of the database that the given PostgreSQL connection resource. Returns PGSQL_CONNECTION_OK or PGSQL_CONNECTION_BAD. This routine returns the status of the specified connection. Int pg_connection_status ( resource $connection ) Returns TRUE on success or FALSE on failure. If PGSQL_CONNECT_FORCE_NEW is passed as connect_type, then a new connection is created in case of a second call to pg_connect(), even if the connection_string is identical to an existing connection.īool pg_connection_reset ( resource $connection ) This opens a connection to a PostgreSQL database specified by the connection_string. Resource pg_connect ( string $connection_string ) If you are looking for a more sophisticated application, then you can look into the PHP official documentation. The following are important PHP routines, which can suffice your requirement to work with PostgreSQL database from your PHP program. This DLL is included with Windows distributions in the latest releases of PHP 5.3.xįor detailed installation instructions, kindly check our PHP tutorial and its official website. Windows users must enable php_pgsql.dll in order to use this extension. You can start/restart the postgres server, in case it is not running, using the following command service postgresql restart Still you can use yum command to install PHP -PostgreSQL interface −īefore you start using the PHP PostgreSQL interface, find the pg_hba.conf file in your PostgreSQL installation directory and add the following line − It is possible to disable it by using -without-pgsql at compile time. The PostgreSQL extension is enabled by default in the latest releases of PHP 5.3.x.
0 kommentar(er)
