-
Notifications
You must be signed in to change notification settings - Fork 0
/
blogExp.php
37 lines (20 loc) · 1.37 KB
/
blogExp.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
$sql="select s.s_name , u.uni_name from student s join university u where s_interests=uni_name";
$result=mysqli_query($conn , $sql);
///both are the snytax of comparing two cloumns of two different table
$suni="select s_interests from student";
$u="select uni_name from university";
if($suni=$u){
echo "matched university";
}
<?php
$sql="SELECT *,((sign_up.interMarks*50/100)+(sign_up.EnteryTestMarks*50/100)) as 'Your meritc' FROM `sign_up` join university_record on university_record.university_id = sign_up.Interested_uni where university_record.relative_Score<= ((sign_up.interMarks*50/100)+(sign_up.EnteryTestMarks*50/100))";
echo "Matched University";
// <img src="img/bg-img/"+$row["uni_pic"]/>
echo "You can also apply in following universities";
$sql="SELECT *,((sign_up.interMarks*50/100)+(sign_up.EnteryTestMarks*50/100)) as 'Your meritc' FROM `sign_up` join university_record where university_record.relative_Score<= ((sign_up.interMarks*50/100)+(sign_up.EnteryTestMarks*50/100))";
?>
<?php
$query = "SELECT * FROM university JOIN category WHERE university.cat_id = category.cat_id;";
$results = mysqli_query($conn, $query);
while($row = mysqli_fetch_assoc($results)) :
?>