I have a form which I check using php if there are records on the database. If records exist in the database then the input box will be auto-filled. I have done that, no worries. The issue is if I want to modify the text in the input box, then I cant get the new value of the input box. How can I do that?
<?php
$title="Welcome";
require("connect.php");
session_start();
if(isset($_SESSION['CurrentUser'])) {
$AppID=$_SESSION['CurrentUser'];
}
else{
header("Location: ApplicantLogin.php");
}
$Flag = mysql_query("SELECT EXISTS(SELECT 1 FROM Submission WHERE AppID='$AppID') AS FLAG");
$SubmissionDetailSQL=mysql_query("SELECT * FROM Submission WHERE AppID = '$AppID'");
function saveData() {
if (isset($_POST['QualificationPlace']) && isset($_POST['QualificationType']) && isset($_POST['QualificationInstitution']) && isset($_POST['QualificationMonth'])
&& isset($_POST['QualificationYear']) && isset($_POST['QualificationSubject']) && isset($_POST['QualificationGrade'])){
$QualificationPlace = $_POST['QualificationPlace'];
$QualificationType = $_POST['QualificationType'];
$QualificationInstitution = $_POST['QualificationInstitution'];
$QualificationMonth = $_POST['QualificationMonth'];
$QualificationYear = $_POST['QualificationYear'];
$QualificationSubject = $_POST['QualificationSubject'];
$QualificationGrade = $_POST['QualificationGrade'];
mysql_query("UPDATE Submission SET QualificationPlace='$QualificationPlace', QualificationType='$QualificationType',
QualificationInstitution='$QualificationInstitution', QualificationMonth='$QualificationMonth', QualificationYear='$QualificationYear',
QualificationSubject='$QualificationSubject', QualificationGrade='$QualificationGrade' WHERE AppID=$AppID");
}
}
if (isset($_POST['savebtn'])) {
saveData();
header("Location: applicantCase.php");
}
if (isset($_POST['nextbtn'])) {
saveData();
header("Location: ApplicantApplyEmployment.php");
}
if (mysql_fetch_array($Flag) == True) {
while ($SubmissionDetails=mysql_fetch_array($SubmissionDetailSQL)){
$_SESSION['QualificationPlace']=$SubmissionDetails['QualificationPlace'];
$_SESSION['QualificationType']=$SubmissionDetails['QualificationType'];
$_SESSION['QualificationInstitution']=$SubmissionDetails['QualificationInstitution'];
$_SESSION['QualificationMonth']=$SubmissionDetails['QualificationMonth'];
$_SESSION['QualificationYear']=$SubmissionDetails['QualificationYear'];
$_SESSION['QualificationSubject']=$SubmissionDetails['QualificationSubject'];
$_SESSION['QualificationGrade']=$SubmissionDetails['QualificationGrade'];
}
}
include( "html/applicantsheader.html" );
include( "html/ApplicantApplyQualifications.html" );
include( "html/footer.html" );
?>
The HTML Code:
<div class="col-sm-4 col-sm-offset-5 col-md-4 col-md-offset-5 main">
<h1 class="page-header">Qualifications</h1>
<form action="ApplicantApplyQualifications.php" method="POST">
<!-- Select Basic -->
<fieldset class="form-group">
<label for="Name">Where was the qualification taken?</label>
<?php echo "<input type='text' name='QualificationPlace' class='form-control' placeholder=''value=".$_SESSION['QualificationPlace'].">" ;?>
</fieldset>
<fieldset class="form-group">
<label for="Name">Qualification Type</label>
<?php echo "<input type='text' name='QualificationType' class='form-control' placeholder=''value=".$_SESSION['QualificationType'].">" ;?>
</fieldset>
<fieldset class="form-group">
<label for="Name">Awarding Institution</label>
<?php echo "<input type='text' name='QualificationInstitution' class='form-control' placeholder=''value=".$_SESSION['QualificationInstitution'].">" ;?>
</fieldset>
<fieldset class="form-group">
<label for="Surname">Month / Year</label>
<div class="input-group">
<?php echo "<input type='text' name='QualificationMonth' class='form-control' placeholder=''value=".$_SESSION['QualificationMonth'].">" ;?>
<span class="input-group-addon">-</span>
<?php echo "<input type='text' name='QualificationYear' class='form-control' placeholder=''value=".$_SESSION['QualificationYear'].">" ;?>
</div>
</fieldset>
<fieldset class="form-group">
<label for="Surname">Subject</label>
<?php echo "<input type='text' name='QualificationSubject' class='form-control' placeholder=''value=".$_SESSION['QualificationSubject'].">" ;?>
</fieldset>
<fieldset class="form-group">
<label for="Surname">Grade</label>
<?php echo "<input type='text' name='QualificationGrade' class='form-control' placeholder=''value=".$_SESSION['QualificationGrade'].">" ;?>
</fieldset>
<br>
<button type="submit" value="signup" name="savebtn" class="btn btn-primary">Save & Exit</button>
<button type="submit" value="signup" name="nextbtn" class="btn btn-primary">Next</button>
</form>
</div> <!-- /container -->
The problem must be the value=".$_SESSION['QualificationPlace'].". But how can I do it differently ?