YUI Library Home

YUI Library Examples: DataTable Control: Datatable with Autocomplete

DataTable Control: Datatable with Autocomplete

This example uses two AutoComplete Controls to populate a DataTable with data received via XHR from the Yahoo! Local webservice.

View example in new window.

Phone
City
Data error.

Sample Code for this Example

Data:

1{"ResultSet":{ 
2    "totalResultsAvailable":665, 
3    "totalResultsReturned":10, 
4    "firstResultPosition":1, 
5    "ResultSetMapUrl":"http:\/\/local.yahoo.com\/mapview?stx=pizza&csz=Sunnyvale%2C+CA+94089&city=Sunnyvale&state=CA&radius=15&ed=9brhZa131DwigChqKlCo22kM1H_9WgoouCr87Ao-", 
6    "Result":[{ 
7        "Title":"Pizza Depot", 
8        "Address":"919 E Duane Ave", 
9        "City":"Sunnyvale", 
10        "State":"CA", 
11        "Phone":"(408) 245-7760", 
12        "Latitude":"37.388537", 
13        "Longitude":"-122.003972", 
14        "Rating":{ 
15            "AverageRating":"3.5", 
16            "TotalRatings":"5", 
17            "TotalReviews":"5", 
18            "LastReviewDate":"1161495667"}, 
19        "Distance":"0.93", 
20        "Url":"http:\/\/local.yahoo.com\/details?id=21332021&stx=pizza&csz=Sunnyvale+CA&ed=6tiAL6160Sx1XVIEu1zIWPu6fD8rJDV4.offJLNUTb1Ri2Q.R5oLTYvDCz8YmzivI7Bz0gfrpw--", 
21        "ClickUrl":"http:\/\/local.yahoo.com\/details?id=21332021&stx=pizza&csz=Sunnyvale+CA&ed=6tiAL6160Sx1XVIEu1zIWPu6fD8rJDV4.offJLNUTb1Ri2Q.R5oLTYvDCz8YmzivI7Bz0gfrpw--", 
22        "MapUrl":"http:\/\/maps.yahoo.com\/maps_result?name=Pizza+Depot&desc=4082457760&csz=Sunnyvale+CA&qty=9&cs=9&ed=6tiAL6160Sx1XVIEu1zIWPu6fD8rJDV4.offJLNUTb1Ri2Q.R5oLTYvDCz8YmzivI7Bz0gfrpw--&gid1=21332021", 
23        "BusinessUrl":"http:\/\/pizza-depot.com\/", 
24        "BusinessClickUrl":"http:\/\/pizza-depot.com\/"}, 
25 
26        ... 
27    ]} 
28} 
view plain | print | ?

CSS:

1#autocomplete, #autocomplete_zip { 
2    height: 25px; 
3} 
4#dt_input, #dt_input_zip { 
5    position: static; 
6    width: 300px; 
7} 
8#dt_input_zip { 
9    width: 60px; 
10} 
11/* This hides the autocomplete drop downs */ 
12#dt_ac_container, #dt_ac_zip_container { 
13    display: none; 
14} 
view plain | print | ?

Markup:

1<div id="autocomplete"> 
2    <label for="dt_input">Search Term: </label><input id="dt_input" type="text" value="pizza"> 
3    <div id="dt_ac_container"></div> 
4</div> 
5<div id="autocomplete_zip"> 
6    <label for="dt_input_zip">Zip Code: </label><input id="dt_input_zip" type="text" value="94089"> 
7    <div id="dt_ac_zip_container"></div> 
8</div> 
9<div id="json"></div> 
view plain | print | ?

JavaScript:

1(function() { 
2    var Dom = YAHOO.util.Dom, 
3    Event = YAHOO.util.Event, 
4    queryString = '&results=20&output=json', 
5    zip = null, 
6    myDataSource = null, 
7    myDataTable = null; 
8 
9    var getZip = function(query) { 
10        query = parseInt(query, 10); 
11        if (!YAHOO.lang.isNumber(query)) { 
12            query = zip; 
13            Dom.get('dt_input_zip').value = zip; 
14            YAHOO.log('Invalid zip code, must be a number', 'warn', 'example'); 
15        } 
16        myDataSource.sendRequest('datatable=yes&zip=' + query + '&query=' + Dom.get('dt_input').value + queryString, 
17            myDataTable.onDataReturnInitializeTable, myDataTable);         
18    }; 
19    var getTerms = function(query) { 
20        myDataSource.sendRequest('datatable=yes&query=' + query + '&zip=' + Dom.get('dt_input_zip').value + queryString, 
21        myDataTable.onDataReturnInitializeTable, myDataTable); 
22    }; 
23 
24    Event.onDOMReady(function() { 
25        zip = Dom.get('dt_input_zip').value; 
26         
27        var oACDS = new YAHOO.util.FunctionDataSource(getTerms); 
28        oACDS.queryMatchContains = true; 
29        var oAutoComp = new YAHOO.widget.AutoComplete("dt_input","dt_ac_container", oACDS); 
30         
31 
32        var oACDSZip = new YAHOO.util.FunctionDataSource(getZip); 
33        oACDSZip.queryMatchContains = true; 
34        var oAutoCompZip = new YAHOO.widget.AutoComplete("dt_input_zip","dt_ac_zip_container", oACDSZip); 
35        //Don't query until we have 5 numbers for the zip code 
36        oAutoCompZip.minQueryLength = 5; 
37 
38        var formatUrl = function(elCell, oRecord, oColumn, sData) { 
39            elCell.innerHTML = "<a href='" + oRecord.getData("ClickUrl") + "' target='_blank'>" + sData + "</a>"; 
40        }; 
41 
42        var myColumnDefs = [ 
43            { key:"Title", 
44                label:"Name", 
45                sortable:true, 
46                formatter: formatUrl 
47            }, 
48            { key:"Phone" }, 
49            { key:"City" }, 
50            { key:"Rating.AverageRating", 
51                label:"Rating", 
52                formatter:YAHOO.widget.DataTable.formatNumber,  
53                sortable:true 
54            } 
55        ]; 
56 
57        myDataSource = new YAHOO.util.DataSource("assets/php/ylocal_proxy.php?"); 
58        myDataSource.responseType = YAHOO.util.DataSource.TYPE_JSON; 
59        myDataSource.connXhrMode = "queueRequests"; 
60        myDataSource.responseSchema = { 
61            resultsList: "ResultSet.Result", 
62            fields: [ 
63                "Title", 
64                "Phone", 
65                "City", 
66                { 
67                    key: "Rating.AverageRating", 
68                    parser:"number" 
69                }, 
70                "ClickUrl" 
71            ] 
72        }; 
73 
74        myDataTable = new YAHOO.widget.DataTable("json", myColumnDefs, 
75            myDataSource, {initialRequest: 'datatable=yes&query=' + Dom.get('dt_input').value + '&zip=' + Dom.get('dt_input_zip').value + queryString }); 
76 
77    }); 
78})(); 
view plain | print | ?

Configuration for This Example

You can load the necessary JavaScript and CSS for this example from Yahoo's servers. Click here to load the YUI Dependency Configurator with all of this example's dependencies preconfigured.

YUI Logger Output:

Logger Console

INFO 5703ms (+0) 1:23:58 PM:
DataTable  instance yui-dt0
DataTable showing message: Data error.
ERRO 5703ms (+0) 1:23:58 PM:
DataSource  instance2
Null data
ERRO 5703ms (+1) 1:23:58 PM:
DataSource  instance2
JSON data could not be parsed: <?php

/* yadl_spaceid - Skip Stamping */

// Yahoo! proxy

// Hard-code hostname and path:
define ('PATH', 'http://local.yahooapis.com/LocalSearchService/V2/localSearch');

$type = "text/xml";

// Get all query params
$query = "?";
foreach ($_GET as $key => $value) {
    if(($key == "output") && ($value == "json")) {
        $type = "application/json";
    }
    $query .= urlencode($key)."=".urlencode($value)."&";
}

foreach ($_POST as $key => $value) {
    if(($key == "output") && ($value == "json")) {
        $type = "application/json";
    }
    $query .= $key."=".$value."&";
}
$query .= "appid=YahooDemo";
$url = PATH.$query;


// Open the Curl session
$session = curl_init($url);

// Don't return HTTP headers. Do return the contents of the call
curl_setopt($session, CURLOPT_HEADER, false);
curl_setopt($session, CURLOPT_RETURNTRANSFER, true);

// Make the call
$response = curl_exec($session);

header("Content-Type: ".$type);
echo $response;
curl_close($session);

?>

INFO 5702ms (+451) 1:23:58 PM:
DataSource  instance2
Received live data response for "datatable=yes&query=pizza&zip=94089&results=20&output=json"
INFO 5251ms (+1) 1:23:58 PM:
DataSource  instance2
Making connection to live data for "datatable=yes&query=pizza&zip=94089&results=20&output=json"
INFO 5250ms (+0) 1:23:58 PM:
DataTable  instance yui-dt0
DataTable showing message: Loading...
WARN 5250ms (+0) 1:23:58 PM:
DataTable  instance yui-dt0
Could not find DragDrop for resizeable Columns
INFO 5250ms (+3) 1:23:58 PM:
DataTable  instance yui-dt0
TH cells for 4 keys created
INFO 5247ms (+0) 1:23:58 PM:
RecordSet  instance yui-rs0
RecordSet initialized
INFO 5247ms (+2) 1:23:58 PM:
ColumnSet  instance yui-cs0
ColumnSet initialized
INFO 5245ms (+0) 1:23:58 PM:
DataSource  instance2
DataSource initialized
INFO 5245ms (+0) 1:23:58 PM:
AutoComplete  instance1 dt_input_zip
AutoComplete initialized
INFO 5245ms (+1) 1:23:58 PM:
DataSource  instance1
DataSource initialized
INFO 5244ms (+1) 1:23:58 PM:
AutoComplete  instance0 dt_input
AutoComplete initialized
INFO 5243ms (+27) 1:23:58 PM:
DataSource  instance0
DataSource initialized
INFO 5216ms (+5216) 1:23:58 PM:
LogReader  instance0
LogReader initialized
INFO 0ms (+0) 1:23:53 PM:
global
Logger initialized

Note: You are viewing this example in debug mode with logging enabled. This can significantly slow performance.

Reload with logging
and debugging disabled.

More DataTable Control Resources:

Copyright © 2010 Yahoo! Inc. All rights reserved.

Privacy Policy - Terms of Service - Copyright Policy - Job Openings