{"id":68,"date":"2020-05-27T17:45:01","date_gmt":"2020-05-27T08:45:01","guid":{"rendered":"https:\/\/speedloger.com\/?p=68"},"modified":"2020-05-27T20:34:14","modified_gmt":"2020-05-27T11:34:14","slug":"azure-app-service%e3%81%aemysql-in-app%e3%82%92wordpress%e3%81%8b%e3%82%89%e4%bd%bf%e3%81%86","status":"publish","type":"post","link":"https:\/\/speedloger.com\/?p=68","title":{"rendered":"Azure App Service\u306eMySQL in App\u3092WordPress\u304b\u3089\u4f7f\u3046"},"content":{"rendered":"

AppService\u5074\u3067\u8a2d\u5b9a\u3057\u305f\u5024\u3067\u30a2\u30af\u30bb\u30b9<\/p>\n

wp-config.php\u3092\u66f8\u304d\u63db\u3048<\/h1>\n
<?php\nif(!isset($_SERVER["MYSQLCONNSTR_localdb"])) throw new Exception('MYSQLCONNSTR ENV is not defined');\n\n$azure_mysql_connstr = $_SERVER["MYSQLCONNSTR_localdb"];\n$azure_mysql_connstr_match = preg_match(\n  "\/".\n    "Database=(?<database>.+);".\n    "Data Source=(?<datasource>.+):".\n    "(?<port>.+);".\n    "User Id=(?<userid>.+);".\n    "Password=(?<password>.+)".\n  "\/u",\n  $azure_mysql_connstr,\n  $_);\n\nif($azure_mysql_connstr_match === false) throw new Exception('Could not parse for MYSQLCONNSTR ENV');\n\n$db_settings = [\n    'host'      => $_['datasource'],\n    'port'      => $_['port'],\n    'database'  => $_['database'],\n    'username'  => $_['userid'],\n    'password'  => $_['password'],\n];\n\nvar_dump($db_settings);\n?><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
AppService\u5074\u3067\u8a2d\u5b9a\u3057\u305f\u5024\u3067\u30a2\u30af\u30bb\u30b9 wp-config.php\u3092\u66f8\u304d\u63db\u3048 <?php if(!isset($_SERVER["MYSQLCONNSTR_localdb"])) thro… » read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":""},"categories":[7,6],"tags":[],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t