单击链接时不显示Mysql字段数据


Mysql Field Data not displaying when a link is clicked?

如果单击链接,我将尝试从数据库中获取数据。

我使用了这个例子中建议的示例代码——点击链接时获取mysql字段数据?

但当我点击链接时,它不起作用,什么也不会出现。

main.php

<?php
include('conn.php');
$sql2    = "SELECT Title FROM addpromo";
$result2 = mysql_query($sql2);
echo "<div id='"links'">'n";
echo "<ul>'n";
while ($row2 = mysql_fetch_assoc($result2)) {
    echo "<li> <a href='"fullproject.php?title='""
        . urlencode($row2['Title']) . "'">"
        . htmlentities($row2['Title']) . "</a>'n</li>";
}
echo "</ul>";
echo "</div>";
?>

这显示正确。但当我点击链接时,fullproject.php中没有显示任何内容,只是一个空白页。

fullproject.php

<?php
// Connect to server.
include('conn.php');
$projectname = isset($_GET['Title']);
$sql1 = "SELECT Title FROM addpromo WHERE Title = '$projectname'";
$result1 = mysql_query($sql1);
while ($row1 = mysql_fetch_assoc($result1)) {
    echo "Project Name: " . $row1['Title'] . "<br />";
    echo "<br /> ";
}
?>

有人能帮我解决这个问题吗,或者用任何其他方式让它成为可能(如果点击链接,从数据库中获取数据)?

更改到此

main.php

<?php
include('conn.php');
$sql2="SELECT Title FROM addpromo";
$result2=mysql_query($sql2);    
echo '<div id="links">';
echo '<ul>';
while($row2 = mysql_fetch_assoc($result2)){
echo '<li><a href="fullproject.php?title='.urlencode($row2['Title']).'">'.htmlentities($row2['Title']).'</a></li>';
}
echo '</ul>';
echo '</div>';
?>

fullproject.php

<?php
if(isset($_GET['title'])){
    include('conn.php');
    $projectname= $_GET['title'];
    $sql1="SELECT Title FROM addpromo WHERE Title = '$projectname'";
    $result1=mysql_query($sql1);    
    while($row1 = mysql_fetch_assoc($result1)) {
      echo "Project Name: " . $row1['Title']. "<br />";    
      echo "<br /> ";
    }
}
?>

无论是否设置了标题,都会存储一个布尔值$projectname= isset($_GET['Title']);。而是使用$projectname = $_GET['Title'];

isset返回一个布尔值(true/false),您需要变量的实际值:

$projectname= $_GET['title'];

此外,您必须只传递标题作为URL参数,而不将其括在引号内。所以这行有一个错误:

echo "<li> <a href='"fullproject.php?title=" . urlencode($row2['Title']) . "'">"

注意title=

后缺少''"