\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4e38\u3054\u3068\u30b3\u30d4\u30fc\u3059\u308b\u5fc5\u8981\u304c\u751f\u3058\u3066\u3001\u305d\u306e\u969b\u306b\u30c7\u30fc\u30bf\u306b\u51e6\u7406\u3092\u52a0\u3048\u306a\u3051\u308c\u3070\u306a\u3089\u306a\u304b\u3063\u305f\u306e\u3067\u3001PHP \u3067\u66f8\u3044\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n
\u307e\u305a\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u542b\u307e\u308c\u308b\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n
<?php\r\n\r\n$DB = mysqli_connect( 'localhost', 'username', 'password', 'databasename') or die(mysqli_connect_error()); \r\nmysqli_set_charset($DB, 'utf8');\r\n\r\n$sql = "SHOW TABLES;";\r\n$result = mysqli_query($DB, $sql) or die(mysqli_error($DB2));\r\n\r\n$rows = mysqli_num_rows($result);\r\n\r\nfor ($i = 0; $i < $rows; $i = $i + 1) {\r\n\r\n\t$row = mysqli_fetch_array($result);\r\n\r\n\techo $row[0]."\\n";\r\n\r\n}\r\n?><\/code><\/pre>\n\u51fa\u529b\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u30c6\u30fc\u30d6\u30eb\u540d\u304c\u4e26\u3073\u307e\u3059\u3002<\/p>\n
authors\r\ntable_College_Physics\r\ntable_friend\r\ntable_ryuji-kondo\r\n<\/code><\/pre>\n\u6b21\u306b\u3001\u30b3\u30d4\u30fc\u3067\u3059\u3002\u30b3\u30d4\u30fc\u5148\u306e\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u306f\u7a7a\u306e\u3082\u306e\u3092\u524d\u3082\u3063\u3066\u7528\u610f\u3057\u3066\u304a\u304d\u307e\u3059\u3002\u30b3\u30d4\u30fc\u3059\u308b\u524d\u306b\u3001\u540c\u3058\u69cb\u9020\u306e\u7a7a\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3066\u3001\u305d\u306e\u5f8c\u30c7\u30fc\u30bf\u3092\u79fb\u3057\u307e\u3059\u3002<\/p>\n
<?php\r\n\r\n$DB = mysqli_connect( 'localhost', 'username', 'password', '\u30b3\u30d4\u30fc\u5143\u306eDB') or die(mysqli_connect_error()); \r\nmysqli_set_charset($DB, 'utf8');\r\n\r\n$DB2 = mysqli_connect( 'localhost', 'username', 'password', '\u30b3\u30d4\u30fc\u5148\u306eDB') or die(mysqli_connect_error()); \r\nmysqli_set_charset($DB2, 'utf8');\r\n\r\n\r\n\r\n$sql = "SHOW TABLES;";\r\n\r\n$result = mysqli_query($DB, $sql) or die(mysqli_error($DB));\r\n\r\n$rows = mysqli_num_rows($result);\r\n\r\n\r\n\r\nfor ($i = 0; $i < $rows; $i = $i + 1) {\r\n\r\n\t$row = mysqli_fetch_array($result);\r\n\r\n\t$a_table_name = "`".$row[0]."`";\r\n\r\n\r\n\t$sql = "CREATE TABLE \u30b3\u30d4\u30fc\u5148\u306eDB.$a_table_name LIKE \u30b3\u30d4\u30fc\u5143\u306eDB.$a_table_name";\r\n\r\n\tmysqli_query($DB2, $sql) or die(mysqli_error($DB2));\r\n\r\n\r\n\t$sql = "INSERT INTO \u30b3\u30d4\u30fc\u5148\u306eDB.$a_table_name SELECT * FROM \u30b3\u30d4\u30fc\u5143\u306eDB.$a_table_name";\r\n\r\n\tmysqli_query($DB2, $sql) or die(mysqli_error($DB2));\r\n\r\n}\r\n\r\n?><\/code><\/pre>\n\u3053\u306e\u624b\u9806\u3067\u30b3\u30d4\u30fc\u3059\u308b\u3068\u3001AUTO INCREMENT \u306a\u3069\u3082\u305d\u306e\u307e\u307e\u30b3\u30d4\u30fc\u3055\u308c\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4e38\u3054\u3068\u30b3\u30d4\u30fc\u3059\u308b\u5fc5\u8981\u304c\u751f\u3058\u3066\u3001\u305d\u306e\u969b\u306b\u30c7\u30fc\u30bf\u306b\u51e6\u7406\u3092\u52a0\u3048\u306a\u3051\u308c\u3070\u306a … Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-5383","post","type-post","status-publish","format-standard","hentry","category-column"],"_links":{"self":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/5383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5383"}],"version-history":[{"count":15,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/5383\/revisions"}],"predecessor-version":[{"id":5408,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/5383\/revisions\/5408"}],"wp:attachment":[{"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5383"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zairyo.susi.oita-u.ac.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}