public function Run($sql) { $config = array('type' => \Swoole\Database::TYPE_MYSQLi, 'host' => "127.0.0.1", 'port' => 3306, 'dbms' => 'mysql', 'engine' => 'MyISAM', 'user' => "root", 'passwd' => "", 'name' => "mysql", 'charset' => "utf8", 'setname' => true); $db = new \Swoole\Database($config); $db->connect(); $result = $db->query($sql); return $result->fetchall(); }
<?php define('DEBUG', 'on'); define('WEBPATH', realpath(__DIR__ . '/..')); //包含框架入口文件 require WEBPATH . '/libs/lib_config.php'; $config = array('type' => Swoole\Database::TYPE_MYSQLi, 'host' => '10.10.2.38', 'user' => 'root', 'password' => 'root', 'database' => 'chelun'); $db = new \Swoole\Database($config); $db->connect(); $res = $db->query("select * from test22"); var_dump($res);