<?php $oddzien = $_POST['oddzien']; $odmiesiac = $_POST['odmiesiac']; $odrok = $_POST['odrok']; $dodzien = $_POST['dodzien']; $domiesiac = $_POST['domiesiac']; $dorok = $_POST['dorok']; echo " <center> <br> <table border=1 style='border-collapse: collapse' cellpadding='10'> <tr class=naglowek><td align=center>Wyszukiwanie zdarzen wg daty</td></tr> <tr> <td align=right> "; echo " <form method=post action=log_view.php> [dzien] [miesiac] [rok] <br> Szukaj danych z data od: <select size=1 name=oddzien> "; echo " <option>01</option> <option>02</option> </select> <select size=1 name=odmiesiac> "; echo " <option>01</option> <option>02</option> </select> <select size=1 name=odrok> "; echo " <option>2008</option> <option>2009</option> </select> <br><br><center><input type=submit value=Szukaj></center> </form>"; if ($odrok > "" and $odmiesiac > "") { $search = "data_rejestracji>=$odrok$odmiesiac$oddzien"; } else $limit = "LIMIT 10"; ?>
Plik log_view.php
require_once('./lukaszbeer.php'); // plik obslugujacy komunikacje z baza danych $naglowki = array('KAM', 'PH', 'idBH', 'PHPH', 'DSA', 'KSA', ); $result=mysql_query("SELECT numer_zamowienia FROM tv where $search"); echo $search; echo $zapytanie; ?> <head> <style type="text/css" media="screen, projection"> @import url('./style.css'); </style> <title>Witaj w Active Reports</title> <meta http-equiv="Content-type" content="text/html; charset=windows-1250" /> </head> <body> <table border="1"> <tr> <?php foreach ($naglowki as $nag) { } for ($i=0; $i<$ilew; $i++) {