php - 我想更新我的数据库

问题描述

1-现在我已经在我的数据库上添加了一些文本，然后我想更新我的数据库

有人可以帮助我吗？我希望有一个人可以帮助我

<?php
       mysqli_query($db,"INSERT INTO tasks (task,status) 
       VALUES ('$task','$status')");
       header('location:SIMPLE.PHP');
       }
         }
             if (isset($_GET['check_selected'])) {
                foreach ($_GET['check_selected'] as $key => $value) {
               $row = mysqli_query($db,"DELETE FROM tasks WHERE id  =  
            $value;") or die(mysqli_error($db));
          }
               }
                $tasks = mysqli_query($db,"SELECT * FROM tasks ORDER BY id DESC");
             ?>

  <!DOCTYPE html>
      <html>
   <body>

            <form method="GET" action="SIMPLE.PHP">
             <input type="text" name="search" class="status_input" placeholder="TEXT" /> 

                    <input id='textbox' type='checkbox' value='1' name='status'>

                    <button type="submit" class="add_btn" name="submit">Add</button>                                         
                      <p><?php echo $errors; ?></p>
                     </form>                
              <form action="SIMPLE.PHP" method="GET">

               <tbody>
                   <tr>  
             <p><button type="submit" class="btn btn-success" name="save">DELETE</button></p>
       <?php
           foreach ($rows as $row_id  => $row)
       {
       ?>  
                    <input name="check_selected[]" type="checkbox"  value=<?php echo $row['id'];?>"/>
          <input name = "checkbox[]" type="checkbox"  id="checkbox[]" value="<?php echo     $row['status'];?>" 

                 <?PHP if($row['status']){echo 'checked';
                 }   
                 ?>
              >
              <td class= "task"><?php echo $row['task']?></td>
          <?PHP
           }
          ?>
          </tr>      
          </tbody>
         </form>
        </body>
     </html>

标签： phpdatabasesql-update

php - 我想更新我的数据库

问题描述

解决方案

推荐阅读