DataTables warning: table id=data-table - Requested unknown parameter 'Practice skills' for row 0, column 5. For more information about this error, please see http://datatables.net/tn/4

Ng Jo-Yi
Ng Jo-Yi used Ask the Experts™
on
DataTables warning: table id=data-table - Requested unknown parameter 'Practice skills' for row 0, column 5. For more information about this error, please see http://datatables.net/tn/4
Upload2.html
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <title>Import CSV File into Jquery Datatables using PHP Ajax</title>
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.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.6/js/bootstrap.min.js"></script>
  <script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
  <script src="https://cdn.datatables.net/1.10.12/js/dataTables.bootstrap.min.js"></script>  
  <link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css" />
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  <style>
  .box
  {
   max-width:600px;
   width:75%;
   margin: 0 auto;;
  }
  </style>
    </head>
    <body>
	<div class="container">
   <br />
    <h3 align="center">Mark distribution Sheet</h3>
   <h3 align="center">Introduction to Mobile Application</h3>
   <br />
<form action="import2.php" method="post" enctype="multipart/form-data">
<div class="col-md-3">
     <br />
     <label>Add More Data</label>
    </div> 
	<div class="col-md-4">  
            <input type="file" name="csv_file">
			</div>  
	<div class="col-md-5">
            <input type="submit" value="Upload">
			</div>  
			<div style="scrollleft"></div>
			<div style="clear:both></div>

        </form>
	<br />
   <br />
   <div class="table-responsive" >
    <table class="table table-striped table-bordered" id="data-table">
     <thead>
      <tr>
       <th width=10%>Student ID</th>
       <th width=14%> Name</th>
	   <th width=2%> Sem</th>
	   <th> Sec</th>
	   <th width=5%>Chapter_Exam</th>
	   <th width=10%> Practice skill</th>
	   <th> Assignment</th>
	   <th> Final_Exam</th>
	   <th> Total </th>
	   <th> Grade</th>
	   <th> C01</th>
	   <th> C02</th>
	   <th >C03</th>  
       <th >C04</th>  
	   <th >C05</th>   
	   <th>Status</th>
      </tr>
     </thead>
	 <tfoot>
            <tr>
	            <th>AM1701001001</th>
	            <th>AKMAL NABIL BIN MUHAMAD ISA</th>
	            <th>4</th>
	            <th>1</th>
	            <th>82</th>
	            <th>92</th>
				<th>90</th>
				<th>67</th>
				<th>80</th>
				<th>A-</th>
				<th>83</th>
				<th>83</th>
				<th>83</th>
				<th>83</th>
				<th>92</th>
				<th>Pass</th>
            </tr>
        </tfoot>
    </table>
   </div>
  </div>
  <script>
  $(document).ready(function(){
	jsonData = [{"student_id":"AM1701001002","name":"AMIR NAQIUDDIN BIN ABDULLAH","Sem":"4","Sec":"1","Chapter_Exam":"49","Practice skill":"41","Assignment":"77","Final_Exam":"29","Total":"45","Grade":"C-","C01":"49","C02":"49","C03":"49","C04":"49","C05":"41","Status":"Pass"},{"student_id":"AM1701001003","name":"JOHAN ARIFF BIN MUHD ZAKRI","Sem":"4","Sec":"1","Chapter_Exam":"66","Practice skill":"45","Assignment":"40","Final_Exam":"25","Total":"40","Grade":"D","C01":"44","C02":"44","C03":"37","C04":"44","C05":"45","Status":"Pass"},{"student_id":"AM1701001004","name":"MOHAMAD AIRIL AZLI BIN KAMAR","Sem":"4","Sec":"1","Chapter_Exam":"60","Practice skill":"48","Assignment":"55","Final_Exam":"19","Total":"40","Grade":"D","C01":"46","C02":"46","C03":"41","C04":"46","C05":"48","Status":"Pass"},{"student_id":"AM1701001005","name":"MOHAMAD AMIRUL BIN OTHMAN","Sem":"4","Sec":"1","Chapter_Exam":"62","Practice skill":"55","Assignment":"83","Final_Exam":"39","Total":"55","Grade":"C+","C01":"60","C02":"60","C03":"59","C04":"60","C05":"55","Status":"Pass"},{"student_id":"AM1701001006","name":"MOHAMAD FIRDAUS BIN MUTALIB","Sem":"4","Sec":"1","Chapter_Exam":"50","Practice skill":"48","Assignment":"75","Final_Exam":"32","Total":"47","Grade":"C-","C01":"51","C02":"51","C03":"52","C04":"51","C05":"48","Status":"Pass"},{"student_id":"AM1701001007","name":"MOHAMAD IKHWAN BIN JOHAR","Sem":"4","Sec":"1","Chapter_Exam":"76","Practice skill":"48","Assignment":"76","Final_Exam":"57","Total":"63","Grade":"B-","C01":"64","C02":"64","C03":"60","C04":"64","C05":"48","Status":"Pass"},{"student_id":"AM1701001008","name":"MOHAMMAD AIMAN BIN ABDULLAH","Sem":"4","Sec":"1","Chapter_Exam":"58","Practice skill":"41","Assignment":"83","Final_Exam":"41","Total":"53","Grade":"C","C01":"56","C02":"56","C03":"55","C04":"56","C05":"41","Status":"Pass"},{"student_id":"AM1701001009","name":"MOHAMMAD NASYRIK BIN OTHMAN","Sem":"4","Sec":"1","Chapter_Exam":"49","Practice skill":"44","Assignment":"74","Final_Exam":"41","Total":"50","Grade":"C","C01":"52","C02":"52","C03":"53","C04":"52","C05":"44","Status":"Pass"}];
		
		$('#data-table').DataTable({
			data  :  jsonData,
			columns :  [
				{ data : "student_id" },
				{ data : "name" },
				{ data : "Sem" },
				{ data : "Sec" },
				{ data : "Chapter_Exam" },
				{ data : "Practice skills" },
				{ data : "Assignment" },
				{ data : "Final_Exam" },
				{ data : "Total" },
				{ data : "Grade" },
				{ data : "C01" },
				{ data : "C02" },
				{ data : "C03" },
				{ data : "C04" },
				{ data : "C05" },
				{ data : "Status" }
			]
		});
	});
	</script>
    </body>
</html>

Open in new window

import2.php
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);


if ( ! empty($_FILES['csv_file']['name']) ) {

    $file_data = fopen($_FILES['csv_file']['name'], 'r');
    fgetcsv($file_data);

    while($row = fgetcsv($file_data) ) {
      
        if( count($row)>15):
            //now you know you have at least 16 element
            $data[] = array(
			'student_id'  => $row[0],
            'name'  => $row[1],
            'Sem'  => $row[2],
            'Sec'  => $row[3],
			 'Chapter_Exam'  => $row[4],
			  'Practice skill'  => $row[5],
			   'Assignment'  => $row[6],
			   'Final_Exam'  => $row[7],
			   'Total'  => $row[8],
			   'Grade'  => $row[9],
			   'C01'  => $row[10],
			   'C02'  => $row[11],
			   'C03'  => $row[12],
			   'C04'  => $row[13],
			   'C05'  => $row[14],
			    'Status'  => $row[15]
				);
        endif;
		};

    echo json_encode($data);
}

Open in new window

Mobile.csv
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Eddie ShipmanAll-around developer

Commented:
Your data says this: "Practice skill"
Your grid is looking for: "Practice skills"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial