Advertisement
Guest User

Untitled

a guest
Oct 3rd, 2016
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.13 KB | None | 0 0
  1. I am trying to edit form values in php. Here is my html code of the form.
  2.  
  3. <?php
  4. $connect = mysqli_connect("localhost", "root", "", "epanel");
  5. $id=$_POST['search'];
  6.  
  7.  
  8. $sql = "SELECT * FROM university WHERE uno= '$id'";
  9. $results1=mysqli_query($connect,$sql);
  10. while($ro=mysqli_fetch_array($results1))
  11. {
  12. $id=$ro[0];
  13. $name=$ro[1];
  14. $phone=$ro[2];
  15. $email=$ro[3];
  16. $address=$ro[4];
  17. $state=$ro[5];
  18. $pincode=$ro[6];
  19. }
  20. ?>
  21.  
  22. <html>
  23.  
  24. <body>
  25. <h1 style="color:black;"><u>Change University Details</u></h1></br>
  26. <form method="post" id="registration_form" action="uedit/enft">
  27. <table >
  28. </br>
  29.  
  30. <tr>
  31.  
  32. <td><input type="hidden" id="uid" name="uid" value="<?php echo "$id" ?>" size="30"/> <span id="j" /></span></td>
  33. </tr>
  34.  
  35. <tr>
  36. <td><label for="uname"> Name</label></td>
  37. <td><input type="text" id="name" name="uname" value="<?php echo "$name" ?>" size="30"/> <span id="n" /></span></td>
  38. </tr>
  39.  
  40.  
  41. <tr>
  42. <td><label for="uphone">Phone_no</label></td>
  43. <td><input type="text" name="uphone" id="phn" value="<?php echo "$phone" ?>" size="30" width="20%"><span id="p" /></span></td>
  44.  
  45. </tr>
  46.  
  47. <tr >
  48. <td><label for="uemail">Email_Id</td>
  49. <td><input type="text" name="uemail" id="emailid" value="<?php echo "$email" ?>" size="30"><span id="e" /></span></td>
  50. </label>
  51. </tr>
  52.  
  53.  
  54.  
  55. <tr>
  56. <td><label for="uaddress">Address</td>
  57. <td><input type="textarea" name="uaddress" id="add" value="<?php echo "$address" ?>" rows="10" cols="10"></textarea><span id="a"/></span></td>
  58. </tr>
  59.  
  60. <tr>
  61. <td><label for="ustate">State</td>
  62. <td><select name="ustate" required>
  63. <?php
  64. $servername = "localhost";
  65. $username = "root";
  66. $password = "";
  67. $dbname = "epanel";
  68. $conn = mysqli_connect($servername, $username, $password, $dbname);
  69. $query="SELECT stname from state";
  70. $res=mysqli_query($conn,$query);
  71. foreach($res as $r)
  72. {
  73. ?>
  74. <option value="<?php echo $r['stname']; ?>"><?php echo $r['stname'];?></option>
  75.  
  76. <?php
  77. }
  78. ?>
  79.  
  80. </select>
  81.  
  82. <span id="s" /></span></td>
  83. </tr>
  84.  
  85.  
  86. <tr>
  87. <td><label for="upincode">Pin_Code</td>
  88. <td><input type="text" name="upincode" id="pin" value="<?php echo "$pincode" ?>" size="30"><span id="k" /></span></td>
  89. </tr>
  90. <tr>
  91.  
  92.  
  93. <tr>
  94. <td><input type="submit" name="submit" value="UPDATE"></td>
  95. </tr>
  96. </table>
  97. </form>
  98. </body>
  99. </html>
  100.  
  101. Here is the js code. Validations are not working properly, the form is being submitted even after some form values are not correct.
  102.  
  103. <script>
  104.  
  105.  
  106.  
  107. $("#n").hide();
  108. $("#p").hide();
  109. $("#e").hide();
  110. $("#a").hide();
  111. $("#k").hide();
  112.  
  113.  
  114.  
  115. var name;
  116. var ph;
  117. var em;
  118. var a ;
  119. var pc;
  120.  
  121. $("#name").focusout(function() {
  122.  
  123. check_username();
  124.  
  125.  
  126. });
  127.  
  128. $("#phn").focusout(function() {
  129.  
  130. check_phone();
  131.  
  132. });
  133.  
  134. $("#emailid").focusout(function() {
  135.  
  136. check_email();
  137.  
  138.  
  139. });
  140.  
  141. $("#add").focusout(function() {
  142.  
  143. check_add();
  144.  
  145. });
  146.  
  147. $("#pin").focusout(function() {
  148.  
  149. check_pin();
  150.  
  151. });
  152.  
  153.  
  154. function check_username() {
  155.  
  156. var na= $("#name").val();
  157. var pat = new RegExp(/^[a-zA-Z ]+$/);
  158.  
  159. if(pat.test(na)) {
  160. $("#n").hide();
  161. name=false;
  162.  
  163.  
  164. } else {
  165.  
  166. $("#n").html("Invalid name");
  167. $("#n").show();
  168. name = true;
  169.  
  170. }
  171.  
  172. return name;
  173.  
  174.  
  175. }
  176.  
  177. function check_phone() {
  178.  
  179. var pho= $("#phn").val();
  180. var pat = new RegExp(/^[0-9]{8,11}$/);
  181.  
  182. if(pat.test(pho)) {
  183. $("#p").hide();
  184. ph = false;
  185.  
  186.  
  187. } else {
  188.  
  189. $("#p").html("Invalid Phone");
  190. $("#p").show();
  191. ph = true;
  192.  
  193. }
  194. return ph;
  195.  
  196. }
  197.  
  198. function check_email() {
  199.  
  200. var pattern = new RegExp(/^[+a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,4}$/i);
  201.  
  202. if(pattern.test($("#emailid").val())) {
  203. $("#e").hide();
  204. em = false;
  205.  
  206. } else {
  207. $("#e").html("Invalid email address");
  208. $("#e").show();
  209. em = true;
  210.  
  211. }
  212. return em;
  213.  
  214. }
  215.  
  216. function check_add() {
  217.  
  218. var au = $("#add").val();
  219. var pat = new RegExp(/^[0-9a-zA-Z,/ -]+$/);
  220.  
  221. if(pat.test(au)) {
  222. $("#a").hide();
  223. a = false;
  224. return a;
  225.  
  226. } else {
  227. $("#a").html("Invalid address");
  228. $("#a").show();
  229. a = true;
  230.  
  231. }
  232. return a;
  233.  
  234. }
  235.  
  236. function check_pin() {
  237.  
  238. var pho= $("#pin").val();
  239. var pat = new RegExp(/^[1-9][0-9]{5}$/);
  240.  
  241. if(pat.test(pho)) {
  242. $("#k").hide();
  243. pc = false;
  244.  
  245. } else {
  246.  
  247. $("#k").html("Invalid Pincode");
  248. $("#k").show();
  249. pc = true;
  250.  
  251. }
  252. return pc;
  253. }
  254.  
  255. $("#registration_form").submit(function() {
  256.  
  257.  
  258.  
  259. var ne=check_username();
  260.  
  261.  
  262. var pe=check_phone();
  263.  
  264. var eme=check_email();
  265.  
  266. var ad=check_add();
  267.  
  268.  
  269. var che=check_pin();
  270.  
  271.  
  272.  
  273.  
  274. if (ne === 'false' && pe==='false' && eme==='false' && ad==='false' && che==='false')
  275. {
  276.  
  277. return true;
  278. }
  279.  
  280. else
  281.  
  282. {
  283.  
  284. return false;
  285.  
  286. }
  287.  
  288.  
  289.  
  290.  
  291.  
  292.  
  293. });
  294.  
  295.  
  296.  
  297.  
  298. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement