Membuat tombol aktifkan/nonaktifkan menggunakan PHP dan MySQL

<?php

 

    

    $con = mysqli_connect("localhost","root","","courses");

 

    

    

    

    $sql = "SELECT * FROM `courses`";

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

    $All_courses = mysqli_fetch_all($Sql_query,MYSQLI_ASSOC);

?>

 

<!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">

    

    <!-- Using internal/embedded css -->

    <style>

        .btn{

            background-color: red;

            border: none;

            color: white;

            padding: 5px 5px;

            text-align: center;

            text-decoration: none;

            display: inline-block;

            font-size: 20px;

            margin: 4px 2px;

            cursor: pointer;

            border-radius: 20px;

        }

        .green{

            background-color: #199319;

        }

        .red{

            background-color: red;

        }

        table,th{

            border-style : solid;

            border-width : 1;

            text-align :center;

        }

        td{

            text-align :center;

        }

    </style>    

</head>

 

<body>

    <h2>Courses Table</h2>

    <table>

        <!-- TABLE TOP ROW HEADINGS-->

        <tr>

            <th>Course Name</th>

            <th>Course Status</th>

            <th>Toggle</th>

        </tr>

        <?php

 

            

            foreach ($All_courses as $course) { ?>

            <tr>

                <td><?php echo $course['Course_name']; ?>

                <td><?php 

                        

                        

                        

                        

                        if($course['status']=="1"

                            echo "Active";

                        else

                            echo "Inactive";

                    ?>                          

                </td>

                <td>

                    <?php 

                    if($course['status']=="1"

 

                        

                        

                        

                        

                        

                        

                        

                        echo

"<a href=deactivate.php?id=".$course['id']." class="btn red">Deactivate</a>";

                    else

                        echo

"<a href=activate.php?id=".$course['id']." class="btn green">Activate</a>";

                    ?>

            </tr>

           <?php

                }

                

           ?>

    </table>

</body>

 

</html>