| <?php | |
| /* MySQL connection */ | |
| include( $_SERVER['DOCUMENT_ROOT']."/datatables/mysql.php" ); /* ;-) */ | |
| $gaSql['link'] = mysql_pconnect( $gaSql['server'], $gaSql['user'], $gaSql['password'] ) or | |
| die( 'Could not open connection to server' ); | |
| mysql_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" language="javascript" src="../../js/jquery.js"></script> | |
| <script type="text/javascript" language="javascript" src="../../js/jquery.dataTables.js"></script> | |
| <script type="text/javascript" charset="utf-8"> | |
| $(document).ready(function() { | |
| var iStart = new Date().getTime(); | |
| if ( typeof console != 'undefined' ) { | |
| console.profile(); | |
| } | |
| for ( var i=0 ; i<1 ; i++ ) | |
| { | |
| var oTable = $('#example').dataTable({"bDestroy": true}); | |
| } | |
| if ( typeof console != 'undefined' ) { | |
| console.profileEnd(); | |
| } | |
| 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 = mysql_query( $sQuery, $gaSql['link'] ) or die(mysql_error()); | |
| while ( $aRow = mysql_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 © Allan Jardine 2008-2009. | |
| </span> | |
| </div> | |
| </div> | |
| </body> | |
| </html> |