网页带表单的数据记录添加
HTML表单
Firstname:
Lastname:
Age:
PHP页
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
$sql="INSERT INTO Persons (FirstName, LastName, Age) VALUES ('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con) ;
?>
mysql 系统函数:
mysql_connect(),连接数据库
mysql_select_db(),查找到连接的数据库表
mysql_query(),执行sql查询
mysql_close(),关闭数据库连接