Просмотр архива Генератор форм


<?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 oTable = $('#example').dataTable();
                var iStart = new Date().getTime();
                
                //if ( typeof console != 'undefined' ) {
                //    console.profile();
                //}
                for ( var i=0 ; i<10 ; i++ )
                {
                    var oTable = $('#example').dataTable({"bDestroy": true});
                }
                //if ( typeof console != 'undefined' ) {
                //    console.profileEnd();
                //}
                
                //oTable.fnSort( [[ 1, '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 = 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 &copy; Allan Jardine 2008-2009.
                </span>
            </div>
        </div>
    </body>
</html>