Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(isset($_POST['submit']));
- {
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "data";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $name = $_POST['studentname'];
- $fname = $_POST['fathername'];
- $pdadd = $_POST['paddress'];
- $psadd = $_POST['personaladdress'];
- $sex = $_POST['sex'];
- $city = $_POST['city'];
- $course = $_POST['course'];
- $district = $_POST['district'];
- $state = $_POST['state'];
- $pincode = $_POST['pincode'];
- $emailid = $_POST['emailid'];
- $dob = $_POST['dob'];
- $mobileno = $_POST['mobileno'];
- $sql = "INSERT INTO student_form (name, father_name, postal_address, personal_address, sex, city, course, district, state, pincode, email_id, dob, mobile_no)
- VALUES ('$name','$fname', '$pdadd', '$psadd', '$sex', '$city', '$course', '$district', '$state', '$pincode', '$emailid', '$dob', '$mobileno')";
- if ($conn->query($sql) === TRUE) {
- echo "New record created successfully";
- } else
- {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- ?>
- <html>
- <head>
- <title>Student Registration Form</title>
- </head>
- <body>
- <form action="" method="post" name="StudentRegistration" >
- <table cellpadding="2" width="20%" bgcolor="99FFFF" align="center"
- cellspacing="2">
- <tr>
- <td colspan=2>
- <center><font size=4><b>Student Registration Form</b></font></center>
- </td>
- </tr>
- <tr>
- <td>Name</td>
- <td><input type="text" name="studentname" id="studentname" size="30"></td>
- </tr>
- <tr>
- <td>Father Name</td>
- <td><input type="text" name="fathername" id="fathername"
- size="30"></td>
- </tr>
- <tr>
- <td>Postal Address</td>
- <td><input type="text" name="paddress" id="paddress" size="30"></td>
- </tr>
- <tr>
- <td>Personal Address</td>
- <td><input type="text" name="personaladdress"id="personaladdress" size="30">
- </td>
- </tr>
- <tr>
- <td>Sex</td>
- <td>
- <input type="radio" name="sex" value="male" size="10">Male
- <input type="radio" name="sex" value="Female" size="10">Female
- </td>
- </tr>
- <tr>
- <td>City</td>
- <td>
- <select name="city">
- <option value="-1" selected>select..</option>
- <option value="New Delhi">NEW DELHI</option>
- <option value="Mumbai">MUMBAI</option>
- <option value="Goa">KHARAR</option>
- <option value="Patna">CHANDIGARH</option>
- </select></td>
- </tr>
- <tr>
- <td>Course</td>
- <td><select name="course">
- <option value="-1" selected>select..</option>
- <option value="B.Tech">B.TECH</option>
- <option value="MCA">MCA</option>
- <option value="MBA">MBA</option>
- <option value="BCA">BCA</option>
- </select></td>
- </tr>
- <tr>
- <td>District</td>
- <td><select name="district">
- <option value="-1" selected>select..</option>
- <option value="Nalanda">NALANDA</option>
- <option value="UP">UP</option>
- <option value="Goa">MOHALI</option>
- <option value="Patna">PATNA</option>
- </select></td>
- </tr>
- <tr>
- <td>State</td>
- <td><select Name="state">
- <option value="-1" selected>select..</option>
- <option value="New Delhi">NEW DELHI</option>
- <option value="Mumbai">MUMBAI</option>
- <option value="Goa">PUNJAB</option>
- <option value="Bihar">BIHAR</option>
- </select></td>
- </tr>
- <tr>
- <td>PinCode</td>
- <td><input type="text" name="pincode" id="pincode" size="30"></td>
- </tr>
- <tr>
- <td>EmailId</td>
- <td><input type="text" name="emailid" id="emailid" size="30"></td>
- </tr>
- <tr>
- <td>DOB</td>
- <td><input type="text" name="dob" id="dob" size="30"></td>
- </tr>
- <tr>
- <td>MobileNo</td>
- <td><input type="text" name="mobileno" id="mobileno" size="30"></td>
- </tr>
- <tr>
- <td>
- <input type="reset">
- </td>
- <td colspan="2">
- <input type="submit" name="name" value="Submit Form" />
- </td>
- </tr>
- </table>
- </form>
- <table border="1" width="80">
- <tr>
- <td>Name</td>
- <td>Fathers Name</td>
- <td>Postal Address</td>
- <td>Personal Address</td>
- <td>Sex</td>
- <td>City</td>
- <td>Course</td>
- <td>District</td>
- <td>State</td>
- <td>Pincode</td>
- <td>Email id</td>
- <td>D.O.B</td>
- <td>Mobile no</td>
- </tr>
- <?php $sql = "SELECT * FROM `student_form` "; $result = $conn->query($sql);
- if ($result->num_rows > 0)
- {
- // output data of each row
- while($row = $result->fetch_assoc())
- {
- ?>
- <tr>
- <td><?php echo $row['name']; ?></td>
- <td><?php echo $row['father_name']; ?></td>
- <td><?php echo $row['postal_address']; ?></td>
- <td><?php echo $row['personal_address']; ?></td>
- <td><?php echo $row['sex']; ?></td>
- <td><?php echo $row['city']; ?></td>
- <td><?php echo $row['course']; ?></td>
- <td><?php echo $row['district']; ?></td>
- <td><?php echo $row['state']; ?></td>
- <td><?php echo $row['pincode']; ?></td>
- <td><?php echo $row['email_id']; ?></td>
- <td><?php echo $row['dob']; ?></td>
- <td><?php echo $row['mobile_no']; ?></td>
- </tr>
- <?php }?>
- </table>
- <?php
- } else {
- echo "0 results";
- }
- $conn->close();
- }?>
- </body>
- </html>
Add Comment
Please, Sign In to add comment