server.php

<?php
    //require('connect.php');
    session_start();

    // variable declaration
    //$username = "";
    //$email    = "";
    $errors = array();
    //$_SESSION['success'] = "";

    //$username = "";
    //$psw = "";
    //$secPsw = "";
    //$email = "";


// connect to database
$db = mysqli_connect('localhost', 'st2014', 'progress', 'st2014');
//echo "db - " . $db;

if ($db->connect_error) {
    die("Ühendamine andmebaasiga nurjus: " . $db->connect_error);
}

// REGISTER USER
    if (isset($_POST['username'])){
        // receive all input values from the form
        //print_r(array('test', $_POST));
        //print_r(array('test', $_POST['username']);
         $username = mysqli_real_escape_string ($db, $_POST['username']);
         //print_r($db, $_POST['username']);
         $psw = mysqli_real_escape_string ($db, $_POST['psw']);
         $secPsw = mysqli_real_escape_string ($db, $_POST['secPsw']);
         $email = mysqli_real_escape_string ($db, $_POST['email']);

         //echo "Done: ". $username;
         // form validation: ensure that the form is correctly filled
    // if ($username == "") {
    //     array_push($errors, "Kasutajanimi on kohustuslik väli!");
    // }
    // if ($psw == "") {
    //     array_push($errors, "Parool on kohustuslik väli!");
    // }
    // if ($psw != $secPsw) {
    //     array_push($errors, "Kaks parooli peavad ühtima!");
    // }
    // if ($email == "") {
    //     array_push($errors, "Email on kohustuslik väli!");
    // }

     // register user if there are no errors in the form
    //if (count($errors) == 0) {
    //$password = md5($psw);//encrypt the password before saving in the database

        $sql = "INSERT INTO t172500_users (username,psw,secPsw,email) VALUES ('$username','$psw','$secPsw','$email');";
        //$sql = "INSERT INTO t172500_users (username,psw,secPsw,email) VALUES ('midagiVeel','midagiVeel','midagiVeel','midagiVeel@midagi.ee');";
        //$sql = "INSERT INTO t172500_users (username,psw,secPsw,email) VALUES ('$_POST[username]','$_POST[psw]','$_POST[secPsw]','$_POST[email]');";
        $result = mysqli_query($sql);
        // //mysqli_query($db, $query);
            if($result){
               echo "User Created Successfully.";
            }else{
               echo "User Registration Failed";
            }
        //$_SESSION['username'] = $username;
        //$_SESSION['success'] = "Sa oled nüüd sisse logitud";

        //   if ($db -> query($sql) === TRUE) {
        //       echo "Uus kasutaja andmebaasi loodud";
        //   } else {
        //       echo "Error: " . $sql . "<br>" . $sql -> error;
        //   }

        // $db->close();

        //header('location: index.php');
    }
//}

// // LOGIN USER
// if (isset($_POST['login_user'])) {
//     $username = mysqli_real_escape_string($db, $_POST['username']);
//     $psw = mysqli_real_escape_string($db, $_POST['psw']);

//     if (empty($username)) {
//         array_push($errors, "Kasutajanimi on kohustuslik väli!");
//     }
//     if (empty($psw)) {
//         array_push($errors, "Parool on kohustuslik väli!");
//     }

//     if (count($errors) == 0) {
//         $password = md5($psw);
//         $query = "SELECT * FROM users WHERE username = '$username' AND password = '$psw'";
//         $results = mysqli_query($db, $query);
//         if (mysqli_num_rows($results) == 1) {
//           $_SESSION['username'] = $username;
//           $_SESSION['success'] = "Sa oled sisse logitud";
//           header('location: index.php');
//         }else {
//             array_push($errors, "Vale kasutajanime ja parooli seos!");
//         }
//     }
//   }

  ?>