以下は、C#を使用してFreePBXのMySQLデータベースから通話履歴を取得するサンプルコード
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
using System; using MySql.Data.MySqlClient; class Program { static void Main(string[] args) { string connectionString = "server=<AsteriskのIPアドレス>;port=3306;user=myuser;password=mypassword;database=asteriskcdrdb"; using (MySqlConnection conn = new MySqlConnection(connectionString)) { conn.Open(); string query = "SELECT * FROM cdr WHERE calldate BETWEEN '2025-01-01' AND '2025-01-31'"; MySqlCommand cmd = new MySqlCommand(query, conn); using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Console.WriteLine($"Call Date: {reader["calldate"]}, Caller ID: {reader["src"]}, Destination: {reader["dst"]}, Duration: {reader["duration"]}"); } } } } } |
