<?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);
