如何读取其他数据库的表？

wmhjf12

如何读取其他数据库的表？我想链接其他数据库中几个表。应该怎样查询？

1 贡献

最佳答案

配置文件，参考
config\config_global.php

1. //本站数据库配置
   
2. $_config['db']['1']['dbhost'] = 'localhost';
   
3. $_config['db']['1']['dbuser'] = 'root';
   
4. $_config['db']['1']['dbpw'] = '';
   
5. $_config['db']['1']['dbcharset'] = 'gbk';
   
6. $_config['db']['1']['pconnect'] = '0';
   
7. $_config['db']['1']['dbname'] = 'apilocal';
   
8. $_config['db']['1']['tablepre'] = 'pre_';
   
9. 
   
10. //连第2个数据库配置
    
11. $_config['db']['2']['dbhost'] = 'mysql服务地址';
    
12. $_config['db']['2']['dbuser'] = '用户名';
    
13. $_config['db']['2']['dbpw'] = '密码';
    
14. $_config['db']['2']['dbcharset'] = '编码';
    
15. $_config['db']['2']['pconnect'] = '1';
    
16. $_config['db']['2']['dbname'] = '数据库名';
    
17. $_config['db']['2']['tablepre'] = 'pre_';//表前缀
    
18. 
    
19. //连第3个数据库配置
    
20. $_config['db']['3']['dbhost'] = 'mysql服务地址';
    
21. $_config['db']['3']['dbuser'] = '用户名';
    
22. $_config['db']['3']['dbpw'] = '密码';
    
23. $_config['db']['3']['dbcharset'] = '编码';
    
24. $_config['db']['3']['pconnect'] = '1';
    
25. $_config['db']['3']['dbname'] = '数据库名';
    
26. $_config['db']['3']['tablepre'] = 'pre_';//表前缀
    
27. 
    
28. //数据2中需要查询的表，一行一个，表名不要前缀，后面写数据库编号
    
29. $_config['db']['map']=array(
    
30.         'table_1'=>'2',
    
31.         'table_2'=>'2',
    
32.         'table_3'=>'2',
    
33.         'table_4'=>'3',
    
34.         'table_5'=>'3',
    
35.         'table_6'=>'3',
    
36. );

复制代码

看上面的示例，数据库2和数据库3是其他站点的。

• 人工智能实验室
• 发表于2022-8-18 10:09:49
• 详细答案 >

人工智能实验室

配置文件，参考
config\config_global.php

1. //本站数据库配置
   
2. $_config['db']['1']['dbhost'] = 'localhost';
   
3. $_config['db']['1']['dbuser'] = 'root';
   
4. $_config['db']['1']['dbpw'] = '';
   
5. $_config['db']['1']['dbcharset'] = 'gbk';
   
6. $_config['db']['1']['pconnect'] = '0';
   
7. $_config['db']['1']['dbname'] = 'apilocal';
   
8. $_config['db']['1']['tablepre'] = 'pre_';
   
9. 
   
10. //连第2个数据库配置
    
11. $_config['db']['2']['dbhost'] = 'mysql服务地址';
    
12. $_config['db']['2']['dbuser'] = '用户名';
    
13. $_config['db']['2']['dbpw'] = '密码';
    
14. $_config['db']['2']['dbcharset'] = '编码';
    
15. $_config['db']['2']['pconnect'] = '1';
    
16. $_config['db']['2']['dbname'] = '数据库名';
    
17. $_config['db']['2']['tablepre'] = 'pre_';//表前缀
    
18. 
    
19. //连第3个数据库配置
    
20. $_config['db']['3']['dbhost'] = 'mysql服务地址';
    
21. $_config['db']['3']['dbuser'] = '用户名';
    
22. $_config['db']['3']['dbpw'] = '密码';
    
23. $_config['db']['3']['dbcharset'] = '编码';
    
24. $_config['db']['3']['pconnect'] = '1';
    
25. $_config['db']['3']['dbname'] = '数据库名';
    
26. $_config['db']['3']['tablepre'] = 'pre_';//表前缀
    
27. 
    
28. //数据2中需要查询的表，一行一个，表名不要前缀，后面写数据库编号
    
29. $_config['db']['map']=array(
    
30.         'table_1'=>'2',
    
31.         'table_2'=>'2',
    
32.         'table_3'=>'2',
    
33.         'table_4'=>'3',
    
34.         'table_5'=>'3',
    
35.         'table_6'=>'3',
    
36. );

复制代码

看上面的示例，数据库2和数据库3是其他站点的。

wmhjf12

感谢感谢