无法在数据发布上建立 mysql 连接 [英] unable to make mysql connection on data post
本文介绍了无法在数据发布上建立 mysql 连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的文件名是contacts.php;我希望如果按下选择按钮,选择函数被调用.但它显示错误.我编写了以下代码:
my filename is contacts.php;i want that if select button is pressed select function is called.but it is showing error.i have written following code:
//contacts.php
<?php
//1.CREATE CONNECTION
$connection=mysql_connect("localhost","root","human");
if(!$connection)
{
die("DataBase Connection Failed: ".mysql_error());
}
//2.SELECT DATABASE
$db_select=mysql_select_db("vikas",$connection);
if(!$db_select)
{
die("DataBase Selection Failed: ".mysql_error());
}
if(isset($_REQUEST['select']))
{
select();
}
//select function
function select()
{
echo '<div id="show" style="background-color:#DDDDDD;">';
$result=mysql_query("select * from contacts", $connection);
if(!$result)
{
die("DataBase Query Failed: ".mysql_error());
}
echo <<<END
<table name=contact>
<tr><th>ID</th>
<th>NAME</th>
<th>NUMBER</th></tr>
END;
while($row=mysql_fetch_array($result))
{
echo '<tr><td>'.$row["number"].'</td><td>'.$row["name"].'</td></tr>';
}
echo '</div>';
}
//end of select
?>
<html>
<body>
<form action="contacts.php">
ENTER ID:<br>
<input type="text" name="id"/><br>
ENTER NAME(20 chars):<br>
<input type="text" name="name"/><br>
ENTER NUMBER(10 digits):<br>
<input type="text" name="number"/><br>
<input type="submit" name="select" value="select"/>
</form>
</body>
</html>
但它显示错误 undefined var connection .please help这是错误未定义变量:C:\wamp\www\site2sms-call\contacts.php 中的连接"
but it is showing error undefined var connection .please help this is the error "Undefined variable: connection in C:\wamp\www\site2sms-call\contacts.php"
推荐答案
因为 $connection
不在 select
函数范围内.通过函数参数传递.
Because $connection
in not within select
function scope. Pass it via function parameter.
function select($connection)
{
echo '<div id="show" style="background-color:#DDDDDD;">';
$result=mysql_query("select * from contacts", $connection);
调用选择函数时
if(isset($_REQUEST['select']))
{
select($connection);
}
这篇关于无法在数据发布上建立 mysql 连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文