/*
    function findUser($find_username,$find_password){
    // username/password authenticated
    // and only 1 match
        $query = "SELECT defined_username,user_id,user_name,e_address ";
        $query .= "FROM tbl_users ";
        $query .= "WHERE defined_username = '{$find_username}' ";
        $query .= "AND hashed_password = '{$find_password}' ";
        $query .= "LIMIT 1";
        $result_set = mysql_query($query);
        confirm_query($result_set);
        if($found_user = mysql_fetch_array($result_set)){
            $_SESSION['user_id'] = $found_user['user_id'];
            $_SESSION['username'] = $found_user['user_name'];
            $_SESSION['email'] = $found_user['e_address'];
            return true;
        }else{
            return false;
        }
    }*/

    function findUser($newconnection,$find_username,$find_password){
    // username/password authenticated
    // and only 1 match
        $query = "SELECT defined_username,user_id,user_name,e_address ";
        $query .= "FROM tbl_users ";
        $query .= "WHERE defined_username = ? ";
        $query .= "AND hashed_password = ? ";
        $query .= "LIMIT 1";

        $stmt = mysqli_stmt_init($newconnection);
        if (!mysqli_stmt_prepare($stmt, $query)){
           return "Failed to prepare" . $query;
        }
        mysqli_stmt_bind_param($stmt,"ss", $find_username,$find_password);
        mysqli_stmt_execute($stmt);

         /* bind result variables */
        //mysqli_stmt_bind_result($stmt, $defined_username, $user_id,$user_name, $e_address);

        /* store result */
        mysqli_stmt_store_result($stmt);

        /* fetch values */
        //mysqli_stmt_fetch($stmt);
        If (mysqli_stmt_num_rows($stmt) == 1){
            while (mysqli_stmt_fetch($stmt)) {
                //printf ("%s (%s)\n", $name, $code);
                $_SESSION['user_id'] = $user_id;
                $_SESSION['username'] = $user_name;
                $_SESSION['email'] = $e_address;
            }
            return true;
        }else{
            return mysqli_stmt_num_rows($stmt);
        }
    }