在另一个PHP页面中打印$ _GET值

Question

I have the following. My issue is when the 'Buy' link is clicked on index.php, on the paynow.php page does not show anything. Where have I gone wrong?

P.S: Theunitprice echos fine. So I know that there is no issue is pulling data from the SQL database.

index.php

$sql_content = "show columns from cameras";
$get_res = mysql_query($sql_content);
$cols = mysql_num_rows($get_res);
$page = $_REQUEST['page'];
$start = ($page-1)*8;
$sql_content1 = "select * from cameras limit $start,$per_page";
$query = mysql_query($sql_content1);

$j=0;
while ($rows = mysql_fetch_assoc($query))
{
?>
<link href="style1.css" rel="stylesheet" type="text/css" />

<div id='mainFrame'>
    <div id='totalFrame'>
        <div id='priceX'><b>Rs.&nbsp;</b>&nbsp;<?php echo $rows['unitprice'];?></div><!--pricex-->
        <div id='buynow'><a href="paynow.php?id="<?php echo $rows['model']; ?>">Buy</a></div>
    </div><!--close total frame-->
</div>
<?php

paynow.php

<?php
print $_GET["id"]; 
?>

Answer 1

To start with, you should immediately stop using any mysql_* functions. Take a look here: http://php.net/manual/en/function.mysql-query.php

The interface is now deprecated and you should use PDO_MySQL or MySQLi.

You also have a potential SQL injection vulnerability in your code as you're not sanitising the input to the SQL query.

For your question, the syntax highlighting right here on SO has highlighted your problem, you have an extra " in your code:

<div id='buynow'><a href="paynow.php?id="<?php echo $rows['model']; ?>">Buy</a></div>

Should be this:

<div id='buynow'><a href="paynow.php?id=<?php echo $rows['model']; ?>">Buy</a></div>