1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 | <?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> |