请教一个session的问题~~~

[mynamesucks]

请见如下2个程序：
check.php

<?php

include("conn.php");
$username=$_POST['username'];
$password=$_POST['password'];
$row="select * from user where username='".$username."' and password='".$password."'";
$result=mysql_query($row,$connection);
$num=mysql_num_rows($result);
if($num){
$_SESSION["username"]=$username;
$_SESSION["password"]=$password;
header("location:suclogin.php");
}
else
header("location:failogin.php");

?>

degree.php

<?php

session_start();
include("conn.php");
if (isset($_SESSION["username"]) and isset($_SESSION["password"]));
$username=$_SESSION["username"];
$password=$_SESSION["password"];
$row="select degree from user where username='".$username."' and password='".$password."'";
$query=mysql_query($row,$connection);
echo $query;

?>

运行后一直说$username=$_SESSION["username"];
$password=$_SESSION["password"];这2行有错
我对session的语法不是很熟，请教各位高手看看哪里有错误，急啊~~~~~ ToT

[ccterran]

1,最好把错误提示写出来
2,
if (isset($_SESSION["username"]) and isset($_SESSION["password"]));
$username=$_SESSION["username"];
$password=$_SESSION["password"];
不对吧
if (isset($_SESSION["username"]) and isset($_SESSION["password"])){
$username=$_SESSION["username"];
$password=$_SESSION["password"];
}

[ccterran]

1,最好把错误提示写出来
2,
if (isset($_SESSION["username"]) and isset($_SESSION["password"]));
$username=$_SESSION["username"];
$password=$_SESSION["password"];
不对吧
if (isset($_SESSION["username"]) and isset($_SESSION["password"])){
$username=$_SESSION["username"];
$password=$_SESSION["password"];
}

[mynamesucks]

错误提示：
Notice: Undefined index: username in D:\Apache\Apache2\htdocs\degree.php on line 14

Notice: Undefined index: password in D:\Apache\Apache2\htdocs\degree.php on line 15
Resource id #4

麻烦各位帮我看看了。。。

[ccterran]

没有注册成功哦,
1,check.php前面应该有session_start();
2,if($num)应该是if($num=="1")

[52juanjuan]

1.你的session_register在那里呢？
2.if (isset($_SESSION["username"]) and isset($_SESSION["password"]));
$username=$_SESSION["username"];
$password=$_SESSION["password"];
这一条跟
$username=$_SESSION["username"];
$password=$_SESSION["password"];
这个有区别吗？多了一个分号改：2.if (isset($_SESSION["username"]) and isset($_SESSION["password"]))
$username=$_SESSION["username"];
$password=$_SESSION["password"];

3.$num=mysql_num_rows($result);
if($num){
$_SESSION["username"]=$username;
$_SESSION["password"]=$password;
header("location:suclogin.php");
}
这里得到值了吗？

[mynamesucks]

多谢楼上2位
我改成了
<?php

session_start();
include("conn.php");
if (isset($_SESSION["username"]) and isset($_SESSION["password"]))
{
$username=$_SESSION["username"];
$password=$_SESSION["password"];
$row="select degree from user where username='".$username."' and password='".$password."'";
$query=mysql_query($row,$connection);
echo $query;
}
?>

这次显示出来的是
Resource id #4
还是哪里有点问题。。。

[mynamesucks]

多谢楼上2位，我把degree改了一下
<?php

session_start();
include("conn.php");
if (isset($_SESSION["username"]) and isset($_SESSION["password"]))
{
$username=$_SESSION["username"];
$password=$_SESSION["password"];
$row="select degree from user where username='".$username."' and password='".$password."'";
$query=mysql_query($row,$connection);
echo $query;
}
?>

现在显示的是
Resource id #4
还是哪里有点问题好象。。。

[ccterran]

没有什么异常吧,你的mysql_query($row,$connection);返回的是资源,你干吗要输出它呢?可以用mysql_fetch_array或者mysql_fetch_object取出其中的值

[mynamesucks]

我的degree里的select那句里的degree是个数据库里的字段
我想让他显示出来，但是却显示Resource id #4
check.php里的mysql_num_rows我是想看看有没有记录，所以后面用if($num)
我是想让degree.php根据check.php里的username和password的值去显示同一个表中的degree
拜托各位再看看吧，我从早上想到现在了。。。水平低没办法啊。。。

[ccterran]

$array=mysql_fetch_array($query);
echo $array["degree"];

[skystar008]

呵呵,session就这么晕吗?!

[mynamesucks]

多谢iwind兄啊，可以了~~~~~~~~~
degree改成
<?php

session_start();
include("conn.php");
if (isset($_SESSION["username"]) and isset($_SESSION["password"]))
{
$username=$_SESSION["username"];
$password=$_SESSION["password"];
$row="select * from user where username='".$username."' and password='".$password."'";
$query=mysql_query($row,$connection);
$result=mysql_fetch_array($query);
echo $result["degree"];
}
?>
可以显示degree字段了
真的太感谢了~~~~~~~~~~~~~

[mynamesucks]

这个。。。还有个问题，咋给分啊。。。

[ccterran]

好像在"管理"里面.....

[mynamesucks]

恩,ok了，多谢iwind大大了~~~