composer 安装

windows 下安装参考 https://www.cnblogs.com/bean-sprout/p/6377085.html

linux安装
1. 下载composer
curl -sS https://getcomposer.org/installer | php

//下载成功
Composer (version 1.10.10) successfully installed to: /root/composer.phar
Use it: php composer.phar

2. 进入 /root目录 移动或复制composer到环境下可执行
mv composer.phar /usr/local/bin/composer

3. 测试是否安装成功
composer -V
4. 这步很关键，更新composer为国内源,不然经常会超时或者直接连不上。
composer config -g repo.packagist composer https://packagist.phpcomposer.com

composer 命令

composer list #显示所有命令

composer show #显示所有包信息

composer install #在 composer.json 配置中添加依赖库之后运行此命令安装

composer create-project laravel/laravel Laravel --prefer-dist 5.1.* #创建项目

composer search packagename #搜索包

composer update #更新所有包

composer update monolog/monolog #更新指定包

composer remove monolog/monolog #移除指定的包

composer require monolog/monolog #添加指定包

composer require monolog/monolog:1.19 #添加指定包和版本

composer require monolog/monolog=1.19 #添加指定包和版本

composer require monolog/monolog 1.19 #添加指定包和版本

composer dump-autoload #如果更新了composer.json需要更新autoload

tp5 安装(windows cmd 运行)

composer create-project topthink/think tp5 –prefer-dist

验证码和图片类安装
1. composer require topthink/think-captcha
2. composer require topthink/think-image
3. composer require topthink/think-testing

更新包 composer update


在多版本php环境,指定composer使用的php版本

https://my.oschina.net/wangyongtao/blog/1844554

composer命令介绍

https://learnku.com/docs/composer/2018/03-cli/2084

##  excel扩展安装
1. 切换到你网站的根目录
cd /home/wwwroot/xxxx
2. 下载PHPExcel
composer require phpoffice/phpexcel
3. 在项目中使用excel表格导出

function export(){//导出Excel
    $xlsName  = "export";
    $xlsCell  = array(
        array('uid','账号序列'),
        array('nickname','名字'),
        array('email','邮箱'),
    );
    $xlsData  = Db::name('表名')->Field('uid,nickname,email')->select();
    exportExcel($xlsName,$xlsCell,$xlsData);
}

// common.php
/**
* [exportExcel Excel 表格导出]
* @param  [type] $expTitle     [文件名称]
* @param  [type] $expCellName  [表头名称]
* @param  [type] $expTableData [要导出的数据]
*/
function exportExcel($expTitle,$expCellName,$expTableData){
    //include_once EXTEND_PATH.'PHPExcel/PHPExcel.php';//方法二
    $xlsTitle = iconv('utf-8', 'gb2312', $expTitle);//文件名称
    $fileName = $expTitle.date('_YmdHis');//or $xlsTitle 文件名称可根据自己情况设定
    $cellNum = count($expCellName);
    $dataNum = count($expTableData);
    //方法一 composer安装使用
    $objPHPExcel = new PHPExcel();
    //方法二 放在extend引用
    //$objPHPExcel = new \PHPExcel();
    $cellName = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ','AK','AL','AM','AN','AO','AP','AQ','AR','AS','AT','AU','AV','AW','AX','AY','AZ');
    $objPHPExcel->getActiveSheet(0)->mergeCells('A1:'.$cellName[$cellNum-1].'1');//合并单元格
    $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $expTitle.'  Export time:'.date('Y-m-d H:i:s'));
    for($i=0;$i<$cellNum;$i++){
        $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i].'2', $expCellName[$i][1]);
    }
    // Miscellaneous glyphs, UTF-8
    for($i=0;$i<$dataNum;$i++){
        for($j=0;$j<$cellNum;$j++){
            $objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j].($i+3), $expTableData[$i][$expCellName[$j][0]]);
        }
    }
    ob_end_clean();//这一步非常关键，用来清除缓冲区防止导出的excel乱码
    header('pragma:public');
    header('Content-type:application/vnd.ms-excel;charset=utf-8;name="'.$xlsTitle.'.xls"');
    header("Content-Disposition:attachment;filename=$fileName.xls");//"xls"参考下一条备注
    $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');//"Excel2007"生成2007版本的xlsx，"Excel5"生成2003版本的xls
    $objWriter->save('php://output');
    exit;
}