Input Name (Submit type)

Search:

[insert_php]
echo $_POST[“fname”] . “\n”;
$fname=trim($_POST[“fname”]);
if ($fname!=””){$fname=”%”.$fname.”%”;}

require “../php/dbConnect.php”;
require “../php/submit/findSubmit”;

$sql = “SELECT * FROM tbl_online_admission_form WHERE CONCAT(name,registration) LIKE ‘$fname’ ORDER BY registration”;
$result = $conn->query($sql);

if($result->num_rows==1){
$sql = “SELECT* FROM sec_att_june WHERE rollno LIKE ‘$fname'”;
$result = $conn->query($sql);

$flag=0;
while($row = $result->fetch_assoc()) {
if($flag==0){echo “
Roll No: “.$row[“rollno”].”
Name: “.$row[“name”].”

“;$flag=1;}
echo $row[“Subject”].”: “.$row[“attlec”].”/”. $row[“totlec”].”=”.round(($row[“attlec”]/ $row[“totlec”])*100).”%”.”
“;
}

}else{
echo “
“.”$result->num_rows”.” Records found.”.”
“;
while($row = $result->fetch_assoc()) {
echo search1($row[registration]).”->”.$row[“name”].”
“;
}
}

[/insert_php]