Example #1
0
        echo 'Please enter email';
    }
    if ($validator->validatePassword($_POST['password']) == false) {
        echo 'Please enter password';
    }
    if ($validator->validateName($_POST['name']) && $validator->validateName($_POST['email']) && $validator->validatePassword($_POST['password'])) {
        $user1 = new User();
        $user1->setName($_POST['name']);
        $user1->setEmail($_POST['email']);
        $user1->setPassword($_POST['password']);
        $user1->setMessage($_POST['message']);
        $database = new Database();
        if ($database->Connect($servername, $dbname, $username, $password)) {
            $database->setTable('users');
            if (!$database->userExists($_POST['name'])) {
                $database->AddData($user1->getName(), $user1->getEmail(), $user1->getPassword(), $user1->getMessage());
                session_start();
                $_SESSION['username'] = $_POST['name'];
                header("Location: admin.php");
            } else {
                echo "User exists";
            }
            $database->Close();
        }
    }
}
/* sql to create table
$sql = "CREATE TABLE Users(id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) NOT NULL, email VARCHAR(50), password VARCHAR(255),  message VARCHAR(255))";
$conn->exec($sql);*/
/*
        $results = $conn->query('SELECT * FROM users');