Sky-Map/Constellations.php at master · nisha710/Sky-Map · 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
73
74
75
76
<!-- <!DOCTYPE html>
<html lang="en">
<head>
    <title></title>
    <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" type="text/css" href="css/style.css">
  <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css">
  <link href="https://fonts.googleapis.com/css?family=Josefin+Sans&display-swap" rel="stylesheet">

</head>
<body>

</body>
</html> -->

<?php

$con =mysqli_connect('localhost','root','Nisha@111','dbms');
// require_once('config/db.php');
$query="select * from constellations";
$result=mysqli_query($con,$query);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <title>Constellations Table</title>
    <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" type="text/css" href="css/style.css">
  <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css">
  <link href="https://fonts.googleapis.com/css?family=Josefin+Sans&display-swap" rel="stylesheet">


</head>
<body class="bg-dark">
    <div class="container">
        <div class="row mt-5">
            <div class="col">
                <div class="card mt-5">
                    <div class="card-header">
                        <h2 class="display-6 text-center">Constellations Table</h2>
                    </div>
                    <div class="card-body">
                        <table class="table table-bordered text-center">
                            <tr class="bg-dark text-white">
                                <td> Constellation Name </td>
                                <td> Area (degree sq.) </td>
                                <td> Know More </td>
                            </tr>
                            <tr>
                               <?php
                                while($row = mysqli_fetch_assoc($result)){
                                    ?>
                                  <td><?php echo $row['C_name']; ?></td>
                                  <td><?php echo $row['Area_square_degrees']; ?></td>
                                  <?php
                                  echo "<td><a href='1.php?Namee=" . $row["C_name"] . "'>Read More</a></td>";
                                  ?>

                               </tr>
                               <?php
                                }


                                ?>

                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</body>
</html>