<?php

error_reporting(E_ALL);
ini_set('display_errors', 1);

$email = $_POST['email'];
$password = $_POST['password'];

$db_username = "root";
$db_password = "";

$conn = new PDO("mysql:dbname=dashboard;host=localhost", $db_username, $db_password);

$stmt = $conn->prepare("SELECT * FROM `users` WHERE `email`= :email");
$stmt->bindParam(":email", $email);
$stmt->execute();

$query = $stmt->fetch();

if ($query) {
    echo "Email existiert schon.";
} else {
    $stmt2 = $conn->prepare("INSERT INTO `users`(`email`, `password`) VALUES (:email,:password)");
    $stmt2->bindParam(":email", $email);
    $stmt2->bindParam(":password", $password);

    if ($stmt2->execute()) {
        echo "Signup erfolgreich.";
    }
}