简单得实现PHP登录注册 与数据库交互

创建数据库连接文件config.php

<?php
# connect.php文件
// 数据库连接参数
$db =  [
    'type' => 'mysql',
    'host' => 'localhost',
    'dbname' => 'test',
    'username' => 'root',
    'password' => 'root',
];

// 配置数据源DSN信息
$dsn = "{$db['type']}:host={$db['host']};dbname={$db['dbname']}";

// 连接数据库
try {
	$pdo = new PDO($dsn, $db['username'], $db['password']);
} catch (PDOException $e) {
	die('Connection Failed: ' . $e->getMessage());
}
?>

实现登录判断功能得PHP文件loginck.php

<?php
header("Content-Type: text/html;charset=utf-8");
if(!session_id())session_start();
require __DIR__  . '/db.php';//导入连接数据库
$username= $_POST['username'];
$password= $_POST['password'];


// ORDER BY 对数组进行排序。 条件是根据 key(字段) 来进行 正序(ASC) 倒序(DESC)
$sql = 'SELECT * FROM `users` WHERE `username` = :username AND `password` = :password LIMIT 1';
$stmt = $pdo->prepare($sql);
$stmt->execute(['username'=>$username, 'password'=>md5($password)]);
$user = $stmt -> fetch(PDO::FETCH_ASSOC);



if($user['password'] !=md5($password)){
echo("<script type='text/javascript'>alert('密码错误！');window.location.href='./login.php';</script>");
	exit;
}

$_SESSION['user'] = $user['username'];
	echo '<br>';
	echo("<script type='text/javascript'>alert('登录成功！');window.location.href='./index.php';</script>");
	exit;
?>

新人第一次发文 大佬勿喷！！！！！