\u540c\u4e00\u306eMySQL\u30b5\u30fc\u30d0\u30fc\u3067db1\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306etable1\u30c6\u30fc\u30d6\u30eb\u3068\u3001db2\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306etable2\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3057\u305f\u304b\u3063\u305f\u3002\u5171\u6709\u306e\u30ab\u30e9\u30e0\u306fid\u3068\u3059\u308b\u3002\u4ee5\u4e0b\u306b\u5bfe\u5fdc\u65b9\u6cd5\u3092\u30e1\u30e2\u3002<\/p>\n
<\/p>\n
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, 'db1');\r\n$mysqli->set_charset('utf8');\r\n$query = '\r\n SELECT * \r\n FROM db1.table1 AS a \r\n LEFT JOIN db2.table2 AS b \r\n ON a.id = b.id\r\n';<\/pre>\n\u3042\u3068\u3053\u308c\u30c6\u30b9\u30c8\u3057\u3066\u3066\u6c17\u4ed8\u3044\u305f\u3093\u3060\u3051\u3069\u3001\u6700\u521d\u306b\u63a5\u7d9a\u3059\u308bDB\u306b\u95a2\u3057\u3066\u306f\u3069\u3053\u3067\u3082\u3044\u3044\u307f\u305f\u3044\u3002SELECT\u6a29\u9650\u3055\u3048\u3042\u308c\u3070\u3001<\/p>\n
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, 'db3'); \/\/\u5b9f\u969b\u306b\u4f7f\u3046\u306e\u306fdb1\u3068db2\u3060\u3051\u3069\u3001db3\u3092\u63a5\u7d9a\u3057\u3066\u3082ok\r\n$mysqli->set_charset('utf8');\r\n$query = '\r\n SELECT * \r\n FROM db1.table1 AS a \r\n LEFT JOIN db2.table2 AS b \r\n ON a.id = b.id\r\n';<\/pre>\n\u3068\u3044\u3046\u5f62\u3067\u3082\u3044\u3051\u308b\u3002<\/p>\n
\u307e\u305f\u3001\u540c\u4e00\u30d5\u30a1\u30a4\u30eb\u5185\u3067\u7570\u306a\u308bDB\u306b\u63a5\u7d9a\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u3044\u3061\u3044\u3061close\u3057\u3066\u305f\u3051\u3069\u300cdb\u540d.table\u540d\u300d\u3067\u66f8\u3051\u3070\u305d\u306e\u5fc5\u8981\u306f\u7121\u304b\u3063\u305f\u3002\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u5f62\u3002<\/p>\n
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, 'db3');\r\n$mysqli->set_charset('utf8');\r\n$query = '\r\n SELECT * \r\n FROM db1.table1\r\n';\r\n$row = $mysqli->query($query);\r\nwhile ($rs = $row->fetch_array(MYSQLI_ASSOC)) {\r\n var_dump($rs);\r\n}\r\n$query = '\r\n SELECT * \r\n FROM db2.table2\r\n';\r\n$row = $mysqli->query($query);\r\nwhile ($rs = $row->fetch_array(MYSQLI_ASSOC)) {\r\n var_dump($rs);\r\n}<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
\u540c\u4e00\u306eMySQL\u30b5\u30fc\u30d0\u30fc\u3067db1\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306etable1\u30c6\u30fc\u30d6\u30eb\u3068\u3001db2\u30c7\u30fc ... <\/p>\n","protected":false},"author":1,"featured_media":1072,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/1958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=1958"}],"version-history":[{"count":0,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/1958\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/1072"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=1958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=1958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=1958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}