display-table
Differences
This shows you the differences between two versions of the page.
| — |
display-table [2016/05/17 12:42] (current) mh created |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | <code> | ||
| + | <html> | ||
| + | <head> | ||
| + | |||
| + | <script src="https://code.jquery.com/jquery-2.2.0.min.js"></script> | ||
| + | <script | ||
| + | src="https://cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"> | ||
| + | </script> | ||
| + | | ||
| + | <link | ||
| + | href="https://cdn.datatables.net/1.10.11/css/jquery.dataTables.min.css" | ||
| + | type="text/css" rel="stylesheet" /> | ||
| + | </head> | ||
| + | |||
| + | <script> | ||
| + | $(document).ready(function() { | ||
| + | |||
| + | $('#countrytable').DataTable(); | ||
| + | |||
| + | } ); | ||
| + | </script> | ||
| + | |||
| + | <?php | ||
| + | |||
| + | $dbh = mysqli_connect("127.0.0.1", "world", "world", "world"); | ||
| + | |||
| + | if (!$dbh) { | ||
| + | echo "Error: Unable to connect to MySQL." . PHP_EOL; | ||
| + | echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL; | ||
| + | echo "Debugging error: " . mysqli_connect_error() . PHP_EOL; | ||
| + | exit; | ||
| + | } | ||
| + | |||
| + | $result = $dbh->query( | ||
| + | 'select Name, Population, SurfaceArea | ||
| + | from country order by Population desc' | ||
| + | ); | ||
| + | |||
| + | |||
| + | $rows = $result->fetch_all(MYSQLI_ASSOC); | ||
| + | |||
| + | echo format_html_table($rows, 'countrytable'); | ||
| + | |||
| + | function format_html_table ($rows, $tableid) { | ||
| + | $html = ""; | ||
| + | $thead = "<table id='$tableid' class='display' cellspacing='0' \ | ||
| + | >\n<thead>\n<tr>\n"; | ||
| + | $html .= "\n<tbody>\n<tr>\n"; | ||
| + | foreach ($rows as $rownum => $row ) { | ||
| + | foreach ($row as $colname => $colvalue) { | ||
| + | if ($rownum == 0) { | ||
| + | $thead .= sprintf(" <th>%s</th>\n", $colname); | ||
| + | } | ||
| + | $html .= sprintf(" <td>%s</td>\n", $colvalue); | ||
| + | } | ||
| + | $html .= "</tr>\n"; | ||
| + | } | ||
| + | $html = $thead ."</tr>\n</thead>". $html; | ||
| + | $html .= "</tbody>\n</table>"; | ||
| + | return $html; | ||
| + | } | ||
| + | ?> | ||
| + | </code> | ||
display-table.txt ยท Last modified: 2016/05/17 12:42 by mh
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
