public function buildInsertQuery($table, $data)
    {
        $sql = "INSERT INTO " . $this->quoteSpecialName($table) . " ";

        if (!empty($data['ON DUPLICATE'])) {
            $onDuplicate = $data['ON DUPLICATE'];
            unset($data['ON DUPLICATE']);
        }

        $keys = $values = '';

        foreach ($data as $key => $value) {
            if (!empty($keys)) $keys .= ', ';
            if (!empty($values)) $values .= ', ';

            $keys .= '`' . $key . '`';
            $values .= $this->escapeItem($value);
        }

        $keys = '(' . $keys . ')';
        $values = '(' . $values . ')';

        $sql .= $keys . ' VALUES ' . $values;

        if (!empty($onDuplicate)) {
            $sql .= " ON DUPLICATE KEY UPDATE " . $onDuplicate;
        }

        $sql .= ';';

        return $sql;
    }
public function buildInsertQuery($table, $data)
    {
        $sql = "INSERT INTO " . $this->quoteSpecialName($table) . " ";

        if (!empty($data['ON DUPLICATE'])) {
            $onDuplicate = $data['ON DUPLICATE'];
            unset($data['ON DUPLICATE']);
        }

        $keys = $values = '';

        foreach ($data as $key => $value) {
            if (!empty($keys)) $keys .= ', ';
            if (!empty($values)) $values .= ', ';

            $keys .= '`' . $key . '`';
            $values .= $this->escapeItem($value);
        }

        $keys = '(' . $keys . ')';
        $values = '(' . $values . ')';

        $sql .= $keys . ' VALUES ' . $values;

        if (!empty($onDuplicate)) {
            $sql .= " ON DUPLICATE KEY UPDATE " . $onDuplicate;
        }

        $sql .= ';';

        return $sql;
    }
public function buildInsertQuery ( $ table , $ data ) { $ sql = "INSERT INTO " . $ this -> quoteSpecialName ( $ table ) . " " ; if ( ! empty ( $ data [ 'ON DUPLICATE' ] ) ) { $ onDuplicate = $ data [ 'ON DUPLICATE' ] ; unset ( $ data [ 'ON DUPLICATE' ] ) ; } $ keys = $ values = '' ; foreach ( $ data as $ key => $ value ) { if ( ! empty ( $ keys ) ) $ keys .= ', ' ; if ( ! empty ( $ values ) ) $ values .= ', ' ; $ keys .= '`' . $ key . '`' ; $ values .= $ this -> escapeItem ( $ value ) ; } $ keys = '(' . $ keys . ')' ; $ values = '(' . $ values . ')' ; $ sql .= $ keys . ' VALUES ' . $ values ; if ( ! empty ( $ onDuplicate ) ) { $ sql .= " ON DUPLICATE KEY UPDATE " . $ onDuplicate ; } $ sql .= ';' ; return $ sql ; }
Perform an insert query

@param string $table
@param string[] $data
@return integer|boolean
Perform an insert query