PHP? ???? Baidu Wenxin Yiyan API ?????? ??? ?? ?? ? ??? ???? ?????.

Yiyan API? ? ???? ??? ??? ? ?? ?? ?? ?? API ?????? ?? ???? ??????. ???? ???? ??? ?? ? API ?????? ???? ? ???? ???? ???? ???? ???. ??? ????? ?? ? ??? ?? ??? ??? ?? ??? ?????.

? ????? PHP ??? ???? Baidu Wenxin Yiyan API ?????? ??? ?? ?? ? ??? ???? ??? ?????. ??? MySQL ??????? ???? ?????? ??? ??? ???? ?? ??? ??? ?? ??? ????.

?? ?????? ??? ??? ??? ?????? ???? ???? ???. id, api, Category, Created_at ??? ???? api_logs?? ???? ??? ? ????. ? ? id? ??? ?? ???, api? ?????? ??? ??, Category? Yiyan API?? ???? ??,created_at? ?? ?? ?????.

??? api_logs ???? ???? SQL????.

CREATE TABLE api_logs (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  api VARCHAR(255) NOT NULL,
  category VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

???? Yiyan API? ??? ??? ???? PHP ??? ???? ???. Yiyan API? ????? ?? ???? ?? ?? ??? ??? ? ????. ?? ??? ??? ????.

// 獲取一言API的返回結(jié)果
$result = file_get_contents('https://v1.hitokoto.cn');

// 解析返回結(jié)果
$data = json_decode($result, true);

// 獲取返回結(jié)果中的類型和內(nèi)容
$category = $data['type'];
$content = $data['hitokoto'];

// 記錄日志
$sql = "INSERT INTO api_logs (api, category) VALUES ('https://v1.hitokoto.cn', '$category')";
mysqli_query($conn, $sql);

????? ?? file_get_contents ??? ???? Yiyan API? ?? ??? ????. ?? ?? json_decode ??? ???? ??? ??? ?? ???? ??? ???? ?????. ???? MySQLi? mysqli_query ??? ???? SQL insert ?? ???? ?????? ??? ??? ??? api_logs ???? ?????.

?? Yiyan API ?????? ??? ?? ??? ???????. ???? ??? ??? ? ????. ??? ??? ????? ??? ??? ???? ??? ????.

// 查詢每個類型的接口訪問次數(shù)
$sql = "SELECT category, COUNT(*) AS count FROM api_logs GROUP BY category";
$result = mysqli_query($conn, $sql);

// 輸出結(jié)果
while ($row = mysqli_fetch_assoc($result)) {
  echo '類型：' . $row['category'] . '，訪問次數(shù)：' . $row['count'] . '<br>';
}

????? SQL? GROUP BY ?? ???? ???? ??? ????? COUNT ??? ???? ????? ??? ??? ?????. ? ???. ??? ?? ??? mysqli_fetch_assoc ??? ?? ????, ?? ??? ??? ????.

?? ?? ??? ?? Baidu Wenxin Yiyan API ?????? ??? ?? ?? ? ??? ??? ? ????. ??, IP ??, ?? ? ?? ??? ??? ????? ?? ?? ?? ??? ???? ? ?? ?? ??? ?? ??? ???? ??? ?? ????.

??:

? ???? PHP? ???? Baidu Wenxin Yiyan API ?????? ??? ?? ?? ? ??? ???? ???? ??? ?????. MySQL? ?? ??? ????, PHP ??? ???? ??? ???? ?????. ? ?? ?? ???? ??? ?? ?? ???? ??? ?? ? ?? ????? ?? ??? ??? ? ??? ????.

? ??? PHP? ???? Baidu Wenxin Yiyan API ?????? ??? ?? ?? ? ??? ???? ?????.? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!