01 Jquery AJAX

01 Jquery AJAX

        function displayData_datalist(tID,file,field,whereString) {

            t_url="<?=AWS?>/ETC/system/04_AWS/06_%E6%9F%A5%E8%A9%A2%E8%A1%A8%E6%A0%BC/04_webservice_json.php?action=select&file="+file+"&field="+field;
            console.log(t_url);
            $.ajax({
                url: '<?=$path?>/04_AWS/06_查詢表格/04_webservice_json.php?action=select&field='+field,
                data: {'url':encodeURI(t_url),'tID':tID,'file':file,'field':field,'where':whereString},
                type: 'GET',
                contentType: "application/x-www-form-urlencoded; charset=utf-8",
                dataType:'json',
                async:true,
                success : function(data) {
                    if(tID!="委託項目1_list")
                    {
                        var nameArray = data['data'];
                        var lastvalue = null;
                        $.each(nameArray, function (i, item) {
                            t1 = "#" + tID;
                            //console.log(item[field]);
                            if (lastvalue != item[field]) {
                                $(t1).append($("<option>").attr('value', item[field]).text(item[field]));
                                lastvalue = item[field];
                            }
                        });
                    }
                },
                error : function(request,error)
                { console.log("error");
                }
            });
        }

而PHP那邊


$fxls = isset($_GET['file']) ? $_GET['file'] : 'test.xls';
$fxls2 ='files/'.$fxls;
$action = isset($_GET['action']) ? $_GET['action'] : 'select';
$ext = strtolower(pathinfo($fxls2 , PATHINFO_EXTENSION));
$tID = isset($_GET['tID']) ? $_GET['tID'] : '';
$file = isset($_GET['file']) ? $_GET['file'] : '';
$field = isset($_GET['field']) ? $_GET['field'] : '';
$where = isset($_GET['where']) ? $_GET['where'] : '';

    if (is_array($arr)==true &&  count($arr) > 0) {
        echo json_encode(array(
            "success" => true,
            "id" => 1909051,
            "data" => $arr,
            "debug" => $field,
            "msg" => $msg,
            "filename" =>$fxls,
            "tID" =>$tID,
            "file" =>$file,
            "field" =>$field,
            "where" =>$where,
            //"msg" => "OK",
        ));
    } else {
        echo json_encode(array(
            "success" => false,
            "id" => 1908273,
            "debug" => "file name:" . $fxls,
            "debug" => $msg,
            "msg" => $msg,
            //"msg" => "error",
        ));
    }
javascript
01 String 字串CH04 ArrayCH05 FormCH05 時間日期Ch10 AJAX