PHP By Example


<?php
// custom callback function

function fruit($name, $colour) {

    return "{$name}: {$colour}";

}



$pdo = new PDO("sqlite::memory:", null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);

$int = $pdo->exec(

    "CREATE TABLE fruit
    (name, colour, calories INT);

INSERT INTO fruit VALUES
    ('apple', 'red', 150),
    ('banana', 'yellow', 250),
    ('kiwi', 'brown', 75),
    ('lemon', 'yellow', 25),
    ('orange', 'orange', 300),
    ('pear', 'green', 150),
    ('watermelon', 'pink', 90)"  // string $exec_statement

);



$pdostatement = $pdo->prepare(

    "SELECT name, colour FROM fruit", // string $statement,

    [
  PDO::ATTR_CASE => PDO::CASE_UPPER,
] // array $driver_options = array()

);



$bool = $pdostatement->execute(

      // array $input_parameters

);



$array = $pdostatement->fetchAll (
    
✓?, // [int $fetch_style]
    , // [mixed $fetch_argument]
      // [array $ctor_args = array()]
);
?>


      

                  
            $pdo
            =
            
'PDO instance'
          
                  
            $int
            =
            
7
          
                  
            $pdostatement
            =
            
'PDOStatement instance'
          
                  
            $bool
            =
            
true
          
                  
            $array
            =
            
[
  0 => [
    'NAME' => 'apple',
    0 => 'apple',
    'COLOUR' => 'red',
    1 => 'red',
  ],
  1 => [
    'NAME' => 'banana',
    0 => 'banana',
    'COLOUR' => 'yellow',
    1 => 'yellow',
  ],
  2 => [
    'NAME' => 'kiwi',
    0 => 'kiwi',
    'COLOUR' => 'brown',
    1 => 'brown',
  ],
  3 => [
    'NAME' => 'lemon',
    0 => 'lemon',
    'COLOUR' => 'yellow',
    1 => 'yellow',
  ],
  4 => [
    'NAME' => 'orange',
    0 => 'orange',
    'COLOUR' => 'orange',
    1 => 'orange',
  ],
  5 => [
    'NAME' => 'pear',
    0 => 'pear',
    'COLOUR' => 'green',
    1 => 'green',
  ],
  6 => [
    'NAME' => 'watermelon',
    0 => 'watermelon',
    'COLOUR' => 'pink',
    1 => 'pink',
  ],
]

`#1`	`PDOStatement::fetchAll`	`(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90)" / / $statement = "SELECT name, colour FROM fruit" / / $driver_options = [PDO::ATTR_CASE => PDO::CASE_UPPER] */)`
`#2`	`PDOStatement::fetchAll`	`(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90)" / / $statement = "SELECT name, colour FROM fruit" */ PDO::FETCH_COLUMN, 0)`
`#3`	`PDOStatement::fetchAll`	`(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90), ('apple', 'green', 150), ('pear', 'yellow', 150)" / / $statement = "SELECT name, colour FROM fruit" */ PDO::FETCH_COLUMN \| PDO::FETCH_GROUP)`
`#4`	`PDOStatement::fetchAll`	`(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90)" / / $statement = "SELECT name, colour FROM fruit" */ PDO::FETCH_CLASS)`
`#5`	`PDOStatement::fetchAll`	`(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90)" / / $statement = "SELECT name, colour FROM fruit" */ PDO::FETCH_FUNC, "fruit")`

$pdo	=	`'PDO instance'`
$int	=	`7`
$pdostatement	=	`'PDOStatement instance'`
$bool	=	`true`
$array	=	[ 0 => [ 'NAME' => 'apple', 0 => 'apple', 'COLOUR' => 'red', 1 => 'red', ], 1 => [ 'NAME' => 'banana', 0 => 'banana', 'COLOUR' => 'yellow', 1 => 'yellow', ], 2 => [ 'NAME' => 'kiwi', 0 => 'kiwi', 'COLOUR' => 'brown', 1 => 'brown', ], 3 => [ 'NAME' => 'lemon', 0 => 'lemon', 'COLOUR' => 'yellow', 1 => 'yellow', ], 4 => [ 'NAME' => 'orange', 0 => 'orange', 'COLOUR' => 'orange', 1 => 'orange', ], 5 => [ 'NAME' => 'pear', 0 => 'pear', 'COLOUR' => 'green', 1 => 'green', ], 6 => [ 'NAME' => 'watermelon', 0 => 'watermelon', 'COLOUR' => 'pink', 1 => 'pink', ], ]

PDOStatement::fetchAll()