-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy patha_learn.php
137 lines (122 loc) · 6.36 KB
/
a_learn.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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css" integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
<link rel="stylesheet" href="a_css/a_contact.css">
</head>
<body>
<nav>
<div class="row text-center">
<img src="img/logo.png" alt="" class="rounded mx-auto d-block" width="75%">
</div>
<br><br>
<div class="user">
<img src="img/user.svg" alt="">
<p>Hi, Sarthak</p>
<button type="submit" onclick="log_out()">Log Out</button>
</div>
<script>
function log_out()
{
location.href = "index.php";
}
</script>
<br>
<!-- Menu Area -->
<ul class="menu">
<li><a href="a_login.php">HOME</a></li>
<li><a href="a_dict.php">DICTIONARY</a></li>
<li><a href="a_thesaurus.php">THESAURUS</a></li>
<li><a href="a_learn.php">LEARN GRAMMAR</a></li>
<li><a href="a_test.php">TEST YOUR GRAMMAR</a></li>
<li><a href="a_upcoming.php">UPCOMING EVENTS</a></li>
<li><a href="a_profile.php">MY PROFILE</a></li>
<li><a href="a_about.php">ABOUT</a></li>
<li><a href="a_authors.php">AUTHORS</a></li>
</ul>
<br><br><br>
<!-- -->
<a href="a_contact.php" id="social_head">CONTACT US</a>
<hr id="social_head_udr">
<ul class="social">
<li><a href="tel:+919809102900"><img src="img/phone.png" alt="" class="rounded-circle" width="100%"></a></li>
<li><a href="mailto: [email protected]"><img src="img/message.png" alt="" class="rounded-circle" width="100%"></a></li>
<li><a href="https://www.instagram.com/"><img src="img/insta.png" alt="" class="rounded-circle" width="100%"></a></li>
<li><a href="https://www.facebook.com/"><img src="img/facebook.png" alt="" class="rounded-circle" width="100%"></a></li>
</ul>
</nav>
<div class="container">
<br>
<a href="#" id="contact_head">LEARN GRAMMAR</a>
<hr id="contact_head_udr">
<br><br>
<?php
$db_host='127.0.0.1';
$db_user='root';
$db_pass='';
$db_name='english';
$conn=mysqli_connect($db_host,$db_user,$db_pass,$db_name);
if(!$conn )
{
die('Failed to connect mysql database'.mysqli_connect_error());
}
// echo "YOYO";
$sql='SELECT * from engvideos ORDER BY views DESC';
$query = mysqli_query($conn,$sql);
if(!$query)
{
die('error found'.mysqli_error($conn));
}
$c=0;
while($row=mysqli_fetch_array($query))
{ ?>
<div class="card mb-3" style="box-shadow: 0px 1px 5px black inset;">
<div class="row g-0">
<form class="col-4 m-0 d-flex align-items-center justify-content-center" action="play_video.php" method="GET">
<button type="submit" name="submit" value="<?php echo $row['name'];?>" style="width:90%;border:none;outline:none;background-color:transparent;"><video class="rounded" src="<?php echo $row['video'];?>" width="100%"></video><h5 class="col-6" style="position: absolute; top: 40%; left: 50%; transform: translate(-50%, -40%);"><?php echo $row['name'];?></h5></button>
</form>
<div class="col-8">
<div class="card-body p-3">
<div class="col-3 ml-auto">
<?php
$count = $row['rating'];
echo '<small style="font-size:0.5em">'.$row['rating'].' / 5.0 stars </small>';
$countleft = 5-$count;
while($count>=1)
{
echo'<img src="img/full_star.jpg" style="width: 10%; height: 100%" alt="">';
$count--;
}
if($count>0)
{
echo'<img src="img/half_star.jpg" style="width: 10%; height: 100%" alt="">';
}
while($countleft>=1)
{
echo'<img src="img/empty_star.jpg" style="width: 10%; height: 100%" alt="">';
$countleft--;
}
?>
</div>
<h5 class="card-title mb-1"><?php echo $row['name'];?></h5>
<p class="card-text font-italic" style="font-size: 0.8em;">Instructor - <?php echo $row['instructor'];?></p>
<p class="card-text"><?php echo substr($row['description'],0,100); echo '...'?></p>
<p class="card-text"><small class="text-muted"><?php echo $row['length'];?> min</small></p>
<img src="img/views.png" alt="" width="2%"><span style="font-size: 0.8em; color: #00000075;"> <?php echo $row['views'];?> views</span>
</div>
</div>
</div>
</div>
<?php }?>
</div>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<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-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js" integrity="sha384-OgVRvuATP1z7JjHLkuOU7Xw704+h835Lr+6QL9UvYjZE3Ipu6Tp75j7Bh/kR0JKI" crossorigin="anonymous"></script>
</body>
</html>