--- a/table.php +++ b/table.php @@ -1,1 +1,99 @@ +<?php +include ("config.php"); +include ("lib/tag-cloud/src/lotsofcode/TagCloud/TagCloud.php"); +includeHeader("title"); +?> + + <div class="starter-template"> + <br/> + <br/> + + <h1>Bootstrap starter template</h1> + + <p class="lead">Use this document as a way to quickly start any new project.<br> All you get is this text and a + mostly barebones HTML document.</p> + + <div id="search-example-year-filter" style="float: left;"> + Year: + <select id="search-year" name="year"> + <option></option> + <option>2001</option> + <option>2003</option> + <option>2008</option> + <option>2013</option> + </select> + </div> + + <div id="search-function-example-price-filter" style="float: left; margin-bottom: 1em;"> + Max Price: + $<input id="max-price" type="number" step="1000" data-dynatable-query="max-price"> + </div> + + + <table id="my-table"> + <thead> + <?php + $row = 0; + $csvfile = './data/DCaaS+Catalogue+September+2013 PublicDCaaS_AFI_Part_3_Sec_5_Service_.csv'; + if (($handle = fopen($csvfile, "r")) !== FALSE) { + while (($data = fgetcsv($handle, 4096, ",")) !== FALSE) { + if ($row == 0) { + echo "<thead><th>" . implode($data, "</th><th>") . "</th></thead> \n"; + } else { + echo "<tr><td>" . implode($data, "</td><td>") . "</td></tr> \n"; + } + $row++; + } + fclose($handle); + } + ?> + </table> + </div> + + + +<!-- Bootstrap core JavaScript +================================================== --> +<!-- Placed at the end of the document so the pages load faster --> +<script src="https://code.jquery.com/jquery-1.10.2.min.js"></script> +<script src="js/bootstrap.min.js"></script> +<script src="js/dynatable/jquery.dynatable.js"></script> +<script> + $('#my-table').dynatable(); + + $('#search-example').dynatable({ + features: { + paginate: false, + recordCount: false, + sorting: false + }, + inputs: { + queries: $('#search-year') + } + }); + + $('#search-function-example') + .bind('dynatable:init', function (e, dynatable) { + dynatable.queries.functions['max-price'] = function (record, queryValue) { + return parseFloat(record.price.replace(/,/, '')) <= parseFloat(queryValue); + }; + }) + .dynatable({ + features: { + paginate: false, + recordCount: false, + sorting: false, + search: false + }, + inputs: { + queries: $('#max-price') + } + }); + +</script> + +<?php +includeFooter(); +?> +