Jump to content

Chris721

Members
 View Profile  See their activity

  • Posts

    23

  • Joined

  • Last visited

 Content Type 

Posts posted by Chris721

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Cost`=`60',

    in PHP Coding Help

    Posted

    code now looks like

     

     

     
<title>Inputing Travel Detials</title>
 
<header>
  <h1 align="center"> Adding Travel Detials </h1>
  
 
  <body>
  
<table border="1">
  <tr>
    <td><a href="index.php"> Home Page </a></td>
    <td><a href="administratorhomepage.html">Administrator Home Page </a></td>
    <td><a href="viewhomepage.html">View Home Page </a></td>
    <td><a href="Inputhomepage.html">Input Home Page </a></td>
  </tr>
</table>
   
<center><img  src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center>
       
<table border="1">
  <tr>
   <td><a href="Changetraveldetials.html">Modify More Travel Detials </a></td>
  </tr>
</table>
 
<?php
 
include "connection.php";
 
$Applicant_ID = $_POST["Applicant_ID"];
$Method_Of_Travel = $_POST["Method_Of_Travel"];
$Cost = $_POST["Cost"];
$ETA = $_POST["ETA"];
$Main_Gate_Advised = $_POST["Main_Gate_Advised"];
 
$query = ("UPDATE int_board_applicant SET 'Method_Of_Travel'='$Method_Of_Travel', 'Cost'=$Cost, 'ETA'='$ETA', 'Main_Gate_Advised'='$Main_Gate_Advised' WHERE 'Applicant_ID'='$Applicant_ID'");
   
 
$result = mysqli_query($dbhandle, $query) 
    or die(mysqli_error($dbhandle));
 
if($result){ echo "Success!"; }
 
  else{ echo "Error."; }
 
 
// successfully insert data into database, displays message "Successful".
 if($query){
  echo "Successful";
}
 
  else {
  echo "Data not Submitted";
}
 
 
//closing the connection
   mysqli_close($dbhandle)
 
?>
 
</body>
 

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Cost`=`60',

    in PHP Coding Help

    Posted

    I have been looking at this code most of the morning and do not have a clue what is wrong with the code. I am hoping its not a stupid mistake, can someone please help me out? thank you 

     

     

     
<title>Inputing Travel Detials</title>
 
<header>
  <h1 align="center"> Adding Travel Detials </h1>
  
 
  <body>
    <p>  <center><img  src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center>
        <table border="1">
          <tr>
            <td><a href="index.php"> Home Page </a></td>
            <td><a href="administratorhomepage.html">Administrator Home Page </a></td>
            <td><a href="viewhomepage.html">View Home Page </a></td>
            <td><a href="Inputhomepage.html">Input Home Page </a></td>
            <td><a href="traveldetials.html">Enter More Travel Detials </a></td>
        </table>
    </p>
 
 
<?php
 
include "connection.php";
 
$Applicant_ID = $_POST["Applicant_ID"];
$Method_Of_Travel = $_POST["Method_Of_Travel"];
$Cost = $_POST["Cost"];
$ETA = $_POST["ETA"];
$Main_Gate_Advised = $_POST["Main_Gate_Advised"];
 
$query = ("UPDATE `int_board_applicant` SET `Method_Of_Travel`=`$Method_Of_Travel', `Cost`=`$Cost', `ETA`='$ETA', `Main_Gate_Advised`='$Main_Gate_Advised' WHERE `Applicant_ID`='$Applicant_ID'");
   
 
$result = mysqli_query($dbhandle, $query) 
    or die(mysqli_error($dbhandle));
 
if($result){ echo "Success!"; }
 
  else{ echo "Error."; }
 
 
// successfully insert data into database, displays message "Successful".
 if($query){
  echo "Successful";
}
 
  else {
  echo "Data not Submitted";
}
 
 
//closing the connection
   mysqli_close($dbhandle)
   
 
 
 
 
?>

    Notice: Undefined variable: searchq in C:\wamp\www\search2.php on line 17

    in PHP Coding Help

    Posted · Edited by Chris721 


    
 
    
<title>Applicant Data view</title>
    
 
    
 <p>  <center><img  src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center>
    
        <table border="1">
    
          <tr>
    
            <td><a href="index.php"> Home Page </a></td>
    
            <td><a href="administratorhomepage.html">Administrator Home Page </a></td>
    
            <td><a href="viewhomepage.html">View Home Page </a></td>
    
        </table>
    
    </p>
    
 
    
<?php
    
 
    
  $searchq =($_GET['search']);
    
  
    
 
    
include "connection.php";
    
 
    
 
    
$sql = ("SELECT * FROM applicant WHERE `Firstname` LIKE '$searchq' OR `Lastname` LIKE '$searchq'");  
    
$result = $dbhandle->query($sql) or die($dbhandle->error);
    
 echo "<table border='1'>
    
  <tr>
    
    <th>Applicant Id</th>
    
    <th>Firstame</th>
    
    <th>Lastname</th>
    
    <th>Address</th>
    
    <th>Date Of Birth</th>
    
    <th>Contact Number</th>
    
    <th>Next Of Kin</th>
    
    <th>Next Of Kin Address</th>
    
    <th>Vetting Date</th>
    
    <th>Clearance Expiry</th>
    
    <th>Current Employer</th>
    
    <th>Date Applied</th>
    
    <th>Resubmitting</th>
    
    <th>Number Of Previous Attempts</th>
    
    <th>Why</th>
    
    <th>Qualificaton 1</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
    <th>Qualificaton 2</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
    <th>Qualificaton 3</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
    <th>Qualificaton 4</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
    <th>Qualificaton 5</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
    <th>Qualificaton 6</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
    <th>Qualificaton 7</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
    <th>Qualificaton 8</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
    <th>Qualificaton 9</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
    <th>Qualificaton 10</th>
    
    <th>Date Completed</th>
    
    <th>Expiry Date</th>
    
  </tr>";
    
  
    
if (isset ($_GET["search"])) {
    
  $searchq = $_GET["$sql"];
    
  $searchq = ("#[^a-z, A-Z]#i"); 
    
  
    
if ($result->num_rows > 0) {
    
    // output data of each row
    
   while($row = $result->fetch_assoc())    
    
  {
    
  echo "<tr>";
    
    echo "<td>" . $row['Applicant_ID'] . "</td>";
    
    echo "<td>" . $row['Firstname'] . "</td>";
    
    echo "<td>" . $row['Lastname'] . "</td>";
    
    echo "<td>" . $row['Address'] . "</td>";
    
    echo "<td>" . $row['DOB'] . "</td>";
    
    echo "<td>" . $row['Telephone_No'] . "</td>";
    
    echo "<td>" . $row['NOK'] . "</td>";
    
    echo "<td>" . $row['NOK_Address'] . "</td>";
    
    echo "<td>" . $row['Vetting_Date'] . "</td>";
    
    echo "<td>" . $row['Clearance_Expiry'] . "</td>";
    
    echo "<td>" . $row['Current_Employer'] . "</td>";
    
    echo "<td>" . $row['Date_applied'] . "</td>";
    
    echo "<td>" . $row['Resubmission'] . "</td>";
    
    echo "<td>" . $row['Number_of_Attempts'] . "</td>";
    
    echo "<td>" . $row['Why'] . "</td>";
    
    echo "<td>" . $row['Qual_1'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_1'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_1'] . "</td>";
    
    echo "<td>" . $row['Qual_2'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_2'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_2'] . "</td>";
    
    echo "<td>" . $row['Qual_3'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_3'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_3'] . "</td>";
    
    echo "<td>" . $row['Qual_4'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_4'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_4'] . "</td>";
    
    echo "<td>" . $row['Qual_5'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_5'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_5'] . "</td>";
    
    echo "<td>" . $row['Qual_6'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_6'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_6'] . "</td>";
    
    echo "<td>" . $row['Qual_7'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_7'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_7'] . "</td>";
    
    echo "<td>" . $row['Qual_8'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_8'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_8'] . "</td>";
    
    echo "<td>" . $row['Qual_9'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_9'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_9'] . "</td>";
    
    echo "<td>" . $row['Qual_10'] . "</td>";
    
    echo "<td>" . $row['Date_Completed_10'] . "</td>";
    
    echo "<td>" . $row['Run_out_date_10'] . "</td>";
    
  echo "</tr>";
    
  }
    
echo "</table>";
    
  } else {
    
      echo "0 results";
    
  }
    
  }
    
$dbhandle->close(); 
    
?>

    Notice: Undefined variable: searchq in C:\wamp\www\search2.php on line 17

    in PHP Coding Help

    Posted · Edited by Chris721

    I am sure there is something wrong around the

     

    if ($result->num_rows > 0) {

        // output data of each row
        while($row = mysqli_fetch_array($result))    
     
    area of the code, if I try to echo anything after that it doesn't work, I have tried everything I know and can't seem to fix it.
     
     

     

    <title>Applicant Data view</title>
     
     <p>  <center><img  src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center>
            <table border="1">
              <tr>
                <td><a href="index.php"> Home Page </a></td>
                <td><a href="administratorhomepage.html">Administrator Home Page </a></td>
                <td><a href="viewhomepage.html">View Home Page </a></td>
            </table>
        </p>
     
    <?php
     
      $searchq =($_GET['search']);
      
     
    include "connection.php";
     
     
    $sql = ("SELECT * FROM applicant WHERE `Firstname` LIKE '$searchq' OR `Lastname` LIKE '$searchq'");  
    $result = $dbhandle->query($sql) or die($dbhandle->error);
     echo "<table border='1'>
      <tr>
        <th>Applicant Id</th>
        <th>Firstame</th>
        <th>Lastname</th>
        <th>Address</th>
        <th>Date Of Birth</th>
        <th>Contact Number</th>
        <th>Next Of Kin</th>
        <th>Next Of Kin Address</th>
        <th>Vetting Date</th>
        <th>Clearance Expiry</th>
        <th>Current Employer</th>
        <th>Date Applied</th>
        <th>Resubmitting</th>
        <th>Number Of Previous Attempts</th>
        <th>Why</th>
        <th>Qualificaton 1</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 2</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 3</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 4</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 5</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 6</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 7</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 8</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 9</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 10</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
      </tr>";
      
    if (isset ($_GET["search"])) {
      $searchq = $_GET[`search`];
      $searchq = ("#[^a-z, A-Z]#i"); 
      
    if ($result->num_rows > 0) {
        // output data of each row
        while($row = mysqli_fetch_array($result))    
      {
      echo "<tr>";
        echo "<td>" . $row['Applicant_ID'] . "</td>";
        echo "<td>" . $row['Firstname'] . "</td>";
        echo "<td>" . $row['Lastname'] . "</td>";
        echo "<td>" . $row['Address'] . "</td>";
        echo "<td>" . $row['DOB'] . "</td>";
        echo "<td>" . $row['Telephone_No'] . "</td>";
        echo "<td>" . $row['NOK'] . "</td>";
        echo "<td>" . $row['NOK_Address'] . "</td>";
        echo "<td>" . $row['Vetting_Date'] . "</td>";
        echo "<td>" . $row['Clearance_Expiry'] . "</td>";
        echo "<td>" . $row['Current_Employer'] . "</td>";
        echo "<td>" . $row['Date_applied'] . "</td>";
        echo "<td>" . $row['Resubmission'] . "</td>";
        echo "<td>" . $row['Number_of_Attempts'] . "</td>";
        echo "<td>" . $row['Why'] . "</td>";
        echo "<td>" . $row['Qual_1'] . "</td>";
        echo "<td>" . $row['Date_Completed_1'] . "</td>";
        echo "<td>" . $row['Run_out_date_1'] . "</td>";
        echo "<td>" . $row['Qual_2'] . "</td>";
        echo "<td>" . $row['Date_Completed_2'] . "</td>";
        echo "<td>" . $row['Run_out_date_2'] . "</td>";
        echo "<td>" . $row['Qual_3'] . "</td>";
        echo "<td>" . $row['Date_Completed_3'] . "</td>";
        echo "<td>" . $row['Run_out_date_3'] . "</td>";
        echo "<td>" . $row['Qual_4'] . "</td>";
        echo "<td>" . $row['Date_Completed_4'] . "</td>";
        echo "<td>" . $row['Run_out_date_4'] . "</td>";
        echo "<td>" . $row['Qual_5'] . "</td>";
        echo "<td>" . $row['Date_Completed_5'] . "</td>";
        echo "<td>" . $row['Run_out_date_5'] . "</td>";
        echo "<td>" . $row['Qual_6'] . "</td>";
        echo "<td>" . $row['Date_Completed_6'] . "</td>";
        echo "<td>" . $row['Run_out_date_6'] . "</td>";
        echo "<td>" . $row['Qual_7'] . "</td>";
        echo "<td>" . $row['Date_Completed_7'] . "</td>";
        echo "<td>" . $row['Run_out_date_7'] . "</td>";
        echo "<td>" . $row['Qual_8'] . "</td>";
        echo "<td>" . $row['Date_Completed_8'] . "</td>";
        echo "<td>" . $row['Run_out_date_8'] . "</td>";
        echo "<td>" . $row['Qual_9'] . "</td>";
        echo "<td>" . $row['Date_Completed_9'] . "</td>";
        echo "<td>" . $row['Run_out_date_9'] . "</td>";
        echo "<td>" . $row['Qual_10'] . "</td>";
        echo "<td>" . $row['Date_Completed_10'] . "</td>";
        echo "<td>" . $row['Run_out_date_10'] . "</td>";
      echo "</tr>";
      }
    echo "</table>";
      } else {
          echo "0 results";
      }
      }
    $dbhandle->close(); 
    ?>

    Notice: Undefined variable: searchq in C:\wamp\www\search2.php on line 17

    in PHP Coding Help

    Posted

    I have done that and I am now getting no errors but no posts, the code now looks like this 

     

     

    <title>Applicant Data view</title>
     
     <p>  <center><img  src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center>
            <table border="1">
              <tr>
                <td><a href="index.php"> Home Page </a></td>
                <td><a href="administratorhomepage.html">Administrator Home Page </a></td>
                <td><a href="viewhomepage.html">View Home Page </a></td>
            </table>
        </p>
     
    <?php
     
      $searchq =($_GET['search']);
      
      
     
    include "connection.php";
     
     
    $sql = ("SELECT * FROM applicant WHERE `Firstname` LIKE $searchq OR `Lastname` LIKE $searchq")  or die("Could Not Search");
    $result = $dbhandle->query($sql);
     echo "<table border='1'>
      <tr>
        <th>Applicant Id</th>
        <th>Firstame</th>
        <th>Lastname</th>
        <th>Address</th>
        <th>Date Of Birth</th>
        <th>Contact Number</th>
        <th>Next Of Kin</th>
        <th>Next Of Kin Address</th>
        <th>Vetting Date</th>
        <th>Clearance Expiry</th>
        <th>Current Employer</th>
        <th>Date Applied</th>
        <th>Resubmitting</th>
        <th>Number Of Previous Attempts</th>
        <th>Why</th>
        <th>Qualificaton 1</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 2</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 3</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 4</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 5</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 6</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 7</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 8</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 9</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
        <th>Qualificaton 10</th>
        <th>Date Completed</th>
        <th>Expiry Date</th>
      </tr>";
      
    if(isset ($_GET["submit"])) {
      $searchq = $_GET[`submit`];
      $searchq = preg_replace("#[^a-z]#i","",$searchq); 
     
    if ($result->num_rows > 0) {
        // output data of each row
        while($row = mysqli_fetch_array($result))
      {
           echo "<tr>";
      echo "<td>" . $row['Applicant_ID'] . "</td>";
      echo "<td>" . $row['Firstname'] . "</td>";
      echo "<td>" . $row['Lastname'] . "</td>";
      echo "<td>" . $row['Address'] . "</td>";
      echo "<td>" . $row['DOB'] . "</td>";
      echo "<td>" . $row['Telephone_No'] . "</td>";
      echo "<td>" . $row['NOK'] . "</td>";
      echo "<td>" . $row['NOK_Address'] . "</td>";
      echo "<td>" . $row['Vetting_Date'] . "</td>";
      echo "<td>" . $row['Clearance_Expiry'] . "</td>";
      echo "<td>" . $row['Current_Employer'] . "</td>";
      echo "<td>" . $row['Date_applied'] . "</td>";
      echo "<td>" . $row['Resubmission'] . "</td>";
      echo "<td>" . $row['Number_of_Attempts'] . "</td>";
      echo "<td>" . $row['Why'] . "</td>";
      echo "<td>" . $row['Qual_1'] . "</td>";
      echo "<td>" . $row['Date_Completed_1'] . "</td>";
      echo "<td>" . $row['Run_out_date_1'] . "</td>";
      echo "<td>" . $row['Qual_2'] . "</td>";
      echo "<td>" . $row['Date_Completed_2'] . "</td>";
      echo "<td>" . $row['Run_out_date_2'] . "</td>";
      echo "<td>" . $row['Qual_3'] . "</td>";
      echo "<td>" . $row['Date_Completed_3'] . "</td>";
      echo "<td>" . $row['Run_out_date_3'] . "</td>";
      echo "<td>" . $row['Qual_4'] . "</td>";
      echo "<td>" . $row['Date_Completed_4'] . "</td>";
      echo "<td>" . $row['Run_out_date_4'] . "</td>";
      echo "<td>" . $row['Qual_5'] . "</td>";
      echo "<td>" . $row['Date_Completed_5'] . "</td>";
      echo "<td>" . $row['Run_out_date_5'] . "</td>";
      echo "<td>" . $row['Qual_6'] . "</td>";
      echo "<td>" . $row['Date_Completed_6'] . "</td>";
      echo "<td>" . $row['Run_out_date_6'] . "</td>";
      echo "<td>" . $row['Qual_7'] . "</td>";
      echo "<td>" . $row['Date_Completed_7'] . "</td>";
      echo "<td>" . $row['Run_out_date_7'] . "</td>";
      echo "<td>" . $row['Qual_8'] . "</td>";
      echo "<td>" . $row['Date_Completed_8'] . "</td>";
      echo "<td>" . $row['Run_out_date_8'] . "</td>";
      echo "<td>" . $row['Qual_9'] . "</td>";
      echo "<td>" . $row['Date_Completed_9'] . "</td>";
      echo "<td>" . $row['Run_out_date_9'] . "</td>";
      echo "<td>" . $row['Qual_10'] . "</td>";
      echo "<td>" . $row['Date_Completed_10'] . "</td>";
      echo "<td>" . $row['Run_out_date_10'] . "</td>";
      echo "</tr>";
      }
    echo "</table>";
      } else {
          echo "0 results";
      }
      }
    $dbhandle->close(); 
    ?>

    Notice: Undefined variable: searchq in C:\wamp\www\search2.php on line 17

    in PHP Coding Help

    Posted

    I am new to php and html, I am trying to make a search function where you can search by a persons firstname or lastname but I am getting an error. the error is Notice: Undefined variable: searchq in C:\wamp\www\search2.php on line 17. Can anyone help me please

     

     

     

     

    <title>Applicant Data view</title>

     

     <p>  <center><img  src="cyberwarfareimage1.png" alt="Squadron logo" style="width:200px;height:200px" style="middle"></center>

            <table border="1">

              <tr>

                <td><a href="index.php"> Home Page </a></td>

                <td><a href="administratorhomepage.html">Administrator Home Page </a></td>

                <td><a href="viewhomepage.html">View Home Page </a></td>

            </table>

        </p>

     

    <?php

     

    include "connection.php";

     

     

    $sql = ("SELECT * FROM applicant WHERE `Firstname` LIKE $searchq OR `Lastname` LIKE $searchq")  or die("Could Not Search");

    $result = $dbhandle->query($sql);

     echo "<table border='1'>

      <tr>

        <th>Applicant Id</th>

        <th>Firstame</th>

        <th>Lastname</th>

        <th>Address</th>

        <th>Date Of Birth</th>

        <th>Contact Number</th>

        <th>Next Of Kin</th>

        <th>Next Of Kin Address</th>

        <th>Vetting Date</th>

        <th>Clearance Expiry</th>

        <th>Current Employer</th>

        <th>Date Applied</th>

        <th>Resubmitting</th>

        <th>Number Of Previous Attempts</th>

        <th>Why</th>

        <th>Qualificaton 1</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

        <th>Qualificaton 2</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

        <th>Qualificaton 3</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

        <th>Qualificaton 4</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

        <th>Qualificaton 5</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

        <th>Qualificaton 6</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

        <th>Qualificaton 7</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

        <th>Qualificaton 8</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

        <th>Qualificaton 9</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

        <th>Qualificaton 10</th>

        <th>Date Completed</th>

        <th>Expiry Date</th>

      </tr>";

      

    if(isset ($_POST["submit"])) {

      $searchq = $_POST[`submit`];

      $searchq = preg_replace("#[^a-z]#i","",$searchq);

     

     

     

      

     

    if ($result->num_rows > 0) {

        // output data of each row

        while($row = mysqli_fetch_array($result))

      {

           echo "<tr>";

      echo "<td>" . $row['Applicant_ID'] . "</td>";

      echo "<td>" . $row['Firstname'] . "</td>";

      echo "<td>" . $row['Lastname'] . "</td>";

      echo "<td>" . $row['Address'] . "</td>";

      echo "<td>" . $row['DOB'] . "</td>";

      echo "<td>" . $row['Telephone_No'] . "</td>";

      echo "<td>" . $row['NOK'] . "</td>";

      echo "<td>" . $row['NOK_Address'] . "</td>";

      echo "<td>" . $row['Vetting_Date'] . "</td>";

      echo "<td>" . $row['Clearance_Expiry'] . "</td>";

      echo "<td>" . $row['Current_Employer'] . "</td>";

      echo "<td>" . $row['Date_applied'] . "</td>";

      echo "<td>" . $row['Resubmission'] . "</td>";

      echo "<td>" . $row['Number_of_Attempts'] . "</td>";

      echo "<td>" . $row['Why'] . "</td>";

      echo "<td>" . $row['Qual_1'] . "</td>";

      echo "<td>" . $row['Date_Completed_1'] . "</td>";

      echo "<td>" . $row['Run_out_date_1'] . "</td>";

      echo "<td>" . $row['Qual_2'] . "</td>";

      echo "<td>" . $row['Date_Completed_2'] . "</td>";

      echo "<td>" . $row['Run_out_date_2'] . "</td>";

      echo "<td>" . $row['Qual_3'] . "</td>";

      echo "<td>" . $row['Date_Completed_3'] . "</td>";

      echo "<td>" . $row['Run_out_date_3'] . "</td>";

      echo "<td>" . $row['Qual_4'] . "</td>";

      echo "<td>" . $row['Date_Completed_4'] . "</td>";

      echo "<td>" . $row['Run_out_date_4'] . "</td>";

      echo "<td>" . $row['Qual_5'] . "</td>";

      echo "<td>" . $row['Date_Completed_5'] . "</td>";

      echo "<td>" . $row['Run_out_date_5'] . "</td>";

      echo "<td>" . $row['Qual_6'] . "</td>";

      echo "<td>" . $row['Date_Completed_6'] . "</td>";

      echo "<td>" . $row['Run_out_date_6'] . "</td>";

      echo "<td>" . $row['Qual_7'] . "</td>";

      echo "<td>" . $row['Date_Completed_7'] . "</td>";

      echo "<td>" . $row['Run_out_date_7'] . "</td>";

      echo "<td>" . $row['Qual_8'] . "</td>";

      echo "<td>" . $row['Date_Completed_8'] . "</td>";

      echo "<td>" . $row['Run_out_date_8'] . "</td>";

      echo "<td>" . $row['Qual_9'] . "</td>";

      echo "<td>" . $row['Date_Completed_9'] . "</td>";

      echo "<td>" . $row['Run_out_date_9'] . "</td>";

      echo "<td>" . $row['Qual_10'] . "</td>";

      echo "<td>" . $row['Date_Completed_10'] . "</td>";

      echo "<td>" . $row['Run_out_date_10'] . "</td>";

      echo "</tr>";

      }

    echo "</table>";

      } else {

          echo "0 results";

      }

      }

    $dbhandle->close(); 

    ?>

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.