duanchi4184 2017-10-25 06:43
浏览 31
已采纳

在循环php7中的视图中访问对象方法

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) { ?>
    <tr>
        <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">
            <td>
                <input type="hidden" name="id" value="<?php echo $teamleader->id?>">
                <input type="submit" class="btn btn-default" name="edit" value="Edit">
            </td>
        </form>
        <form action="index.php" method="post">
            <td>
                <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?')">
            </td>
        </form>
    </tr>
    <?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:

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

    And the code with using ajax/jQuery is:

    $(document).ready(function(){
       $('.btn-delete').on('click',function(){
          var _this = $(this);
          var _teamleaderid = $(this).data('teamleaderid');
    
          if (!confirm('Are you sure you want to delete this team leader?')) return false;
          $.ajax(
              url:'delete.php',
              type:'post',
              data: {
                  teamleaderid: _teamleaderid
              },
              dataType:'json',
              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:

    <?php 
    ... #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);
    die();
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 综合布线实例设计,就好看好看不恐怖可好滤镜好聚
  • ¥15 使用moviepy库视频合并时出错
  • ¥30 FLUENT液固传质UDF
  • ¥15 怎么看梯度直方图以,怎么判断梯度消失/爆炸,怎么解决
  • ¥15 aspnetdll文件访问拒绝
  • ¥15 wpf中在模版中寻找元素
  • ¥15 MFC平台生成指定圆
  • ¥15 jmeter出现403
  • ¥500 求华为P30PRO手机硬盘数据恢复
  • ¥15 关于#vscode#的问题:ESP32开发板对接MQTT实现小灯泡的开关