Advertisement
mfn

NSS DB

mfn
Aug 9th, 2013
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.69 KB | None | 0 0
  1. <div id="NSSdbmain">
  2. <form action="" method="POST" name="NSSdb" enctype="multipart/form-data">
  3. <div class="textName">First Name:</div>
  4. <input class="writePlace" tabindex="1" placeholder="First Name" autocomplete=​"off" type="text" name="fname" id="fname"  autofocus="autofocus">
  5. <div class="textName">Last Name:</div>
  6. <input class="writePlace" tabindex="2" placeholder="Last Name" autocomplete=​"off" type="text" name="lname" id="lname">
  7. <div class="textName">Father's Name:</div>
  8. <input class="writePlace" tabindex="3" placeholder="Father's Name" autocomplete=​"off" type="text" name="fathername" id="fathername">
  9. <div class="textName">Class:</div>
  10. <select class="SelectextName" tabindex="4" name="classname" id="classname">
  11. <option value="Select a class." selected="selected" >Select a class.</option>
  12. <option value="B.Com">B.Com</option>
  13. <option value="B.Sc">B.Sc</option>
  14. <option value="B.A">B.A</option>
  15. <option value="BBA">BBA</option>
  16. <option value="BCA">BCA</option>
  17. </select>
  18. <div class="textName">Section:</div>
  19. <div id="selsection">
  20. <select class="SelectextName" tabindex="5" name="unsection" id="unsection">
  21. <option value="Select Class First">Select Class First</option>
  22. </select>
  23. </div>
  24. <div id="NoSection">
  25. <select class="SelectextName" tabindex="5" name="nosection" id="nosection">
  26. <option value="-">-</option>
  27. </select>
  28. </div>
  29. <div id="bcomSec">
  30. <select class="SelectextName" tabindex="5" name="bcomsection" id="bcomsection">
  31. <?php
  32. include('./includes/BcomSection.php');
  33. ?>
  34. </select>
  35. </div>
  36. <div id="bscSec">
  37. <select class="SelectextName" tabindex="5" name="bscsection" id="bscsection">
  38. <?php
  39. include('./includes/BscSection.php');
  40. ?>
  41. </select>
  42. </div>
  43. <div class="textName">Year:</div>
  44. <div id="selcyear">
  45. <select class="SelectextName" tabindex="6" name="selyear" id="selyear" style="width: 180px">
  46. <option value="Select Sub Section First">Select Sub Section First</option>
  47. </select>
  48. </div>
  49. <div id="ClassYear">
  50. <select class="SelectextName" tabindex="6" name="cyear" id="cyear">
  51. <option value="Ist Year">Ist Year</option>
  52. <option value="IInd Year">IInd Year</option>
  53. <option value="IIIrd Year">IIIrd Year</option>
  54. </select>
  55. </div>
  56. <div class="textName">Roll No:</div>
  57. <input class="writePlace" tabindex="7" placeholder="Roll No" autocomplete=​"off" type="text" name="rollno" id="rollno">
  58. <div class="textName">Gender:</div>
  59. <select class="SelectextName" tabindex="8" name="gender" id="gender">
  60. <option value="Male">Male</option>
  61. <option value="Female">Female</option>
  62. </select>
  63. <div class="textName">Mobile:</div>
  64. <input class="writePlace" tabindex="9" placeholder="9876543210" autocomplete=​"off" type="text" name="mobile" id="mobile">
  65. <div class="textName">Family Category:</div>
  66. <select class="SelectextName" tabindex="10" name="fcategory" id="fcategory">
  67. <option value="GEN">General</option>
  68. <option value="SC">SC</option>
  69. <option value="ST">ST</option>
  70. <option value="OBC">OBC</option>
  71. </select>
  72. <div class="textName">Blood Group:</div>
  73. <select class="SelectextName" tabindex="11" name="bloodg" id="bloodg">
  74. <option value="A+">A+</option>
  75. <option value="A-">A-</option>
  76. <option value="AB+">AB+</option>
  77. <option value="AB-">AB-</option>
  78. <option value="B+">B+</option>
  79. <option value="B-">B-</option>
  80. <option value="O+">O+</option>
  81. <option value="O-">O-</option>
  82. </select>
  83.  
  84. <!-- div class="textName">Literacy:</div -->
  85. <!-- input class="writePlace" tabindex="1" placeholder="Literacy" autocomplete=​"off" type="text" name="literacy" id="literacy" -->
  86. <!-- div class="textName">Survey:</div -->
  87. <!-- input class="writePlace" tabindex="1" placeholder="Survey" autocomplete=​"off" type="text" name="survey" id="survey" -->
  88. <input class="SubmitMain" tabindex="12" align="center" type="submit" onclick="return ValidateForm ();" name="NSSdbSubmit" value="Submit"/>
  89. </form>
  90. </div>
  91.  
  92. <?php
  93. include("./includes/mySQL.php");
  94.  
  95. if (isset($_REQUEST['NSSdbSubmit'])) {
  96. switch ($_REQUEST['NSSdbSubmit']) {
  97. case 'Submit':
  98. $fname = $_POST['fname'];
  99. $lname = $_POST['lname'];
  100. $fathername = $_POST['fathername'];
  101. $classname = $_POST['classname'];
  102. $section = $_POST[''];
  103. $cyear = $_POST['cyear'];
  104. $rollno = $_POST['rollno'];
  105. $gender = $_POST['gender'];
  106. $mobile = $_POST['mobile'];
  107. $fcategory = $_POST['fcategory'];
  108. $bloodg = $_POST['bloodg'];
  109.  
  110. if($_POST['NSSdbSubmit']=='Submit')
  111.  
  112. $sql = "INSERT into $tbl_name (fname,lname,fathername,classname,section,cyear,rollno,gender,mobile,fcategory,bloodg) values('".$fname."','".$lname."','".$fathername."','".$classname."','".$section."','".$cyear."','".$rollno."','".$gender."','".$mobile."','".$fcategory."','".$bloodg."')";
  113. $result=mysql_query($sql) or die(mysql_error());
  114. echo "Database inserted successfully.";
  115. return true;
  116. }
  117. };
  118. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement