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);
<?php global $php; if (empty($php->config['db'][$php->factory_key])) { throw new Swoole\Exception\Factory("db->{$php->factory_key} is not found."); } if (!empty($php->config['db'][$php->factory_key]['use_proxy'])) { $db = new Swoole\Database\Proxy($php->config['db'][$php->factory_key]); } else { $db = new Swoole\Database($php->config['db'][$php->factory_key]); $db->connect(); } return $db;