Download the PHP package flyokai/zend-db-sql-insertmultiple without Composer
On this page you can find all versions of the php package flyokai/zend-db-sql-insertmultiple. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.
Example:
Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories.
In this case some credentials are needed to access such packages.
Please use the auth.json textarea to insert credentials, if a package is coming from a private repository.
You can look here for more information.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?
Informations about the package zend-db-sql-insertmultiple
flyokai/zend-db-sql-insertmultiple
User docs →
AGENTS.mdMulti-row
INSERT INTO … VALUES (…), (…), (…)for Laminas DB.
Adds Laminas\Db\Sql\InsertMultiple, a single-statement multi-row insert builder that is otherwise missing from Laminas DB. Adapted from the original Zend\Db\Sql\Insert.
Features
- Multi-row
INSERT … VALUES (…), (…), (…) INSERT … SELECT- Two value-merging strategies:
VALUES_SET(replace) andVALUES_MERGE(append) - Compatible with Laminas
Sql::buildSqlString()/Sql::prepareStatementForSqlObject()
Installation
Quick start
Multi-row insert
INSERT … SELECT
Value merging
API
| Method | Purpose |
|---|---|
into(string $table) |
Set target table |
columns(array $columns) |
Define column list (call before values()) |
values(array\|Select $values, int $flag = VALUES_SET) |
Set/append rows or provide a Select |
select(Select $select) |
Convenience for INSERT…SELECT |
getRawState($key) |
Introspect internal state (for debugging) |
Internals
- Each row is
ksort()-ed for consistent column ordering. - Named parameters are generated as
insMulti0,insMulti1, … - Non-scalar values (Expressions, Literals) are cached per column to avoid redundant SQL generation.
Gotchas
columns()is required beforevalues()with array data. Missing columns throwsInvalidArgumentException.- No built-in chunking — generates a single statement for all rows. MySQL has statement size limits (~1000 tuples by default). Calling code must chunk.
- Empty values produce empty SQL — if no rows,
processInsert()returns an empty string silently. - Cannot mix
VALUES_MERGEwith aSelect— throws. - Parameter naming is global — counter is shared across all rows (
insMulti0,insMulti1, …).
See also
flyokai/laminas-db-bulk-update—InsertOnDuplicateextendsInsertMultiplewith upsert behaviour and ID resolutionflyokai/laminas-db— base abstraction
License
BSD-3-Clause
All versions of zend-db-sql-insertmultiple with dependencies
PHP Build Version
Package Version
Requires
php Version
>=5.3.23
laminas/laminas-db Version ~2.5
laminas/laminas-stdlib Version ^2.5 || ^3.0
laminas/laminas-db Version ~2.5
laminas/laminas-stdlib Version ^2.5 || ^3.0
The package flyokai/zend-db-sql-insertmultiple contains the following files
Loading the files please wait ...