[eluser]Ssendol[/eluser]
This is controller. (sample.php)
Code:
<?php
class Sample extends Controller {
function Sample()
{
parent::Controller();
$this->load->helper(array('form', 'url', 'date'));
}
function index($cY=NULL, $cM=NULL, $cD=NULL )
{
$DATA['AutoSearch'] = "sample/get_Names";
echo $this->load->view("_sample");
}
function get_Names()
{
$q = $this->input->post('q',TRUE);
if (!$q) return;
// form dropdown and myql get name
$members = $this->db->get('member');
// go foreach
foreach($members->result() as $MemInfo)
{
$UserName = $MemInfo->LastName.", ".$MemInfo->FirstName;
$items[$UserName] = $MemInfo->LastName."|".$MemInfo->FirstName;
}
foreach ($items as $key=>$value) {
if (strpos(strtolower($key), $q) !== false) {
echo "$key|$value\n";
}
}
}
}
?>
This is view. (_sample.php)
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html >
<.script src="<?=base_url()?>js/jquery.js" type="text/javascript">[removed]
<.script src="<?=base_url()?>js/jquery.bgiframe.min.js" type="text/javascript">[removed]
<.script src="<?=base_url()?>js/jquery.ajaxQueue.js" type="text/javascript">[removed]
<.script src="<?=base_url()?>js/jquery.autocomplete.js" type="text/javascript">[removed]
<.script src="<?=base_url()?>js/thickbox-compressed.js" type="text/javascript">[removed]
<.script src="<?=base_url()?>js/pstrength.js" type="text/javascript">[removed]
<.script src="<?=base_url()?>js/localdata.js" type='text/javascript'>[removed]
<.link rel="stylesheet" type="text/css" href="<?=base_url()?>js/main.css" />
<.link rel="stylesheet" type="text/css" href="<?=base_url()?>js/jquery.autocomplete.css" />
<.link rel="stylesheet" type="text/css" href="<?=base_url()?>js/thickbox.css" />
<.script type="text/javascript">
$().ready(function() {
$("#last").autocomplete("sample/get_Names", {
width: 200,
selectFirst: false
});
});
<./script>
<HTML>
<BODY>
<input type="text" id="last" autocomplete="off"></div>
</BODY>
</HTML>
When I use as follow works OK.
127.0.0.1/test/index.php/sample
But, I add URI segment as follow dows not work.
127.0.0.1/test/index.php/sample/123/abc/123
Drowpdown shows View file (_sample.php) instead DB contents.
Please help me to solve this problem.
Thank you.
PS. I add period(.) like <.script to prevent the code removed.