PHP实现API实例

<?php
    //http://localhost/ApiDemo/getApi.php?para={"name":"name","email":"12345678@qq.com"}
//取得请求参数para
    $param = $_GET["para"];
    //echo $param;
    $json_param = json_decode($param);
    
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "dbname";
//连接数据库
$con = mysqli_connect($servername,$username,$password,$dbname);
if (!$con)
{
    die('Could not connect: ' . mysql_error());
}

$sql = "insert into userinfo(name,email,addtime) values('".$json_param->name."','".$json_param->email."',NOW())";

//echo $sql;
//插入数据
$result = $con->query($sql);

$sql = "select name,email,addtime from userinfo order by addtime desc";

$result = $con->query($sql);
//输出请求结果
echo "userinfo have ".$result->num_rows;
echo "<br>";

if ($result->num_rows > 0) {
    // 输出数据
    while ($row = $result->fetch_assoc()) {
        echo "name: " . $row["name"] . " - email: " . $row["email"]. " - addtime: " . $row["addtime"];
        echo "<br>";
    }
} else {
    echo "0 结果";
}
$con->close();

?>