tpk

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "bit2018";
$msg ='';
$std_id = $_GET['id'];
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

if(isset($_POST['updatebtn']))
{
    $std_fname  = $_POST['std_fname'];
    $std_lname = $_POST['std_lname'];
    $std_roll = $_POST['std_roll'];
    $std_contact = $_POST['std_contact'];
    $std_address = $_POST['std_address'];

    $sqlQuery = "UPDATE students SET std_fname='$std_fname', std_lname='$std_lname', std_roll='$std_roll', std_contact='$std_contact', std_address='$std_address' WHERE std_id='$std_id'";
    if(mysqli_query($conn,$sqlQuery))
    {
        $msg = "Information Updated Successfully";
    }
    else
    {
        $msg = "Problem in Updating Data";
    }
}


$selectQuery = "SELECT * FROM students WHERE std_id='$std_id'";
$result = mysqli_query($conn, $selectQuery);
$info = mysqli_fetch_assoc($result);

?>
<h1 style="color: green"><?php echo $msg; ?> </h1>
<fieldset>
    <legend>Student Update Form</legend>
    <form method="POST">
    <b>First Name: </b> <input type="text" value="<?php echo $info['std_fname']; ?>" name="std_fname" required>
    <hr>

    <b>Last Name: </b> <input type="text" value="<?php echo $info['std_lname']; ?>" name="std_lname" required>
    <hr>

    <b>Roll: </b> <input type="text" value="<?php echo $info['std_roll']; ?>" name="std_roll" required>
    <hr>

    <b>Contact: </b> <input type="text" name="std_contact" value="<?php echo $info['std_contact']; ?>" required>
    <hr>

    <b>Address: </b> <input type="text" name="std_address" value="<?php echo $info['std_address']; ?>" required>
    <hr>

    <button type="submit" name="updatebtn">Update</button>
    </form>
</fieldset>