ellisgl / GeekLab-GLPDO2

src/Bindings/MySQL/MySQLStringBindings.php

<?php

namespace GeekLab\GLPDO2\Bindings\MySQL;

use GeekLab\GLPDO2\Bindings\StringBindingInterface;
use InvalidArgumentException;
use JsonException;
use PDO;

class MySQLStringBindings implements StringBindingInterface
{
    /**
     * @param mixed $value
     * @param bool  $null
     *
     * @return array{string, int}

The doc comment array{string, int} at position 2 could not be parsed: Expected ':' at position 2, but found 'string'.

     * @throws JsonException
     */
    public function bJSON(mixed $value, bool $null = false): array
    {
        // Use NULL?
        if ($value === null) {
            if ($null) {
                return $this->bStr(null, true);
            }

            throw new JsonException('Can not bind NULL in JSON spot.');
        }

        if (is_object($value)) {
            $value = json_encode($value);
        } elseif (is_string($value)) {
            $JSON = json_decode($value, false, 255);

            if (json_last_error()) {
                throw new JsonException('Can not bind invalid JSON in JSON spot. (' . json_last_error_msg() . ')');
            }

            $value = json_encode($JSON);
        } else {
            throw new JsonException('Can not bind invalid JSON in JSON spot. (' . $value . ')');
        }

        return $this->bStr($value);
    }

    /**
     * Create and bind string for LIKE() statements.
     *
     * @param string $value
     * @param bool   $ends   Ends with?
     * @param bool   $starts Starts with?
     *
     * @return array{string}

The doc comment array{string} at position 2 could not be parsed: Expected ':' at position 2, but found 'string'.

     */
    public function bLike(string $value, bool $ends = false, bool $starts = false): array
    {
        $arr = ['%', $value, '%'];

        if ($starts) {
            // Starts with.
            array_shift($arr);
        }

        if ($ends) {
            // Ends with.
            array_pop($arr);
        }

        return [implode('', $arr)];
    }

    /**
     * Bind a string value.
     *
     * @param float | bool | int | string | null $value
     * @param bool                               $null
     * @param int                                $type
     *
     * @return array{string, int}

The doc comment array{string, int} at position 2 could not be parsed: Expected ':' at position 2, but found 'string'.

     * @throws InvalidArgumentException
     */
    public function bStr(
        float | bool | int | string | null $value,
        bool $null = false,
        int $type = PDO::PARAM_STR
    ): array {
        if ($value === null) {
            if (!$null) {
                throw new InvalidArgumentException('Can not bind NULL in string spot.');
            }

            $type = PDO::PARAM_NULL;
        }

        return [(string)$value, $type];
    }

    /**
     * Convert an array into a string and bind it.
     * Great for IN() statements.
     *
     * @param array{} | array{mixed}      $values

The doc comment array{} | array{mixed} at position 6 could not be parsed: Expected ':' at position 6, but found 'mixed'.

     * @param float | bool | int | string $default
     *
     * @return array{float | bool | int | string}

The doc comment array{float | bool | int | string} at position 2 could not be parsed: Expected ':' at position 2, but found 'float'.

     */
    public function bStrArr(array $values, float | bool | int | string $default = ''): array
    {
        return [empty($values) ? $default : '\'' . implode("', '", $values) . '\''];
    }
}