connect_error) die("Database connection failed: " . $conn->connect_error); session_start(); // === SIGNUP === if (isset($_POST['signup'])) { $user = $_POST['username']; $pass = password_hash($_POST['password'], PASSWORD_DEFAULT); $check = $conn->query("SELECT * FROM users WHERE username='$user'"); if ($check->num_rows == 0) { $conn->query("INSERT INTO users (username, password) VALUES ('$user','$pass')"); echo ""; } else { echo ""; } } // === LOGIN === if (isset($_POST['login'])) { $user = $_POST['username']; $pass = $_POST['password']; $res = $conn->query("SELECT * FROM users WHERE username='$user'"); if ($res->num_rows > 0) { $row = $res->fetch_assoc(); if (password_verify($pass, $row['password'])) { $_SESSION['username'] = $user; } else echo ""; } else echo ""; } // === LOGOUT === if (isset($_GET['logout'])) { session_destroy(); header("Location: index.php"); exit; } // === POST FORUM === if (isset($_POST['post_forum']) && isset($_SESSION['username'])) { $msg = $conn->real_escape_string($_POST['message']); $u = $_SESSION['username']; $conn->query("INSERT INTO forum_posts (username, message) VALUES ('$u','$msg')"); } // === SUBMIT TECHNIQUE === if (isset($_POST['submit_tech']) && isset($_SESSION['username'])) { $tech = $conn->real_escape_string($_POST['technique']); $u = $_SESSION['username']; $conn->query("INSERT INTO techniques (username, technique) VALUES ('$u','$tech')"); } // === SAVE DREAM === if (isset($_POST['save_dream']) && isset($_SESSION['username'])) { $dream = $conn->real_escape_string($_POST['dream_text']); $u = $_SESSION['username']; $conn->query("INSERT INTO dream_journal (username, dream_text) VALUES ('$u','$dream')"); } ?> Lucid Dreaming Hub

Lucid Dreaming Hub

Login or Register

Welcome, 🌙

Explore techniques, share dreams, and talk in the forum.

Logout

Lucid Dreaming Techniques

query("SELECT * FROM techniques ORDER BY id DESC"); while ($row = $res->fetch_assoc()) { echo "
{$row['username']}: {$row['technique']}
"; } ?>

Forum

query("SELECT * FROM forum_posts ORDER BY id DESC"); while ($row = $res->fetch_assoc()) { echo "
{$row['username']}: {$row['message']}
"; } ?>

Submit a Technique

Dream Journal

query("SELECT * FROM dream_journal WHERE username='$u' ORDER BY id DESC"); while ($row = $res->fetch_assoc()) { echo "
{$row['dream_text']}
"; } ?>