PHP访问数据库问题(200分)

  • 主题发起人 delphifans_hx
  • 开始时间
D

delphifans_hx

Unregistered / Unconfirmed
GUEST, unregistred user!
我在51.net上申请了个主页,最近遇到了一个问题:
member.php:
<?
$Host = "localhost";
$User_Name = "";
//用户名
$Password = "";
//密码
$dbLink =@mysql_connect($Host, $User_Name, $Password);
mysql_select_db("delphifans-hx",$dbLink);//选择数据库
$sql =
"insert into member(userid,password,email,name,address,website,description,company,oicq,remote_ip)
values('$userid','$password','$email','$name','$address','$website','$description',
'$company','$oicq','$REMOTE_ADDR')";
if (mysql_query("$sql"));
print("successful");//显示则成功
print(mysql_error());//出错提示;
print("/n");
print("$sql");//返回sql
?>
返回令我莫名奇妙:
successful No Database Selected insert into member(userid,password,email,name,address,website,description,company,oicq,remote_ip) values('asdffdgfg','asdf','asdf','asdf','asdf','asdf','asdfasdf', 'asdf','asdf','218.75.129.138')
 
successful //执行成功
No Database Selected //没有数据库被选择
insert into member
(userid,password,email,name,address,website,description,company,oicq,remote_ip)
values('asdffdgfg','asdf','asdf','asdf','asdf','asdf','asdfasdf', 'asdf','asdf','218.75.129.138')
//SQL语句
 
$dbLink =@mysql_connect($Host, $User_Name, $Password);
mysql_select_db("delphifans-hx",$dbLink);//选择数据库
数据库没有联接成功,你把@去掉看看你的数据库联接有没有成功
 

if (mysql_query("$sql"));
<-这里多了一个";"号
print("successful");//显示则成功
print(mysql_error());//出错提示;
 
刚就两位的正:
No Database Selected
insert into member(userid,password,email,name,address,website,description,company,oicq,remote_ip) values('asdf','asdf','asdf','asdf','asdf','asdf','asdfasdf', 'asdf','asdf','218.75.129.138'
还是没有选择数据库
 
那只能说明一个问题你的数据库名有问题,是单机调试吗?
 
数据库一定没有问题,因为我下载了phpmyadmin放在
我的网站上http://pascalhome.51.net/phpmyadmin
config.inc.php的25行填的就是这个名字,很好用呀
 
谢谢你问题已经解决了?
不知你是否建了网站,是否可以参观一下,顺便学点经验
 
接受答案了.
 
顶部