Sistema de filtro de tabela dinamica PHP
Prezados boa tarde,
Preciso de construir um sistema de filtro para a tabela gerada automaticamente através de uma pesquisa select e while para uma tabela comum html.
Penso em fazer da seguinte maneira:
* Colocar a linha onde entram os parâmetros do filtro dentro de um formulário onde quando acionado passam as informações via $_POST para dentro da mesma página (pois o action do formulário aponta para mesma página).
* Assim será possível utilizar o $_POST para realizar os filtros dentro do recordset nos select. Que por sua vez estarão dentro de um if(isset()) para verificar sua existência e selecionar qual select mostrará na tela(com todos os registros ou com filtro).
O problema é que ao acionar o botão FILTRO, não está submetendo o formulário. Abaixo segue código com o formulário e tabela:
< table id="tabela" width="100%" border="0">
2.<thead>
3.<tr>
4.<th bgcolor="#304B73">Cliente</th>
5.<th bgcolor="#304B73">Componente / Modelo / Fabricante</th>
6.<th bgcolor="#304B73">TMPF / TMPR / TMEF</th>
7.<th colspan="2" bgcolor="#304B73">Ação</th>
8.</tr>
9.<tr>
10.<form action="system.php" method="post">
11.<th bgcolor="#304B73">
12.<select name="clients" id="clients">
13.<option value="">Todos</option>
14.<?php15.do {
16.?>
17.<option value="<?php echo $row_clients_list['client']?>"><?php echo $row_clients_list['client']?></option>
18.<?php
19.} while ($row_clients_list = mysql_fetch_assoc($clients_list));
20.$rows = mysql_num_rows($clients_list);
21.if($rows > 0) {
22.mysql_data_seek($clients_list, 0);
23.$row_clients_list = mysql_fetch_assoc($clients_list);24.}
25.?>
26.</select>
27.</th>
28.<th bgcolor="#304B73">
29.<select name="component" id="component">
30.<option value="">Todos</option>
31.<?php32.do {
33.?>
34.<option value="<?php echo $row_components_list['name']?>"><?php echo $row_components_list['name']?></option>
35.<?php
36.} while ($row_components_list = mysql_fetch_assoc($components_list));
37.$rows = mysql_num_rows($components_list);
38.if($rows > 0) {
39.mysql_data_seek($components_list, 0);
40.$row_components_list = mysql_fetch_assoc($components_list);41.}
42.?>
43.</select>44./
45.<select name="model" id="model">
46.<option value="">Todos</option>
47.<?php48.do {
49.?>
50.<option value="<?php echo $row_components_list['model']?>"><?php echo $row_components_list['model']?></option>
51.<?php
52.} while ($row_components_list = mysql_fetch_assoc($components_list));
53.$rows = mysql_num_rows($components_list);
54.if($rows > 0) {
55.mysql_data_seek($components_list, 0);
56.$row_components_list = mysql_fetch_assoc($components_list);57.}
58.?>
59.</select>60./
61.<select name="manufacturer" id="manufacturer">
62.<option value="">Todos</option>
63.<?php64.do {
65.?>
66.<option value="<?php echo $row_components_list['manufacturer']?>"><?php echo $row_components_list['manufacturer']?></option>
67.<?php
68.} while ($row_components_list = mysql_fetch_assoc($components_list));
69.$rows = mysql_num_rows($components_list);
70.if($rows > 0) {
71.mysql_data_seek($components_list, 0);
72.$row_components_list = mysql_fetch_assoc($components_list);73.}
74.?>
75.</select>
76.</th>
77.<th bgcolor="#304B73">
78.<select>
79.<option value="" selected>-</option>
80.<option value="=">igual a</option>
81.<option value=">">maior que</option>
82.<option value="<">menor que</option>
83.</select>
84.<input id='mtxx' name='mtxx' type='number' />
85.</th>
86.<th colspan="2" bgcolor="#304B73"><input type="submit" value="Filtrar" /> | <input type="button" onclick="javascript: location.href='#rec_openModal'" value="Adicionar componente" /></th>
87.</form>
88.</tr>
89.</thead>
90.<?php $c = 0; ?>
91.<?php do { ?>
92.<tbody>
93.<tr class="<?=($c++%2==1) ? 'odd' : 'even' ?>">
94.<td><?php echo $row_components['client']; ?></td>
95.<td><?php echo $row_components['name']?> / <?php echo $row_components['model']?> / <?php echo $row_components['manufacturer']?></td>
96.<td><?php echo $row_components['mttf']?> / <?php echo $row_components['mttr']?> / <?php echo $row_components['mtbf']; ?></td>
97.<td><form id="edit" action="mysql/update_ppcm_maintenance_preventive.php" method="POST">
98.<input type="hidden" name="update_idppcm_maintenance" value="<?php echo $row_components['idppcm_maintenance']?>">
99.<input type="image" name="buttom" src="imagens/edit.png" width="24" height="24">
100.</form></td>
101.<td><form id='delete' action="mysql/del_ppcm_maintenance_preventive.php" method="POST">
102.<input type="hidden" name="del_name" value="<?php echo $row_components['name']?>">
103.<input type="hidden" name="del_model" value="<?php echo $row_components['model']?>">
104.<input type="hidden" name="del_client" value="<?php echo $row_components['client']?>">
105.<input type="hidden" name="del_idppcm_maintenance" value="<?php echo $row_components['idppcm_maintenance']?>">
106.<input type="image" name="buttom" src="imagens/delete.png" width="24" height="24">
107.</td></form>
108.</tr>
109.<?php } while ($row_components = mysql_fetch_assoc($components)); ?>
110.</tbody>
111.</table>Discussão (0)
Carregando comentários...