如何讀取其他數據庫的表？

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

感謝感謝