gargsahaj.github.io/connection_req.php at main · gargsahaj/gargsahaj.github.io · 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
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
<?php
session_start();
$conn=mysqli_connect('127.0.0.1:3307','root','ameta1234','ams');
if(! $conn){
	die('Could not connect: '.mysqli_error());
}
$username=$_SESSION['username'];
$q="SELECT * from user natural inner join student where gmail in(select sgmail from connection where agmail='$username' and status=0 )";
$result=mysqli_query($conn,$q);
$row=mysqli_num_rows($result);
$i=0;
while($res=mysqli_fetch_assoc($result))
{
$arr[$i]['gmail']=$res['gmail'];
$arr[$i]['name']=$res['name'];
$arr[$i]['phone_no']=$res['phone_no'];
$arr[$i]['branch']=$res['branch'];
$arr[$i]['year']=$res['year'];
$i++;
}
mysqli_close($conn);
?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Company-HTML Bootstrap theme</title>

    <!-- Bootstrap -->
    <link href="css/bootstrap.min.css" rel="stylesheet">
	<link rel="stylesheet" href="css/font-awesome.min.css">
	<link rel="stylesheet" href="css/animate.css">
	<link href="css/prettyPhoto.css" rel="stylesheet">
	<link href="css/style.css" rel="stylesheet" />
    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
    <script type="text/javascript">
    	function fun1(i1)
    	{
             var req=new XMLHttpRequest();
            req.open("GET","http://localhost/Alumni Management System/ajax1.php?x="+i1,false);
            req.send();
    		window.location.href='http://localhost/Alumni%20Management%20System/connection_req.php';
    	}

    </script>
  </head>
  <body>
	<header>
		<nav class="navbar navbar-default navbar-fixed-top" role="navigation">
			<div class="navigation">
				<div class="container">
					<div class="navbar-header">
						<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target=".navbar-collapse.collapse">
							<span class="sr-only">Toggle navigation</span>
							<span class="icon-bar"></span>
							<span class="icon-bar"></span>
							<span class="icon-bar"></span>
						</button>
						<div class="navbar-brand">
							<a href="index.html"><h1><span>Alumni</span> Management<span> System</span></h1></a>
						</div>
					</div>

					<div class="navbar-collapse collapse">
						<div class="menu">
							<ul class="nav nav-tabs" role="tablist">
								<li role="presentation"><a href="logout.php" class="active">logout</a></li>
								<li role="presentation"><a href="connected_stud.php" class="active">connected student</a></li>
								<li role="presentation"><a href="alumni_welcome.php" class="active">Home</a></li>
							</ul>
						</div>
					</div>
				</div>
			</div>
		</nav>
	</header>

	<div id="breadcrumb">
		<div class="container">
			<div class="breadcrumb" >
				<li><p><?php echo $_SESSION['username'];?></p></li>
			</div>
		</div>
	</div>
	<div style='position:relative;top:50px;'>
		<h3>connection request</h3>
	 <table style="width:100%;color:black;">
  <tr>
    <th>name</th>
    <th>gmail</th>
    <th>phone no</th>
    <th>branch</th>
    <th>year</th>
  </tr>
  	<?php
    for($j=0;$j<$i;$j++)
    {
    	echo '<tr>';
    echo '<td>'.$arr[$j]['name'].'</td>';
    echo '<td>'.$arr[$j]['gmail'].'</td>';
    echo '<td>'.$arr[$j]['phone_no'].'</td>';
     echo '<td>'.$arr[$j]['branch'].'</td>';
      echo '<td>'.$arr[$j]['year'].'</td>';
      echo "<td><button id=".$arr[$j]['gmail']." onclick=fun1(this.id)>Accept</button></td>";

echo '</tr>';
    }
    ?>

</table>
	   </div>

	</div>

	<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
	<script src="js/jquery-2.1.1.min.js"></script>
    <!-- Include all compiled plugins (below), or include individual files as needed -->
    <script src="js/bootstrap.min.js"></script>
	<script src="js/jquery.prettyPhoto.js"></script>
    <script src="js/jquery.isotope.min.js"></script>
	<script src="js/wow.min.js"></script>
	<script src="js/functions.js"></script>

  </body>
</html>