一、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
二、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="提交" />
</form>
</body>
</html></span>
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>