Willry\QueryBuilder\QueryHelpers::bind()

Complexity

Conditions	6
Paths	9

Size

Total Lines	23
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	0	Features	0

<?php
    public static function bind(\PDOStatement &$stmt, array $params = [])
    {
        $defaultType = \PDO::PARAM_STR;

        foreach ($params as $key => $value) {
            $type = $defaultType;

            if (is_int($value)) {
                $type = \PDO::PARAM_INT;
            }

            if (is_resource($value)) {
                $type = \PDO::PARAM_LOB;
            }

            if (is_bool($value)) {
                $type = \PDO::PARAM_BOOL;
            }

            $stmt->bindValue(
                is_string($key) ? $key : $key + 1,
                $value,
                $type
            );
}