S.No. | District | Name of College | University | Address | Principal | NAAC | Contact | Web Link $con= mysqli_connect("localhost", "abpc_db", "*wmpr77Mc6enzIag","abpc_db") ; $name=''; $name=$_POST['city']; if($name!=''){ $name=$_POST['city']; $query = mysqli_query($con,"SELECT * from college where name like'%$name%' "); $r = mysqli_fetch_array($query); echo" |
---|---|---|---|---|---|---|---|---|
1 | $r[dist] | $r[name] | $r[univ] | $r[address] | $r[pr] | $r[naac] | $r[ph] | $r[link]"; } else{ $y=date('Y');$i=1; $query = mysqli_query($con,"SELECT * FROM college order by name ASC"); while($r = mysqli_fetch_array($query)){ if($i%2==1)echo" |
";else{echo" | ||||||||
";} echo"$i | $r[dist] | $r[name] | $r[univ] | $r[address] | $r[pr] | $r[naac] | $r[ph] | $r[link]"; $i=$i+1; } } ?> |