在PostgresSQL数据库中插入PHP表单

<?php
// 获取表单提交的数据
$name = $_POST['name'];
$age = $_POST['age'];
$email = $_POST['email'];

// 连接到PostgreSQL数据库
$dbconn = pg_connect("host=localhost dbname=mydatabase user=myuser password=mypassword");

// 插入数据到数据库
$query = "INSERT INTO mytable (name, age, email) VALUES ('$name', '$age', '$email')";
$result = pg_query($query);

// 检查插入是否成功
if ($result) {
    echo "数据插入成功！";
} else {
    echo "数据插入失败！";
}

// 关闭数据库连接
pg_close($dbconn);
?>

<form action="insert_data.php" method="post">
    <!-- 表单字段 -->
    <input type="text" name="name" placeholder="姓名">
    <input type="text" name="age" placeholder="年龄">
    <input type="email" name="email" placeholder="电子邮件">
    <input type="submit" value="提交">
</form>