'updating sql with php

I need to be able to update my sql table from open to close task.

I already wrote code for this but it is not working properly. On the modal it shows 2 'continue' buttons and right now the task table contains two tasks. Can somebody help me?

This is what the modal looks like:

enter image description here

and this is my code:

<?php

if (isset($_POST["closetask"])) {

    $close_task_id = mysqli_real_escape_string($con, $_POST["close_task_id"]);
    $sql = "UPDATE task SET task_status='closed' WHERE id_task='$close_task_id'";
    $result = mysqli_query($con, $sql);
    if ($result) {
        $_SESSION['success'] = "Task closed";
        $_SESSION['text'] = "Task has been closed successfully";
        $_SESSION['icon'] = "success";
    } else {
        $_SESSION['success'] = "Error";
        $_SESSION['text'] = "Unkown error, please try again";
        $_SESSION['icon'] = "error";
    }
}

?>
<?php
$query = "SELECT * FROM task ORDER BY id_task DESC";
$result = mysqli_query($con, $query);
?>
<!-- reject button --> 
<form action="task-view.php" method="post" enctype="multipart/form-data">
<div id="rejectModal" class="modal fade" role="dialog" >
  <div class="modal-dialog modal-lg">
    <!-- Modal content-->
    <div class="modal-content">
      <div class="modal-header">
        <h4 class="modal-title">Close this task?</h4>
        <button type="button" class="close" data-dismiss="modal">&times;</button>
      </div>
      <div class="modal-body">

       <div class="d-flex align-items-center justify-content-center form-group" >
                <p class="align-items-center text-center" for="company">This button means closing the task. Are you sure you want to continue?</p>
            
       </div>
      
     </div>
      <div class="modal-footer">
      <?php
        while ($row = mysqli_fetch_array($result)) {

            if ($row['task_status'] == 'open'){
                $check_task = '
               
                    <input type="text" name="close_task_id" class="form-control" value="' . $row["id_task"] . '" hidden>
                    <button class="btn btn-success" type="submit" name="closetask"  class="btn btn-success">Continue</button>
                    
                    </button>
                    
                     ';
            }
            echo ' 
            <br>
            ' . $check_task . '  
            ';
         }
            ?>
       
      </div>
    </div>
  </div>
</div>
</div> 
</form>
<!-- end of reject button--> 
         <?php
    if (isset($_SESSION['success']) && $_SESSION['success'] != '') {
    ?>
        <script>
            swal({
                title: "<?php echo $_SESSION['success']; ?>",
                text: "<?php echo $_SESSION['text']; ?>",
                icon: "<?php echo $_SESSION['icon']; ?>",
                button: "OK",
            });
        </script>
    <?php
        unset($_SESSION['success']);
    }
    ?>
phpsqlbuttonmodal-dialog


Solution 1:[1]

Well, after going through your code snippet, I could see this query

$query = "SELECT * FROM task ORDER BY id_task DESC";
$result = mysqli_query($con, $query);

meaning this fetches all records in the task table, the two continue buttons you see are coming from the while loop

while ($row = mysqli_fetch_array($result)) {
  ....
}

it logically implies you have two records or rows in your database task table and all the records where retrieved from the table.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Apollos Geofrey

Related Questions