DataTables

uniojnqoifazy

hi all,
it's my code , but i can't see anything ,
anyone else know how to solve the problem ?

datatable.php

 <?php
$con = mysql_connect("localhost", "root", "pwd");

if (!$con) {
    die("Error: " . mysql_error());
}

mysql_select_db("sample", $con);

$result = mysql_query("SELECT * FROM countries");
?>
<!DOCTYPE html>
<html>
    <head>
        <title>DataTables</title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        
        <script src="media/js/jquery.js" type="text/javascript"></script>
        <script src="media/js/jquery.dataTables.js" type="text/javascript"></script>
        
        <style type="text/css">
            @import "media/css/demo_table_jui.css";
            @import "media/themes/smoothness/jquery-ui-1.8.4.custom.css";
        </style>
        
        <style>
            *{
                font-family: arial;
            }
        </style>
        <script type="text/javascript" charset="utf-8">
            $(document).ready(function(){
                $('#datatables').dataTable({
                    "sPaginationType":"full_numbers",
                    "aaSorting":[[2, "desc"]],
                    "bJQueryUI":true
                });
            })
            
        </script>
        
    </head>
    <body>
        <div>
            <table id="datatables" class="display">
                <thead>
                    <tr>
                        <th>Country</th>
                        <th>Population</th>
                        <th>Internet Users</th>
                        <th>Penetration (% Population)</th>
                        <th>World % Users</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                    while ($row = mysql_fetch_array($result)) {
                        ?>
                        <tr>
                            <td><?=$row['name']?></td>
                            <td><?=$row['population']?></td>
                            <td><?=$row['internet_users']?></td>
                            <td><?=$row['penetration']?></td>
                            <td><?=$row['world_users']?></td>
                        </tr>
                        <?php
                    }
                    ?>
                </tbody>
            </table>
        </div>
    </body>
</html>

DataTables

Howdy, Stranger!

Support

Categories