Download the PHP package m35/thecsv without Composer
On this page you can find all versions of the php package m35/thecsv. 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 thecsv
yii2-thecsv
yii2 csv export extension
1. Install
Run php composer.phar require m35/thecsv
or
Add "m35/thecsv": "*" in your composer.json file.
2. Usage
3. Parameters & Examples
3.0 Parameters
3.0.1 string type
You can specify a table name as the parameter, and it would export all the data of the table and automatically generate the table fields name as csv header.
3.0.2 array type
-
table：table name (string)
-
fields：the table fields you want to export, it would export all the fields if you not set (array)
-
exceptFields：except the table fields you set above if ture，default to false(bool)
-
header：the csv header(array)
-
condition：use the condition in where part with the table(mixed). for details: http://www.yiiframework.com/doc-2.0/yii-db-query.html#where()-detail
-
limit：limit with the table(int)
-
offset：offset with the table(int)
-
orderby：order by with the table(mixed). for details: http://www.yiiframework.com/doc-2.0/yii-db-querytrait.html#orderBy()-detail
-
name：the export file name. e.g.'data.csv', automatically generate if you not set(string)
-
sql：use the SQL syntax to export the data(string)
-
bind：bind values with the SQL syntax(array)
-
target：the directory name you want to save the file, it would turn the behavior to save the file on server other than downloading the file(string)
-
fp：you can directly specify the resource to put the data(resource)
-
data：directly set the export data other than selecting from table(array)
-
query：Yii2 Framework Query object(yii\db\Query). for details: http://www.yiiframework.com/doc-2.0/yii-db-query.html
-
reader：Yii2 Framework DataReader object(yii\db\DataReader). for details: http://www.yiiframework.com/doc-2.0/yii-db-datareader.html
3.1 Examples: export the table data（assume we have a table named 'user'）
3.1.1 Export all data from 'user' table
3.1.2 Export just 'username' and 'password' fields of the 'user' table
3.1.3 Export data without 'status' field
3.1.4 Export just 'username' and 'password' fields of the 'user' table and specify the csv header
3.1.5 Export the data without header
3.1.6 Export the active user data using condition
for details: http://www.yiiframework.com/doc-2.0/yii-db-query.html#where()-detail
3.1.7 Export the active user data using condition, orderby and limit
3.1.8 Using SQL syntax
3.1.9 Using SQL syntax and bind values
3.1.10 Using Query object
for details: http://www.yiiframework.com/doc-2.0/yii-db-query.html
3.1.11 Using DataReader object
for details: http://www.yiiframework.com/doc-2.0/yii-db-datareader.html
3.2 Example: export data
3.3、Examples: other
3.3.1
3.3.2
3.3.3
yii2-thecsv（Yii2框架csv数据导出扩展）
1、安装
运行 php composer.phar require m35/thecsv
或
添加 "m35/thecsv": "*"
2、使用
3、参数及示例
3.0、参数列表
3.0.1、string类型
直接指定表名称，下载该表所有数据，自动生成表字段名称。
3.0.2、array类型参数
-
table：数据表名称 (string)
-
fields：要导出的表字段 (array)
-
exceptFields：是否是排除字段模式，默认false(bool)
-
header：自定义表头(array)
-
condition：导出表条件(mixed) 请参考http://www.yiiframework.com/doc-2.0/yii-db-query.html#where()-detail
-
limit：限制数量(int)
-
offset：偏移(int)
-
orderby：排序(mixed) 请参考http://www.yiiframework.com/doc-2.0/yii-db-querytrait.html#orderBy()-detail
-
name：自定义文件名(string)
-
sql：自定义SQL语句(string)
-
bind：与sql结合绑定参数(array)
-
target：导出目录，如果设置target，则默认行为由下载变为保存文件到服务器(string)
-
fp：直接导出数据到指定的资源(resource)
-
data：自定义导出数据(array)
-
query：Yii2框架Query类型对象(yii\db\Query) 请参考http://www.yiiframework.com/doc-2.0/yii-db-query.html
-
reader：Yii2框架DataReader类型对象(yii\db\DataReader) 请参考http://www.yiiframework.com/doc-2.0/yii-db-datareader.html
3.1、示例：导出数据表（以user表为例子）
3.1.1、导出数据表完整数据
3.1.2、导出user表的用户名和密码
3.1.3、导出user表除status字段外的所有数据
3.1.4、导出user表的用户名和密码，自定义表头
3.1.5、导出user表的用户名和密码，不要表头
3.1.6、导出user表有效用户，使用condition
condition请参考http://www.yiiframework.com/doc-2.0/yii-db-query.html#where()-detail
3.1.7、导出user表有效用户，使用orderby和limit
3.1.8、自定义SQL
3.1.9、自定义SQL，绑定参数
3.1.10、使用Query
3.1.11、使用reader
3.2、示例：导出数据
3.3、示例：其他
3.3.1
3.3.2
3.3.3
All versions of thecsv with dependencies
PHP Build Version
Package Version
No informations.
The package m35/thecsv contains the following files
Loading the files please wait ....