SimplePHP\Model\CRUD::update()

Complexity

Conditions	7
Paths	48

Size

Total Lines	28
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function update(String $params, Array $values, Int $primary): bool
    {
        $params = explode(',', $params);
        $data = [];
        $countParams = count($params);
        for($i = 0; $i < $countParams; $i++) {
            $data[$i] = ":".$params[$i][0].$params[$i][1].$params[$i][2].", ";
        }
        $result = '';
        $final = array_map(null, $params, $data);
        foreach($final as $key => $vals) {
            foreach($vals as $chave => $val) {
                $result .= str_replace(':', ' = :', $val);
            }
        }
        $result = rtrim($result, ', ');
        $sql = $this->conn->prepare("UPDATE {$this->table} SET {$result} WHERE {$this->primary} = '{$primary}'");
        for($i = 0; $i < $countParams; $i++) {
            $data[$i] = ":".$params[$i][0].$params[$i][1].$params[$i][2];
        }
        $countData = count($data);
        for($i = 0; $i < $countData; $i++) {
            $sql->bindParam($data[$i], $values[$i]);
        }
        if($sql->execute()) {
            return true;
        } else {
            return false;
        }
}