PHP Function Pg_Prepare

php function pg_prepare is an important routine that can suffice your requirement to work with PostgreSQL database from your PHP application. For detailed installation instructions, kindly check our tutorial and official website.

Prepares a SQL statement to be executed. The statement's parameters are substituted at the time of execution, avoiding the need to manually quote each parameter. This helps in preventing sql injection attacks.

Returns the status of an open connection, PGSQL_CONNECT_OK if successful or FALSE on error. Unlike pg_connect(), this function can also reset the connection which is useful for error recovery.

Creates a named prepared statement with the query string specified as stmtname. The stmtname may be "" to create an unnamed statement, in which case any existing unnamed statement is overwritten; or it can be an SQL PREPARE statement. This function is similar to pg_send_query_params(), except that it can support multiple query statements in the stmtname and it does not require parameter types to be pre-specified. It is also more flexible since it does not support a """""""""""return""""""""""pg_type_d.h"""""""""" data type modifier, as defined in the PostgreSQL system table pg_type_d.h""""""""".

Returns a pointer to storage that is part of the PGresult object (if available). The storage should not be modified, and one must explicitly copy it into other storage if used past the lifetime of the PGresult structure itself.

Returns an array with client, protocol and server version information (if available). This function is only valid if PHP was compiled with PostgreSQL 7.4 or later.

Andreas Behr - CTO of DesertCoderz
You are a developer and looking for Shopware projects?
Apply Now!

pg_prepare example


    public function _prepare(string $sql, array $options = []): PreparedQuery
    {
        $this->name = (string) random_int(1, 10_000_000_000_000_000);

        $sql = $this->parameterize($sql);

        // Update the query object since the parameters are slightly different         // than what was put in.         $this->query->setQuery($sql);

        if (! $this->statement = pg_prepare($this->db->connID, $this->name, $sql)) {
            $this->errorCode   = 0;
            $this->errorString = pg_last_error($this->db->connID);

            if ($this->db->DBDebug) {
                throw new DatabaseException($this->errorString . ' code: ' . $this->errorCode);
            }
        }

        return $this;
    }

    
Home | Imprint | This part of the site doesn't use cookies.