To-Let/search.php at main · ARBHARADWAJ/To-Let · GitHub

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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<?php
$con=mysqli_connect("localhost","root","", "profile_details");
if(!$con){
    echo "Errorwith the connection with the database;";
}

//$ar=array("profilepage.html",)

?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <link rel="stylesheet" href="style3.css">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title></title>

</head>
<body>
<div class="pic">
<img src="sss.jpg" alt="no img" height="600px" width="100%" >
<h2>Select your option:</h2>
</div>


<form action="search.php" method="post">
    <Label>Sort By :</Label>
    <select name="select" class="selectc">
        <option value="new">Most recent</option>
        <option value="lth">Price low to high</option>
        <option value="htl">price high to low</option>
    </select>

    <Label>menbers in room : </Label>
    <select name="select2" class="selectcv">
        <option value="4">4</option>
        <option value="5">5</option>
        <option value="8">8</option>
</select>
        <input type="submit" name="submit" class="submit" value="Search">
</form>
<br>


<?php
$sql="select *from profile;";
$res=mysqli_query($con,$sql);
while($a=mysqli_fetch_assoc($res)){  ?>
    <div class="detals">
        <div style="display: inline-flex; ">
        <h3 style="margin-left:10px; color:rgb(32, 59, 234)"><?php echo $a["Owner_name"]??"" ?></h3>
        <a href="<?php echo $a['link']; ?>" class="rating2">see more details</a>
        </div>
        <hr>
        <div style="display: inline-flex; ">
        <p style="margin-right:20px; margin-left:10px;">Availability :<?php echo $a["Availability"]??"" ?></p>
        <p>price: <?php echo $a['price']??""  ?></p>

        <p class="rating">Rating: <?php echo $a["rating"]??""   ?></p></div>
    </div>
<?php

}


?>

</body>
</html>