currently I am doing a university assignment called "Online Examination System".
I had proceed to "Teacher part" and teacher is responsible to add Questions and Answers then INSERT into Database.
However, I cannot make this happen, can anyone helps me? Thanks
My addTest.php code as belows:
<!DOCTYPE html>
<html>
<head>
<title>Add New Test by teacher</title>
</head>
<form method="post" action="addTest.php">
<h2>Add New Test Form</h2>
<table border = '1'>
<td colspan='12'><a href='teacherPage.php'><input type='button' value='Close'/></a></td>
<h2>Add new Test</h2>
<tr><td>Test ID: </td><td><input type = 'text' name='test_id' /></td></tr>
<tr><td>Test name: </td><td><input type = 'text' name='test_name'/></td></tr>
<tr><td>Test Given Time in minutes: </td><td><input type = 'text' name='test_time'/></td></tr>
<tr><td>Test's date: </td><td><input type = 'date' name='test_date'/></td></tr>
<tr><td>Number of questions: </td><td><input type = 'number' name='no_Ques' /></td></tr>
<td colspan='2'>
<button type="submit" class="btn" name="confirm" >Confirm</button><br></td>
<tr><td colspan='2'>
<button type="submit" class="btn" name="add" >Add</button><br></td></tr>
</table>
</form>
<body>
<?php
include ("database.php");//Config file
session_start();
$sessuname = $_SESSION['Uname']; //automatically retrieve teacher ID from Login
$Moderator_ID="";
$sqlTeacher = "select TEACH_ID from TeacherUser where TEACH_USERNAME='$sessuname' LIMIT 1";
$TeacherNo = mysqli_query($conn, $sqlTeacher);
while ($Row = mysqli_fetch_row($TeacherNo))
{
for ($i=0; $i<count($Row); $i++)
{
$Moderator_ID=$Row[0];
}
}
//Used to spawn how many text area for questions and answers.
if (isset($_POST['confirm'])){
$No_Ques = $_POST['no_Ques'];
for($i=1;$i<=$No_Ques;$i++)
{
echo"<br><table><thead><th>Question ".$i."</th></thead>";
echo"<tr><td>Test Questions: </td><td><textarea name='test_question[".$i."]' cols ='35' rows ='6'></textarea></td></tr>";
echo"<tr><td>Test Answers: </td><td><textarea name='test_ans' cols ='35' rows ='6'></textarea></td></tr></table><hr><br>";
}
}
//Used to submit the entries into database
if (isset($_POST['add'])) {
$Test_ID = $_POST['test_id'];
$Test_Name = $_POST['test_name'];
$Test_Time = $_POST['test_time'];
$Test_Date = $_POST['test_date'];
$test_check_query = "SELECT * FROM TestDetails WHERE TEST_ID='$Test_ID' LIMIT 1";
$test_result = mysqli_query($conn, $test_check_query);
$test_exist = mysqli_fetch_assoc($test_result);
for($i=0;$i<$_POST['no_Ques'];$i++)
{
$Test_Ques = array();
$Ques=array();
$Test_Ques = trim($_POST['test_question']);
//It says $Test_Ques is not recognize == no value found in it when print_r.
//Not working :(
//print_r($Test_Ques);
//array_push($Ques,$Test_Ques);
//echo"Array is ".$Test_Ques[$i];
$que="<pre>$test_question</pre>";
$ans="<pre>$test_ans</pre>";
$test_sql = "INSERT INTO TestDetails (TEST_ID, TEST_NAME, TEST_QUESTION, TEST_ANS,
TEST_TIME, TEST_DATE, TEST_MODERATOR, TEST_MODERATOR_ID)
VALUES ('$Test_ID', '$Test_Name', '$que', '$ans',
'$Test_Time', '$Test_Date', '$sessuname', '$Moderator_ID')";
//The result is insert nothing into database.
$result = mysqli_query($conn, $test_sql);
}
//If test existed, added failed
if($test_exist){
if ($test_exist['TEST_ID'] == $Test_ID){
echo "<br>The test is already added. Please add with another test ID.";
mysqli_close($conn);
}
}
//New Test added successful
else{
echo"<br>New Test added successfully!<br><br>";
echo"New test ID is <strong>".$Test_ID."</strong>.<br>";
echo"New test name is <strong>".$Test_Name."</strong>.<br>";
echo"New test date is when <strong>".$Test_Date."</strong>.<br>";
header("refresh:5; url=addTest.php"); //check for port :8080
}
}
?>
</body>
</html>
Output:
A simple forms had created
After enter question number, textareas had been spawn
My Answer:
To insert multiple textareas into the SQL database in PHP, you need to modify your code to handle the array of textareas for questions and answers. Here's an updated version of your addTest.php code:
php
include ("database.php"); // Config file
session_start();
$sessuname = $_SESSION['Uname']; // Automatically retrieve teacher ID from Login
$Moderator_ID = "";
$sqlTeacher = "select TEACH_ID from TeacherUser where TEACH_USERNAME='$sessuname' LIMIT 1";
$TeacherNo = mysqli_query($conn, $sqlTeacher);
while ($Row = mysqli_fetch_row($TeacherNo)) {
for ($i = 0; $i < count($Row); $i++) {
$Moderator_ID = $Row[0];
}
}
if (isset($_POST['add'])) {
$Test_ID = $_POST['test_id'];
$Test_Name = $_POST['test_name'];
$Test_Time = $_POST['test_time'];
$Test_Date = $_POST['test_date'];
$test_check_query = "SELECT * FROM TestDetails WHERE TEST_ID='$Test_ID' LIMIT 1";
$test_result = mysqli_query($conn, $test_check_query);
$test_exist = mysqli_fetch_assoc($test_result);
if ($test_exist) {
if ($test_exist['TEST_ID'] == $Test_ID) {
echo "
The test is already added. Please add with another test ID.";
mysqli_close($conn);
}
} else {
$No_Ques = $_POST['no_Ques'];
for ($i = 1; $i <= $No_Ques; $i++) {
$Test_Ques = $_POST['test_question'][$i];
$Test_Ans = $_POST['test_ans'][$i];
$test_sql = "INSERT INTO TestDetails (TEST_ID, TEST_NAME, TEST_QUESTION, TEST_ANS, TEST_TIME, TEST_DATE, TEST_MODERATOR, TEST_MODERATOR_ID)
VALUES ('$Test_ID', '$Test_Name', '$Test_Ques', '$Test_Ans', '$Test_Time', '$Test_Date', '$sessuname', '$Moderator_ID')";
$result = mysqli_query($conn, $test_sql);
}
echo "
New Test added successfully!
";
echo "New test ID is $Test_ID.
";
echo "New test name is $Test_Name.
";
echo "New test date is when $Test_Date.
";
header("refresh:5; url=addTest.php"); // Check for port :8080
}
}
?>
Add New Test by teacher
In this updated code:
1. The form now includes an array of textareas for questions and answers with names like `test_question[1]`, `test_ans[1]`, `test_question[2]`, `test_ans[2]`, and so on.
2. When the form is submitted, the PHP code retrieves the values of questions and answers from the array and inserts them into the database along with other test details.
3. The code checks if the test ID already exists in the database before inserting a new test.
Make sure to adjust the code according to your database structure and requirements.
Rate this post
3 of 5 based on 8899 votesComments