autoComplete() 만들어보기.

function ajaxAutoComplete(column, word){

$.ajax({

url:'ajaxAutoComplete.php',

type:'post',

data:{'column':column, 'word':word},

success:function(response_txt){

var data = JSON.parse(response_txt)

$( "#"+column ).autocomplete({

source: data,

focus:function(e,ui){return false;}

});

}

});

}

 

 

 

 

<?

/* db 연결 파일 */

include($_SERVER[DOCUMENT_ROOT].'/gnuboard4/dbconfig.php');

@extract($_POST);

 

if( $column != 'mb_name' ){

$sql = "select distinct($column) from excel_goodsPic where $column like '%$word%' order by $column asc limit 0, 15";

}else{

$sql = "select distinct($column) from g4_member where $column like '%$word%' order by $column asc limit 0, 15";

}

$result = $dbConn->query($sql);

$word_arr = array();

while($row = mysqli_fetch_array($result)){

$word_arr[] = $row[$column];

}

 

echo json_encode($word_arr);

?>

 

 

사용법 : <input type='text' onkeyup="ajaxAutoComplete('컬럼', '문자열')" />