我想用 PHP 在我的页面中按表显示一些数据库信息，有关更多信息，用户必须单击以获取更多信息...
我目前有这个代码：
<?php
$connection = new mysqli("localhost", "root", "", "simozar");
$sql = "SELECT * FROM customer";
$result = mysqli_query($connection, $sql);
if (mysqli_num_rows($result) > 0) {
echo "<table dir='rtl' class='table table-bordered'>
<tr>
<td>name</td>
<td>job</td>
<td>phone number</td>
</tr>";
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>
<td>$row[first_name] $row[last_name]</td>
<td>$row[job]</td>
<td>$row[phone_num]</td>
<td><button type='button' class='btn btn-info' data-
toggle='modal' data-target='#more_info'>show more info</button></td>
</tr>";
}
echo "</table>";
} else {
echo "no information";
}
$connection->close();
?>
<div id="more_info" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-body">
echo "<table dir='rtl' class='table table-bordered'>
<tr>
<td>name</td>
<td>job</td>
<td>phone number</td>
<td>home address</td>
<td>postal code</td>
<td>home phone number</td>
<td>date</td>
</tr>";
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>
<td>$row[first_name] $row[last_name]</td>
<td>$row[job]</td>
<td>$row[phone_num]</td>
<td>$row[home_address]</td>
<td>$row[postcode]</td>
<td>$row[home_phone_num]</td>
<td>$row[date]</td>
</tr>";
}
echo "</table>";
</div>
</div>
</div>
</div>
我的页面上有一个简单的表格，带有一个按钮(在这个表格中，我有一些来自表格的行(，我想通过单击一个按钮以模式显示这个表格中的所有行......
在使用 js 调用模式的情况下，您的id必须是唯一的。
试试这个：
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<!-- jQuery library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<?php
$connection = new mysqli("localhost", "root", "", "simozar");
$sql = "SELECT * FROM customer";
$result = mysqli_query($connection, $sql);
if (mysqli_num_rows($result) > 0) {
echo "<table dir='' class='table table-bordered'>
<tr>
<td>name</td>
<td>job</td>
<td>phone number</td>
</tr>";
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>
<td>$row[first_name] $row[last_name]</td>
<td>$row[job]</td>
<td>$row[phone_num]</td>
<td><button type='button' class='btn btn-info' data-toggle='modal' data-target='#more_info".$row['phone_num']."'>show more info</button></td>
</tr>";
$modal.="<div id='more_info".$row['phone_num']."' class='modal fade' role='dialog'>
<div class='modal-dialog'>
<div class='modal-content'>
<div class='modal-body'>
<table class='table table-bordered'>
<tr>
<td>name</td>
<td>job</td>
<td>phone number</td>
<td>home address</td>
<td>postal code</td>
<td>home phone number</td>
<td>date</td>
</tr><tr>
<td>$row[first_name] $row[last_name]</td>
<td>$row[job]</td>
<td>$row[phone_num]</td>
<td>$row[home_address]</td>
<td>$row[postcode]</td>
<td>$row[home_phone_num]</td>
<td>$row[date]</td>
</tr>
</table>';
</div>
</div>
</div>
</div>";
}
echo "</table>";
}else{
echo "no information";
}
echo $modal;
$connection->close();
?>
</body>
</html>
它应该有效。