又是数据库问题,悲哀---谁推荐点数据库资料?
mysql改掉密码后重启mysql访问网站没问题了---不过今天却发现网站论坛可以登陆,但是提交注册信息的话.而且登陆后发布的信息应该也是没存到数据库---因为它虽然提示信息发布成功,但是刷新内容还是一样的。
注册页面的一段代码: $result=mysql_query($sql);
if($result){
//页面跳转
$url="../login.php";
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('注册成功!请点确定返回登陆界面!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}
else{
echo "数据连接失败!";估计是保存的设置问题?请指教!
mysql改掉密码后重启mysql访问网站没问题了---不过今天却发现网站论坛可以登陆,但是提交注册信息的话.而且登陆后发布的信息应该也是没存到数据库---因为它虽然提示信息发布成功,但是刷新内容还是一样的。
注册页面的一段代码: $result=mysql_query($sql);
if($result){
//页面跳转
$url="../login.php";
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('注册成功!请点确定返回登陆界面!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}
else{
echo "数据连接失败!";估计是保存的设置问题?请指教!
$num = mysql_affected_rows($result);
if($num>0){
//页面跳转
$url= "../login.php ";
echo " <SCRIPT LANGUAGE= 'Javascript '> ";
echo "alert( '注册成功!请点确定返回登陆界面! '); ";
echo "location.href= '$url ' ";
echo " </SCRIPT> ";
}
else{
echo "数据连接失败! ";
还是不行,变这样子了---
Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in K:\phpsever\www\htdocs\12cde\inc\SAVEregist.php on line 82
数据连接失败!
$result=mysql_query($mysql);
//$num = mysql_affected_rows($result);
$rs=mysql_fetch_array($result); //shuzu
$num=$rs[0]; //记录总数
if($num>0){
//页面跳转
//$url= "../login.php ";
echo " <SCRIPT LANGUAGE= 'Javascript '> ";
echo "alert( '注册成功!请点确定返回登陆界面! '); ";
echo "location.href= '$url ' ";
echo " </SCRIPT> ";
}
else{
echo "数据连接失败! ";
}
$sql="select * from member where account='$_POST[username]';";
$result=mysql_query($sql);注册那里加多句echo $result输出空白,echo $sql输出下面的内容:
INSERT INTO member ( typeid, account, psw, email, question, answer, sex, name, birthday, address, qq, companyaddr, companybusiness, companytel, companyfax, companyweb, date, institutions, education, post, pic, expertise ) VALUES ( '0', '1212', '121212', '[email protected]', '0', '', '男', '121', '', '', '', '', '', '', '', '', '2009-11-23', '121', '1212', '12121', '1.jpg', '1' )
看看你用的mysql用户名和密码都有啥权限? 可以从那里登录。
首先你数据库应该就没连接上吧?
-------------------------------
指点迷津网 http://www.zhidianmijin.com
$result=mysql_query($sql);
$sql="select * from member where account='$_POST[username]'";
$result=mysql_query($sql);
$num = mysql_num_rows($result);
if($num>0){
//页面跳转
$url= "../login.php ";
echo " <SCRIPT LANGUAGE= 'Javascript '> ";
echo "alert( '注册成功!请点确定返回登陆界面! '); ";
echo "location.href= '$url ' ";
echo " </SCRIPT> ";
}
else{
echo "数据连接失败! ";
数据连接失败!
session_start();
header('Content-Type:text/html;charset=GB2312');//避免输出乱码
include('../inc/inc.php');//包含数据库基本配置信息
$datetime=date('Y-m-d');//获得系统时间
$url=$_SERVER['HTTP_REFERER'];//跳转页面
//检查域名是否存在
$sql="select * from member where account='$_POST[username]';";
$result=mysql_query($sql);
if($_POST['postcode']!=$_SESSION["code"])
{
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('您输入的验证码错误,请重新输入!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}elseif(mysql_num_rows($result)>0){
//页面跳转
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('您输入的用户名错误!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}elseif($_POST['userpwd']!=$_POST['reuserpwd']){
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('您输入的两次密码不正确!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}elseif($_POST['username']==""||$_POST['userpwd']==""||$_POST['reuserpwd']==""||$_POST['email']==""){
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('带*号的选项必须填写!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}else
{
$sql="INSERT INTO member (
typeid,
account,
psw,
email,
question,
answer,
sex,
name,
birthday,
address,
qq,
companyaddr,
companybusiness,
companytel,
companyfax,
companyweb,
date,
institutions,
education,
post,
pic,
expertise
) VALUES (
'".$_POST['typeid']."',
'".$_POST['username']."',
'".$_POST['userpwd']."',
'".$_POST['email']."',
'".$_POST['question']."',
'".$_POST['answer']."',
'".$_POST['sex']."',
'".$_POST['name']."',
'".$_POST['birthday']."',
'".$_POST['address']."',
'".$_POST['qq']."',
'".$_POST['companyaddr']."',
'".$_POST['companybusiness']."',
'".$_POST['companytel']."',
'".$_POST['companyfax']."',
'".$_POST['companyweb']."',
'$datetime',
'".$_POST['institutions']."',
'".$_POST['education']."',
'".$_POST['post']."',
'".$_POST['head']."',
'".$_POST['expertise']."'
)";
//$result=mysql_query($sql);
if($result){
//页面跳转
$url="../login.php";
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('注册成功!请点确定返回登陆界面!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}
else{
echo "数据连接失败!";
}
}
?>
把第二句$result=mysql_query($sql);注释掉后提示注册成功,跳入登录界面。莫非是单线程只响应第一个mysql_query????本以为问题解决了!但实际上用刚注册的帐号是登录不了,数据库没写进去,用旧用户登录进去也不了新的信息的---问题清晰点好像---不过还没解决办法----
厄~~貌似7楼说得对头,之前改过几次数据库密码连网站都上不去的,说链接数据库失败后来改了inc文件夹里inc.php的密码配置,重启mysql可以访问网站了。但现在不能注册之类的,又是访问数据库失败,谁知道哪里还要改动的?????用phpmyadmin管理数据库的。
$num = mysql_num_rows($result);
数据库: 12cde
生成日期: 2009 年 11 月 24 日 06:09
生成者: phpMyAdmin 2.11.9.2 / MySQL 5.0.21-community-nt
SQL 查询: show grants for '12cde'@'localhost';
行数: 2 Grants for 12cde@localhost
GRANT USAGE ON *.* TO '12cde'@'localhost' IDENTIFIED BY PASSWORD '*5CE55462499C94B5FE59B0267B6A9DE13AE84B89'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `12cde`.* TO '12cde'@'localhost'
------------
权限应该没问题吧?7楼你说没连接到数据库什么意思?是什么没连到数据库?
echo "$sql";,在数据连接失败后面也加多这两个输出
结果如下:
Resource id #4select * from member where account='zhengyehan';数据连接失败!INSERT INTO member ( typeid, account, psw, email, question, answer, sex, name, birthday, address, qq, companyaddr, companybusiness, companytel, companyfax, companyweb, date, institutions, education, post, pic, expertise ) VALUES ( '0', 'zhengyehan', 'zhengyehan', '[email protected]', '0', '', '男', '123', '', '', '', '', '', '', '', '', '2009-11-24', '1231', '231', '231', '1.jpg', '1' )
两种可能:1. mysql 用户权限问题:
看你的用户是否有insert权限。 通过grant 命令授权一下。 (查看mysql手册)
mysql用户的添加修改, 都要重新载入权限。 (flush *** )2. mysql数据库文件的写权限:
找到数据库文件, 看看属性是否可写。-------------------------------
指点迷津网 http://www.zhidianmijin.com