首页 > 代码库 > php表单提交至数据库

php表单提交至数据库

一、php配置MySQL

1、将php安装目录下的php_mysql.dll和MySQL安装目录下的libmysql.dll文件拷贝至c:/windows/system32中;

2、配置php.ini

extension=php_gd2.dll

extension=php_mbstring.dll

extension=php_mysql.dll
extension=php_mysqli.dll

把上面四个.dll的最前面的;去掉

二、php表单提交至数据库的实现过程

1、login.php页面

<span style="font-size:14px;"><html>
<title>login page</title>
<body>

<form action="add.php" method="post">
    Name: <input type="text" name="username"/><br />
	Email: <input type="text" name="email" /><br />
	<input type="submit" name="submit" value=http://www.mamicode.com/"提交" />>
2、add.php页面

<span style="font-size:14px;"><?php
include("conn.php");
?>
<?php
if(isset($_POST["submit"]))
{
    $sql = "insert into users(username, email) values('$_POST[username]', '$_POST[email]')";
	mysqli_query($conn, $sql);
	echo "添加成功";
}
?></span>

3、conn.php页面

<span style="font-size:14px;"><?php
$conn = new mysqli("localhost", "root", "159357");
$conn->select_db("db_test");
//mysql_query("set name 'gb2312'");
$conn->set_charset("utf8");
?></span>