PHPを使用してパブリックアカウントのサブスクリプション機能を開発する方法

<?php
$xml = file_get_contents('php://input');

$data = simplexml_load_string($xml, 'SimpleXMLElement', LIBXML_NOCDATA);

$openid = $data->FromUserName;

<?php
$servername = "localhost";
$username = "yourusername";
$password = "yourpassword";
$dbname = "yourdbname";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO users (openid, subscribe_time) VALUES ('$openid', NOW())";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

<?php
$access_token = "youraccess_token";
$openid = "useropenid";
$template_id = "yourtemplateid";
$content = "yourcontent";

$url = "https://api.weixin.qq.com/cgi-bin/message/template/send?access_token=" . $access_token;

$data = array(
    "touser" => $openid,
    "template_id" => $template_id,
    "data" => array(
        "content" => array(
            "value" => $content
        )
    )
);

$data_json = json_encode($data);

$ch = curl_init($url);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_POSTFIELDS, $data_json);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
    'Content-Type: application/json',
    'Content-Length: ' . strlen($data_json))
);

$response = curl_exec($ch);

if(curl_errno($ch)){
    echo 'Curl error: ' . curl_error($ch);
}

curl_close($ch);

echo $response;