如何从URL获得价值 [英] How get value from URL

问题描述

我想从URL中获取价值，以便通过ID从数据库中选择数据.我想要ID值.

I want to get value from URL to choose data from database by ID. I want value for id.

例如，如果我打开www.example.com/index.php?id=12
我想获取数据库中id = 12的值.

For example if I open www.example.com/index.php?id=12
I want to get value whose id = 12 in database.

如果我打开www.example.com/index.php?id=7
在数据库中获取id为7的值，依此类推.

If I open www.example.com/index.php?id=7
get value whose id = 7 in database and so on.

我有一些代码:

$results = mysql_query("SELECT * FROM next WHERE id=$id");    
while ($row = mysql_fetch_array($results))     
{       
    $url = $row['url'];
    echo $url;    
}

推荐答案

网站网址:

http://www.example.com/?id=2

代码:

$id = intval($_GET['id']);
$results = mysql_query("SELECT * FROM next WHERE id=$id");    
while ($row = mysql_fetch_array($results))     
{       
    $url = $row['url'];
    echo $url; //Outputs: 2
}

这篇关于如何从URL获得价值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！