PHP菜鸟入门之简单的登录注册

刚入门的时候做的，很多东西还不会就做的麻烦了些，样式简洁
功能：登录注册注销。登陆成功则显示信息，登录失败则提示错误。
登录页面login.html：

div {
width: 400px;
margin: auto;
border:1px solid black;
padding-left: 150px;
}
input {
margin-top: 3px;
margin-bottom: 3px;
}
form {
margin-bottom: 20px;
}





please login




name:      



password:





还没有账号?点此处注册 

注册页面（有用户名的正则判断）register.php

getMessage();
}
?>

	please input your message


	
">
		name:    
		
		 *
		

		password:
		
		 *
		

		
		 
		去登陆
		

			
		
	

主页面（登录之后的页面无论是否成功都跳转到这个页面）login.php

 $value) {
		$search_user = $value["count(uname)"];
	}
	
	if ($search_user == 1) {
		$display = true;
			
			$result_text = "welcome " . $_POST["name"] . "!!! 请选择您要进行的操作(修改/注銷)";
			echo "

";
			
			$sql_emp = "select e.*,s.* from emp e,score s where e.uname='" . $search_name . "' and e.uname = s.uname;";
			$emp = sqlQuery('test', $sql_emp);
			$sql_max = 'select max(math) from test.score;';
			$score_max = sqlQuery('test', $sql_max);
			$sql_min = 'select min(chinese) from test.score;';
			$score_min = sqlQuery('test', $sql_min);
	} else {
		
		$display = false;
		$result_text = "please check your username and password";
		throw new Exception('your password or username is wrong');
	}
} catch (Exception $e) {
	echo  $e->getMessage();
}
?>

	


	

		name:    
		" placeholder="" readonly />
		

		password:
		
		

		(修改成功会直接前往登录主页！)
	
	  ">注销
	  回到登录页面
	



 $value) {
			$total_score = $value["chinese"] + $value["math"];
			$average_score = $total_score / 2;
			echo "";
			echo "";
			echo "";
			echo "";
			echo "";
			echo "";
			echo "";
			echo "";
		}
		foreach ($score_max as $key => $value) {
			echo "数学最高分是:";
			echo $value["max(math)"];
		}
		foreach ($score_min as $key => $value) {
			echo "语文最低分是";
			echo $value["min(chinese)"];
		}
	}
	?>

	

		
name
		
gender
		
dept
		
math_score
		
chinese_score
		
total_score
		
average_score
	
	
" . $value["uname"] . "
" . $value["gender"] . "
" . $value["dept"] . "
" . $value["math"] . "
" . $value["chinese"] . "
" . $total_score . "
" . $average_score . "

删除方法：delete.php

getMessage();
}
echo "
";
echo "点击前往登录页面";
echo "
";
echo "点击前往注册页面";
?>

修改方法modify.php

getMessage();
}
?>

错误页面error.php

	
		

			name:    
			
			
		
	

连接数据库方法 connection.php(我放在了db文件夹下面，注意路径)

 "set names utf8"));
	} catch (PDOException $e) {
		die("Error:" . $e->getMessage() . "
");
	}
	return $dbh;
}
function sqlQuery($udb_name, $sql)
{
	//初始化一个PDO对象
	$dbh =  dbConn($udb_name);
	$shou = $dbh->query($sql);
	return $shou;
}
function sqlExec($udb_name, $sql)
{
	//初始化一个PDO对象
	$dbh = dbConn($udb_name);
	$num = $dbh->exec($sql);
	return $num;
}