duanchi4184 2017-10-25 06:43
浏览 31


I'm pulling an array of objects from my database and iterating through them using PHP to display a table. Each result row of the table has the option of deleting that particular record from the database. Each row is also an object, and the object type has a method that will delete itself from the database.

The problem I'm having is thinking through how to get this to work in the view. Right now if you click the delete button, it sets a POST variable to "delete" and reloads the same page wherein a listener process detects the variable and initiates the delete via a hidden input that contains the records database id.

This is all well and good, but these are all objects. Shouldn't each object be able to access it's own methods? It seems the only barrier to this is the interplay between PHP script and HTML forms. My code is below. Ideally, when the delete button is pressed, that particular instance of the object teamleader can run its method teamleader->delete_team_leader().

        <?php foreach($teamleaders as $teamleader) { ?>
        <td><?php echo $teamleader->first_name; ?></td>
        <td><?php echo $teamleader->last_name; ?></td>
        <td><img src="<?php echo '../img/' . $teamleader->photo;?>" alt="" class="img-fluid tiny-tl-img"></td>
        <td><?php echo nl2br(substr($teamleader->bio, 0, 100));?>...</td>
        <td><?php echo $teamleader->url_name;?></td>
        <form action="index.php?a=edittl" method="post">
                <input type="hidden" name="id" value="<?php echo $teamleader->id?>">
                <input type="submit" class="btn btn-default" name="edit" value="Edit">
        <form action="index.php" method="post">
                <input type="hidden" value="<?php echo $teamleader->id?>" name="id">
                <input type="submit" class="btn btn-danger" name="delete" value="Delete" onclick="return confirm('Are you sure you want to delete this team leader?')">
    <?php } ?>
  • 写回答

1条回答 默认 最新

  • douturan1807 2017-10-25 07:32

    In your case, the best solution I think you can use ajax/jQuery for editing or deleting action. You don't need to use many forms as now.

    The code in front-end like this:

    <script src="jquery.min.js"></script>
    <?php foreach($teamleaders as $teamleader) { ?>
        <td><?php echo $teamleader->url_name;?></td>        
            <input type="submit" class="btn btn-default btn-edit" name="edit" value="Edit" data-teamleaderid="<?php echo $teamleader->id?>">
            <input type="submit" class="btn btn-danger btn-delete" name="delete" value="Delete" data-teamleaderid="<?php echo $teamleader->id?>">
    <?php } ?>

    And the code with using ajax/jQuery is:

          var _this = $(this);
          var _teamleaderid = $(this).data('teamleaderid');
          if (!confirm('Are you sure you want to delete this team leader?')) return false;
              data: {
                  teamleaderid: _teamleaderid
              success:function(data) {
                 if (data.return) {
                     $(_this).parent().parent().remove();/*Remove the current row in table html*/
                     alert('This teamleader has been deleted');

    The delete.php code in backend is:

    ... #connect database
    $teamleader_id = filter_input(INPUT_POST,'teamleader');
    $check_delete = $dbconn->query("DELETE from teamleader_table WHERE id={$teamleader_id}");
    print json_encode('return'=>$check_delete);
    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥15 全志v3s耳机音频输出口怎么外接功放
  • ¥15 华为ensp使用基本ACL限制公司网络访问
  • ¥15 帮我做下照片上的PLC题
  • ¥15 labview2022 使用modbus报缺少依赖?
  • ¥15 谷歌地图是不是不开通结算功能,api会使用不了哦
  • ¥15 unity腾讯云对象存储机型适配
  • ¥15 求全国交通咨询模拟代码,要求如下,可以完全在dev c++运行
  • ¥15 根据要求修改程序编码
  • ¥15 用 Python 做一个用 Excel 表导入的答题系统
  • ¥15 使用微信开发者工具实现一个“婚博会”小程序