PHP Archives - 俺的BLOG

Laravel的oauth使用

Laravel中使用oauth做授权认证，包含1. 颁发访问令牌（授权码，最常用）；2. 密码授权令牌；3. 隐式授权令牌；4.客户端凭证授权令牌；5.私人访问令牌

参考文档：

Laravel之分页

获取数据集时使用paginate()方法。
视图文件中加载显示分页链接。

示例代码参考：

//Controller: 
$query = SendMessages::query()->orderBy('id', 'desc'); 
$record = $query->paginate($request->input('limit')??10);//paginate()的参数是每页显示的条数

//Controller:

$query = SendMessages::query()->orderBy('id', 'desc');

$record = $query->paginate($request->input('limit')??10);//paginate()的参数是每页显示的条数

//view:

...//table表格内容

{!! $record->links('vendor/pagination/default') !!}

//view:

...//table表格内容

{!! $record->links('vendor/pagination/default') !!}

效果图：

Laravel使用oauth时的报错修复

若出现类似错误提示 get id of no-object ，且定位发现错误出现在/vendor/laravel/passport/src/PersonalAccessTokenFactory.php文件中的类似代码：$client->id ，则只需执行以下命令创建新的client即可：php artisan passport:install

【参考：https://laravel.com/docs/5.8/passport】

Laravel中使用excel导入导出

使用composer安装库：composer require maatwebsite/excel

项目地址：https://github.com/Maatwebsite/Laravel-Excel

导入：

创建Import对象：php artisan make:import UsersImport
将导入的excel内容解析成数组：$excelContent = Excel::toArray(new UsersImport, $request->file('user_file'));

导出：

创建Export对象：php artisan make:export UsersExport
修改collection()方法，返回要导出的数据return collect($exportArrayData）;
保存导出的excel文件:

$fileName = date("Y-m-d_H:i:s").'.xls';
$res = Excel::store(new UsersExport($exportArrayData), $fileName, 'oss');//oss表示存储方式用oss，也可以用local等存储在storage目录中（具体参考项目配置文件 config/filesystems.php），通过实例化UsersExport传递初始化参数，为collect方法提供导出数据。

1 2	$fileName = date("Y-m-d_H:i:s").'.xls'; $res = Excel::store(new UsersExport($exportArrayData), $fileName, 'oss');//oss表示存储方式用oss，也可以用local等存储在storage目录中（具体参考项目配置文件 config/filesystems.php），通过实例化UsersExport传递初始化参数，为collect方法提供导出数据。

【参考：https://docs.laravel-excel.com/3.1/exports/】

Laravel使用提示

1。为env文件生成secret： php artisan key:generate

2。启用oauth时，需要执行以下命令创建认证文件：

- run: openssl genrsa -out storage/oauth-private.key 4096
 - run: openssl rsa -in storage/oauth-private.key -pubout > storage/oauth-public.key
（否则会报类似错误： <code>storage/oauth-public.key" does not exist or is not readable  </code>）

- run: openssl genrsa -out storage/oauth-private.key 4096

- run: openssl rsa -in storage/oauth-private.key -pubout > storage/oauth-public.key

（否则会报类似错误： <code>storage/oauth-public.key" does not exist or is not readable </code>）

laravel解析excel文件中的日期字段

使用以下类库解析excel：https://github.com/Maatwebsite/Laravel-Excel

需要解析日期字段时，建议使用 PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($dateFromExcel) ，封装后的方法如下，

function transformDate($value, $format = 'Y-m-d')
{
    try {
        return \Carbon\Carbon::instance(\PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($value));
    } catch (\ErrorException $e) {
        return \Carbon\Carbon::createFromFormat($format, $value);
    }
}

function transformDate($value, $format = 'Y-m-d')

{

try {

return \Carbon\Carbon::instance(\PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($value));

} catch (\ErrorException $e) {

return \Carbon\Carbon::createFromFormat($format, $value);

}

【参考】

1. https://github.com/Maatwebsite/Laravel-Excel;

2. https://github.com/Maatwebsite/Laravel-Excel/issues/1832#issuecomment-442572868

composer国内镜像源

使用方法：

修改项目根目录中的composer.json，修改或添加以下内容：

"repositories": {
        "packagist": {
            "type": "composer",
            "url": "https://packagist.laravel-china.org"
        }
    }

"repositories": {

"packagist": {

"type": "composer",

"url": "https://packagist.laravel-china.org"

}

镜像源地址：

https://packagist.laravel-china.org/

安装swoole

若使用pecl或编译安装swoole时，出现如下类似错误，

undefined symbol: __builtin_saddl_overflow

1	undefined symbol: __builtin_saddl_overflow

则需要升级下gcc(达到5.0以上版本)：

sudo yum install -y yum-utils  centos-release-scl
sudo yum -y --enablerepo=centos-sclo-rh-testing install devtoolset-7-gcc
echo "source /opt/rh/devtoolset-7/enable" | sudo  tee -a /etc/profile
source /opt/rh/devtoolset-7/enable
gcc --version

sudo yum install -y yum-utils centos-release-scl

sudo yum -y --enablerepo=centos-sclo-rh-testing install devtoolset-7-gcc

echo "source /opt/rh/devtoolset-7/enable" | sudo tee -a /etc/profile

source /opt/rh/devtoolset-7/enable

gcc --version

【摘自：】https://forum.phalconphp.com/discussion/17595/problem-with-compiled-phalcon-with-php-721

安装swoole时可能出现的错误

错误内容类似如下：

define UNEXPECTED(condition) __builtin_expect(!!(condition), 0)

1	define UNEXPECTED(condition) __builtin_expect(!!(condition), 0)

解决方式：

sudo yum install centos-release-scl
sudo yum install devtoolset-7
scl enable devtoolset-7 bash

sudo yum install centos-release-scl

sudo yum install devtoolset-7

scl enable devtoolset-7 bash

【摘自：】https://github.com/swoole/swoole-src/issues/2119

PS, 用 pecl install swoole 时，使用默认安装配置项比较容易成功

yum安装PHP7

The CentOS 7 official software repositories have PHP 5.4 which has reached the end of life and no longer actively maintained by the developers.

To keep up with the latest features and security updates, you need a newer (probably the latest) version of PHP on your CentOS 7 system.

For the purpose of this guide, we will be operating the system as root, if that is not the case for you, make use of the sudo command to acquire root privileges.

Installing PHP 7 on CentOS 7

1. To install PHP 7, you have to install and enable EPEL and Remi repository on your CentOS 7 system with the commands below.

# yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
# yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm

1 2	# yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm # yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm

2. Next, you need to install yum-utils, a collection of useful programs for managing yum repositories and packages. It has tools that basically extend yum’s default features.

It can be used for managing (enabling or disabling) yum repositories as well as packages without any manual configuration and so much more.

# yum install yum-utils

1	# yum install yum-utils

3. One of the programs provided by yum-utils is yum-config-manager, which you can use to enable Remirepository as the default repository for installing different PHP versions as shown.

# yum-config-manager --enable remi-php70   [<strong>Install PHP 7.0</strong>]

1	# yum-config-manager --enable remi-php70 [<strong>Install PHP 7.0</strong>]

If you want to install PHP 7.1, PHP 7.2 or PHP 7.3 on CentOS 7, just enable it as shown.

# yum-config-manager --enable remi-php71   [<strong>Install PHP 7.1</strong>]
# yum-config-manager --enable remi-php72   [<strong>Install PHP 7.2</strong>]
# yum-config-manager --enable remi-php73   [<strong>Install PHP 7.3</strong>]

# yum-config-manager --enable remi-php71 [Install PHP 7.1]

# yum-config-manager --enable remi-php72 [Install PHP 7.2]

# yum-config-manager --enable remi-php73 [Install PHP 7.3]

4. Now install PHP 7 with all necessary modules with the command below.

# yum install php php-mcrypt php-cli php-gd php-curl php-mysql php-ldap php-zip php-fileinfo

1	# yum install php php-mcrypt php-cli php-gd php-curl php-mysql php-ldap php-zip php-fileinfo

Afterwards, double check the installed version of PHP on your system.

# php -v

# php -v

Check PHP Version in CentOS 7

【原文：】https://www.tecmint.com/install-php-7-in-centos-7/