Online PHP editor | output for UbM1N

@ 2019-06-03T05:36:38Z

<?php

class Database
{
    protected static $instance;
    protected $pdo;
    protected $lastExecute;
    
    protected function __construct()
    {
        $this->pdo = new PDO('sqlite::memory:');
    }
    
    public static function instance()
    {
        if (null === self::$instance) {
            self::$instance = new self;
        }

        return self::$instance;
    }
    
    /**
     * @return PDOStatement|false
     */
    public function run($sql, $args = [])
    {
        if (!$args) {
            return $this->pdo->query($sql);
        }
        if ($stmt = $this->pdo->prepare($sql)) {
            $this->lastExecute = $stmt->execute($args);
        }

        return $stmt;
    }

    /**
     * @return null|bool
     */
    public function getLastExecute()
    {
       return $this->lastExecute;
    }
    
    public function __call($method, $args)
    {
        if (is_callable([$this->pdo, $method])) {
            //php 5.6+ variadic optimization (aka splat operator)
            return $this->pdo->$method(...$args);
            //PHP <= 5.5
            //return call_user_func_array(array($this->pdo, $method), $args);
        }
        throw new \BadMethodCallException(sprintf('Unknown method PDO::%s called!', $method));
    }
}


//RunTime code
$db = Database::instance();
$db->run('SELECT ?', ['foo', 'bar']);
var_dump($db->getLastExecute()); //false

Output for 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.34, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33: bool(false)
Output for 4.4.2 - 4.4.9: Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /in/UbM1N on line 5
Process exited with code 255.
Output for 4.3.0 - 4.3.1, 4.3.5 - 4.3.11, 4.4.0 - 4.4.1: Parse error: parse error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /in/UbM1N on line 5
Process exited with code 255.
Output for 4.3.2 - 4.3.4: Parse error: parse error, expecting `T_OLD_FUNCTION' or `T_FUNCTION' or `T_VAR' or `'}'' in /in/UbM1N on line 5
Process exited with code 255.
Output for 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29: Parse error: syntax error, unexpected '[' in /in/UbM1N on line 26
Process exited with code 255.
Output for 5.0.0 - 5.0.5: Parse error: parse error, unexpected '[' in /in/UbM1N on line 26
Process exited with code 255.
Output for 5.4.0 - 5.4.45: Parse error: syntax error, unexpected '.', expecting ')' in /in/UbM1N on line 50
Process exited with code 255.
Output for 5.5.0 - 5.5.38: Parse error: syntax error, unexpected '.' in /in/UbM1N on line 50
Process exited with code 255.
Output for 8.0.0 - 8.0.30, 8.1.0 - 8.1.34, 8.2.0 - 8.2.34, 8.3.0 - 8.3.35, 8.4.1 - 8.4.26, 8.5.0 - 8.5.11: Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 25 column index out of range in /in/UbM1N:32 Stack trace: #0 /in/UbM1N(32): PDOStatement->execute(Array) #1 /in/UbM1N(61): Database->run('SELECT ?', Array) #2 {main} thrown in /in/UbM1N on line 32
Process exited with code 255.

preferences:dark modelive previewkey bindings