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

报告相同问题?

悬赏问题

  • ¥30 STM32 INMP441无法读取数据
  • ¥100 求汇川机器人IRCB300控制器和示教器同版本升级固件文件升级包
  • ¥15 用visualstudio2022创建vue项目后无法启动
  • ¥15 x趋于0时tanx-sinx极限可以拆开算吗
  • ¥500 把面具戴到人脸上,请大家贡献智慧
  • ¥15 任意一个散点图自己下载其js脚本文件并做成独立的案例页面,不要作在线的,要离线状态。
  • ¥15 各位 帮我看看如何写代码,打出来的图形要和如下图呈现的一样,急
  • ¥30 c#打开word开启修订并实时显示批注
  • ¥15 如何解决ldsc的这条报错/index error
  • ¥15 VS2022+WDK驱动开发环境