spieleprogrammierer.de - Forum und Wiki zur Spieleprogrammierung und Spieleentwicklung

Quellcode

<?php

    // Author: Tobias Simon
    // Date: 23.03.2017
        // Date: 25.03.2017
    
    $servername = "localhost";
    $servernickname = "root";
    $serverpassword = "";
    $db_name = "accounts";
    
    $action = $_REQUEST['action'];
    
    // Connection
    $con = new mysqli($servername, $servernickname, $serverpassword, $db_name);
    
    // Check Connection
    if(!$con) die("Connection Failed! ".mysqli_connect_error());
    
    function check($stmt, $param) {
        if(!$stmt) die("Failed to prepare statement");
        $stmt->bind_param('s', $param);
        $stmt->execute();
        echo $stmt->fetch() ? 'true' : 'false';
    }
    
    if($action == 'check_email') {
        check($con->prepare("SELECT 1 FROM accounts WHERE email = ?"), $_REQUEST['email']);
    } if($action == 'check_nickname') {
        check($con->prepare("SELECT 1 FROM accounts WHERE nickname = ?"), $_REQUEST['nickname']);
    } elseif($action == 'register') {
        $email = $_REQUEST['email'];
        $nickname = $_REQUEST['nickname'];
        $password = $_REQUEST['password'];
        
        $stmt = $con->prepare('INSERT INTO accounts (nickname, email, password) VALUES (?, ?, ?)');
        $stmt->bind_param('sss', $nickname, $email, password_hash($password, PASSWORD_DEFAULT));
        if(!$stmt) die("Failed to prepare statement");
        $stmt->execute();
    }