mindplay\sql\framework\QueryFormatter

Complexity

Total Complexity

4

Size/Duplication

Total Lines	21
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	formatQuery()	0	12	4

<?php

namespace mindplay\sql\framework;

class QueryFormatter
{
    /**
     * @param string $sql
     * @param array  $params
     *
     * @return string SQL with emulated prepare (for diagnostic purposes only)
     */
    public static function formatQuery($sql, $params)
    {
        foreach ($params as $name => $value) {
            $quoted_value = $value === null
                ? "NULL"
                : (is_numeric($value) ? $value : "'{$value}'");

            $sql = str_replace(":{$name}", $quoted_value, $sql);
        }

        return $sql;
    }
}