LessQL\Database::insertPrepared PHP Method

insertPrepared() protected method

Insert rows using a prepared query
protected insertPrepared ( string $table, array $rows ) : PDOStatement | null
$table string
$rows array
return PDOStatement | null
    protected function insertPrepared($table, $rows)
    {
        $columns = $this->getColumns($rows);
        if (empty($columns)) {
            return;
        }
        $query = $this->insertHead($table, $columns);
        $query .= "( ?" . str_repeat(", ?", count($columns) - 1) . " )";
        $statement = $this->prepare($query);
        foreach ($rows as $row) {
            $values = array();
            foreach ($columns as $column) {
                $value = (string) $this->format(@$row[$column]);
                $values[] = $value;
            }
            $this->onQuery($query, $values);
            $statement->execute($values);
        }
        return $statement;
    }