You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

PHP不同代码段中访问数据库查询$row变量问题(已解决)

问题与解决方案

已解决

我正在开发一个模态框(modal),想要显示数据库中某条记录的数据,代码中的按钮用于打开该模态框。

原记录列表显示代码

$sql = "SELECT ID, eventName, evLocation, evDTime, evNotes, Approved FROM events WHERE CreaterId = '{$_SESSION["userid"]}' ORDER BY evLocation";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        global $row;
        while($row = $result->fetch_assoc()) {
            echo '<ul><li>Title: '.$row["eventName"].'</li><li>Location: '.$row["evLocation"].'</li><li>Time: '.$row["evDTime"].'</li><li>Details: '.$row["evNotes"].'</li><button id="myBtn">View</button><br></ul>';
        }
    } else {
        echo "<br>"."0 results";
    }

原模态框代码

<div id="myModal" class="modal">
    <div class="modal-content">
        <span class="close">&times;</span>
        <h1>Event</h1>
        <h4>Title: <?php echo $row["eventName"];?></h4>
        <h4>Address: </h4>
        <h4>Timing: </h4>
    </div>
</div>

请问如何将模态框中的$row["eventName"]与数据库查询结果关联起来?


修复方案

$sql = "SELECT ID, eventName, evLocation, evDTime, evNotes, Approved FROM events WHERE CreaterId = '{$_SESSION["userid"]}' ORDER BY evLocation";
        $result = $conn->query($sql);
        if ($result->num_rows > 0) {
            global $yourEvent;
            while($row = $result->fetch_assoc()) {
                $yourEvent = $row["eventName"];
                echo '<ul><li>Title: '.$row["eventName"].'</li><li>Location: '.$row["evLocation"].'</li><li>Time: '.$row["evDTime"].'</li><li>Details: '.$row["evNotes"].'</li><button id="myBtn">View</button><br></ul>';
                echo '<div id="myModal" class="modal"><div class="modal-content">
                <span class="close">&times;</span><h1>Event</h1>';
                echo '<h4>Title: '.$row["eventName"].'</h4>';
                echo '</div></div><script src="script.js"></script>';
            }
        } else {
            echo '<br>'."0 results";
        }

内容的提问来源于stack exchange,提问作者Ryan C

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.08.21 05:15:34