November 11, 2019November 11, 2019lifebix Datainsert into DataBase Html Form <!DOCTYPE html> <html> <head> <title>Form Example</title> </head> <body> <form action="form.php" method="POST"> <input type="text" name="username" placeholder="Enter User Name"/> <input type="number" name="pass" placeholder="Enter passWOrd"/> <button type="submit">Submit</button> </form> </body> </html> PHP Code For Inseert Data <?php //Html Values $studentName= $_POST['username']; $studentRollNum= $_POST['pass']; $serverName="localhost"; $userName="root"; $password=""; $dbName="batchfour"; //Create connection to Databse $conn=new MySqli("localhost",$userName,$password,$dbName); //Db COnnetion Checkig if($conn->connect_error){ die(“Checking error”.$conn->connect_error); } //Inserting Data $sql=”INSERT INTO studentinformation(std_name,std_reg_num) values(‘$studentName’,’$studentRollNum’)”; if($conn->query($sql)===true){ echo “New record created successfully”; } else { echo “Error: ” . $sql . “<br>” . $conn->error; } //COnnection CLose $conn->close(); ?>