Php登录表单不起作用使用mamp不加载它只有一个白屏


Php login form dont work using mamp dont load its only a white screen

打开浏览器时没有加载php,这是我的数据库 信息:我的

MySQL数据库可以使用phpMyAdmin进行管理。

要从您自己的脚本连接到MySQL服务器,请使用以下连接参数:

Host     localhost
Port     8889
User     root
Password root

例:

$link = mysql_connect('localhost', 'root', 'root');或者您可以使用 UNIX 套接字进行连接:

Socket      /Applications/MAMP/tmp/mysql/mysql.sock
User        root
Password    root

例:

$link = mysql_connect(
  ':/Applications/MAMP/tmp/mysql/mysql.sock',
  'root',
  'root'
);

有一些相当的问题...

   <?php

$host = "localhost";
$user = "root";
$pass = "root";
$db = "test";
mysql_connect($host, $user, $pass);
mysql_select_db($db);
if (isset($_POST['username'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$sql = "SELECT * FROM users WHERE username='".$username."' AND password'".$password."' LIMIT 1";
$res = mysql_query($sql);
if mysql_num_row($res) == 1) {
echo "You have succesfully logged in.";
exit ();
}   else {
echo "Invalid login info. Please return to the previous page.";
exit ();
    }
}

?>
<!DOCTYPE html>
<!--[if lt IE 7]> <html class="lt-ie9 lt-ie8 lt-ie7" lang="en"> <![endif]-->
<!--[if IE 7]> <html class="lt-ie9 lt-ie8" lang="en"> <![endif]-->
<!--[if IE 8]> <html class="lt-ie9" lang="en"> <![endif]-->
<!--[if gt IE 8]><!--> <html lang="en"> <!--<![endif]-->
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>Dark Login Form</title>
<link rel="stylesheet" href="css/style.css">
 <!--[if lt IE 9]><script src="//html5shim.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
<style script="javascript">
<style type="text/css">
Body,p {
color: red;
}
.Button {
-moz-box-shadow:inset 0px 1px 0px 0px #bbdaf7;
-webkit-box-shadow:inset 0px 1px 0px 0px #bbdaf7;
box-shadow:inset 0px 1px 0px 0px #bbdaf7;
background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #000000), color-stop(1, #ff0000) );
background:-moz-linear-gradient( center top, #79bbff 5%, #378de5 100% );
filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#79bbff    ', endColorstr='#378de5');
background-color:;
-webkit-border-top-left-radius:0px;
-moz-border-radius-topleft:0px;
border-top-left-radius:0px;
-webkit-border-top-right-radius:0px;
-moz-border-radius-topright:0px;
border-top-right-radius:0px;
-webkit-border-bottom-right-radius:0px;
-moz-border-radius-bottomright:0px;
border-bottom-right-radius:0px;
-webkit-border-bottom-left-radius:0px;
-moz-border-radius-bottomleft:0px;
border-bottom-left-radius:0px;
text-indent:0;
border:0px solid #FF0000;
display:inline-block;
color:#FFFFFF;
font-family:Arial;
font-size:15px;
font-weight:bold;
font-style:normal;
height:40px;
line-height:40px;
width:101px;
text-decoration:none;
text-align:center;
text-shadow:1px 1px 0px #528ecc;
margin-right:0.3em;
}
.Button:hover {
background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #000000), color-stop(1, #ff0000) );
background:-moz-linear-gradient( center top, #378de5 5%, #79bbff 100% );
filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#', endColorstr='#79bbff');
background-color:#;
}.Button:active {
position:relative;
top:1px;    
}</style>
</head>
<body>
<form method="post" action="login.php">
<p>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<center>
  <label for="login">Email:</label>
  <input type="text" name="username" id="login" value="name@example.com">
    </p>
    <p>
  <label for="password">Password:</label>
  <input type="password" name="password" id="password" value="4815162342">
 </p>   
<input class="Button" type="submit" value=Log In></a>
</center>       
<p class="forgot-password"><a href="forgotpassword.html">Forgot your password?</a></p>
</form>
</section>
</body>
</html>

您的连接端口不是默认的 MYSQL 端口。

用$link = mysql_connect('localhost:8889', 'root', 'root');用于连接到服务器的格式。

教程在。http://php.net/manual/en/function.mysql-connect.php

你的SQL查询有一些问题,其$sql ="从用户名='".$username.的用户中选择 *和密码".$password."'限制 1";

但是当您检查密码时,您忘记使用"="符号。 检查一下...

如果 mysql_num_row($res) == 1) {if 命令后缺少"("