php Datatables error

quinnd6 · 07-02-2015 7:11pm #1

I'm following a php and crud tutorial from youtube using php and mysql and I'm trying to use datatables to do the search and pagination stuff.
I have a ton of code so not sure what bits might be useful in finding what the problem is.
The error that keeps popping up is
Datatables warning (table id = 'datatables_table_0') requested unknown parameter '0' for row 0.

I need to get rid of this error.
Please can anybody help?

index.php

?php include_once( 'views/header.php' );
    include_once('libs/getData.php');
?>
<script type ="text/javascript" src="js/jquery.js"></script>
<script type ="text/javascript" src="js/datatables.js"></script>
<script type ="text/javascript">
    $(function(){
        $('table.table').DataTable();
    })
        
        
</script> 
 
	<h2 class="left"> Records From Some Table </h2>
	<span class="right"><a href="create_new.php" class="btn btn-success">Insert New Value</a></span>
	<div class="clear"></div>

	<div class="mainDiv">
		<table class="table table-striped table-bordered table-condensed">
			<thead>
				<tr>
					<?php 
                                        if($data !==0) 
                                        {
                                            foreach($fields_name as $f)
                                            {
                                                echo '<th>'.$f.'</th>';
                                            }
                                            echo '<th>Actions</th>';
                                        }
                                        ?>
				</tr>
			</thead>
			<tbody>
					<tr>
						<?php
                                                if($data !== 0)
                                                {
                                                    foreach($data as $key => $value)
                                                    {
                                                        echo '<tr>';
                                                        foreach($fields_name as $f)
                                                        {
                                                            echo '<td>'.$value[$f].'</td>';
                                                        }
                                                        echo '<td><a href="edit.php?id='.$value['id'].'"><i class="icon-edit"></i></a> <a href="delete.php?id='.$value['id'].'"><i class="icon-trash"></i></a></td>
                                                        </tr>';
                                                    }
                                                }
                                                ?>
						
					</tr>
			</tbody>
		</table>
	</div><!-- end mainDiv -->
 </div><!-- end container -->
 </body>
</html>

header.php

<?php include_once('libs/listTables.php'); 
    
?>
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css" />
	<link rel="stylesheet" href="css/style.css" type="text/css" />
	<script type="text/javascript" src="js/jquery.js"></script>
</head>
<body>	
	<div class="navbar">
	  <div class="navbar-inner">
		<div class="container">
			<a class="brand" href="index.php">
				Database Manager
			</a>
		</div>
	  </div>
	</div><!-- end navbar -->
        <div class="container">
            <div class="table_switcher">
                    <form class="well form-inline" method="post" action="switch_tables.php?referrer=<?php echo $_SERVER['REQUEST_URI']; ?>">
                            <label for="Table Name">Table Name</label>
                            <select name="table_name">
                                   <?php
                                    echo '<option value="'.$session_table_name.'" selected="selected">'.$session_table_name.'</option>';
                                    foreach($tables_left as $key => $value)
                                    {
                                        echo '<option value="'.$value.'">'.$value.'</option>';
                                    }
                                   ?>
                            </select>
                            <input type="submit" name="switch_table" value="Switch Table" class="btn btn-primary"/>
                    </form>
            </div><!-- end table_switcher -->
           
            <?php
                
                if(!isset($_SESSION['SESSION_TABLE_NAME']))
                {
                    echo '<div class="alert alert-error"><p>Select a table to get started </p></div>';   ;
                    die;
                }
            ?>

Buford T Justice · 08-02-2015 11:32am

Without seeing the datastructure you have being served to the tables, i'd say its most likely that the amount of columns you have configured in the table doesn't match the number of columns in the html header.

Also, check and see if the default sort order column is sortable. if its not, then this can happen.

php Datatables error

Comments