异步读取文件
异步文件写入
异步事件
异步MySQL
<?php /** * Created by PhpStorm. * User: Ty_Ro * Date: 2018/11/18 * Time: 17:21 */ class Mysql{ public $mysql = ''; public $config = ''; public function __construct() { $this->mysql = new swoole_mysql(); $this->config = array( 'host' => '127.0.0.1', 'port' => 3306, 'user' => 'root', 'password' => 'root', 'database' => 'swoole', 'charset' => 'utf8', //指定字符集 ); } public function add(){ } public function del(){ } public function update(){ } /** * mysql 执行逻辑 * @param $id * @param $username * @return bool */ public function execute($id,$username){ $this->mysql->connect($this->config,function ($mysql,$result){ if($result===false){ var_dump($mysql->connect_errno); } var_dump('连接结果:'.$result); $sql = 'select * from test where id = 1 '; $this->mysql->query($sql,function ($mysql,$res){ //$res 当为select时返回结果集,当为add,del,update时返回bool if($res===true){ //todo }elseif($res===false){ //todo }else{ var_dump($res); } $mysql->close(); }); }); return true; } } $dbsource = new Mysql(); $data = $dbsource->execute(1,'tang'); var_dump($data).PHP_EOL; echo 'start'.PHP_EOL; // 详情页 -》mysql(阅读数) -》msyql 文章 +1 -》页面数据呈现出来