$result=mysql_query("select * from users where username='$username'",$db); 这句应该是查询不到数据的,因为你的$username不存在,如果存在就满足了登录的条件!我想你应该是这一句才对: $result=mysql_query("select * from users where username='$charset'",$db);
$result=mysql_query("select * from users where username='$username'",$db); 这句应该是查询不到数据的,因为你的$username不存在,如果存在就满足了登录的条件!我想你应该是这一句才对: $result=mysql_query("select * from users where username='$charset'",$db); 还是不行,结果一样。。... 楼上的说加个字段来设置用户等级和cl是一样的
如果login是注册的不同session变量,再由hiuser_club.php来判断不就没问题了. <?php session_start(); // Use $HTTP_SESSION_VARS with PHP 4.0.6 or less if (!isset($_SESSION['logined'])) { //login.php registered //not logined } else { //check the validated user type if($_SESSION['userType']=="NORMAL"){ //login.php registered //NORMAIL }else if($_SESSION['userType']=="VIP"){ //login.php registered //VIP }else{ //error }} ?>
$result=mysql_query("select * from users where username='$username'",$db);
这句应该是查询不到数据的,因为你的$username不存在,如果存在就满足了登录的条件!我想你应该是这一句才对:
$result=mysql_query("select * from users where username='$charset'",$db);
{
echo"<a href=user_club.php>会员专区</a>";
}else{
echo"<a href=hiuser_club.php>会员专区</a>";
}
也不知是不是我看错了,我在想,你这个if有什么用
{
echo"<a href=user_club.php>会员专区</a>";
}else{
echo"<a href=hiuser_club.php>会员专区</a>";
}
是这样的..我想如果是VIP会员就进入hiuser_club.php,如果是普通会员则进入user_club.php,但是我又在考虑不管是什么会员只要登录后都能进入hiuser_club.php,所以我真诚的希望高手们帮我解决这个问题..怎么在hiuser_club.php里面使用语句来控制..
谢谢各位!!!
这句应该是查询不到数据的,因为你的$username不存在,如果存在就满足了登录的条件!我想你应该是这一句才对:
$result=mysql_query("select * from users where username='$charset'",$db);
还是不行,结果一样。。...
楼上的说加个字段来设置用户等级和cl是一样的
# 数据表的结构 `users`
#CREATE TABLE users (
id int(10) unsigned NOT NULL auto_increment,
username varchar(16) default NULL,
password varchar(16) default NULL,
passmail varchar(60) default '免费会员',
logined_time datetime default NULL,
logined_id varchar(50) default NULL,
added_date datetime default NULL,
cl enum('普通会员','VIP会员') NOT NULL default '普通会员',
PRIMARY KEY (id)
) TYPE=MyISAM;
为了便于问题的解决..
我将相关代码贴出来.....如下..index.php 于login.php相关...
---------------------------index.php----------------------
<?PHP session_start();
require("config.inc");
$this_time = date( "Y-m-d H:i:s" );
$olded = 10;$old_time = date( "Y-m-d " );
$h0 = date("H");$h1 = date("i");if($h1-$olded>0)$h1-=$olded;else{$h0--;$h1=60+$h1-$olded;}
$old_time .=$h0.":".$h1.":00";
$result = mysql_query("SELECT username FROM users WHERE logined_time<'$old_time'",$db);
while ($myrow = @mysql_fetch_row($result)) {
$result = mysql_query("UPDATE users SET logined_time='',logined_id='' WHERE username='$myrow[2]'",$db);
} if($charset && $charset !=''){
$result = mysql_query("SELECT username FROM users WHERE logined_id='$charset'",$db);
$data=mysql_fetch_array($result);
$user = $data[0];
if($user != '')$result = mysql_query("UPDATE users SET logined_time='$this_time' WHERE logined_id='$charset'",$db);
else{
$charset ='';
}
}srand((double)microtime()*1000000);
$this_id = rand();
//$this_time = date( "Y-m-d H:i:s" );
?>
<html>
...........
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" class="9pt-qq-s">
<?
if($charset && $charset!=''){
$u = $REQUEST_URI;
require("login.php");}
else{
?>
<form method=post action="login.php?u=<? echo "$REQUEST_URI" ?>">
<tr>
<td width="42" height="39" nowrap>用户名 </td>
<td width="60" height="39" nowrap> <input name="username" type="text" id="username" size="10" maxlength="30">
</td>
<td width="46" height="39" nowrap><FONT size="2" face="arial, helvetica">
</FONT></td>
</tr>
<tr>
<td align="center" height="35">密 码</td>
<td align="left" height="35"> <input name="password" type="password" id="password" size="10" maxlength="30">
</td>
<td height="35"> <INPUT name="submit" type="submit" class='login_button' id=" " value=" " width="43" height="21" hspace="1" border="0"></td>
</tr>
<tr valign="bottom">
<td height="23" colspan="3" align="center" valign="middle"><font color="#035CFF"><u><A href="join.php" target="_parent"><span class=9pt-red-s-bt>会员注册</span></A></u></font>
<img src="chinese/images/dot-gray.gif" width="4" height="4">
<span class=9pt-red-s-bt>忘记密码</span></td>
</tr>
<tr>
<td colspan="3" align="right"></td>
</tr>
</form>
<?
}
?>
</table>
.............
</html>-----------------------user_club.php-------------这个身份验证的代码应该怎么写最好...----------------------------------------------
$result = mysql_query("SELECT username FROM users WHERE logined_id='$charset'",$db);
<?php
$result=mysql_query("select * from users where logined_id='$charset'",$db); //不是username='$username'
$myrow=mysql_fetch_array($result);
if($myrow["cl"]=='普通会员')
{
echo"<a href=user_club.php>会员专区</a>";
}
else{
echo"<a href=hiuser_club.php>会员专区</a>";
}
?>
可是新的问题出来了,我这个新手解决不了,..
怎么写一段程序进入user_club.php要求身份验证,只让普通会员进入,而VIP不能直接在地址栏输入hiuser_club.php进入浏览...
相同普通会员不能进入hiuser_club.php...
我想是怎么写好在网页间传递charset的程序.
象if(session_is_registered(charset))
.........
else
....
是肯定不行的...
上面一堆我没看,只看了楼主的,仅对这句话说说.
都输出同一个链接有什么奇怪的?
如果login是注册的不同session变量,再由hiuser_club.php来判断不就没问题了.上面一堆我没看,如果错了,不要P啊
<?php
session_start();
// Use $HTTP_SESSION_VARS with PHP 4.0.6 or less
if (!isset($_SESSION['logined'])) { //login.php registered
//not logined
} else {
//check the validated user type
if($_SESSION['userType']=="NORMAL"){ //login.php registered
//NORMAIL
}else if($_SESSION['userType']=="VIP"){ //login.php registered
//VIP
}else{
//error
}}
?>