<?php
//$connection = mysqli_connect("localhost","root","");
//$db = mysqli_select_db($connection, 'phpcrud');
$connection = mysqli_connect("analogdepat.mysql.db","analogdepat","Un92pac007");
$db = mysqli_select_db($connection, 'analogdepat');
if(isset($_POST['insertdata']))
{
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$course = $_POST['course'];
$contact = $_POST['contact'];
$query = "INSERT INTO student (`fname`,`lname`,`course`,`contact`) VALUES ('$fname','$lname','$course','$contact')";
$query_run = mysqli_query($connection, $query);
if($query_run)
{
echo '<script> alert("Data Saved"); </script>';
header('Location: index.php');
}
else
{
echo '<script> alert("Data Not Saved"); </script>';
}
}
?>