\swoole_mysql

__construct()

__construct() 

on()

on(string  $eventName, callable  $callback) 

set the event callback, current just support close function callback(\Swoole\Mysql $db){}

Parameters

connect()

connect(array  $config, callable  $callback) 

$config = array( 'host' => '192.168.56.102', // the host for mysql server ,support ipv4,ipv6 or unix sock.

'user' => 'test', // mysql user name 'password' => 'test', // password for mysql 'database' => 'test', // the database 'charset' => 'utf8', // choice, if not given, the server charset used ); function callback(\Swoole\Mysql $db, bool $result) { }

Parameters

Throws

\Swoole\Mysql\Exception

$e

escape()

escape(string  $str) : string

use mysqlnd to escape the string use --enable-mysqlnd when compile

Parameters

Returns

query()

query(string  $sql, callable  $callback) 

function callback(\Swoole\Mysql $link, mixed $result) {} when execute fail, the result return false, you can use $link->error and $link->errno to get the error information.

success: if query result sql, the result is the query result otherwise the result is true, you can use $link->insert_id, $link->affected_rows

Parameters

begin()

begin(callable  $callback) 

start a new transaction one link only one transaction, if already exist, then exception function callback(\Swoole\Mysql $link, mixed $result) {}

Parameters

Throws

\Swoole\Mysql\Exception

$e

commit()

commit(callable  $callback) 

commit transaction if not exist, then exception function callback(\Swoole\Mysql $link, mixed $result) {}

Parameters

Throws

\Swoole\Mysql\Exception

$e

rollback()

rollback(callable  $callback) 

rollback transaction if not exist, then exception function callback(\Swoole\Mysql $link, mixed $result) {}

Parameters

Throws

\Swoole\Mysql\Exception

$e

close()

close() 

close the connection