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">×</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">×</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
相关产品推荐
相关产品推荐

