lzg, Author at 俺的BLOG

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

Laravel中使用excel导入导出

使用composer安装库：composer require maatwebsite/excel 项目地址：https://github.com/Maatwebsite/Laravel-Excel 导入：创建Import对象：php artisan make:import UsersImport将导入的excel内容解析成数组：$excelContent = Excel::toArray …

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>）

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/Maatwebsit …

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/

Scrapy爬取内容去重

使用以下pipeline即可：

from scrapy.exceptions import DropItem

class DuplicatesPipeline(object):

    def __init__(self):
        self.ids_seen = set()

    def process_item(self, item, spider):
        if item['id'] in self.ids_seen:
            raise DropItem("Duplicate item found: %s" % item)
        else:
            self.ids_seen.add(item['id'])
            return item

from scrapy.exceptions import DropItem

class DuplicatesPipeline(object):

def __init__(self):

self.ids_seen = set()

def process_item(self, item, spider):

if item['id'] in self.ids_seen:

raise DropItem("Duplicate item found: %s" % item)

else:

self.ids_seen.add(item['id'])

return item

【摘自：】https://docs.scrapy.org/en/latest/topics/item-pipeline.html#duplicates-filter

当你写爬虫抓不到APP请求包的时候该怎么办？

原文链接：https://zhuanlan.zhihu.com/p/46433599

作者存档：lzg