ขอตัวอย่าง code autocomplete เขียนโดย php ที่ดึงข้อมูลจาก oracle แสดงหน่อยค่ะ ใน web juqery ui มีแต่ ดึง text มาแสดงอ่ะค่ะ

var tmp = "";
	        <?
		    $sqllevel 	= ' select * from  APPM_GRADUATE_LEVEL order by LEVEL_CODE asc ';  
		   $rslevel = &$db->Execute($sqllevel);
		    while ($datale= $rslevel->FetchRow()) { 
			echo "tmpp +=\"\\\"".$datale['NAME']."\\\",\"\n";
		}
	     ?>
		// alert(tmpp);
							// auto complete
							var availabletxtGraduateLevels_desc =[tmpp];
		$( "#txtGraduateLevels_desc" ).autocomplete({
			minLength: 0, 
			source: availabletxtGraduateLevels_desc, 
			open:function(){ 
				var valInput=$(this).val();
				if(valInput!=""){
					$(".ui-menu-item a").each(function(){ 
						var matcher = new RegExp("("+valInput+")", "ig" ); 
						var s=$(this).text();
						var newText=s.replace(matcher, "<b>$1</b>");	
						$(this).html(newText); 
					});	
				}
			}
		});

		$( "<button type='button'>&nbsp;</button>" )
			.attr( "tabIndex", -1 ) 
			.attr( "title", "Show All Items" )
			.addClass("myselectword")
			.insertAfter("#txtGraduateLevels_desc") 
			.button({
				icons: {
					primary: "ui-icon-triangle-1-s"
				},
				text: false
			})
			.removeClass( "ui-corner-all" )
			.addClass( "ui-corner-right ui-button-icon" )
			.click(function() { 
				if ($( "#txtGraduateLevels_desc" ).autocomplete( "widget" ).is( ":visible" ) ) {
					$( "#txtGraduateLevels_desc" ).autocomplete( "close" ); 
					return;
				}
				$( "#txtGraduateLevels_desc" ).autocomplete( "search", "" );
				$( "#txtGraduateLevels_desc" ).focus();
			});							
	});

open:function(){ 
				var valInput=$(this).val();
				if(valInput!=""){
					$(".ui-menu-item a").each(function(){ 
						var matcher = new RegExp("^("+valInput+")", "m" ); 
						var s=$(this).text();
						var newText=s.replace(matcher, "<b>$1</b>");	
						$(this).html(newText); 
					});	
				}
			}