= $min_length){ // if query length is more or equal minimum length then
$query = htmlspecialchars($query);
// changes characters used in html to their equivalents, for example: < to >
$query = mysqli_real_escape_string($con,$query);
// makes sure nobody uses SQL injection
$raw_results = mysqli_query($con,"SELECT * FROM tb_reg, tb_login where tb_login.loginid= tb_reg.Lid and tb_login.username='$query'" );
if(mysqli_num_rows($raw_results) > 0){ // if one or more rows are returned do following
while($results = mysqli_fetch_array($raw_results)){
// $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop
$swid="".$results['Lid']."";
//echo "$cid";
$fname=$results['Name'];
$photo=$results['Photo'];
}
}
else{ // if there is no matching rows do following
echo "No results";
echo "";
// echo "";
}
}
else{ // if query length is less than minimum
echo "Minimum length is ".$min_length;
echo "";
echo "";
}
?>
Snehalayam
