我有来自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']."&date=".$row['rel_date']."'> View </a> </td>";
确保将&
转义为&
。