這是我正在處理的代碼演示，我在 MySQL 表中有鏈接，并希望在網(wǎng)站表上顯示它們，但我不想顯示鏈接，而是顯示與 Excel 中的超鏈接相同的名稱。示例：如果我只使用 href=www.google.com鏈接我的代碼：<!DOCTYPE HTML><html><head><title>Pagina teste</title><div align="center"><font size="+3">Lista de Websites</font></div></head><body><style> table, td, th {border: 1px solid black; border-collapse: collapse; } tr:nth-child(even) {background-color: #dcdddd;}</style><table><tr><th><font size="+2">Website Name</font></th><th><font size="+2">Link</font></th></tr><?php$conn = mysqli_connect("localhost", "root", "", "test");// Check connectionif ($conn->connect_error) {die("Connection failed: " . $conn->connect_error);}if(isset($_GET['order'])){ $order = $_GET['order'];}else{ $order = 'websitename';}if(isset($_GET['sort'])){ $sort = $_GET['sort'];}else{ $sort = 'ASC';}$sql = "SELECT websitename, link FROM websites ORDER BY $order $sort";$result = $conn->query($sql);if ($result->num_rows > 0) {// output data of each rowwhile($row = $result->fetch_assoc()) {echo "<tr><td>" . $row["websitename"]. "</td><td>" . $row["link"]. "</td></tr>";}echo "</table>";} else { echo "0 results"; }$conn->close();?></table></body></html>
3 回答
湖上湖
TA貢獻(xiàn)2003條經(jīng)驗 獲得超2個贊
中國商店方法中的公牛，用標(biāo)簽標(biāo)記包圍輸出：
echo "<tr>
<td>" . $row["websitename"]. "</td>
<td><a href=\"" . $row["link"]. "\">" . $row['websitename'] . "</a></td>
</tr>";
慕哥9229398
TA貢獻(xiàn)1877條經(jīng)驗 獲得超6個贊
嘗試這個
<!DOCTYPE HTML>
<html>
<head>
<title>Pagina teste</title>
<div align="center">
<font size="+3">Lista de Websites</font>
</div>
</head>
<body>
<style>
table, td, th {border: 1px solid black; border-collapse: collapse; }
tr:nth-child(even) {background-color: #dcdddd;}
</style>
<table>
<tr>
<th><font size="+2">Website Name</font></th>
<th><font size="+2">Link</font></th>
</tr>
<?php
$conn = mysqli_connect("localhost", "root", "", "test");
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if(isset($_GET['order'])){
$order = $_GET['order'];
}else{
$order = 'websitename';
}
if(isset($_GET['sort'])){
$sort = $_GET['sort'];
}else{
$sort = 'ASC';
}
$sql = "SELECT websitename, link FROM websites ORDER BY $order $sort";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<tr>
<td>".$row["websitename"]."</td>
<td><a href=".$row["link"]." target='_blank'>" . $row["link"]. "</a></td>
</tr>";
}
echo "</table>";
} else { echo "0 results"; }
$conn->close();
?>
</table>
</body>
</html>
蝴蝶不菲
TA貢獻(xiàn)1810條經(jīng)驗 獲得超4個贊
您可以在表格內(nèi)使用錨鏈接。
<?php
echo "<tr>
<td>" . $row["websitename"]. "</td>
<td><a href=".$row["link"]." target='_blank'>" . $row["link"]. "</a></td>
</tr>";
?>
- 3 回答
- 0 關(guān)注
- 185 瀏覽
添加回答
舉報
0/150
提交
取消