Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta http-equiv="X-UA-Compatible" content="ie=edge">
- <title>Document</title>
- <body>
- <?php
- $database = new mysqli('localhost','root','','basa');
- $question1 = "SELECT imie, nazwisko, dzial, stanowisko FROM pracownik WHERE dzial = 'OBSLUGA KLIENTA' AND stanowisko = 'SPRZEDAWCA'";
- $question2 = "SELECT imie, nazwisko, dzial, stanowisko FROM pracowink WHERE stanowisko = 'KIEROWNIK' OR 'MECHANIK'";
- $question3 = "SELECT id_samochod, marka FROM samochod WHERE NOT marka = 'FIAT' AND NOT marka = 'FORD'";
- $question4 = "SELECT id_samochod, marka FROM samochod WHERE marka IN ('MERCEDES','SEAT','OPEL')";
- $question5 = "SELECT imie, nazwisko, data_zatr FROM pracownik WHERE imie IN ('ANNA','MARZENA','ALICJA')";
- $question6 = "SELECT imie, nazwisko, miasto WHERE miasto NOT IN ('WROCLAW','WARSZAWA')";
- $question7 = "SELECT imie, nazwisko FROM klient WHERE nazwisko LIKE '%K%'";
- $question8 = "SELECT imie, nazwisko FROM klient WHERE nazwisko LIKE 'D%SKI'";
- $question9 = "SELECT imie, nazwisko FROM klient WHERE nazwisko LIKE '_O%' OR nazwisko LIKE '_A%'";
- $question10 = "SELECT * FROM samochod WHERE poj_silnika BETWEEN 1100 AND 1600";
- $question11 = "SELECT imie, nazwisko FROM pracownik WHERE data_zatr BETWEEN '1997-01-01' AND '1997-12-31'";
- $question12 = "SELECT marka FROM samochod WHERE przebieg BETWEEN 10000 AND 20000 OR przebieg BETWEEN 30000 AND 40000";
- $question13 = "SELECT imie, nazwisko FROM pracownik WHERE dodatek IS NULL";
- $question14 = "SELECT imie, nazwisko FROM klient WHERE nr_karty_kredyt IS NOT NULL";
- $question15 = "SELECT imie, nazwisko, dodatek
- $question12
- $question13
- $question14
- $w = $database->query($question1);
- while($c = $w->fetch_object()) {
- echo $c->imie." ".$c->nazwisko." ".$c->dzial." ".$c->stanowisko.";
- $database->close();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement