include '../connection.php'; $query = $_POST['query']; if ($query) { echo "You searched $query"; /*$result = $dbh->prepare("select concat(firstName,' ',lastName) as name, match(details) against('$query') as relevance from testTable where match(details) against ('$query')");*/ $result = $dbh->prepare("select firstName, lastName from testTable where details like '%$query%'"); $result->execute(); } ?>
Student Practice Queries |
|
| Name | Relevance |
|---|---|
| '.$row[0].' '.$row[1].' | '. $row['relevance'].' |