-
Notifications
You must be signed in to change notification settings - Fork 0
/
selects.php
54 lines (45 loc) · 1.75 KB
/
selects.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
<?php
session_start();
include ('includes/config.inc.php');
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Language"
content="język" />
<meta http-equiv="Content-Type"
content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name = "author" content = "Jan Gregor" />
<title>SELECTS</title>
<link rel="Stylesheet" type= "text/css" href = "css/bootstrap.min.css" />
<link rel="Stylesheet" type= "text/css" href = "css/style.css?version=1" />
</head>
<body>
<header>
<?php
require_once "includes/header.inc.php"; ?>
</header>
<main>
<center><br><br><br>
<head><h2>selects</h2></head><br><br><br><br><br><br>
<?php $sql = "SELECT * FROM offers WHERE ctgr_id = 2 AND experience_level = 'mid' AND workplace_type = 'office';";
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_array($result)) {
$offer_id = $row['offer_id'];
$workplace_types = $row['workplace_type'];
$experience_levels = $row['experience_level'];
?><h4><?php echo $offer_id . ' ['. $workplace_types . '] ['. $experience_levels . ']'?></h4><?php ;
}?>
<br><br><br><br><br><br><br><br><br><br><br><br>
</main>
<footer>
<?php
require_once "includes/footer.inc.php"; ?>
</footer>
</div> </div>
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>