如何将信息传递到其他页面？

Question

I have the following code which displays a table with two columns, Title and Year, when the user clicks on a title, they are sent to another page (title.php), which will give more information about that title.

echo "<table border=1>
<tr>
<th>Title</th>
<th>Year</th>
</tr>";

while ($record = mysql_fetch_array($myData)) {
    echo "<tr>";
    echo "<td><a href='title.php'>" . $record['title'] . "</a><br />" . $record['plays'] . "</td>";
    echo "<td>" . $record['year'] . "</td>";
    echo "</tr>";
}
echo "</table>";

my question is: how do i pass the title ($result['title']) from the current page to title.php?

Answer 1

In this case, you'll want to pass information using a GET variable:

echo "<table border=1>
<tr>
<th>Title</th>
<th>Year</th>
</tr>";

while ($record = mysql_fetch_array($myData)) {
    echo "<tr>";
    echo "<td><a href='title.php?title=" . $record['title'] . "'>" . $record['title'] . "</a><br />" . $record['plays'] . "</td>";
    echo "<td>" . $record['year'] . "</td>";
    echo "</tr>";
}
echo "</table>";

Although I'd suggest passing an ID representing your primary key instead of a title so that you can grab the title after a db query on title.php

Also, you don't need mysql_fetch_array. In this case, you only need mysql_fetch_assoc.