根据php文档,“一旦脚本执行结束,服务器的链接就会被关闭,除非通过明确地调用mysql_close()来关闭它。”
http://php.net/manual/en/function.mysql-connect.php
何时打开和关闭此脚本的连接:1)未发布用户名时; 2)发布用户名时(请注意形式卫生)?
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die (mysql_error());
mysql_select_db("members") or die(mysql_error());
?>
if (isset ($_POST['username'])){
$username=$_POST['username'];
$sql = mysql_query("INSERT INTO members (username) VALUES('$username'") or die (mysql_error());
}
else{
$username='';
}
?>