How does workerman connect to the database?

Install Workerman/MySQL

Method 1:

can be installed through composer, run the following command on the command line (the composer source is abroad, the installation process may will be very slow).

composer require workerman/mysql

After the above command is successful, the vendor directory will be generated, and then autoload.php under the vendor will be introduced into the project.

require_once __DIR__ . '/vendor/autoload.php';

Method 2:

Download the source code, put the decompressed directory into your own project (any location), and directly require the source file.

require_once '/your/path/of/mysql-master/src/Connection.php';

Code to connect to the database:

// 通过全局变量获得db实例                        
global$db;
  $db= new Workerman\MySQL\Connection('127.0.0.1', '3306', 'root', '','racinggame');
 //执行SQL
 $all_tables=$db->select('name')->from('sys_user')->query();
  print_r(json_encode($all_tables));

For more workerman knowledge, please pay attention to the workerman tutorial column.

The above is the detailed content of How does workerman connect to the database?. For more information, please follow other related articles on the PHP Chinese website!