dplht39359 2018-10-06 07:28
浏览 81
已采纳

如何在codeigniter中将jquery值传递给php模型函数

i need to pass jquery ID value in to my est_model->get_img() function in codeigniter and display all the content in the same modal box, i tried my own logic it doesn't work, please help guys, thank you in advance

here is my code below: modal a tag:

<a href="#view_all_img_modal" data-toggle="modal" data-est-id="<?php echo $row->est_id;?>">View all</a>

my jquery:

$('#view_all_images_modal').on('show.bs.modal', function(e) {
    var est_id = $(e.relatedTarget).data('est-id');
    $.ajax({url:"admin/est_view.php?ID="+est_id,cache:false,success:function(result){
        $("#view_all_img_modal").html(result);
    }});

});

modal box:

<div class="modal fade" id="view_all_img_modal" tabindex="-1" role="dialog">
<div class="row">
    <?php
        $id=$_GET['ID'];
            $est_img=$this->est_model->get_img($id);
            if($est_img):
                foreach ($est_img as $img):
                $ser_img=($img->img_name==NULL)?'no-image.png':$img->img_name;?>
                    <img src="<?php echo base_url('../public/images/rel_img/'.$ser_img);?>">
                <?php endforeach; 
            endif;?>
</div>
</div>

</div>
  • 写回答

1条回答 默认 最新

  • dpwdldgn43486 2018-10-06 07:39
    关注

    Your PHP file can't read the ID from GET request unless the modal box is in fact admin/est_view.php However I think I understand what u'r trying to do,

    STEP 1 :

    create a file called admin/est_view.php that contain just the php script that will extract the data from DB and the foreach clause to form html response, and don't forget it needs to connect to the database.

    Here's an example u can use or develop :

    <?php
        try{
            $pdo = new PDO("mysql:host=localhost;dbname=demo", "root", "passwd");
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        } catch(PDOException $e){
            die("ERROR: Could not connect. " . $e->getMessage());
        }
        try{
            if(isset($_REQUEST["ID"])){
                $sql = "SELECT * FROM images_table WHERE :ID";
                $stmt = $pdo->prepare($sql);
                $term = $_REQUEST["ID"] . '%';
                $stmt->bindParam(":ID", $term);
                $stmt->execute();
                if($stmt->rowCount() > 0){
                    while($row = $stmt->fetch()){
                        echo "<img src=\"" . $row["url"] . "\">";
                    }
                }
            }  
        } catch(PDOException $e){
            die("ERROR: Could not able to execute $sql. " . $e->getMessage());
        }
        unset($stmt);
        unset($pdo);
    ?>
    

    STEP 2 :

    Now you can use your own JS :

    $('#view_all_images_modal').on('show.bs.modal', function(e) {
        var est_id = $(e.relatedTarget).data('est-id');
        $.ajax({url:"admin/est_view.php?ID="+est_id,cache:false,success:function(result){
            $("#view_all_img_modal").html(result);
        }});
    
    });
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 Mapreduce是正常的,在运行其他jar包时并没有任何问题,只是在做LogCount.jar 时出的问题。如图所示
  • ¥15 ImportError: DLL load failed while importing _iterative: 找不到指定的模块。
  • ¥15 如何通过交互分析得出某高危患者对放疗获益更多
  • ¥15 相关性分析中,p<0.05, r=0.29,怎么评价相关性呢
  • ¥15 docker部署Mongodb后输入命令报错?
  • ¥15 将下列流程图转变成python程序代码
  • ¥15 我需要全国每个城市的最新小区名字等数据。
  • ¥15 开发一个小区生态的小程序
  • ¥15 如何解决Excel中dependent dropdown list 的问题
  • ¥15 MddBootstrapInitialize2失败