php版本:5.5.18。
mysql版本:5.6.21。
20141106
经过3天的学习,排错,再学习,再排错,终于把表单的内容写入了数据库,一扫前几天的郁闷,爽了。
1.新建register.php页面,绘制表格,将表格加入表格区域。
<title>会员注册</title>
<form name="form2" method="post" action="reg_new_save.php">
<table width="485" height="310" border="1" align="center">
<tr>
<td colspan="2" align="center">会员注册</td>
</tr>
<tr>
<td width="141" align="center">用户名</td>
<td width="320"><label>
<input name="user_id" type="text" id="user_id">
</label>
</td>
</tr>
<tr>
<td align="center">密码</td>
<td><input name="user_psd" type="password" id="user_psd"></td>
</tr>
<tr>
<td align="center">确认密码</td>
<td><input name="user_psd2" type="password" id="user_psd2"></td>
</tr>
<tr>
<td align="center">性别</td>
<td><label>
<input name="sex" type="radio" value="m" checked="checked">
male
<input type="radio" name="sex" value="f" />
female
</label></td>
</tr>
<tr>
<td align="center">邮箱</td>
<td><input name="email" type="text" id="email"></td>
</tr>
<tr>
<td align="center"> </td>
<td><label>
<input type="submit" name="Submit" value="我要注册">
</label>
<label></label></td>
</tr>
</table>
</form>
2.新建数据库用命令行新建数据库user,
CREATE DATABASE user;
mysql> create table user_member(
> id int(4) not null primary key auto_increment,
> user_id char(20) not null,
> user_psd char(20) not null,
> sex varchar(4) not null,
> email varchar(20) not null);
3.新建reg_new_save.php
<?php
$con=mysqli_connect("localhost","root","password","user");//password 登录数据库的密码
// Check connection
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$userid = $_POST["user_id"];
$pwd = $_POST["user_psd"];
$sex = $_POST["sex"];
$email = $_POST["email"];
echo $_POST["user_id"];
echo "<br/>";
echo $_POST["user_psd"];
echo "<br/>";
echo $_POST["user_psd2"];
echo "<br/>";
echo $_POST["sex"];
echo "<br/>";
echo $_POST["email"];
echo "<br/>";
//Perform queries
$query = "INSERT INTO user_member (user_id,user_psd,sex,email) VALUES ('$userid','$pwd','$sex','$email')";
echo $query;
$result=$con->query($query);
if ($result){
echo "操作执行成功";
}else {
echo "操作执行失败", $con -> error;
}
mysqli_close($con);
?>
20141112
dreamwave8 每次要保存才能在IE中浏览,很麻烦,保存的次数多了对硬盘不好,正在看dreamwave8教程,到了一定阶段就要回过头来学习工具的使用了,不然大大的影响开发,本来可以转向使用zend studio,想想还是算了,下一堆软件麻烦。
转载请附链接:http://blog.csdn.net/lua_denis_2014/article/details/40708409