Guest User

Untitled

a guest
May 2nd, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.60 KB | None | 0 0
  1. <!doctype html>
  2. <html>
  3. <head>
  4. <title> question 4</title>
  5. <link rel="stylesheet" type="text/css" href="4q.css">
  6. <script src="javascript.js" ></script>
  7. </head>
  8.  
  9. <body>
  10.  
  11. <form onsubmit="f1()" name ="myform" >
  12. <div id="obox">
  13. <table border="1" >
  14. <tr >
  15. <th width="55%">Name</th>
  16. <th width="45%">Value</th>
  17. </tr>
  18.  
  19. <tr>
  20. <td>Name</td>
  21. <td> <input type="text" name="name"> </td>
  22. </tr>
  23.  
  24. <tr>
  25. <td>Sex</td>
  26. <td> <input type="radio" name="gender" value="Male" id="check3" >Male<br />
  27. <input type="radio" name="gender" value="Female" id="check4" >Female </td>
  28. </tr>
  29.  
  30. <tr>
  31. <td>Eye colour</td>
  32. <td> <input type="checkbox" value="a" name="over6" id="check1">Over 6 Feet Tall<br />
  33. <input type="checkbox" value="b" name="over200" id="check2">Over 200 Pounds </td>
  34. </tr>
  35. <tr>
  36. <td colspan="2">Describe your athletic ability<br />
  37. <textarea name="txtarea" rows="4" cols="50"></textarea>
  38. </td>
  39. </tr>
  40.  
  41. <tr>
  42. <td colspan="2"><span id="apple"><input type="submit" value="enter my information"></span></td>
  43. </tr>
  44. </table>
  45. </div>
  46. </form>
  47. </body>
  48. </html>
  49.  
  50. CSS
  51. table{
  52. border:3px solid grey;
  53. }
  54. tr,th,td{
  55. border:2px solid grey;
  56. }
  57. #apple{
  58. position:relative;
  59. left:100px;
  60. }
  61.  
  62. JAVASCRIPT
  63. function f1()
  64. {
  65. var x=document.forms["myform"]["name"].value;
  66. if(x == "")
  67. {
  68. alert("name must be filled");
  69. return false;
  70. }
  71.  
  72. if((document.getElementById("check3").checked==false) &&(document.getElementById("check4").checked==false))
  73. {
  74. alert("pls pls check the gender box");
  75. return false;
  76. }
  77.  
  78. if((document.getElementById("check1").checked==false) &&(document.getElementById("check2").checked==false))
  79. {
  80. alert("pls pls check the box");
  81. return false;
  82. }
  83.  
  84.  
  85. var y=document.forms["myform"]["txtarea"].value;
  86. if(y == "")
  87. {
  88. alert("textarea must be filled");
  89. return false;
  90. }
  91. }
  92.  
  93. PHP
  94.  
  95. <?php
  96. $servername = "scse";
  97. $username = "scse";
  98. $password = "scse";
  99.  
  100. $var1=$_POST['fromplace']; use double quotes
  101. $var2=$_POST['toplace'];
  102. $var3=$_POST['doj'];
  103.  
  104.  
  105. $conn = new mysqli($servername, $username, $password);
  106.  
  107. $sql = "INSERT INTO MyGuests (firstname, lastname, email)
  108. VALUES ('John', 'Doe', 'john@example.com')"; use single quotes with variable name
  109.  
  110. $conn->query($sql); /*inserting is done*/
  111.  
  112. /*select statements*/
  113. $sql = "SELECT id, firstname, lastname FROM MyGuests";
  114. $result = $conn->query($sql);
  115. if ($result->num_rows > 0)
  116. {
  117. // output data of each row
  118. while($row = $result->fetch_assoc())
  119. {
  120. echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
  121. }
  122. }
  123.  
  124. $conn->close();
  125. ?>
Add Comment
Please, Sign In to add comment