College db php

 <?php

$server_name="sql12.freesqldatabase.com";

$username="sql12738410";

$password="nS8SynW1uW";

$database_name="sql12738410";

$conn=mysqli_connect($server_name,$username,$password,$database_name);

//now check the connection

if(!$conn)

{

 die("Connection Failed:" . mysqli_connect_error());

}

if(isset($_POST['save'])) {

    $Name = isset($_POST['Name']) ? $_POST['Name'] : '';

    $Technology = isset($_POST['Technology']) ? $_POST['Technology'] : '';

    $Year = isset($_POST['Year']) ? $_POST['Year'] : '';

    $Roll_no = isset($_POST['Roll_no']) ? $_POST['Roll_no'] : '';

    $Phone = isset($_POST['Phone']) ? $_POST['Phone'] : '';

    $Message = isset($_POST['Message']) ? $_POST['Message'] : '';

    

    if($Name && $Technology && $Year && $Roll_no && $Phone && $Message) {

        $sql_query = "INSERT INTO collegecont (Name, Technology, Year, Roll_no, Phone, Message) 

                      VALUES ('$Name', '$Technology', '$Year', '$Roll_no', '$Phone', '$Message')";

        if (mysqli_query($conn, $sql_query)) {

            echo "Your Message Sent Successfully";

        } else {

            echo "Error: " . mysqli_error($conn);

        }

    } else {

        echo "Please fill in all fields.";

    }

    mysqli_close($conn);

}

msgtogct.tiiny.io