如何使用php将动态输入插入数据库

$sql = "INSERT INTO users (id, name) VALUES ('$id', '$name')";

$result = mysqli_query($connection, $sql);

<?php
// 连接数据库
$host = "数据库主机名";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名称";
$connection = mysqli_connect($host, $username, $password, $dbname);

// 检查连接是否成功
if (!$connection) {
    die("数据库连接失败: " . mysqli_connect_error());
}

// 获取动态输入
$id = $_POST['id'];
$name = $_POST['name'];

// 准备SQL语句
$sql = "INSERT INTO users (id, name) VALUES ('$id', '$name')";

// 执行SQL语句
$result = mysqli_query($connection, $sql);

// 检查执行结果
if ($result) {
    echo "数据插入成功";
} else {
    echo "数据插入失败: " . mysqli_error($connection);
}

// 关闭数据库连接
mysqli_close($connection);
?>