insert.html页面
<html>
<body><form action="insert.php" method="post">
ROOT:<input type="text" name="root" />
USER:<input type="text" name="user" /></br>
URL:<input type="text" name="url" />
<input type="submit" /></br>
</form></body>
</html>insert.php页面
</form></body>
</html>
<?php
}
else
{
$host = "host";
$user = "user";
$pass = "pass";
$db = "db";
echo "ccf";
//取得表单中的值,检查表单中的值是否符合标准,并做适当转义,防止SQL注入
$url = empty($_POST['url'])? die("url?"):
mysql_escape_string($_POST['root']);
$root = empty($_POST['root'])? die("root?"):
mysql_escape_string($_POST['root']);
$user = empty($_POST['user'])? die("user?"):
mysql_escape_string($_POST['user']);
//打开数据库连接
$connection = mysql_connect($host, $user, $pass) or die("Unable to connect!");
//选择数据库
mysql_select_db($db) or die("Unable to select database!");
//构造一个SQL查询
$query = "INSERT INTO openurl(url,root,user) VALUES('$url', '$root', '$user')";
//执行该查询
$result = mysql_query($query) or die("Error in query: $query. ".mysql_error());
//插入操作成功后,显示插入记录的记录号
echo "记录已经插入, mysql_insert_id() = ".mysql_insert_id();
//关闭当前数据库连接
mysql_close($connection);
}
?>
为什么插入不成功呢?保存用户名和密码数据库都正确
<html>
<body><form action="insert.php" method="post">
ROOT:<input type="text" name="root" />
USER:<input type="text" name="user" /></br>
URL:<input type="text" name="url" />
<input type="submit" /></br>
</form></body>
</html>insert.php页面
</form></body>
</html>
<?php
}
else
{
$host = "host";
$user = "user";
$pass = "pass";
$db = "db";
echo "ccf";
//取得表单中的值,检查表单中的值是否符合标准,并做适当转义,防止SQL注入
$url = empty($_POST['url'])? die("url?"):
mysql_escape_string($_POST['root']);
$root = empty($_POST['root'])? die("root?"):
mysql_escape_string($_POST['root']);
$user = empty($_POST['user'])? die("user?"):
mysql_escape_string($_POST['user']);
//打开数据库连接
$connection = mysql_connect($host, $user, $pass) or die("Unable to connect!");
//选择数据库
mysql_select_db($db) or die("Unable to select database!");
//构造一个SQL查询
$query = "INSERT INTO openurl(url,root,user) VALUES('$url', '$root', '$user')";
//执行该查询
$result = mysql_query($query) or die("Error in query: $query. ".mysql_error());
//插入操作成功后,显示插入记录的记录号
echo "记录已经插入, mysql_insert_id() = ".mysql_insert_id();
//关闭当前数据库连接
mysql_close($connection);
}
?>
为什么插入不成功呢?保存用户名和密码数据库都正确
可以显示ccf吗?}
else
{ 这个else前面的if条件是什么?