Mercurial > repos > saskia-hiltemann > ireport

comparison DataTables-1.9.4/media/unit_testing/performance/large.php @ 0:ac5f9272033b draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
first upload
author saskia-hiltemann
date Tue, 01 Jul 2014 11:42:23 -0400
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:ac5f9272033b
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>