php接收地址栏上的id,该怎么解决

WBOY
Release: 2016-06-13 10:11:41
Original
1246 people have browsed it

php接收地址栏上的id

PHP code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--><?php $id = $_GET['id']+0;if($id==0) {    echo "参数有误";    exit;}$conn = mysql_connect('loaclhost','root','123456');$sql = 'use msg';mysql_query($sql,$conn);$sql = "select * from denglu where id = $id";$var = mysql_query($sql,$conn);$msg = mysql_fetch_assoc($var);if(!$msg) {    echo '参数有误';    exit;}print_r($msg);?>
Copy after login

文件命名为test.php,编辑环境为editplus,按ctrl+b,在页面上弹出
HTML code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Notice: Undefined index: id in D:\server\apache\www\test.php on line 2参数有误
Copy after login

于是我便在地址栏上输入
HTML code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->http://localhost/test.php[color=#FF0000]?id=2[/color]
Copy after login

可是这次显示的错更多
HTML code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: 不知道这样的主机。 in D:\server\apache\www\test.php on line 7Warning: mysql_connect() [function.mysql-connect]: [2002] php_network_getaddresses: getaddrinfo failed: 不知道这样的主机。 (trying to connect via tcp://loaclhost:3306) in D:\server\apache\www\test.php on line 7Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: 不知道这样的主机。 in D:\server\apache\www\test.php on line 7Warning: mysql_query() expects parameter 2 to be resource, boolean given in D:\server\apache\www\test.php on line 9Warning: mysql_query() expects parameter 2 to be resource, boolean given in D:\server\apache\www\test.php on line 11Warning: mysql_fetch_assoc() expects parameter 1 to be resource, null given in D:\server\apache\www\test.php on line 12鍙傛暟鏈夎
Copy after login

我查找原因好久,实在没招了,哪位大大能帮忙分析原因,感激不尽!!!!!

------解决方案--------------------
mysql_connect(), 数据库连接错误

PHP code
$conn = mysql_connect('loaclhost','root','123456') or die("can not connect Mysql Server");mysql_select_db("数据库名",$conn);//你的数据库名叫 use msg ?$sql = "select * from denglu where id = $id";$var = mysql_query($sql);<br><font color="#e78608">------解决方案--------------------</font><br><?php <br />if(isset($_REQUEST['id'])){<br>	$id = $_REQUEST['id'];<br>	if($id == 0){<br>		exit("The parameter is wrong!");<br>	}<br>}<br>echo $id;<br>@ $conn = mysql_connect('localost', 'root', '123456') or die("Connection Failure:" .mysql_errno());<br>mysql_select_db('msg', $conn);<br>mysql_query("set names ''utf8");<br>$sql =  "select * from denglu where id = $id";<br>$result = mysql_query($sql);<br>while($rs = mysql_fetch_assoc($result)){<br>   var_dump($rs);<br>}<br>输入url: localhost/index.php?id=2即可获取到id<br><font color="#e78608">------解决方案--------------------</font><br>$id=isset($_GET["id"])?$_GET["id"]:0;<div class="clear">
                 
              
              
        
            </div>
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!