Advertisement
_Nishat_tasnim

Untitled

Aug 9th, 2022
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.97 KB | None | 0 0
  1. <?php
  2. require 'account_form.php';
  3. ?>
  4. <!DOCTYPE html>
  5. <html lang="en">
  6. <head>
  7. <meta charset="UTF-8">
  8. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  9. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  10. <title>Document</title>
  11. <link rel="stylesheet" href="loan.css">
  12. <!-- <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-gH2yIJqKdNHPEq0n4Mqa/HGKIhSkIHeL5AyhkYV8i59U5AR6csBvApHHNl/vI1Bx" crossorigin="anonymous"> -->
  13. </head>
  14. <body>
  15. <div class="center">
  16. <h1>Account Edit Information</h1>
  17. <?php
  18. if(isset($_GET['Account_Number']))
  19. {
  20. echo $Account_num = $_GET['Account_Number'];
  21. $query = "SELECT * FROM account_info WHERE Account_Number='$Account_num' ";
  22. $query_run=mysqli_query($connection,$query);
  23. if(mysqli_num_rows($query_run)>0)
  24. {
  25. $acount = myaqli_fetch_array($query_run);
  26. ?>
  27.  
  28. <form action="" method="POST">
  29. <div class="part">
  30. <label for="">First Name</label>
  31. <input type="text" placeholder="Please enter your First Name" value="<?=$acount['First_Name'];?>" required name="firstname">
  32. </div>
  33. <div class="part">
  34. <label for="">Last Name</label>
  35. <input type="text" placeholder="Please enter your Last Name" value="<?=$acount['Last_Name'];?>"required name="lastname">
  36. </div>
  37. <div class="part">
  38. <label for="">Phone Number</label>
  39. <input type="text" placeholder="Please enter your Phone Number"value="<?=$acount['Phone_Number'];?>"required name="phonenumber">
  40. </div>
  41. <div class="part">
  42. <label for="">Address</label>
  43. <input type="text" placeholder="Please enter your address"value="<?=$acount['Address'];?>"required name="address">
  44. </div>
  45. <div class="part">
  46. <label for="">Gender</label>
  47. <select class="select" name="select" id="" placeholder="select"value="<?=$acount['Gender'];?>">
  48. <option value="select">select</option>
  49. <option value="male">Male</option>
  50. <option value="female">Female</option>
  51. <option value="others">others</option>
  52. </select>
  53. </div>
  54. <div class="part">
  55. <label for="">Account Number</label>
  56. <input type="text" placeholder="Please enter the account number"value="<?=$acount['Account_Number'];?>"required name="accountnumber">
  57. </div>
  58. <div class="part">
  59. <label for="">Account type</label>
  60. <input type="text" placeholder="Please enter account type"value="<?=$acount['Account_Type'];?>"required name="accounttype">
  61. </div>
  62. <div class="part">
  63. <label for="">Ammount </label>
  64. <input type="text" placeholder="Please enter ammount"value="<?=$acount['Ammount'];?>"required name="ammount">
  65. </div>
  66. <div class="part">
  67. <input type="submit" value="Update" name="submit" >
  68. </a>
  69. </div>
  70. </form>
  71.  
  72. <?php
  73. }
  74. else{
  75. echo "<h4>No Such Account Found</h4>";
  76. }
  77. }
  78.  
  79. ?>
  80. <br>
  81. <br>
  82. <a class="btn btn-primary" href="http://localhost/Bank-OUT-LOOK/display.php" role="button" text-align>SHOW DETAILS</a>
  83.  
  84. </div>
  85.  
  86. <!-- <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.11.5/dist/umd/popper.min.js" integrity="sha384-Xe+8cL9oJa6tN/veChSP7q+mnSPaj5Bcu9mPX5F5xIGE0DVittaqT5lorf0EI7Vk" crossorigin="anonymous"></script>
  87. <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0/dist/js/bootstrap.min.js" integrity="sha384-ODmDIVzN+pFdexxHEHFBQH3/9/vQ9uori45z4JjnFsRydbmQbmL5t1tQ0culUzyK" crossorigin="anonymous"></script> -->
  88. </body>
  89. </html>
  90. <?php
  91. if(isset($_POST['submit'])){
  92. $firstname =$_POST['firstname'];
  93. $lastname =$_POST['lastname'];
  94. $phonenumber =$_POST['phonenumber'];
  95. $address =$_POST['address'];
  96. $gender =$_POST['select'];
  97. $accountnumber =$_POST['accountnumber'];
  98. $accounttype =$_POST['accounttype'];
  99. $ammount =$_POST['ammount'];
  100.  
  101. if($firstname != "" && $lastname != "" && $phonenumber != "" && $address!= "" && $gender!= "" && $accountnumber!= "" && $accounttype!= "" && $ammount!= "" ){
  102.  
  103. $query = "insert into account_info values('$firstname','$lastname','$phonenumber','$address','$gender','$accountnumber','$accounttype','$ammount')";
  104. $data = mysqli_query($connection,$query);
  105. if($data)
  106. {
  107. // echo "done";
  108. }
  109. else{
  110. echo "failed";
  111. }
  112. }
  113. else {
  114. echo "Please fill the form";
  115. }
  116. }
  117. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement