Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!doctype html>
- <html>
- <head>
- <title> question 4</title>
- <link rel="stylesheet" type="text/css" href="4q.css">
- <script src="javascript.js" ></script>
- </head>
- <body>
- <form onsubmit="f1()" name ="myform" >
- <div id="obox">
- <table border="1" >
- <tr >
- <th width="55%">Name</th>
- <th width="45%">Value</th>
- </tr>
- <tr>
- <td>Name</td>
- <td> <input type="text" name="name"> </td>
- </tr>
- <tr>
- <td>Sex</td>
- <td> <input type="radio" name="gender" value="Male" id="check3" >Male<br />
- <input type="radio" name="gender" value="Female" id="check4" >Female </td>
- </tr>
- <tr>
- <td>Eye colour</td>
- <td> <input type="checkbox" value="a" name="over6" id="check1">Over 6 Feet Tall<br />
- <input type="checkbox" value="b" name="over200" id="check2">Over 200 Pounds </td>
- </tr>
- <tr>
- <td colspan="2">Describe your athletic ability<br />
- <textarea name="txtarea" rows="4" cols="50"></textarea>
- </td>
- </tr>
- <tr>
- <td colspan="2"><span id="apple"><input type="submit" value="enter my information"></span></td>
- </tr>
- </table>
- </div>
- </form>
- </body>
- </html>
- CSS
- table{
- border:3px solid grey;
- }
- tr,th,td{
- border:2px solid grey;
- }
- #apple{
- position:relative;
- left:100px;
- }
- JAVASCRIPT
- function f1()
- {
- var x=document.forms["myform"]["name"].value;
- if(x == "")
- {
- alert("name must be filled");
- return false;
- }
- if((document.getElementById("check3").checked==false) &&(document.getElementById("check4").checked==false))
- {
- alert("pls pls check the gender box");
- return false;
- }
- if((document.getElementById("check1").checked==false) &&(document.getElementById("check2").checked==false))
- {
- alert("pls pls check the box");
- return false;
- }
- var y=document.forms["myform"]["txtarea"].value;
- if(y == "")
- {
- alert("textarea must be filled");
- return false;
- }
- }
- PHP
- <?php
- $servername = "scse";
- $username = "scse";
- $password = "scse";
- $var1=$_POST['fromplace']; use double quotes
- $var2=$_POST['toplace'];
- $var3=$_POST['doj'];
- $conn = new mysqli($servername, $username, $password);
- $sql = "INSERT INTO MyGuests (firstname, lastname, email)
- VALUES ('John', 'Doe', 'john@example.com')"; use single quotes with variable name
- $conn->query($sql); /*inserting is done*/
- /*select statements*/
- $sql = "SELECT id, firstname, lastname FROM MyGuests";
- $result = $conn->query($sql);
- if ($result->num_rows > 0)
- {
- // output data of each row
- while($row = $result->fetch_assoc())
- {
- echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
- }
- }
- $conn->close();
- ?>
Add Comment
Please, Sign In to add comment