如何插入动态输入值在mysql中使用php同时将一个表复制到另一个表

$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名称";

// 使用mysqli扩展连接到MySQL数据库
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 使用PDO扩展连接到MySQL数据库
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    die("连接失败: " . $e->getMessage());
}

$sourceTable = "源表名称";
$targetTable = "目标表名称";

// 复制表结构
$sql = "CREATE TABLE $targetTable LIKE $sourceTable";
$conn->exec($sql);

// 复制表数据
$sql = "INSERT INTO $targetTable SELECT * FROM $sourceTable";
$conn->exec($sql);

$dynamicValue = $_POST['dynamic_value']; // 假设动态输入值通过POST方式获取

// 插入动态输入值
$sql = "INSERT INTO $targetTable (column_name) VALUES ('$dynamicValue')";
$conn->exec($sql);