<!DOCTYPE html>
<html>
<head>
<link rel = "stylesheet" href = "../css/styles.css">
<script src = "../js/functions.js"></script>
</head>
<body>
<div name = "questions" class = "middle-box">
<a href = "Home.php" class = "hl-black"><h1>Simple StackExchange</h1></a>
<h2 id = "lined-under">What's your question?</h2>
<?php
require 'functions.php';
// Create connection
$conn = get_connectqa();
$edit = $_GET['edit'];
printQForm($edit);
if (isset($_POST['post'])) {
$name = $_POST['name'];
$email = $_POST['email'];
$qtopic = $_POST['qtopic'];
$content = $_POST['content'];
if ($edit == -1) {
$result = mysqli_query($conn, "INSERT INTO questions(Name, Email, Topic, Content) VALUES ('{$name}', '{$email}', '{$qtopic}', '{$content}')");
} else {
$result = mysqli_query($conn, "UPDATE questions SET Name = '{$name}', Email = '{$email}', Topic = '{$qtopic}', Content = '{$content}' WHERE ID = '{$edit}'");
}
mysqli_close($conn);
header('Location: Home.php');
}
mysqli_close($conn);
?>
function printQForm($id)
{
if ($id == -1) {
echo '<form method = "post" name = "questions" onsubmit = "return qformValidation()">
<input type = "text" class = "full-form" placeholder = "Name" name = "name" value = "">
<br>
<input type = "text" class = "full-form"placeholder = "Email" name = "email" value = "">
<br>
<input type = "text" class = "full-form"placeholder = "Question Topic" name = "qtopic" value = "">
<br>
<textarea class = "full-form" placeholder = "Content" name = "content" rows = "7"></textarea>
<br>
<input type = "submit" class = "post-button" name = "post" value = "Post">
</form>';
} else {
$conn = get_connectqa();
$result = mysqli_query($conn, "SELECT * FROM questions WHERE ID = " . $id);
$row = mysqli_fetch_assoc($result);
echo '<form method = "post" name = "questions" onsubmit = "return qformValidation()">
<input type = "text" class = "full-form" placeholder = "Name" name = "name" value = "';
echo $row['Name'];
echo '">
<br>
<input type = "text" class = "full-form"placeholder = "Email" name = "email" value = "';
echo $row['Email'];
echo '">
<br>
<input type = "text" class = "full-form"placeholder = "Question Topic" name = "qtopic" value = "';
echo $row['Topic'];
echo '">
<br>
<textarea class = "full-form" placeholder = "Content" name = "content" rows = "7">';
echo $row['Content'];
echo '</textarea>
<br>
<input type = "submit" class = "post-button" name = "post" value = "Post">
</form>';
mysqli_close($conn);
}
}
