注册登录

<?php
require 'conn.php';
class user extends conn
{
	private $member_users;
	private $member_passw;
	private $member_email;
	
	 private function __set($property_name,$value)
	{
		$this->$property_name =$value;
		
	}
	private function __get($property_name)
	{
		if(isset($this->$property_name))
		{
			return ($this->$property_name);
		}else 
		{
			return (NULL);
		}
	}
	
	public function isusernamenotexist()
	{
	  $stmt = "select count(*) from  fz_member where member_users =  '".$this->member_users."'";
		$result = mysql_query($stmt,$this->conn);
		//mysql_query() 仅对 SELECT，SHOW，EXPLAIN 或 DESCRIBE 语句返回一个资源标识符，如果查询执行不正确则返回 FALSE。
//对于其它类型的 SQL 语句，mysql_query() 在执行成功时返回 TRUE，出错时返回 FALSE。
		 mysql_num_rows($result);
		$rs = mysql_fetch_row($result);
		//如果没有更多行则返回 FALSE
		
		if($rs[0]==0)
			{
			return  true;
			}
			else
			{
			return  false;
			}
	
	}
	
	public  function adduser()
	{
	$stmt ="insert into fz_member(member_users,member_passw,member_email) values('".$this->member_users."','".$this->member_passw."','".$this->member_email."') ";
	
	mysql_query($stmt,$this->conn);
	
	return  mysql_insert_id($this->conn);
	}
    
	public  function  login()
	{
		$stmt = "select  * from fz_member where member_users = '".$this->member_users."'";
		$result = mysql_query($stmt,$this->conn);
	if(mysql_num_rows($result)>0)	//if($result)
		{
			$rs = mysql_result($result, 0,"member_passw");
			
			echo $rs;
			echo "<br/>";
			echo $this->member_passw;
			if($rs==$this->member_passw)
			{
			 echo "登录成功";
			}
			else {
			
			echo "密码不正确";
			}
		
		}
		else 
		{
			
			echo "Unable to jump to row 0 on MySQL result index 5 in ";
			//echo "supplied argument is not a valid MySQL result resource;用户名不存在";
		}
	
	}
//mysql_result
//mysql_num_rows
//mysql_num_fields
//mysql_fetch_field
//mysql_free_result
//mysql_num_rows

	
	
	

	//$this->link
//mysql_insert_id
//mysql_close
//mysql_affected_rows
}