MySQLi编写的语句：一行中的短版本

Question

In PHP, I use a lot of one liners like:

Fetch value:

$sql->query("SELECT ID FROM table WHERE condition = 1")->fetch_object()->ID;

Fetch row:

$sql->query("SELECT * FROM table WHERE condition = 1")->fetch_assoc();

Fetch rows:

$sql->query("SELECT * FROM table WHERE condition > 1")->fetch_all(MYSQLI_ASSOC);

Insert row:

$sql->query("INSERT INTO table(`row1`,`row2`) VALUES('".$data1."','".$data2."')");

Delete row:

$sql->query("DELETE FROM table WHERE condition = 1");

Are there also beautiful one liners for prepared statements?

This fails:

$sql->prepare("SELECT ID FROM table WHERE condition = ?")->bind_param("i", $a=1)->execute()->fetch_object()->ID;

This works:

$query = $sql->prepare("SELECT ID FROM table WHERE condition = ?");
$query->bind_param("i", $a=1);
$query->execute();
$query->get_result()->fetch_object()->ID;

Answer 1

Directly - there is no way. But you may use a simple overlay class which will allow you to do so.

class PrepareOverlay {
    private $stmt;  
    private $lastResult = null;      

    public function __construct(PDOStatement $stmt) {
        $this->stmt = $stmt;
    }

    public function __call($name, $arguments) {
        $this->lastResult = call_user_func_array([$this->stmt, $name], $arguments);
        return is_bool($this->lastResult) ? $this : $this->lastResult;
    }

    public function getLastResult() {
        return $this->lastResult;
    }

    public static function prepare($sql, $query) {
        return new self($sql->prepare($query));
    }
}

And use it like this:

PrepareOverlay::prepare($sql, 'SELECT * FROM table WHERE cond = ?')->bindParam('i', $a=1)->execute()->fetchObject()->ID;

Although you will need some phpdoc to make code completion work.