Real-time display of search results not showing after moving to MS SQL using Windows driver (sqlsrv)

[potterboy82]

I got a search engine running using MySQL and PHP within a local network for months now. It has a Google-like feature that shows the results real-time as you type in the keywords. Honestly, I got the code from an online sample but I do understand how it works and made changes from time to time to the scripts since I know basic html, javascript, css and MySQL.

When the team moved to MS SQL, I had to change the scripts using the Microsoft driver (sqlsrv). However, it does not seem to work anymore. I admit, I am a new to this since I have never used MS SQL before. But I was able to validate that my connection to the server works if I execute a query and display database entries on a page. But if I execute a search using keywords, it no longer displays data compared to the MySQL version. No error messages. I highly appreciate any help you can provide. I have been on this for 3 weeks now without any success. I can't really tell if this is php coding issue or there is something wrong somewhere with how my database queries were coded.


Here's the search page script:

<?php
$serverName="servername";
$connectionInfo=array("Database"=>"mydatabase","UID"=>"myusername","PWD"=>"mypassword");
$conn=sqlsrv_connect($serverName,$connectionInfo);

if($conn){
echo "";
}else{
echo "Connection could not be established.<br />";
die( print_r(sqlsrv_errors(),true));
}

if(isset($_POST['search_query'])){
$search_query=preg_replace('#[^a-z 0-9?!]#i',' ',$_POST['search_query']);
echo "<div class=\"searchText\"><b>SEARCH</b></div><hr/>";

$search_query_x=explode(" ",$search_query);
foreach($search_query_x as $search_each){
$x++;
if($x==1)
$construct.="keywords LIKE '%$search_each%'";
else
$construct.="AND keywords LIKE '%$search_each%'";
}
$construct="SELECT * FROM search ";
$run=sqlsrv_query($conn,$construct,array(),array("Scrollable"=>SQLSRV_CURSOR_KEYSET));

$foundnum=sqlsrv_num_rows($run);

if($foundnum==0){
echo "Sorry, your search - <b>$search_query</b> - did not match any article.";
}else{
echo "$foundnum result(s) found!<p>";
while ($runrows=sqlsrv_fetch_array($run,SQLSRV_FETCH_ASSOC))
{
$title=$runrows['title'];
$description=$runrows['description'];
$url=$runrows['url'];
echo "
<div class='width: 400px;'>
<div class='title'><a href='$url' target='_blank'><b>$title</b></a></div>
<div class='description'>$description</div>
<div class='url'>$url</div>
</div>
<br />";
}
}
}else{
echo "<b>WARNING: </b>An error has occured.";
}

sqlsrv_close($conn);
?>