savedata.php

<?php
//assigning value of users data from form
   $stu_name = $_POST['sname'];
   $stu_address = $_POST['saddress'];
   $stu_class = $_POST['selected'];
   $stu_phone = $_POST['sphone'];

   //creating connection
   $conn = new mysqli("localhost","root", "","crud");

   //incase connection failed show message and exit from php script
   if($conn->connect_error){
     die("Connection failed: ".$conn->connect_error());
 }
 
 
   //2nd step run sql query
   //inserting data from table to database 
   $sql = "INSERT INTO students (name,address,class,phone) VALUES ('{$stu_name}','{$stu_address}', '{$stu_class}','{$stu_phone}'); ";
   $result = $conn->query($sql);
 
//after saving user data to database redirecting user to add page
header("location: http://localhost/crud_project/index.php");

 
   //3rd step closing connection
   $conn->close();


   ?>