Untitled

<?php
include ('msconnection.php');
?>
<!DOCTYPE html>
<html>
<head>
</head>
<body>

<div class="adjust">
<center><form class="greatForm" method="post" action="#">
<?php
$query = "SELECT id,Firstname,Lastname,attendance FROM attendance";

$result = sqlsrv_query($conn, $query);

while($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC))
{
    $_SESSION['id'] = $row['id'];
    $_SESSION['Firstname'] = $row['Firstname'];
    $_SESSION['Lastname'] = $row['Lastname'];
    $_SESSION['attendance'] = $row['attendance'];
?>

 <input type="checkbox" name="<?php echo $row['Firstname']; echo $row['Lastname']; ?>" id="<?php echo $row['id']; ?>" value="<?php echo $row['Lastname']; ?>"/>
    <label for="<?php echo $row['attendance']; ?>" >

<?php
}
 ?>

<center><br><br><input type="submit" class="button" style="width:10%;" value="SAVE" name="choose_extra"></center></br>
</form></center>
<?php

    if(isset($_POST['choose_extra']))
    {
        $id = $_SESSION['id'];
        $firstname =$_SESSION['Firstname'];
        $lastname =$_SESSION['Lastname'];
        $attendance = $_SESSION['attendance'];
        $sql = "INSERT INTO attendance(id,Firstname,Lastname,attendance) VALUES ('$id','$firstname','$lastname,'$attendance')";
        if ( ($insert = $conn1->query($sql)===false ))
        {
          echo "failed: ".$conn1->error."rn $sqlrn";
        }
        else
        {
            echo "Order SAVE.";
        }
    }
?>
</div>

</div>
</head>
<body>

Connection

<?php

$serverName = "RENZ_SD1SQLEXPRESS"; //serverNameinstanceName
$connectionInfo=array( "Database"=>"attendance", "UID"=>"sa", "PWD"=>"*******");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>
<?php
$hostname = "localhost";
$username = "root";
$password = "*******";
$database = "attendance";

//connection to the database
 $conn1 = mysqli_connect($hostname,$username,$password,$database)
 or die('Error connecting to MySQL server.');
?>

$sql = "INSERT INTO attendance(id,Firstname,Lastname,attendance) VALUES ('$id','$firstname','$lastname,'$attendance')";

$sql = "INSERT INTO attendance(id,Firstname,Lastname,attendance) VALUES ('$id','$firstname','$lastname','$attendance')";