<?php
  /* mysqli connection */
	include( $_SERVER['DOCUMENT_ROOT']."/datatables/mysqli.php" ); /* ;-) */
	
	$gaSql['link'] =  mysqli_pconnect( $gaSql['server'], $gaSql['user'], $gaSql['password']  ) or
		die( 'Could not open connection to server' );
	
	mysqli_select_db( $gaSql['db'], $gaSql['link'] ) or 
		die( 'Could not select database '. $gaSql['db'] );

?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
	<head>
		<meta http-equiv="content-type" content="text/html; charset=utf-8" />
		<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico" />
		
		<title>DataTables example</title>
		<style type="text/css" title="currentStyle">
			@import "../../css/demo_page.css";
			@import "../../css/demo_table.css";
		</style>
		<script type="text/javascript" src="../../js/jquery.js"></script>
		<script type="text/javascript" src="../../js/jquery.dataTables.js"></script>
		<script type="text/javascript" charset="utf-8">
			$(document).ready(function() {
				
				//if ( typeof console != 'undefined' ) {
				//	console.profile();
				//}
				var oTable = $('#example').dataTable();
				//if ( typeof console != 'undefined' ) {
				//	console.profileEnd();
				//}
				
				var iStart = new Date().getTime();
				
				oTable.fnSort( [[ 1, 'asc' ]] );
				oTable.fnSort( [[ 1, 'asc' ]] );
				oTable.fnSort( [[ 2, 'asc' ]] );
				oTable.fnSort( [[ 1, 'asc' ]] );
				oTable.fnSort( [[ 2, 'asc' ]] );
				oTable.fnSort( [[ 1, 'asc' ]] );
				oTable.fnSort( [[ 2, 'asc' ]] );
				oTable.fnSort( [[ 1, 'asc' ]] );
				oTable.fnSort( [[ 2, 'asc' ]] );
				oTable.fnSort( [[ 1, 'asc' ]] );
				oTable.fnSort( [[ 2, 'asc' ]] );
				oTable.fnSort( [[ 1, 'asc' ]] );
				oTable.fnSort( [[ 2, 'asc' ]] );
				
				var iEnd = new Date().getTime();
				document.getElementById('output').innerHTML = "Test took "+(iEnd-iStart)+" mS";
			} );
		</script>
	</head>
	<body id="dt_example">
		<div id="container">
			<div class="full_width big">
				<i>DataTables</i> performance test - draw
			</div>
			<div id="output"></div>

			<div id="demo">
<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
	<thead>
		<tr>
			<th>id</th>
			<th>name</th>
			<th>phone</th>
			<th>email</th>
			<th>city</th>
			<th>zip</th>
			<th>state</th>
			<th>country</th>
			<th>zip2</th>
		</tr>
	</thead>
	<tbody>
<?php
	$sQuery = "
		SELECT *
		FROM   testData
		LIMIT  2000
	";
	$rResult = mysqli_query($con, $sQuery, $gaSql['link'] ) or die(mysqli_error());
	while ( $aRow = mysqli_fetch_array( $rResult ) )
	{
		echo '<tr>';
		echo '<td><a href="1">'.$aRow['id'].'</a></td>';
		echo '<td>'.$aRow['name'].'</td>';
		echo '<td>'.$aRow['phone'].'</td>';
		echo '<td>'.$aRow['email'].'</td>';
		echo '<td>'.$aRow['city'].'</td>';
		echo '<td>'.$aRow['zip'].'</td>';
		echo '<td>'.$aRow['state'].'</td>';
		echo '<td>'.$aRow['country'].'</td>';
		echo '<td>'.$aRow['zip2'].'</td>';
		echo '</tr>';
	}
?>
	</tbody>
</table>
			</div>
			<div class="spacer"></div>
			
			<div id="footer" style="text-align:center;">
				<span style="font-size:10px;">
					DataTables &copy; Allan Jardine 2008-2009.
				</span>
			</div>
		</div>
	</body>
</html>