How to use my code to load CSV file without Load Data button?

Question

I am trying to use this code to display a CSV file in my datatable, but I can not display without Load data button. I am trying to delete the click (function), but did not work. Thanks for your help! This is my code:

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
 <div class="container">
   <div class="table-responsive">
    <div align="center">
     <button type="button" name="load_data" id="load_data" class="btn btn-info">Load Data</button>
    </div>
    <br />
    <div id="employee_table">
    </div>


<script>
$(document).ready(function(){
 $('#load_data').click(function(){
  $.ajax({
   url:"http://gyogyszerek.cew.hu/datatable/employee.csv",
   dataType:"text",
   success:function(data)
   {
    var employee_data = data.split(/\r?\n|\r/);
    var table_data = '<table class="table table-bordered table-striped">';
    for(var count = 0; count<employee_data.length; count++)
    {
     var cell_data = employee_data[count].split(",");
     table_data += '<tr>';
     for(var cell_count=0; cell_count<cell_data.length; cell_count++)
     {
      if(count === 0)
      {
       table_data += '<th>'+cell_data[cell_count]+'</th>';
      }
      else
      {
       table_data += '<td>'+cell_data[cell_count]+'</td>';
      }
     }
     table_data += '</tr>';
    }
    table_data += '</table>';
    $('#employee_table').html(table_data);
   }
  });
 });
 
});
</script>

Possible duplicate of [How to read data From \*.CSV file using javascript?](https://stackoverflow.com/questions/7431268/how-to-read-data-from-csv-file-using-javascript) — zod, Apr 24 '19 at 19:38

score 0 · Answer 1 · answered Apr 24 '19 at 19:52

0

Deleting

 $('#load_data').click(function(){

should suffice.

Problem is you trying to load an http resource over an https location, an action that will be blocked by most modern browsers for security reasons.

answered Apr 24 '19 at 19:52

Lefteris Fotopoulos

46
4

How to use my code to load CSV file without Load Data button?

1 Answers1