(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.9.0) Dump an SQL prepared command public void PDOStatement::debugDumpParams ( void ) Dumps the information contained by a prepared statement directly on the output. It will provide the SQL query in use, the number of parameters used (Params), the list of parameters with their key name or position, their name, their position in the query (if this is supported by the PDO driver, o

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.2.0) Returns the number of columns in the result set public int PDOStatement::columnCount ( void ) Use PDOStatement::columnCount() to return the number of columns in the result set represented by the PDOStatement object. If the PDOStatement object was returned from PDO::query(), the column count is immediately available. If the PDOStatement object was returned from PDO::prepa

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.9.0) Closes the cursor, enabling the statement to be executed again. public bool PDOStatement::closeCursor ( void ) PDOStatement::closeCursor() frees up the connection to the server so that other SQL statements may be issued, but leaves the statement in a state that enables it to be executed again. This method is useful for database drivers that do not support executing a PDOSt

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 1.0.0) Binds a value to a parameter public bool PDOStatement::bindValue ( mixed $parameter, mixed $value [, int $data_type = PDO::PARAM_STR ] ) Binds a value to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement. Parameters: parameter Parameter identifier. For a prepar

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0) Binds a parameter to the specified variable name public bool PDOStatement::bindParam ( mixed $parameter, mixed &$variable [, int $data_type = PDO::PARAM_STR [, int $length [, mixed $driver_options ]]] ) Binds a PHP variable to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement. Unlike PDOStatement::bindValue(),

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0) Bind a column to a PHP variable public bool PDOStatement::bindColumn ( mixed $column, mixed &$param [, int $type [, int $maxlen [, mixed $driverdata ]]] ) PDOStatement::bindColumn() arranges to have a particular variable bound to a given column in the result-set from a query. Each call to PDOStatement::fetch() or PDOStatement::fetchAll() will update all the variables tha

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0) Set an attribute public bool PDO::setAttribute ( int $attribute, mixed $value ) Sets an attribute on the database handle. Some of the available generic attributes are listed below; some drivers may make use of additional driver specific attributes. PDO::ATTR_CASE: Force column names to a specific case. PDO::CASE_LOWER: Force column names to lower case. PDO::CASE_NATUR

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0) Rolls back a transaction public bool PDO::rollBack ( void ) Rolls back the current transaction, as initiated by PDO::beginTransaction(). A PDOException will be thrown if no transaction is active. If the database was set to autocommit mode, this function will restore autocommit mode after it has rolled back the transaction. Some databases, including MySQL, automatically i

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.2.1) Quotes a string for use in a query. public string PDO::quote ( string $string [, int $parameter_type = PDO::PARAM_STR ] ) PDO::quote() places quotes around the input string (if required) and escapes special characters within the input string, using a quoting style appropriate to the underlying driver. If you are using this function to build SQL statements, you are strongl

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.2.0) Executes an SQL statement, returning a result set as a PDOStatement object public PDOStatement PDO::query ( string $statement ) public PDOStatement PDO::query ( string $statement , int $PDO::FETCH_COLUMN , int $colno ) public PDOStatement PDO::query ( string $statement , int $PDO::FETCH_CLASS , string $classname , array $ctorargs ) public PDOStatement PDO::query ( string $