>  기사  >  백엔드 개발  >  php接收地址栏上的id,该怎么解决

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

WBOY
WBOY원래의
2016-06-13 10:11:411278검색

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);?>

文件命名为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参数有误

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

可是这次显示的错更多
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鍙傛暟鏈夎

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

------解决方案--------------------
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>
성명:
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.