Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- </head>
- <body>
- <form action="lotto.php" method="GET">
- Data:<input type="date" name="data" /><br />
- 1: <input type="number" name="liczba1" /><br />
- 2: <input type="number" name="liczba2" /><br />
- 3: <input type="number" name="liczba3" /><br />
- 4: <input type="number" name="liczba4" /><br />
- 5: <input type="number" name="liczba5" /><br />
- 6: <input type="number" name="liczba6" /><br />
- <input type="submit" value="Wyswietl" />
- </form>
- </body>
- </html>
- <?php
- @$datal = $_GET['data'];
- @$li1 = $_GET['liczba1'];
- @$li2 = $_GET['liczba2'];
- @$li3 = $_GET['liczba3'];
- @$li4 = $_GET['liczba4'];
- @$li5 = $_GET['liczba5'];
- @$li6 = $_GET['liczba6'];
- if ($li1 == $li2 || $li1 == $li3 || $li1 == $li4 || $li1 == $li5 || $li1 == $li6 &&
- $li2 == $li1 || $li2 == $li3 || $li3 == $li4 || $li2 == $li5 || $li2 == $li6 &&
- $li3 == $li1 || $li3 == $li2 || $li3 == $li4 || $li3 == $li5 || $li3 == $li6 &&
- $li4 == $li1 || $li4 == $li2 || $li4 == $li3 || $li4 == $li5 || $li4 == $li6 &&
- $li5 == $li1 || $li5 == $li2 || $li5 == $li3 || $li5 == $li4 || $li5 == $li6 &&
- $li6 == $li1 || $li6 == $li2 || $li6 == $li3 || $li6 == $li4 || $li6 == $li5){
- echo 'Blad nie podano cyfry albo sie potarzaja';
- }
- else if($li1<50 && $li2<50 && $li3<50 && $li4<50 && $li5<50 && $li6<50
- && $li1>0 && $li2>0 && $li3>0 && $li4>0 && $li5>0 && $li6>0) {
- echo $li1 ," ", $li2 ," ", $li3 ," ", $li4 ," ", $li5 ," ", $li6 ," ";
- $host="localhost";
- $user="root";
- $pass="47%!ZgDnP";
- $conn=@mysql_connect($host,$user,$pass);
- $db=@mysql_select_db("lotto");
- $dodaj=@mysql_query("INSERT INTO losowanie SET data='$datal', liczba1='$li1', liczba2='$li2', liczba3='$li3', liczba4='$li4', liczba5='$li5', liczba6='$li6' ");
- echo "dodano do bazy";
- }
- else if ($li1 == null && $li2 == null || $li3<50 || $li4 == null || $li5 == null || $li6 == null){
- echo 'Nie podales danych';
- }
- else {
- echo 'Jedna z cyfr jest mneijsza niz 1 lub wieksza niz 49!';
- }
- ?><br>
- <h1> skrypt spr dane z tabeli</h1>
- <form action="lotto.php" method="GET">
- Wyszukaj wynikow losowania po dacie:<br /> <input type="date" name="data" /><br />
- <input type="submit" value="Wyswietl" />
- </form>
- <br>
- <?php
- @$datals = $_GET['data'];
- if ($datals == null){
- echo "Nie podales Daty";
- }
- else{
- $host="localhost";
- $user="root";
- $pass="47%!ZgDnP";
- $connection = @mysql_connect($host,$user, $pass)
- or die('Brak połączenia z serwerem MySQL.<br />Błąd: '.mysql_error());
- $db = @mysql_select_db('lotto', $connection)
- or die('Nie mogę połączyć się z bazą danych<br />Błąd: '.mysql_error());
- $wynik = @mysql_query("SELECT * FROM losowanie WHERE data LIKE '$datal' ");
- if(mysql_num_rows($wynik) > 0) {
- echo "<table cellpadding=\"2\" border=1>";
- while($r = mysql_fetch_assoc($wynik)) {
- echo "<tr>";
- echo "<td> " .$r['data']. "</td>";
- echo "<td> " .$r['liczba1']. "</td> ";
- echo "<td> " .$r['liczba2']. "</td> ";
- echo "<td> " .$r['liczba3']. "</td> ";
- echo "<td> " .$r['liczba4']. "</td> ";
- echo "<td> " .$r['liczba5']. "</td> ";
- echo "<td> " .$r['liczba6']. "</td> ";
- echo "</tr>";
- }
- echo "</table>";
- }
- mysql_close($connection);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement