久久久久av_欧美日韩一区二区在线_国产精品三区四区_日韩中字在线

Discuz! 官方交流社區(qū)

標題: 如何讀取其他數(shù)據(jù)庫的表？ [打印本頁]
作者: wmhjf12    時間: 2022-7-25 11:52
標題: 如何讀取其他數(shù)據(jù)庫的表？
如何讀取其他數(shù)據(jù)庫的表？我想鏈接其他數(shù)據(jù)庫中幾個表。應該怎樣查詢？

作者: 人工智能實驗室    時間: 2022-8-18 10:09
配置文件，參考
config\config_global.php
  1. //本站數(shù)據(jù)庫配置
  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_';

  10. //連第2個數(shù)據(jù)庫配置
  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'] = '數(shù)據(jù)庫名';
  17. $_config['db']['2']['tablepre'] = 'pre_';//表前綴

  19. //連第3個數(shù)據(jù)庫配置
  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'] = '數(shù)據(jù)庫名';
  26. $_config['db']['3']['tablepre'] = 'pre_';//表前綴

  28. //數(shù)據(jù)2中需要查詢的表，一行一個，表名不要前綴，后面寫數(shù)據(jù)庫編號
  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. );
復制代碼
看上面的示例，數(shù)據(jù)庫2和數(shù)據(jù)庫3是其他站點的。
作者: wmhjf12    時間: 2022-9-1 00:27
感謝感謝



歡迎光臨 Discuz! 官方交流社區(qū) (http://www.9999xn.com/) Powered by Discuz! W1.0