PHP PdoStatement Examples

Programming Language: PHP

Class/Type: PdoStatement

Examples at hotexamples.com: 4

PHP PDOStatement is a class of the PHP Data Objects (PDO) extension, which provides a way to communicate with databases through a common set of interface functions. The PDOStatement class represents a prepared statement and provides methods for executing and retrieving query results.

Example 1: Executing a simple SELECT statement

// Create a PDO object and connect to a database
$pdo = new PDO('mysql:host=localhost;dbname=mydb', 'user', 'pass');

// Prepare a statement and bind a value to a parameter
$stmt = $pdo->prepare('SELECT * FROM mytable WHERE id = :id');
$stmt->bindParam(':id', $id);

// Execute the statement and fetch the results
$id = 1;
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

Example 2: Executing an INSERT statement with transaction

// Begin a transaction
$pdo->beginTransaction();

// Prepare an INSERT statement
$stmt = $pdo->prepare('INSERT INTO mytable (name, age) VALUES (:name, :age)');

// Bind values to parameters
$stmt->bindParam(':name', $name);
$stmt->bindParam(':age', $age);

// Execute the statement multiple times with different values
$name = 'John';
$age = 25;
$stmt->execute();

$name = 'Mary';
$age = 30;
$stmt->execute();

// Commit the transaction
$pdo->commit();

The PDOStatement class is part of the PHP Standard Library.

PHP PdoStatement - 4 examples found. These are the top rated real world PHP examples of PdoStatement extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

execute(1)

fetch(1)

fetchAll(1)

setCountStatement(1)

setFetchMode(1)

setPagination(1)

setPrimaryStatement(1)

setResult(1)

Example #1

Show file

File: Pdo.php Project: zgredzik/pseudo

 /**
  * @param string $statement
  * @return PdoStatement
  */
 public function query($statement)
 {
     if ($this->mockedQueries->exists($statement)) {
         $result = $this->mockedQueries->getResult($statement);
         if ($result) {
             $this->queryLog->addQuery($statement);
             $statement = new PdoStatement();
             $statement->setResult($result);
             return $statement;
         }
     }
 }

Example #2

Show file

File: AbstractPdoFactory.php Project: centralapps/dao

 protected function buildFromPdoStatementLogic(\PdoStatement $statement, callable $callback = null)
 {
     $collection = $this->getCollection();
     $statement->execute();
     while ($row = $statement->fetch(\PDO::FETCH_ASSOC)) {
         $model = new $this->modelClass($this->container);
         if (!$model instanceof ModelInterface) {
             throw new \LogicException("The abstract factory only supports models which implement ModelInterface and have a hydrate method");
         }
         $model->setExistsInDatabase(true);
         if (!is_null($callback)) {
             $model = call_user_func_array($callback, array($model, &$row));
         }
         $model->hydrate($row);
         $collection->add($model);
     }
     return $collection;
 }

Example #3

Show file

File: PdoTrait.php Project: centralapps/pagination

 /**
  * Prepare a statement
  * @param string $statement the SQL query
  * @param array $driver_options
  * @return \PdoStatement
  */
 public function prepare($statement, $driver_options = [])
 {
     if (!is_null($this->pagination)) {
         $pagination_query = $this->paginateQuery($statement, $this->pagination->getCurrentPageNumber(), $this->pagination->getMaxResultsPerPage());
         $count_query = $this->convertToCountQuery($statement);
         $primary_statement = parent::prepare($pagination_query, $driver_options);
         $count_statement = parent::prepare($count_query, $driver_options);
         $statement = new PdoStatement();
         $statement->setPagination($this->pagination);
         $statement->setPrimaryStatement($primary_statement);
         $statement->setCountStatement($count_statement);
         // clear pagination
         $this->pagination = null;
         return $statement;
     } else {
         return parent::prepare($statement, $driver_options);
     }
 }

Example #4

Show file

File: PDOClient.php Project: hgraca/vacancy-repository

 /**
  * @param PDOStatement $stmt
  *
  * @return array
  */
 private function fetchData(PdoStatement $stmt)
 {
     $stmt->setFetchMode(PDO::FETCH_ASSOC);
     $resultAsArray = $stmt->fetchAll();
     return $resultAsArray;
 }