<?php require $KoolControlsFolder."/KoolAutoComplete/koolautocomplete.php"; require $KoolControlsFolder."/KoolAjax/koolajax.php"; $kac = new KoolAutoComplete("kac"); $kac->scriptFolder = $KoolControlsFolder."/KoolAutoComplete"; $kac->width = "160px"; $kac->attachTo = "txtTo"; $kac->styleFolder="office2007"; $kac->itemTemplate = "{html}"; $kac->boxWidth = "400px"; function service($text) { $text = str_replace("\\\"","\"",$text); $token = explode(",",$text); $last_token = $token[sizeof($token)-1]; $last_token = trim($last_token); $items = array(); $result = mysql_query("select firstName, lastName, email from employees where CONCAT(firstName,' ',lastName,' ', email) like '%$last_token%' order by email;"); while($row = mysql_fetch_assoc($result)) { $text = '"'.$row["firstName"]." ".$row["lastName"].'"'."<".$row["email"].">"; $text_array = $token; $text_array[sizeof($text_array)-1] = $text; $text = join(",",$text_array); $html = '"'.$row["firstName"]." ".$row["lastName"].'"'."[".$row["email"]."]";
<?php require $KoolControlsFolder."/KoolAutoComplete/koolautocomplete.php"; $kac = new KoolAutoComplete("kac"); $kac->scriptFolder = $KoolControlsFolder."/KoolAutoComplete"; $kac->width = "160px"; $kac->attachTo = "txtRegion"; $kac->styleFolder="office2007"; $result = mysql_query("select CountryName from kcb_tbcountries"); while($row = mysql_fetch_assoc($result)) { $kac->addItem($row["CountryName"]); } $filter_select = "startwith"; if(isset($_POST["filter_select"])) { $filter_select = $_POST["filter_select"]; } $kac->searchFilter=$filter_select; ?> <form id="form1" method="post"> <div style="float:left;width:300px;margin-bottom:30px;"> <input type="text" id="txtRegion" autocomplete='off' /> <?php echo $kac->Render();?> </div>
<?php require $KoolControlsFolder."/KoolAutoComplete/koolautocomplete.php"; $kac = new KoolAutoComplete("kac"); $kac->scriptFolder = $KoolControlsFolder."/KoolAutoComplete"; $kac->width = "160px"; $kac->attachTo = "txtRegion"; $kac->styleFolder="default"; $result = mysql_query("select CountryName,FlagImage from kcb_tbcountries"); while($row = mysql_fetch_assoc($result)) { $kac->addItem($row["CountryName"],array("image"=>$row["FlagImage"])); } $kac->itemTemplate ="<table><tr><td valign='middle' style='width:22px;height:20px;'><img src='../../../KoolComboBox/Resources/Flags/{image}' alt='{text}' title='{text}' /></td><td valign='middle'>{text}</td></tr></table>"; ?> <form id="form1" method="post"> <div style="padding-left:10px;padding-bottom:10px;"> Enter your country name: <input type="text" id="txtRegion" autocomplete='off' /> <?php echo $kac->Render();?> </div> </form>
<?php /* * This file is ready to run as standalone example. However, please do: * 1. Add tags <html><head><body> to make a complete page * 2. Change relative path in $KoolControlFolder variable to correctly point to KoolControls folder */ $KoolControlsFolder = "../../../../KoolControls"; //Relative path to "KoolPHPSuite/KoolControls" folder require $KoolControlsFolder . "/KoolAutoComplete/koolautocomplete.php"; require $KoolControlsFolder . "/KoolAjax/koolajax.php"; $kac = new KoolAutoComplete("kac"); $kac->scriptFolder = $KoolControlsFolder . "/KoolAutoComplete"; $kac->width = "160px"; $kac->attachTo = "txtTo"; $kac->styleFolder = "office2007"; $kac->itemTemplate = "{html}"; $kac->boxWidth = "400px"; function service($text) { $text = str_replace("\\\"", "\"", $text); $token = explode(",", $text); $last_token = $token[sizeof($token) - 1]; $last_token = trim($last_token); $items = array(); $result = mysql_query("select firstName, lastName, email from employees where CONCAT(firstName,' ',lastName,' ', email) like '%{$last_token}%' order by email;"); while ($row = mysql_fetch_assoc($result)) { $text = '"' . $row["firstName"] . " " . $row["lastName"] . '"' . "<" . $row["email"] . ">"; $text_array = $token; $text_array[sizeof($text_array) - 1] = $text; $text = join(",", $text_array);