Please i am stocked and don't know what to do. I am new and need help
This query Fetch data from a back end of stored information on my database schoolcourse table matching it against data inserted from the studentbio form into the studentbio table.
<?php
global $nwsq, $row;
$Mat = $_SESSION["MatriculationNo"];
$nwsq = $con->query("SELECT schoolcourse.CourseCode, CourseTittle, CourseUnit FROM schoolcourse, studentbio WHERE studentbio.MatriculationNo = '{$Mat}' AND studentbio.Department = schoolcourse.Deparment AND studentbio.Level = schoolcourse.Level");
?>
Now the code below holds the form input i want to insert into a course registration table on my db
<div class="container">
<div class="single">
<div class="form-container">
<h3 class="w3ls-title w3ls-title1">Course Registeration Form</h3>
<form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="post">
<div class="row">
<div class="form-group col-md-12">
<label class="col-md-3 control-lable" for="firstName">Surname</label>
<div class="col-md-9">
<input type="text" name="Surname" path="firstName" id="firstName" class="form-control input-sm" value="" required="" />
</div>
</div>
</div>
<div class="row">
<div class="form-group col-md-12">
<label class="col-md-3 control-lable" for="lastName">Other Names</label>
<div class="col-md-9">
<input type="text" name="Othernames" path="lastName" id="lastName" class="form-control input-sm" value="" required="" />
</div>
</div>
</div>
<div class="row">
<div class="form-group col-md-12">
<label class="col-md-3 control-lable" for="lastName">Matriculation Number</label>
<div class="col-md-9">
<input type="text" name="Matno" path="lastName" id="Mat" class="form-control input-sm" value="" required="" />
</div>
</div>
</div>
This part displays the result on an echoed HTML table tag from the $nwsq select query using while loop
<div class="row">
<div class="form-group col-md-12">
<div class="col-md-9">
<?php
if ($nwsq) {
echo "<table><tr><th>CourseCode</th>
<th>CourseTittle</th>
<th>CourseUnit</th>
</tr>";
while($row = $nwsq->fetch_assoc()) {
echo "<tr><td>".$row["CourseCode"]."</td>
<td>" . $row["CourseTittle"]. "</td>
<td>" . $row["CourseUnit"]. "</td>
</tr>";
}
?>
</div>
</div>
</div>
<input type="button" name="Create" value="RegisterCourse" />
</div>
</div>
</div>
</form>
Here is my major problem; How do i write an insert query to insert this data being displayed by the while loop into a table on mysql database. My code is like this
<?php
if(isset($_POST['Create'])){
$FName = $_POST['Surname'];
$OName = $_POST['Othernames'];
$Mat = $_POST['Matno'];
$statmt = $con->query("INSERT INTO courseregistrationtable (Surname, Othername, MatriculationNo, CourseCode, CourseTittle, CourseUnit) Values('{$FName}', '{$OName}', '{$Mat}', '{$VariableForCourseCode}', '{$VariableForCourseTittle}', '{$VariableForCourseUnit}')");
}
?>
What I have tried:
I have tried writing my insert code like this but this code is not inserting anything to my db
<?php
if (isset($_POST['Create'])) {
$temp_array = array();
while($row = $nwsq->fetch_array()){
$temp_array[] = array('CourseCode'=>$row['CourseCode']);
}
foreach($temp_array as $arr){
foreach($arr as $key=>$val){
if($key == "CourseCode"){ $CourseCode = $val; }
$Teller = $_POST['TellerId'];
$Mat = $_POST['Matno'];
$Stmt = "INSERT INTO courseregistration (TellerId, MatriculationNo, CourseCode) VALUES ($Teller, $Mat, $CourseCode)";
$sq = $con->query($Stmt);
}
}
}?>