- <html>
- <head>
- <title>student</title>
- </head>
- <body>
- <?php
- if(isset($_POST['add']))
- {
- $dbhost='localhost';
- $dbuser='root';
- $dbpass='user@123';
- $dbname='testdb';
- $conn=mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
- if($conn->connect_error)
- {
- die("connection failed:".$conn->connect_error);
- }
- else
- {
- echo "connected sucessfully";
- }
- echo "<br>";
- echo "Database selected </br>";
- $roll_no=$_POST['roll_no'];
- $name=$_POST['name'];
- $marks=$_POST['marks'];
- $grades=$_POST['grades'];
- $sql="CREATE TABLE stud(roll_no int PRIMARY KEY,name varchar(20),marks int,grades varchar(20))";
- echo "</br>";
- if(mysqli_query($conn,$sql))
- {
- echo "New record entered successfully";
- }
- else
- {
- echo "error:",mysqli_error($conn);
- }
- }
- else{
- ?>
- <form method="post" action='<?php $_PHP_SELF ?>'>
- <table width="400" border="0" cellspacing="1" cellpadding="2">
- <tr>
- <td width="100"> ROLL NO</td>
- <td><input name="roll_no" type="text"></td>
- </tr>
- <tr>
- <td width="100"> NAME</td>
- <td><input name="name" type="text"></td>
- </tr>
- <tr>
- <td width="100"> MARKS</td>
- <td><input name="MARKS" type="text"></td>
- </tr>
- <tr>
- <td width="100"> GRADE</td>
- <td><input name="grades" type="text"></td>
- </tr>
- <tr>
- <td width="100"> </td>
- <td></td>
- </tr>
- <tr>
- <td width="100"> </td>
- <td><input name="add" type="submit" value="Add"></td>
- </tr>
- </table>
- </form>
- <?php
- }
- ?>
- </body>
- </html>