API tools faq
paste
Guest User

Untitled

a guest
Apr 14th, 2018
134
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.25 KB | None | 0 0
raw download clone embed print report
  1. public function insertAdmin($adminUsername,$adminPassword,$firstname,$lastname,$birthday,$gender,$civilstatus,$contactno,$address){
  2. if(!empty($adminUsername) && !empty($adminPassword) && !empty($firstname) && !empty($lastname) && !empty($birthday) && !empty($gender) && !empty($civilstatus) && !empty($contactno) && !empty($address)) {
  3. $stmtInsertAdmin = $this->con->prepare("INSERT INTO admins (admin_id, admin_username, admin_password, admin_firstname, admin_lastname, admin_birthday, admin_gender, admin_civilstatus, admin_contactno, admin_address) VALUES (:field1,:field2,:field3,:field4,:field5,:field6,:field7,:field8,:field9,:field10,)");
  4. $stmtInsertAdmin->execute(array(
  5. ':field1'=> NULL,
  6. ':field2' => $adminUsername,
  7. ':field3' => $adminPassword,
  8. ':field4' => $firstname,
  9. ':field5' => $lastname,
  10. ':field6' => $birthday,
  11. ':field7' => $gender,
  12. ':field8' => $civilstatus,
  13. ':field9' => $contactno,
  14. ':field10'=>$address //this is the exact line 62
  15. ));
  16.  
  17. if($stmtInsertAdmin == true) {
  18. echo "<script>alert('successfully Inserted, Thanks!')</script>";
  19. echo "<script>window.open('insertAdmin.php','_self')</script>";
  20. } else {
  21. echo "<script>alert('Your data isn't inserting, please try again!')</script>";
  22. echo "<script>window.open('insertAdmin.php', '_self')</script>";
  23. }
  24. } else {
  25. echo "<script>alert('Please fill all the fields, please try again!')</script>";
  26. echo "<script>window.open('insertAdmin.php', '_self')</script>";
  27. }
  28. }
  29.  
  30. <?php
  31. include("includes/db.php");
  32. include_once("includes/functions.php");
  33. if(isset($_POST['insertNewAdmin'])) {
  34. $username = $_POST['adminUsername'];
  35. $password = $_POST['adminPassword'];
  36. $firstname = $_POST['adminFirstname'];
  37. $lastname = $_POST['adminLastname'];
  38. $birthday = $_POST['adminBirthday'];
  39. $gender = $_POST['adminGender'];
  40. $civilstatus = $_POST['adminCivilstatus'];
  41. $contactno = $_POST['adminContactno'];
  42. $address = $_POST['adminAddress'];
  43. $object = new Functions();
  44. $object->InsertAdmin($username,$password,$firstname,$lastname,$birthday,$gender,$civilstatus,$contactno,$address);
  45. }
  46. ?>
  47.  
  48. <div class="x_content">
  49. <br />
  50. <form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" method="POST" action="insertAdmin.php">
  51.  
  52. <div class="form-group">
  53. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="user-name">Username <span class="required">*</span>
  54. </label>
  55. <div class="col-md-6 col-sm-6 col-xs-12">
  56. <input type="text" id="user-name" name="adminUsername" required="required" class="form-control col-md-7 col-xs-12">
  57. </div>
  58. </div>
  59. <div class="form-group">
  60. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="pass-word">Password <span class="required">*</span>
  61. </label>
  62. <div class="col-md-6 col-sm-6 col-xs-12">
  63. <input type="text" id="pass-word" name="adminPassword" required="required" class="form-control col-md-7 col-xs-12">
  64. </div>
  65. </div>
  66. <div class="form-group">
  67. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">First Name <span class="required">*</span>
  68. </label>
  69. <div class="col-md-6 col-sm-6 col-xs-12">
  70. <input type="text" id="first-name" name="adminFirstname" required="required" class="form-control col-md-7 col-xs-12">
  71. </div>
  72. </div>
  73. <div class="form-group">
  74. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="last-name">Last Name <span class="required">*</span>
  75. </label>
  76. <div class="col-md-6 col-sm-6 col-xs-12">
  77. <input type="text" id="last-name" name="adminLastname" required="required" class="form-control col-md-7 col-xs-12">
  78. </div>
  79. </div>
  80. <div class="form-group">
  81. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="birthday">Date of Birth <span class="required">*</span>
  82. </label>
  83. <div class="col-md-6 col-sm-6 col-xs-12">
  84. <input type="text" id="dateofbirth" name="adminBirthday" required="required" class="form-control col-md-7 col-xs-12">
  85. </div>
  86. </div>
  87. <!-- <div class="form-group">
  88. <label class="control-label col-md-3 col-sm-3 col-xs-12">Date Of Birth <span class="required">*</span>
  89. </label>
  90. <div class="col-md-6 col-sm-6 col-xs-12">
  91. <input id="birthday" class="date-picker form-control col-md-7 col-xs-12" name="adminBirthday" required="required" type="text">
  92. </div>
  93. </div> -->
  94. <div class="form-group">
  95. <label class="control-label col-md-3 col-sm-3 col-xs-12">Gender</label>
  96. <div class="col-md-6 col-sm-6 col-xs-12">
  97. <div id="gender" class="btn-group" data-toggle="buttons">
  98. <label class="btn btn-default" data-toggle-class="btn-primary" data-toggle-passive-class="btn-default">
  99. <input type="radio" name="adminGender" value="male"> &nbsp; Male &nbsp;
  100. </label>
  101. <label class="btn btn-primary" data-toggle-class="btn-primary" data-toggle-passive-class="btn-default">
  102. <input type="radio" name="adminGender" value="female"> Female
  103. </label>
  104. </div>
  105. </div>
  106. </div>
  107. <div class="form-group">
  108. <label class="control-label col-md-3 col-sm-3 col-xs-12">Civil Status</label>
  109. <div class="col-md-6 col-sm-6 col-xs-12">
  110. <div id="civilstatus" class="btn-group" data-toggle="buttons">
  111. <label class="btn btn-default" data-toggle-class="btn-primary" data-toggle-passive-class="btn-default">
  112. <input type="radio" name="adminCivilstatus" value="single"> &nbsp; Single &nbsp;
  113. </label>
  114. <label class="btn btn-primary" data-toggle-class="btn-primary" data-toggle-passive-class="btn-default">
  115. <input type="radio" name="adminCivilstatus" value="married"> Married
  116. </label>
  117. <label class="btn btn-default" data-toggle-class="btn-primary" data-toggle-passive-class="btn-default">
  118. <input type="radio" name="adminCivilstatus" value="divorced"> Divorced
  119. </label>
  120. <label class="btn btn-primary" data-toggle-class="btn-primary" data-toggle-passive-class="btn-default">
  121. <input type="radio" name="adminCivilstatus" value="widowed"> Widowed
  122. </label>
  123. </div>
  124. </div>
  125. </div>
  126. <div class="form-group">
  127. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="contact-number">Contact Number <span class="required">*</span>
  128. </label>
  129. <div class="col-md-6 col-sm-6 col-xs-12">
  130. <input type="text" id="contact-number" name="adminContactno" required="required" class="form-control col-md-7 col-xs-12">
  131. </div>
  132. </div>
  133. <div class="form-group">
  134. <label class="control-label col-md-3 col-sm-3 col-xs-12" for="address">Address <span class="required">*</span>
  135. </label>
  136. <div class="col-md-6 col-sm-6 col-xs-12">
  137. <input type="text" id="address" name="adminAddress" required="required" class="form-control col-md-7 col-xs-12">
  138. </div>
  139. </div>
  140. <div class="ln_solid"></div>
  141. <div class="form-group">
  142. <div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
  143. <input type="submit" class="btn btn-danger" value="Cancel">
  144. <input type="submit" class="btn btn-success" value="Submit" name="insertNewAdmin">
  145. </div>
  146. </div>
  147.  
  148. </form>
  149. </div>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!