ajax table
[dcaas.git] / table.php
blob:a/table.php -> blob:b/table.php
<?php <?php
include ("config.php"); include("config.php");
include ("lib/tag-cloud/src/lotsofcode/TagCloud/TagCloud.php"); include("lib/tag-cloud/src/lotsofcode/TagCloud/TagCloud.php");
   
includeHeader("title"); includeHeader("title");
?> ?>
   
<div class="starter-template"> <div class="starter-template">
<br/> <br/>
<br/> <br/>
   
<h1>Bootstrap starter template</h1> <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 <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> mostly barebones HTML document.</p>
   
<div id="search-example-year-filter" style="float: left;"> <!--<div id="search-example-year-filter" style="float: left;">
Year: Year:
<select id="search-year" name="year"> <select id="search-year" name="year">
<option></option> <option></option>
<option>2001</option> <option>2001</option>
<option>2003</option> <option>2003</option>
<option>2008</option> <option>2008</option>
<option>2013</option> <option>2013</option>
</select> </select>
</div> </div>
   
<div id="search-function-example-price-filter" style="float: left; margin-bottom: 1em;"> <div id="search-function-example-price-filter" style="float: left; margin-bottom: 1em;">
Max Price: Max Price:
$<input id="max-price" type="number" step="1000" data-dynatable-query="max-price"> $<input id="max-price" type="number" step="1000" data-dynatable-query="max-price">
</div> </div>-->
   
   
<table id="my-table"> <table id="my-table">
<thead> <thead><th>acnabn</th><th>service_name</th></thead>
<?php </table>
$row = 0; </div>
$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 <!-- Bootstrap core JavaScript
================================================== --> ================================================== -->
<!-- Placed at the end of the document so the pages load faster --> <!-- 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="https://code.jquery.com/jquery-1.10.2.min.js"></script>
<script src="js/bootstrap.min.js"></script> <script src="js/bootstrap.min.js"></script>
<script src="js/dynatable/jquery.dynatable.js"></script> <script src="js/dynatable/jquery.dynatable.js"></script>
<script> <script>
$('#my-table').dynatable(); $('#my-table').dynatable({
  dataset: {
  ajax: true,
  ajaxUrl: 'data.json.php',
  ajaxOnLoad: true,
  records: []
  }
  });
   
$('#search-example').dynatable({ /* $('#search-example').dynatable({
features: { features: {
paginate: false, paginate: false,
recordCount: false, recordCount: false,
sorting: false sorting: false
}, },
inputs: { inputs: {
queries: $('#search-year') queries: $('#search-year')
} }
}); });
   
$('#search-function-example') $('#search-function-example')
.bind('dynatable:init', function (e, dynatable) { .bind('dynatable:init', function (e, dynatable) {
dynatable.queries.functions['max-price'] = function (record, queryValue) { dynatable.queries.functions['max-price'] = function (record, queryValue) {
return parseFloat(record.price.replace(/,/, '')) <= parseFloat(queryValue); return parseFloat(record.price.replace(/,/, '')) <= parseFloat(queryValue);
}; };
}) })
.dynatable({ .dynatable({
features: { features: {
paginate: false, paginate: false,
recordCount: false, recordCount: false,
sorting: false, sorting: false,
search: false search: false
}, },
inputs: { inputs: {
queries: $('#max-price') queries: $('#max-price')
} }
}); }); */
   
</script> </script>
   
<?php <?php
includeFooter(); includeFooter();
?> ?>