Bank-Website/verify.php at master · namansaxena9/Bank-Website · 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
<html>
<?php

  $conn=mysqli_connect("localhost","root","");
  $sql=mysqli_select_db($conn,'bank');

  $ref=$_POST["reg"];

   $sql=mysqli_query($conn,"select * from application where reference_id=$ref");

    if(mysqli_num_rows($sql)==0)
	{
	   echo "no record found try again";
    }

	else
    {
       $row=mysqli_fetch_assoc($sql);

	   if($row['status']=="pending")
	   {
		   echo "your application is still in process";
       }

	   else if($row['status']=='rejected')
	   {
		   echo "oops your application is rejected";
	   }

       else
	   {
          echo  "your application is accepted "."<br>";

	      $accno="UBI";
		  $accno.=$ref;

	      echo "your account number is ".$accno."<br> <br>";

          $sql=mysqli_query($conn,"select b.username,b.password from account a,user b where a.accountno=b.accountno and b.accountno='$accno' ");

          $row=mysqli_fetch_assoc($sql);

          echo "your user name is :: ".$row['username']."<br><br>";

		  echo "your password is  :: ".$row['password']."<br> <br>";

		}
	}

 ?>

  <br><br> <button type="button" onclick="location.href='verify.html'"> GO BACK </button>

 </html>