Skip to content
Snippets Groups Projects
Select Git revision
  • master default
  • unsecure
2 results
Blame Permalink
questions_20211223161027.php 4.09 KiB 
<?php
session_start();

$host = "127.0.0.1";
$port = "5432";
$user = "postgres";
$password = "postgres";
$db = "demo";

$conn_string = "host=" . $host . " port=5432 dbname=" . $db . " user=" . $user . " password=" . $password . "";

$con = pg_connect($conn_string);
$username = $_SESSION['uname'];

function unset_username()
{
	unset($_SESSION['uname']);
}

if (isset($_GET['name'])) {
	unset_username();
}
?>

<html>

<head>
	<title>Login Page</title>
	<link rel="dns-prefetch" href="//fonts.gstatic.com">
	<link href="https://fonts.googleapis.com/css?family=Nunito" rel="stylesheet">

	<link rel="stylesheet" type="text/css" href="styles.css">
	<link rel="stylesheet" href="app.css">
	<link rel="icon" type="image/png" href="img/favicon.png" />
</head>

<body>
	<div id="app">
		<nav class="navbar navbar-expand-md navbar-light bg-white shadow-sm">
			<div class="container">
				<a class="navbar-brand">
					BattTho
				</a>
				<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="{{ __('Toggle navigation') }}">
					<span class="navbar-toggler-icon"></span>
				</button>

				<div class="collapse navbar-collapse" id="navbarSupportedContent">
					<ul class="navbar-nav me-auto">
					</ul>
					<ul class="navbar-nav ms-auto">

						<?php
						echo '
							<li class="nav-item dropdown">
							<a id="navbarDropdown" class="nav-link" href="#" role="button" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false" v-pre>
								user: ' . $username . '
							</a>

							<li class="nav-item">
								<a class="nav-link" href="login.php?name=true">Logout</a>
							</li>
							<script>
							function logout(){
								<?php unset_username(); ?>
								}
							</script>
							';
						?>

						</li>
					</ul>
				</div>
			</div>
		</nav>
	</div>
	<br>
	<div class="container">
		<div class="row justify-content-center">
			<div class="col-md-8">
				<div class="card">
					<div class="card-header">Make a question!</div>
					<div class="card-body">
						<form method="GET" action="">
							<div class="form-group">
								<input type="text" name="ListQuestion" id="ListQuestion" class="form-control" placeholder="Enter question">
								<button type="submit" name="submit" class="top-buffer">Submit Question</button>
							</div>
						</form>
					</div>
				</div>
				<br>

				<?php

				if (isset($_GET['submit'])) {
					$question = $_GET['ListQuestion'];
					$sql = "INSERT INTO questions (question, userquestion) VALUES ('$question', '$username')";
					$rs = pg_query($con, $sql);
					header('Location: questions.php');
				}

				if (isset($_GET['submit2'])) {
					$answer = $_GET['Answers'];
					$id = $_GET['currentId'];
					$sql = "INSERT INTO answers (answers, questionid, useranswer) VALUES('$answer', '$id', '$username')";
					$rs = pg_query($con, $sql);
					header('Location: questions.php');
				}

				$result = pg_query($con, 'SELECT question, "ID", userquestion FROM questions ORDER by "ID" DESC');
				$result2 = pg_query($con, 'SELECT answers, questionid, useranswer FROM answers');
				while ($row = pg_fetch_assoc($result)) {
					echo ' 
				<div class="card">
					<div class="card-header"> Question: ' . $row["question"] . '
						<div>Question by:  ' . $row["userquestion"] . '</div>
					</div>
					<div class="card-body">
						<form method="GET" action="">';
					pg_result_seek($result2, 0);
					while ($row2 = pg_fetch_assoc($result2)) {
						if ($row["ID"]  == $row2["questionid"]) {
							echo '<p>' . $row2["useranswer"] . ': ' . $row2["answers"] . '</p>';
						}
					}

					echo '
							<input type="hidden" name="currentId" value="' . $row["ID"] . '" />
							<div class="form-group">
								<input type="text" name="Answers" class="form-control" placeholder="Enter answer">
								<button type="submit" name="submit2" class="top-buffer">Submit Answer</button>
							</div>
						</form>
					</div>
				</div>
				<br>
				';
				}

				echo pg_dump -t 'schema-name.table-name' --schema-only database-name;
				?>

			</div>
		</div>
	</div>
</body>