PHP code example of ckales / elasticsearch-sql-hyperf

1. Go to this page and download the library: Download ckales/elasticsearch-sql-hyperf library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

ckales / elasticsearch-sql-hyperf example snippets


composer 



declare(strict_types=1);

return [
    'default' => [
        'host' 		    => 'xxx', // es地址
        'user' 		    => 'xxx', // 用户名
        'password' 	    => 'xxx', // 密码
        'retries'	    => 5, // 重试次数
        'debug'	        => false, // 调试模式，true时会输入转换后es搜索格式
        'log_config'    => default, // hyperf日志配置名称，config/autoload/logger.php中配置
    ],
];





use Es\Es;

// 完全匹配上才可以返回结果
$map = [
    ['status', '=', 1],
    ['title', 'like', '搜索%'],
    ['create_at', 'between', [date('Y-m-d H:i:s', time() - 86400), date('Y-m-d H:i:s')]]
];

// 必须匹配到其中一个
$region_map = [
    ['province', '=', '安徽'],
    ['province', 'in', ['湖北', '上海']],
];

// 必须匹配到其中一个
$keyword_map = [
    ['show_tag', 'like', '%钢铁%'],
    ['hide_tag', 'like', '%材料%'],
];

Es::index('索引（类似mysql表名）')
    ->where($map)
    ->whereOr($region_map)
    ->whereOr($keyword_map)
    ->paginate();