Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <meta charset="UTF-8">
- <title>index</title>
- </head>
- <body>
- <?php
- ?>
- <h2>Kontaktų paieška:</h2>
- <form action="nd.php" method="POST">
- Gimimo metai nuo:
- <input type="number" name="nuo">
- Gimimo metai iki:
- <input type="number" name="iki">
- <input type="submit" value="Ieškoti">
- </form>
- </body>
- </html>
- <-- nd.php-->
- <?php
- $host = "localhost"; // adresas kur duomenu baze
- $user = "root";
- $pass = ""; //slaptazodis
- $db = "kontaktai"; // duomenu baze, prie kurios jungtis
- if (array_key_exists("nuo", $_POST) && array_key_exists("iki", $_POST)) {
- $nuo = $_POST["nuo"];
- $iki = $_POST["iki"];
- if (is_numeric($_POST["nuo"]) && is_numeric($_POST["iki"])) {
- $connection = mysqli_connect($host, $user, $pass, $db); // prisijungimas prie db. isaugomas i kintamaji.
- mysqli_set_charset($connection, "utf8"); // funkcija kuri ištraukiant sutvarko lietuviškas raides.
- $query = mysqli_query($connection, "SELECT * FROM `kontaktai` WHERE `gimimoMetai`>='$nuo' && `gimimoMetai`<='$iki' "); // tas sql serveris ivykdo uzklausia prie kurio prisijungiam, antaras uzklausa nurodoma
- $total = mysqli_num_rows($query); // funkcija, kuri patikrina kiek yra eiluciu
- $i = 0;
- while ($i < $total) {
- $telefonai = mysqli_fetch_assoc($query); // is uzklausos, nespausdina tai perleidziam per Fetch kad spausdintu, po viena eilute
- echo "vardas: " . $telefonai['vardas'];
- echo "<br>pavarde: " . $telefonai['pavarde'];
- echo "<br>el. pastas: " . $telefonai['el.pastas'];
- echo "<br>gimimo metai: " . $telefonai['gimimoMetai'];
- echo "<hr>";
- $i++;
- }
- mysqli_close($connection); // db uzdarymas, paduodamas prisijungimo kintamasis
- echo "Pagal nurodytą rėžį radome: <br>";
- } else if (is_numeric($_POST["nuo"])) {
- $connection = mysqli_connect($host, $user, $pass, $db);
- mysqli_set_charset($connection, "utf8");
- $query = mysqli_query($connection, "SELECT * FROM `kontaktai` WHERE `gimimoMetai`>='$nuo'");
- $total = mysqli_num_rows($query); // funkcija, kuri patikrina kiek yra eiluciu
- $i = 0;
- while ($i < $total) {
- $telefonai = mysqli_fetch_assoc($query);
- echo "vardas: " . $telefonai['vardas'];
- echo "<br>pavarde: " . $telefonai['pavarde'];
- echo "<br>el. pastas: " . $telefonai['el.pastas'];
- echo "<br>gimimo metai: " . $telefonai['gimimoMetai'];
- echo "<hr>";
- $i++;
- }
- mysqli_close($connection);
- echo "Pagal nurodytą rėžį radome: <br>";
- } else if (is_numeric($_POST["iki"])) {
- $connection = mysqli_connect($host, $user, $pass, $db);
- mysqli_set_charset($connection, "utf8");
- $query = mysqli_query($connection, "SELECT * FROM `kontaktai` WHERE `gimimoMetai`<='$iki'");
- $total = mysqli_num_rows($query);
- $i = 0;
- while ($i < $total) {
- $telefonai = mysqli_fetch_assoc($query);
- echo "vardas: " . $telefonai['vardas'];
- echo "<br>pavarde: " . $telefonai['pavarde'];
- echo "<br>el. pastas: " . $telefonai['el.pastas'];
- echo "<br>gimimo metai: " . $telefonai['gimimoMetai'];
- echo "<hr>";
- $i++;
- }
- mysqli_close($connection);
- echo "Pagal nurodytą rėžį radome: <br>";
- } else {
- $connection = mysqli_connect($host, $user, $pass, $db);
- mysqli_set_charset($connection, "utf8");
- $query = mysqli_query($connection, "SELECT * FROM `kontaktai` ");
- $total = mysqli_num_rows($query);
- $i = 0;
- while ($i < $total) {
- $telefonai = mysqli_fetch_assoc($query);
- echo "vardas: " . $telefonai['vardas'];
- echo "<br>pavarde: " . $telefonai['pavarde'];
- echo "<br>el. pastas: " . $telefonai['el.pastas'];
- echo "<br>gimimo metai: " . $telefonai['gimimoMetai'];
- echo "<hr>";
- $i++;
- }
- mysqli_close($connection);
- echo "Pagal nurodytą rėžį radome: <br>";
- }
- } else {
- echo "nepalikite tuščių reikšmių ";
- }
- ?>
- <a href="index.php"><button type="button">Back</button></a>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement