{"id":23653,"date":"2024-12-26T19:12:26","date_gmt":"2024-12-26T10:12:26","guid":{"rendered":"https:\/\/agrimo.jp\/wp\/?page_id=23653"},"modified":"2025-01-19T19:28:00","modified_gmt":"2025-01-19T10:28:00","slug":"c%e3%81%a7%e9%80%9a%e8%a9%b1%e5%b1%a5%e6%ad%b4%e3%82%92%e5%8f%96%e5%be%97%e3%81%99%e3%82%8b","status":"publish","type":"page","link":"https:\/\/agrimo.jp\/wp\/?page_id=23653","title":{"rendered":"8.C#\u3067\u901a\u8a71\u5c65\u6b74\u3092\u53d6\u5f97\u3059\u308b"},"content":{"rendered":"<p>\u4ee5\u4e0b\u306f\u3001C#\u3092\u4f7f\u7528\u3057\u3066FreePBX\u306eMySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u901a\u8a71\u5c65\u6b74\u3092\u53d6\u5f97\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9<\/p>\n<pre class=\"lang:c# decode:true \" title=\"MySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3066CDR\u30c7\u30fc\u30bf\u306e\u30af\u30a8\u30ea\u5b9f\u884c\">using System;\r\nusing MySql.Data.MySqlClient;\r\n\r\nclass Program\r\n{\r\n    static void Main(string[] args)\r\n    {\r\n        string connectionString = \"server=&lt;Asterisk\u306eIP\u30a2\u30c9\u30ec\u30b9&gt;;port=3306;user=myuser;password=mypassword;database=asteriskcdrdb\";\r\n        using (MySqlConnection conn = new MySqlConnection(connectionString))\r\n        {\r\n            conn.Open();\r\n            string query = \"SELECT * FROM cdr WHERE calldate BETWEEN '2025-01-01' AND '2025-01-31'\";\r\n            MySqlCommand cmd = new MySqlCommand(query, conn);\r\n            using (MySqlDataReader reader = cmd.ExecuteReader())\r\n            {\r\n                while (reader.Read())\r\n                {\r\n                    Console.WriteLine($\"Call Date: {reader[\"calldate\"]}, Caller ID: {reader[\"src\"]}, Destination: {reader[\"dst\"]}, Duration: {reader[\"duration\"]}\");\r\n                }\r\n            }\r\n        }\r\n    }\r\n}\r\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u4e0b\u306f\u3001C#\u3092\u4f7f\u7528\u3057\u3066FreePBX\u306eMySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u901a\u8a71\u5c65\u6b74\u3092\u53d6\u5f97\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9 using  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-23653","page","type-page","status-publish","hentry"],"wppr_data":{"cwp_meta_box_check":"No"},"_links":{"self":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/23653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23653"}],"version-history":[{"count":7,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/23653\/revisions"}],"predecessor-version":[{"id":23706,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/23653\/revisions\/23706"}],"wp:attachment":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}