Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>PHP sample website</title>
- <link href="./css/main.css" rel="stylesheet"/>
- <meta charset="utf-8">
- </head>
- <body>
- <?PHP
- session_start();
- function doQuery($serv, $query){
- try {
- $sqlFound = $serv->query($query);
- return $sqlFound;
- }
- catch(PDOException $ex) {
- echo $ex;
- die();
- }
- }
- function addQuery($server, $queryName, $queryEmail, $queryPWord){
- $query = "INSERT INTO users (userName, userEmail, userPWord, userPWHash) VALUES ('" . $queryName . "','" . $queryEmail . "','" . $queryPWord . "','" . hash('tiger128,4', $queryPWord) . "');";
- doQuery($server, $query);
- }
- $db_serv = "mysql:dbname=null;host=127.0.0.1:3306";
- $db_uName = "root";
- $db_pWord = "";
- $conn = new PDO($db_serv, $db_uName, $db_pWord);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- echo "Connection successful.";
- ?>
- <!-- ------------------------------------------------------------- LOGIN FORM BEGINS ------------------------------------------------------------- -->
- <form action="index.php" method="post">
- <fieldset>
- <legend>Sign into an account</legend>
- <label for="uName">Username:</label>
- <input type="text" name="uName"/>
- <label for="email">Email:</label>
- <input type="email" name="uEmail"/>
- <label for="uPWord">Password:</label>
- <input type="password" name="uPWord"/>
- <input type="submit" value="Login"/>
- </fieldset>
- </form>
- <?PHP
- $sqlFind = 'SELECT * FROM users;'; //doQuery($conn, $sqlFind);
- if($_POST['uName'] != ""){
- if($_POST['uEmail'] != ""){
- if($_POST['uPWord'] != ""){
- $uName = $_POST['uName'];
- $uEmail = $_POST['uEmail'];
- $uPWord = $_POST['uPWord'];
- $queryResult = doQuery($conn,$sqlFind);
- forEach($queryResult as $found){
- if($found['userName'] == $uName){
- $isSameUName = true;
- if($found['userEmail'] == $uEmail){
- $isSameUEmail = true;
- if($found['userPWord'] == $uPWord){
- $isSameUPWord = true;
- }
- }
- }
- }
- if($isSameUName == true){
- echo "<p class='succ notif'><span class='data'>" . $uName . "</span>: That username is available!</p>";
- if($isSameUEmail == true) {
- echo "<p class='succ notif'><span class='data'>" . $uEmail . "</span>: That email has been recorded!</p>";
- if($isSameUPWord == true){
- echo "<p class='succ notif'><span class='data'>" . $uPWord . "</span>: That password is correct!</p>";
- }
- else {
- echo "<p class='err notif'><span class='data'>" . $uPWord . "</span>: That password is incorrect!</p>";
- }
- }
- else {
- echo "<p class='err notif'><span class='data'>" . $uEmail . "</span>: No one has registered this email!</p>";
- }
- }
- else {
- echo "<p class='err notif'><span class='data'>" . $uName . "</span>: This username doesn't exist!</p>";
- }
- }
- }
- }
- ?>
- <!-- ------------------------------------------------------------- LOGIN FORM ENDS ------------------------------------------------------------- -->
- <!-- ------------------------------------------------------------- REGISTRATION FORM BEGINS ------------------------------------------------------------- -->
- <form action="index.php" method="post">
- <fieldset>
- <legend>Alternatively, register one</legend>
- <label for="uName">Username:</label>
- <input type="text" name="regUName"/>
- <label for="email">Email:</label>
- <input type="email" name="regUEmail"/>
- <label for="uPWord">Password:</label>
- <input type="password" name="regUPWord"/>
- <input type="submit" value="Register"/>
- </fieldset>
- </form>
- <?PHP
- $sqlFind = 'SELECT * FROM users;'; //doQuery($conn, $sqlFind);
- if($_POST['regUName'] != ""){
- if($_POST['regUEmail'] != ""){
- if($_POST['regUPWord'] != ""){
- $rUName = $_POST['regUName'];
- $rUEmail = $_POST['regUEmail'];
- $rUPWord = $_POST['regUPWord'];
- $queryResult = doQuery($conn,$sqlFind);
- forEach($queryResult as $found){
- if($found['userName'] == $rUName){
- $isSameRegUName = true;
- if($found['userEmail'] == $rUEmail){
- $isSameRegUEmail = true;
- }
- }
- }
- if($isSameRegUName == true){
- echo "<p class='err notif'><span class='data'>" . $rUName . "</span>: Username is already in use!</p>";
- }
- else {
- echo "<p class='succ notif'><span class='data'>" . $rUName . "</span>: Username is available!</p>";
- if($isSameRegUEmail == true) {
- echo "<p class='err notif'><span class='data'>" . $rUEmail . "</span>: Email is already in use!</p>";
- }
- else {
- echo "<p class='succ notif'><span class='data'>" . $rUEmail . "</span>: This email is available!</p>";
- addQuery($conn, $rUName, $rUEmail, $rUPWord);
- }
- }
- }
- }
- }
- /*$check_sql = "SELECT * FROM users WHERE username = :username OR userEmail = :email";
- $check_statement = $conn->prepare($check_sql);
- $check_statement->bindValue(':username', $_POST['uName']);
- $check_statement->bindValue(':email', $_POST['email']);
- $check_statement->execute();
- $check_result = $check_statement->fetchAll();
- */
- ?>
- <!-- ------------------------------------------------------------- REGISTRATION FORM ENDS ------------------------------------------------------------- -->
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement