[HTML] pobierz, plaintext 
  1. <?php
  2. $con = mysql_connect("localhost", "root", "");
  3.  
  4. if (!$con) {
  5.     die("Error: " . mysql_error());
  6. }
  7.  
  8. mysql_select_db("kurier", $con);
  9.  
  10. $result = mysql_query("SELECT * FROM klienci");
  11. ?>
  12. <!DOCTYPE html>
  13. <html>
  14.     <head>
  15.         <title>DataTables</title>
  16.         <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  17.  
  18. 				<link rel="stylesheet" href=" /kurier/inc/wybierz.css " type="text/css" />
  19.  
  20.         <script src="/kurier/media/js/jquery.js" type="text/javascript"></script>
  21.         <script src="/kurier/media/js/jquery.dataTables.js" type="text/javascript"></script>
  22.  
  23.         <style type="text/css">
  24.             @import "/kurier/media/css/demo_table_jui.css";
  25.             @import "/kurier/media/themes/smoothness/jquery-ui-1.8.4.custom.css";
  26.         </style>
  27.  
  28.         <style>
  29.             *{
  30.                 font-family: arial;
  31.             }
  32.         </style>
  33.         <script type="text/javascript" charset="utf-8">
  34.  
  35.  
  36.  
  37. $(document).ready(function() {
  38.     $('#form').submit( function() {
  39.         var sData = $('input', oTable.fnGetNodes()).serialize();
  40.         alert( "The following data would have been submitted to the server: \n\n"+sData );
  41.         return false;
  42.     } );
  43.  
  44.     /* Init the table */
  45.     oTable = $('#datatables').dataTable({
  46.                     "sPaginationType":"full_numbers",
  47.                     "aaSorting":[[2, "desc"]],
  48.                     "bJQueryUI":true
  49.                 });
  50. } );
  51.  
  52.  
  53. /* Get the rows which are currently selected */
  54.  
  55.  
  56.  
  57. 	 </script>
  58.  
  59.     </head>
  60.     <body>
  61.         <div id="wyb_kl">
  62. 				<form id="form">
  63. 					<div style="text-align:right; padding-bottom:1em;">
  64.  
  65. 						<button type="submit">Submit form</button>
  66. 					</div>
  67.             <table id="datatables" class="display">
  68.                 <thead>
  69.                     <tr>
  70.                         <th>ID</th>
  71.                         <th>Nazwa</th>
  72.                         <th>Nip</th>
  73.                         <th>Kod Pocztowy</th>
  74.                         <th>Ulica</th>
  75. 												<th>Nr domu</th>
  76. 												<th>Nr lokalu</th>
  77. 												<th>Tel</th>
  78. 												<th>Email</th>
  79. 												<th>Data</th>
  80.                     </tr>
  81.                 </thead>
  82.                 <tbody>
  83.                     <?php
  84.                     while ($row = mysql_fetch_array($result)) {
  85.                         ?>
  86.                         <tr>
  87.                             <td><?=$row['ID_klient']?></td>
  88.                             <td><?=$row['nazwa']?></td>
  89.                             <td><?=$row['nip']?></td>
  90.                             <td><?=$row['kod']?></td>
  91.                             <td><?=$row['ulica']?></td>
  92. 														<td><?=$row['nr_domu']?></td>
  93.                             <td><?=$row['nr_lokalu']?></td>
  94. 														<td><?=$row['telefon']?></td>
  95.                             <td><?=$row['email']?></td>
  96. 														<td><?=$row['data']?></td>
  97. 														<td><input type="radio" name="klienci[]" id="<?=$row['data']?>" value="<?=$row['data']?>" /></td>
  98.  
  99.                         </tr>
  100.                         <?php
  101.                     }
  102.                     ?>
  103.                 </tbody>
  104.             </table>
  105. 					</form>
  106.         </div>
  107.     </body>
  108. </html>
[HTML] pobierz, plaintext


chce zrobić tabelkę z opcja wyboru uzytkownika , ktorego id przesle do php , problem polega na tym ze automatycznie gdy dodaje kolumne z radio znika mi stylizacja plugin datatables i mozliwosc sortowania