public function insertIgnore(string $table, array $values, ?array $excludeEmptyColumns = null)
    {
        if (null !== $excludeEmptyColumns) {
            $values = SqlPreparator::setNullValues($values, $excludeEmptyColumns);
        }

        [$sql, $params] = array_values(SqlPreparator::prepareInsertIgnore($table, $values));

        $this->conn->executeUpdate($sql, $params);

        return $this->getLastInsertId();
    }
public function insertIgnore(string $table, array $values, ?array $excludeEmptyColumns = null)
    {
        if (null !== $excludeEmptyColumns) {
            $values = SqlPreparator::setNullValues($values, $excludeEmptyColumns);
        }

        [$sql, $params] = array_values(SqlPreparator::prepareInsertIgnore($table, $values));

        $this->conn->executeUpdate($sql, $params);

        return $this->getLastInsertId();
    }
public function insertIgnore ( string $ table , array $ values , ? array $ excludeEmptyColumns = null ) { if ( null !== $ excludeEmptyColumns ) { $ values = SqlPreparator :: setNullValues ( $ values , $ excludeEmptyColumns ) ; } [ $ sql , $ params ] = array_values ( SqlPreparator :: prepareInsertIgnore ( $ table , $ values ) ) ; $ this -> conn -> executeUpdate ( $ sql , $ params ) ; return $ this -> getLastInsertId ( ) ; }
executes "INSERT IGNORE" sql statement by array of parameters

@param string     $table               table name
@param array      $values              values
@param array|null $excludeEmptyColumns array of columns that can contain zero-equal values, set to null
if you want to disable auto-null entirely [default: null]

@return int|string InsertId
executes INSERT IGNORE sql statement by array of parameters