简明现代魔法 -> PHP服务器脚本 -> PHP获取通过URL传递的参数

PHP获取通过URL传递的参数

2009-11-16

以下代码实现了查询数据库，并将数据库的索引 offers_id 通过 URL 发送出去。

发送的语句为 <?php printf("<a href=\"offersDetail.php?offers_id=%s\">%s </a>\n", $myrow["offers_id"],$myrow["offers_name"]); ?> 。

<?php 
include("library/conn.php");
$perpagenum =10;//定义每页显示几条 
$total = mysql_fetch_array(mysql_query("select count(*) from offers_info")); //查询中条数
include("library/pages.php");
$query=mysql_query("select * from offers_info order by offers_date desc limit $startnum,$perpagenum") ; 
$i=$perpagenum*($page-1)+1; 
while($myrow = mysql_fetch_array($query)){ 
?>
	
<table width="500" border="0">

  <tr>
    <td style="color:blue;">
    <?php printf("<a href=\"offersDetail.php?offers_id=%s\">%s </a>\n",
    $myrow["offers_id"],$myrow["offers_name"]); ?></td>
  </tr>

  <? }
  ?>
</table>


</p>
<?php   
    //关闭对数据库的连接  
    mysql_close($myconn);  
?>  

接收 URL 传递的参数，并利用这个参数获取该数据库字段的全部信息。

<?php 
	$id = $_GET['offers_id'];
	
	//$offers_id = $_POST['offers_id'];
	
	include("library/conn.php");
	//$perpagenum =10;//定义每页显示几条 
	//$total = mysql_fetch_array(mysql_query("select count(*) from offers_info")); //查询中条数
	//include("library/pages.php");
	$query=mysql_query("select * from offers_info where offers_id=$id") ; 
	//$i=$perpagenum*($page-1)+1; 
	$myrow = mysql_fetch_array($query);
 	//$myrow=mysql_fetch_array($result);
?>
<table width="90%" border="0">
  <tr>
    <td><font color="blue"><? echo $myrow["offers_name"] ?></font></td>
  </tr>
</table>
</p>
<?php   
    //关闭对数据库的连接  
    mysql_close($myconn);  
?> 

如果想弹出新窗口，可以如下实现。将'"_blank"' 赋给变量 $target，然后在 a 标签里用 target=$target。

<?php 
include("library/conn.php");
$perpagenum =10;//定义每页显示几条 
$total = mysql_fetch_array(mysql_query("select count(*) from offers_info")); //查询中条数
include("library/pages.php");
$query=mysql_query("select * from offers_info order by offers_date 
desc limit $startnum,$perpagenum") ; 
$i=$perpagenum*($page-1)+1; 
$target = '"_blank"';
//echo $target;
while($myrow = mysql_fetch_array($query)){ 
?>
<?php printf("<a href=\"offersDetail.php?offers_id=%s\" target=$target>%s </a>\n",
$myrow["offers_id"],$myrow["offers_name"]); ?></a>