本人初学php，很多东西都不懂，希望老鸟给些意见！
下面这是一个简单的表单页面，提交到了register1.php.<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>注册页面</title>
</head>
<body>
<form action="register1.php" method="post" name="registForm">
<table width="330" border="0" align="center" cellpadding="5" bgcolor="#eeeeee">
<tr>
<td width="40%">用户名:</td>
<td><input name="username" type="text" id="username"/></td>
</tr>
<tr>
<td>姓名:</td>
<td><input name="name" type="text" id="name"/></td>
</tr>
<tr>
<td>密码:</td>
<td><input name="pwd" type="text" id="pwd"/></td>
</tr>
<tr>
<td>邮箱:</td>
<td><input name="email" type="text" id="email"/></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="提交" name="submit"/>
<input type="reset" value="重置" name="button"/>
</td>
</tr>
</table>
</form>
</body>
</html>register1.php<?php
$username = $_POST['username'];
$name = $_POST['name'];
$pwd = $_POST['pwd'];
$email = $_POST['email'];if(!empty($username))
{
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con); $sql = "insert into t_user (f_username,f_password,f_name,f_email) values ";
$sql .= "('$username','$pwd','$name','$email')";
echo $sql."<br/>\n";
if(!mysql_query($sql,$con))
{
die("Error:".mysql_error());
}
echo "1 record added";
mysql_close($link);
}
?>当我填写完register.php的相关信息后，提交到register1.php,输出的结果为：
insert into t_user (f_username,f_password,f_name,f_email) values ('123','123','123','123')
Error:No database selected
我也搜过No database selected这个问题，一种解决方案是吧sql语句放到phpMyAdmin中执行，我放到哪里去执行了，可以执行，没有报错。希望各位老鸟赐教！
下面这是一个简单的表单页面，提交到了register1.php.<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>注册页面</title>
</head>
<body>
<form action="register1.php" method="post" name="registForm">
<table width="330" border="0" align="center" cellpadding="5" bgcolor="#eeeeee">
<tr>
<td width="40%">用户名:</td>
<td><input name="username" type="text" id="username"/></td>
</tr>
<tr>
<td>姓名:</td>
<td><input name="name" type="text" id="name"/></td>
</tr>
<tr>
<td>密码:</td>
<td><input name="pwd" type="text" id="pwd"/></td>
</tr>
<tr>
<td>邮箱:</td>
<td><input name="email" type="text" id="email"/></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="提交" name="submit"/>
<input type="reset" value="重置" name="button"/>
</td>
</tr>
</table>
</form>
</body>
</html>register1.php<?php
$username = $_POST['username'];
$name = $_POST['name'];
$pwd = $_POST['pwd'];
$email = $_POST['email'];if(!empty($username))
{
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con); $sql = "insert into t_user (f_username,f_password,f_name,f_email) values ";
$sql .= "('$username','$pwd','$name','$email')";
echo $sql."<br/>\n";
if(!mysql_query($sql,$con))
{
die("Error:".mysql_error());
}
echo "1 record added";
mysql_close($link);
}
?>当我填写完register.php的相关信息后，提交到register1.php,输出的结果为：
insert into t_user (f_username,f_password,f_name,f_email) values ('123','123','123','123')
Error:No database selected
我也搜过No database selected这个问题，一种解决方案是吧sql语句放到phpMyAdmin中执行，我放到哪里去执行了，可以执行，没有报错。希望各位老鸟赐教！
改为：
mysql_select_db("my_db", $con) or die(mysql_error());看看输出什么错误（估计是不存在my_db数据库，数据库名没打错吧？）
这个test是数据库名？
这样写是错误的，看一下：
resource mysql_connect ([ string $server [, string $username [, string $password [, bool $new_link [, int $client_flags ]]]]] )
mysql_connect()的第四个参数应该是个bool值，用法自己看手册。
http://www.php.net/manual/zh/function.mysql-connect.php