checked multiple values from Database



<?php

   include_once 'dbconnect.php';

   $id= $_GET['/'];

    $sql="select * from tbl_user where id={$id}";

    $result_set=mysqli_query($con,$sql);

    $count=mysqli_num_rows($result_set);

    if($count>0){

        $data=mysqli_fetch_assoc($result_set);

        $id=$data['id'];

        $name=$data['Name'];

        $fname=$data['Father'];

        $mobile=$data['Mobile'];

        $email=$data['Email'];

        $course=$data['Course'];

    

        

        $gender=$data['Gender'];

       $course = explode(',',$course);

       

         $gender=$data['Gender'];

    }


?>


<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Edit</title>

    <style>

    fieldset{

        background:aqua;


    }

    h1{

        color:blue;

    }

    legend{

        color:blue; 

        font-size:25px; 

    }

    a{

        font-size:28px;

        text-decoration:none;


        

        

    }

    a:hover{

        background:yellow;

    }

    

    </style>

</head>

<body><center>

    <h1>Edit</h1>

    

    <form action="" method="POST" enctype="multipart/form-data">

    <fieldset style="width:40%">

    <legend>Edit Here</legend>

    <p>Name:

    <input  type="hidden" value="<?php echo $id; ?>" name="id">

    <input type="text" name="name" value="<?php echo $name; ?>">

    </p>

    

    <p>

    Father Name:

    <input type="text" name="fname" value="<?php echo $fname;?>">

    </p>

    

    <p>

    Mobile Number:

    <input type="number" name="mobile" value="<?php echo $mobile;?>">

    </p>


    <p>

    Email:

    <input type="email" name="email" value="<?php echo $email;?>">

    </p>


    <p>

    Course:

    <?php

    //print_r($course);

  // Create checkboxes

 

  $course_arr = ['10th','12th','Diploma'];

  foreach($course_arr as $course_list){

    $bbb = "$course_list";

    

  $checked = "";

    if(in_array($bbb,$course)){

      $checked = "checked";

      


    }

    echo '<input type="checkbox" name="course1[]" value="'.$course_list.'" '.$checked.' >'.$course_list.'';


    

    

  }

  ?>



  

    </p>


    <p>

    Gender:

    Male<input type="radio" name="gender" <?php if(trim($gender)=="male"){echo "checked" ;}?> value="male" >

    Female<input type="radio" name="gender"<?php if(trim($gender)=="fimale"){echo "checked" ;}?> value="female">

    </p>

   <input type="submit" name="submit"  value="Submit">

       </fieldset>

    </form>

    </center>

</body>

</html>



Insert and Display checked multiple values from Database