PHP バックエンド設計の中核ポイントの詳細な分析

$servername = "localhost"; //数据库服务器名称
$username = "username"; //连接数据库的用户名
$password = "password"; //连接数据库的密码
$dbname = "myDB"; //要连接的数据库名称

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检测连接是否成功
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$uname = $conn->real_escape_string($_POST['username']);
$upass = $conn->real_escape_string($_POST['password']);

$sql = "SELECT * FROM users WHERE username = '".$uname."' AND password = '".$upass."'";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    //登录成功
} else {
    //登录失败
}

$uname = $conn->real_escape_string($_POST['username']);
$upass = $conn->real_escape_string($_POST['password']);
$uemail = $conn->real_escape_string($_POST['email']);

$sql = "INSERT INTO users (username, password, email) VALUES ('".$uname."', '".$upass."', '".$uemail."')";

if ($conn->query($sql) === TRUE) {
    //插入成功
} else {
    //插入失败
}

$target_dir = "uploads/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));

// 检测文件是否为图像
if(isset($_POST["submit"])) {
    $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
    if($check !== false) {
        // 是图像
        $uploadOk = 1;
    } else {
        // 不是图像
        $uploadOk = 0;
    }
}

// 检测文件是否已经存在
if (file_exists($target_file)) {
    $uploadOk = 0;
}

// 尝试上传文件
if ($uploadOk == 0) {
    // 上传失败
} else {
    if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
        //上传成功
    } else {
        // 上传失败
    }
}