外贸独立站(日本)

有一个复合索引：INDEX(`a`, `b`, `c`);

使用方式	                                        能否用上索引
select * from users where a = 1 and b = 2	能用上a、b
select * from users where b = 2 and a = 1	能用上a、b（有MySQL查询优化器）
select * from users where a = 2 and c = 1	能用上a
select * from users where b = 2 and c = 1	不能

trim($otmp, chr(0xc2) . chr(0xa0))

$otmp = str_replace(chr(0xc2) . chr(0xa0), '', $otmp);

<?php
class Server
{
    private $serv;
    public function __construct() {
        $this->serv = new swoole_server("0.0.0.0", 9501);
        $this->serv->set(array(
            'worker_num' => 1,   //一般设置为服务器CPU数的1-4倍
            'daemonize' => 1,  //以守护进程执行
            'max_request' => 10000,
            'dispatch_mode' => 2,
            'task_worker_num' => 8,  //task进程的数量
            "task_ipc_mode " => 3 ,  //使用消息队列通信，并设置为争抢模式
            //"log_file" => "log/taskqueueu.log" ,//日志
        ));
        $this->serv->on('Receive', array($this, 'onReceive'));
        // bind callback
        $this->serv->on('Task', array($this, 'onTask'));
        $this->serv->on('Finish', array($this, 'onFinish'));
        $this->serv->start();
    }

    public function onReceive( swoole_server $serv, $fd, $from_id, $data ) {
        //echo "Get Message From Client {$fd}:{$data}n";
        // send a task to task worker.
        $serv->task( $data );
    }

    public function onTask($serv,$task_id,$from_id, $data) {
        $array = json_decode( $data , true );
        if ($array['url']) {
            return $this->httpGet( $array['url'] , $array['param']  );
        }

    }

    public function onFinish($serv,$task_id, $data) {
        //echo "Task {$task_id} finishn";
        //echo "Result: {$data}n";
    }


    protected function httpGet($url,$data){
        if ($data) {
            $url .='?'.http_build_query($data) ;
        }
        $curlObj = curl_init();    //初始化curl，
        curl_setopt($curlObj, CURLOPT_URL, $url);   //设置网址
        curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);  //将curl_exec的结果返回
        curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, FALSE);
        curl_setopt($curlObj, CURLOPT_SSL_VERIFYHOST, FALSE);
        curl_setopt($curlObj, CURLOPT_HEADER, 0);         //是否输出返回头信息
        $response = curl_exec($curlObj);   //执行
        curl_close($curlObj);          //关闭会话
        return $response;
    }

}
$server = new Server();

<?php
class Client
{
    private $client;

    public function __construct() {
        $this->client = new swoole_client(SWOOLE_SOCK_TCP);
    }

    public function connect() {
        if( !$this->client->connect("127.0.0.1", 9501 , 1) ) {
            echo "Connect Error";
        }
        $data = array(
            "url" =>  "http://192.168.10.19/send_mail" ,
            "param" => array(
                "username"=>'test',
                "password" => 'test'
            )
        );
        $json_data = json_encode($data);
        $this->client->send( $json_data );
    }
}

$client = new Client();
$client->connect();

curl_multi_add_handle — 向curl批处理会话中添加单独的curl句柄
curl_multi_close — 关闭一组cURL句柄
curl_multi_exec — 运行当前 cURL 句柄的子连接
curl_multi_getcontent — 如果设置了CURLOPT_RETURNTRANSFER，则返回获取的输出的文本流
curl_multi_info_read — 获取当前解析的cURL的相关传输信息
curl_multi_init — 返回一个新cURL批处理句柄
curl_multi_remove_handle — 移除curl批处理句柄资源中的某个句柄资源
curl_multi_select — 等待所有cURL批处理中的活动连接
curl_multi_setopt — 为 cURL 并行处理设置一个选项
curl_multi_strerror — Return string describing error code

<?php
$urls = array(
    'https://979137.com/',
    'http://www.sina.com.cn/',
    'http://www.sohu.com/',
    'http://www.163.com/'
);   
//1、初始化一个批处理handle
$mh = curl_multi_init();
 
//2、往批处理handle 添加curl_init来的子handle
foreach ($urls as $i => $url) {   
    $conn[$i] = curl_init($url);   
    curl_setopt($conn[$i], CURLOPT_HEADER, 0);   
    curl_setopt($conn[$i], CURLOPT_CONNECTTIMEOUT, 60);   
    curl_setopt($conn[$i], CURLOPT_RETURNTRANSFER, true);  
    curl_multi_add_handle($mh, $conn[$i]);   
}   

//3、并发执行，直到全部结束。
do {   
    curl_multi_exec($mh, $active);   
} while ($active);   
 
//4、获取结果
foreach ($urls as $i => $url) {   
    $data = curl_multi_getcontent($conn[$i]);
    echo ($data);
    echo '<hr />';
}
 
//5、移除子handle，并close子handle
foreach ($urls as $i => $url) {   
  curl_multi_remove_handle($mh,$conn[$i]);   
  curl_close($conn[$i]);   
}   
 
//6、关闭批处理handle
curl_multi_close($mh);  

$file = $request->file('femails');
$emails = file_get_contents($file->getRealPath());
$emails = explode(PHP_EOL, $emails);
$ids = [];
foreach ($emails as $email) {
    $result = preg_replace('/[\x00-\x1F\x80-\xFF]/', '', $email);
    $recipient = Recipient::firstOrCreate(
        [
            'email' => trim($result)
        ],
        [
            'is_use' => 1
        ]
    );
    array_push($ids, $recipient->id);
}