php如何从第一页的链接中获取id和日期


php how to get the id and the date from the link in the 1st page?

我有来自clientsLoanview.php的链接代码

   $query = "SELECT MID,mem_name,loan_amount,advanced_interrest,pay_months,type,rel_date,due_date,collateral,rel_by,
                        (loan_amount * ((advanced_interrest/100) * pay_months)) as current,
                        ((loan_amount * ((advanced_interrest/100) * pay_months))+loan_amount) as payable
                     FROM loan_transaction order by rel_date ";
            $retrieve = mysql_query($query)or die("Query Failed:".mysql_error());

            while($row = mysql_fetch_array($retrieve)){
                echo "<tr>";
                echo "<td id='row'>".$row['MID']."</td>";
                echo '<td id="row">'.$row["mem_name"].'</td>';
                echo '<td id="row">'.$row["loan_amount"].'</td>';
                echo '<td id="row">'.$row["advanced_interrest"].'</td>';
                echo '<td id="row">'.$row["current"].'</td>';
                echo '<td id="row">'.$row["payable"].'</td>';
                echo '<td id="row">'.$row["pay_months"].'</td>';
                echo '<td id="row">'.$row["type"].'</td>';
                echo '<td id="row">'.$row["rel_date"].'</td>';
                echo '<td id="row">'.$row["due_date"].'</td>';
                echo "<td id='row'> <a name='view' href='viewAllPersonalLoan.php?id=".$row['MID']."'> View </a> </td>";                 
                echo "<td id='row'> <a name='view' href='viewPersonalLoan.php?id=".$row['MID'].",date=".$row['rel_date']."'> View </a> </td>";
            }
        ?>

我想获得while循环中提供的具有指定id的特定行的id和日期(即id=1和日期=2015-2-26)。此代码不起作用。

    echo "<td id='row'> <a name='view' href='viewPersonalLoan.php?id=".$row['MID'].",date=".$row['rel_date']."'> View </a> </td>";

请帮助我获得正确的语法,以便我可以在下一页中使用此语法或任何其他语法。

viewPersonalLoan.php

    $id=$_GET['id'];
    $date=$_GET['date'];

谢谢你的回答。请帮我做这件事

要传递多个参数,需要使用&而不是,:将它们连接起来

echo "<td id='row'> <a name='view' href='viewPersonalLoan.php?id=".$row['MID']."&amp;date=".$row['rel_date']."'> View </a> </td>";

确保将&转义为&amp;