所以我正在制作我的第一个网站,并试图通过xaamp连接到运行在apache服务器上的mysql数据库
我的代码在下面,当我尝试登录时,它给出了错误,数据库的屏幕截图也附在上
include("config.php");
session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
// username and password sent from form
$myusername = mysqli_real_escape_string($db,$_POST['username']);
$mypassword = mysqli_real_escape_string($db,$_POST['password']);
$sql = "SELECT id FROM admin WHERE username = '$myusername' and passcode = '$mypassword'";
$result = mysqli_query($db,$sql);
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
$active = $row['active'];
$count = mysqli_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count == 1) {
session_register("myusername");
$_SESSION['login_user'] = $myusername;
header("location: index.html");
}else {
$error = "Your Login Name or Password is invalid";
}
}
?>
config.php:
define('DB_SERVER', '127.0.0.1');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', 'rootpassword');
define('DB_DATABASE', 'database');
$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
?>
错误:
警告:mysqli_connect((:(HY000/1045(:拒绝用户"root"@"localhost"(使用密码:YES(在第6行的D:\examplep\htdocs\Website\Websiteassesment\config.php中访问
警告:mysqli_real_escape_string((要求参数1为mysqli,布尔值在第8行的D:\examplep\htdocs\Website\Websiteassesment\loginform.php中给出
警告:mysqli_real_escape_string((要求参数1为mysqli,布尔值在第9行的D:\examplep\htdocs\Website\Websiteassesment\loginform.php中给出
警告:mysqli_query((要求参数1为mysqli,布尔值在第12行的D:\examplep\htdocs\Website\Websiteassesment\loginfor.php中给出
警告:mysqli_fetch_array((要求参数1为mysqli_result,在第13行的D:\examplep\htdocs\Website\Websiteassesment\loginform.php中给定null
注意:正在尝试访问第14行中D:\examplep\htdocs\Website\Websiteassesment\loginform.php中null类型值的数组偏移量
警告:mysqli_num_rows((要求参数1为mysqli_result,在第16行的D:\examplep\htdocs\Website\Websiteassesment\loginfor.php中给定null
如有任何帮助,将不胜感激
此错误表示您的mySQL登录凭据不正确。检查用户名root
和密码rootpassword
是否正确。