php表单验证mysql问题
<html><head><tittle>MessageBorad</tittle></head><body><formaction=""method="post"name...
<html>
<head><tittle>Message Borad</tittle></head>
<body>
<form action="" method="post" name="myfrom">
<fieldset>Username: <input type="text" name="username" value="" /></fieldset>
<fieldset>Password: <input type="password" name="password" value="" /></fieldset>
<fieldset><input type="submit" name="Login" value="Login" /></fieldset>
</form>
</body>
</html>
<?php
$errmsg = "";
if (!empty($_POST["username"])){
define('DB_HOST', 'localhost');
define('DB_NAME', 'guestbook');
define('DB_USER', 'root');
define('DB_PASSWORD', '');
define('DB_CHARSET', 'UTF8');
function connectDb() {
try{
$dsn = 'mysql:host=' . DB_HOST . ';dbname=' . DB_NAME;
$pdo = new PDO($dsn, DB_USER, DB_PASSWORD);
$pdo->exec('SET ' . DB_CHARSET);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $pdo;
}catch(PDOException $e){
throw new Exception($e->getMessage());
return false;
}
}
function pdoPrepare($pdo, $sql, $parameters=NULL) {
$prepare = $pdo->prepare($sql);
if($parameters){
$prepare->execute($parameters);
}else{
$prepare->execute();
}
return $prepare;
}
$pdo = connectDb();
$result = "SELECT * FROM user WHERE username = '$_POST["username"]' and password = '$_POST["password"]' ";
if($result && $result->num_rows>0){
header('Location:*');
echo $errmsg = "Login successed";
}else {
echo $errmsg="Incorrect username or password login failed"; }
}
else{
$errmsg = "Please input your username";
}
?>
求大侠看看哪里有问题 不胜感激 展开
<head><tittle>Message Borad</tittle></head>
<body>
<form action="" method="post" name="myfrom">
<fieldset>Username: <input type="text" name="username" value="" /></fieldset>
<fieldset>Password: <input type="password" name="password" value="" /></fieldset>
<fieldset><input type="submit" name="Login" value="Login" /></fieldset>
</form>
</body>
</html>
<?php
$errmsg = "";
if (!empty($_POST["username"])){
define('DB_HOST', 'localhost');
define('DB_NAME', 'guestbook');
define('DB_USER', 'root');
define('DB_PASSWORD', '');
define('DB_CHARSET', 'UTF8');
function connectDb() {
try{
$dsn = 'mysql:host=' . DB_HOST . ';dbname=' . DB_NAME;
$pdo = new PDO($dsn, DB_USER, DB_PASSWORD);
$pdo->exec('SET ' . DB_CHARSET);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $pdo;
}catch(PDOException $e){
throw new Exception($e->getMessage());
return false;
}
}
function pdoPrepare($pdo, $sql, $parameters=NULL) {
$prepare = $pdo->prepare($sql);
if($parameters){
$prepare->execute($parameters);
}else{
$prepare->execute();
}
return $prepare;
}
$pdo = connectDb();
$result = "SELECT * FROM user WHERE username = '$_POST["username"]' and password = '$_POST["password"]' ";
if($result && $result->num_rows>0){
header('Location:*');
echo $errmsg = "Login successed";
}else {
echo $errmsg="Incorrect username or password login failed"; }
}
else{
$errmsg = "Please input your username";
}
?>
求大侠看看哪里有问题 不胜感激 展开
1个回答
展开全部
报了语法错误吧Parse error: syntax error这种吧
$result = "SELECT * FROM user WHERE username = '$_POST["username"]' and password = '$_POST["password"]' ";
这是有问题的;
正确的:$result = "SELECT * FROM user WHERE username = '$_POST[username]' and password = '$_POST[password]' ";
双引号里面不能有双引号，这是常识。
追问
谢谢你还专门运行了一下。。。。。
不过这个错误不是主要的 我是个新手菜鸟，谢谢你
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
