Anonymous

class WpSqlInsertBuilder extends WpStatmentBuilder 
{
    private $values;
    
    public function __construct($fields)
    {
        $cols   = '';
        $values = '';
        $lastValue = end($fields);
        $lastCol   = key($fields);
                     array_pop($fields);
        
        foreach ($fields as $column => $value)
        {
            $cols   .= "$column, ";
            $values .= "'$value', ";
        }
        
        $this->values = " ($cols $lastCol) VALUES($values '$lastValue')";
        return $this;
    }
    
    public function into($table)
    {
        $this->sql = 'INSERT INTO ' . $table . $this->values;
        return $this;
    }
}