webapp/resources/datatables-1.9.4/media/unit_testing/performance/large.php

   1 <?php
   2   /* MySQL connection */
   3         include( $_SERVER['DOCUMENT_ROOT']."/datatables/mysql.php" ); /* ;-) */
   4
   5         $gaSql['link'] =  mysql_pconnect( $gaSql['server'], $gaSql['user'], $gaSql['password']  ) or
   6                 die( 'Could not open connection to server' );
   7
   8         mysql_select_db( $gaSql['db'], $gaSql['link'] ) or
   9                 die( 'Could not select database '. $gaSql['db'] );
  10
  11 ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
  12 <html>
  13         <head>
  14                 <meta http-equiv="content-type" content="text/html; charset=utf-8" />
  15                 <link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico" />
  16
  17                 <title>DataTables example</title>
  18                 <style type="text/css" title="currentStyle">
  19                         @import "../../css/demo_page.css";
  20                         @import "../../css/demo_table.css";
  21                 </style>
  22                 <script type="text/javascript" language="javascript" src="../../js/jquery.js"></script>
  23                 <script type="text/javascript" language="javascript" src="../../js/jquery.dataTables.js"></script>
  24                 <script type="text/javascript" charset="utf-8">
  25                         $(document).ready(function() {
  26                                 var oTable = $('#example').dataTable();
  27                                 var iStart = new Date().getTime();
  28
  29                                 //if ( typeof console != 'undefined' ) {
  30                                 //      console.profile();
  31                                 //}
  32                                 for ( var i=0 ; i<10 ; i++ )
  33                                 {
  34                                         var oTable = $('#example').dataTable({"bDestroy": true});
  35                                 }
  36                                 //if ( typeof console != 'undefined' ) {
  37                                 //      console.profileEnd();
  38                                 //}
  39
  40                                 //oTable.fnSort( [[ 1, 'asc' ]] );
  41                                 //oTable.fnSort( [[ 1, 'asc' ]] );
  42                                 //oTable.fnSort( [[ 2, 'asc' ]] );
  43                                 //oTable.fnSort( [[ 1, 'asc' ]] );
  44                                 //oTable.fnSort( [[ 2, 'asc' ]] );
  45
  46                                 var iEnd = new Date().getTime();
  47                                 document.getElementById('output').innerHTML = "Test took "+(iEnd-iStart)+" mS";
  48                         } );
  49                 </script>
  50         </head>
  51         <body id="dt_example">
  52                 <div id="container">
  53                         <div class="full_width big">
  54                                 <i>DataTables</i> performance test - draw
  55                         </div>
  56                         <div id="output"></div>
  57
  58                         <div id="demo">
  59 <table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
  60         <thead>
  61                 <tr>
  62                         <th>id</th>
  63                         <th>name</th>
  64                         <th>phone</th>
  65                         <th>email</th>
  66                         <th>city</th>
  67                         <th>zip</th>
  68                         <th>state</th>
  69                         <th>country</th>
  70                         <th>zip2</th>
  71                 </tr>
  72         </thead>
  73         <tbody>
  74 <?php
  75         $sQuery = "
  76                 SELECT *
  77                 FROM   testData
  78                 LIMIT  2000
  79         ";
  80         $rResult = mysql_query( $sQuery, $gaSql['link'] ) or die(mysql_error());
  81         while ( $aRow = mysql_fetch_array( $rResult ) )
  82         {
  83                 echo '<tr>';
  84                 echo '<td><a href="1">'.$aRow['id'].'</a></td>';
  85                 echo '<td>'.$aRow['name'].'</td>';
  86                 echo '<td>'.$aRow['phone'].'</td>';
  87                 echo '<td>'.$aRow['email'].'</td>';
  88                 echo '<td>'.$aRow['city'].'</td>';
  89                 echo '<td>'.$aRow['zip'].'</td>';
  90                 echo '<td>'.$aRow['state'].'</td>';
  91                 echo '<td>'.$aRow['country'].'</td>';
  92                 echo '<td>'.$aRow['zip2'].'</td>';
  93                 echo '</tr>';
  94         }
  95 ?>
  96         </tbody>
  97 </table>
  98                         </div>
  99                         <div class="spacer"></div>
 100
 101                         <div id="footer" style="text-align:center;">
 102                                 <span style="font-size:10px;">
 103                                         DataTables &copy; Allan Jardine 2008-2009.
 104                                 </span>
 105                         </div>
 106                 </div>
 107         </body>
 108 </html>