} $table = DB_NAME; echo "Connecting ... <br>"; $mysql = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, '', DB_PORT); echo "Connected .. <br>"; if ($mysql->connect_error) { die($mysql->connect_error); } echo "Creating datatbase ... <br>"; $mysql->query("CREATE DATABASE IF NOT EXISTS " . DB_NAME); echo "Database created <br>"; echo "Filling with Tables <br>"; $mysql->select_db($table); $mysql->query("CREATE TABLE IF NOT EXISTS users(id INT NOT NULL AUTO_INCREMENT, username VARCHAR(16) NOT NULL, password VARCHAR(64) NOT NULL, token VARCHAR(23), time DATETIME, PRIMARY KEY(id))"); echo "Finished ... <br>"; echo 'Inserting User and getting up ... <br>'; echo "\n"; try { print_r($api->sign_up("Hallo", hash("sha256", "Hallo"), hash("sha256", "Hallo"))); $pass = hash("sha256", "Hallo"); $api->query("INSERT INTO users(username, password) VALUES ('Hallo', {$pass}"); } catch (Exception $e) { echo $e->getTraceAsString(); echo "\n at :" . $e->getLine(); } echo "\n"; echo 'User Hallo with Password Hallo inserted ...<br>'; echo 'Created the SQL and made Tables ...<br> '; echo '<iframe src="../login"></iframe>'; echo "\n"; echo '<a href="../index.php">Go Back</a>';
<?php @E_DEPRECATED; //TODO: Rework require_once 'api.php'; $api = new api(); $user = $_POST["username"]; $pass = hash("sha256", $_POST["password"]); $pass2 = hash("sha256", $_POST["password2"]); $api->sign_up($user, $pass, $pass2); ?> <!DOCTYPE html> <html> <head lang="en"> <meta charset="UTF-8"> <title>Signup - Reloading</title> </head> <body> <!-- TODO: Use ajax --> <script src="/api/libs/jquery-2.1.4.js"></script> <script type="text/javascript"> /* $.ajax({ url:"login.php", method: "post", }"login.php", {username: <?php echo $user; ?> , password: <?php echo $_POST["password"]; ?>