<?php
class MySQL_User {
//*************************************检查用户ID参数是否存在,(是否注册),防止恶意用户直接填写参数
function check_user($userid){
global $MySQL;
$SQL=" SELECT User FROM user where User='".$userid."'";
$resultss=$MySQL->query($SQL);
$count=mysql_numrows($resultss);
if ($count!=1){//>=1
return false;//不存在
}else{
return true;//存在
}
}
function check_passwd($user,$passwd){
global $MySQL;
$SQL=" SELECT User,Password FROM user where User='$user' AND Password=";
$SQL.="PASSWORD('$passwd')";
//echo $SQL;
$resultss=$MySQL->query($SQL);
$count=mysql_numrows($resultss);
if ($count!=1){//>=1
return false;//不存在
}else{
return true;//存在
}
}
//***************检查字符串是否为空******************
function CheckEmptyString($C_char)
{
if (!is_string($C_char)) return false;
if (empty($C_char)) return false;
if ($C_char=='') return false;
return true;
}
function CheckPassword($C_passwd)
{
if (!$this->CheckLengthBetween($C_passwd, 4, 20)) return false;
if (!ereg("^[_a-zA-Z0-9]*$", $C_passwd)) return false;
return true;
}
function CheckLengthBetween($C_cahr, $I_len1, $I_len2=100)
{
$C_cahr = trim($C_cahr);
if (strlen($C_cahr) < $I_len1) return false;
if (strlen($C_cahr) > $I_len2) return false;
return true;
}
function ShowCopyright(){
global $copyright;
echo $copyright;
}
function TextFilter($str){
$str = chop($str);
$str = nl2br(htmlspecialchars( $str ));
return $str;
}
function DomainStrReplace($vdstr){
$vdstr = str_replace(".","_",$vdstr);
return $vdstr;
}
//******************************** 用户申请函数 ****************************
function Grant($username,$password,$host){
global $MySQL,$phpMyAdmin;
//检查表单数据合法性
$check_boolean=true;
if(!$this->CheckEmptyString($username)||!$this->CheckPassword($password)){
$check_result="密码不合法，请确定你的密码是否(4-16位数字,字母及组合)!";
$check_boolean=false;
}
if($this->check_user($username)){
$check_result="用户名已经存在!";
$check_boolean=false;
}
if(!$check_boolean){
$check_result.=" <a href='#' onclick='javascript:history.go(-1)'>返回修改</a>";
echo $check_result;
}else{
$SQL="Create Database $username";
$MySQL->query($SQL);
$SQL="GRANT ALL PRIVILEGES ON $username.* TO $username@'$host' IDENTIFIED BY '$password'";
$result=$MySQL->query($SQL);
$RegMsg="注册成功!请保存好你的用户和密码<br>";
$RegMsg.="MySQL 用户: $username <br>";
$RegMsg.="MySQL 密码: $password <br>";
$RegMsg.="MySQL 主机: $host <br>";
$RegMsg.="MySQL 数据库: $username <br>";
$RegMsg.=$phpMyAdmin;
if ($result){
echo $RegMsg;
}
}
}
function ModifyHost($username,$password,$host){
global $MySQL,$phpMyAdmin;
//检查表单数据合法性
$check_boolean=true;
if(!$this->CheckEmptyString($username)||!$this->CheckPassword($password)){
$check_result="密码不合法，请确定你的密码是否(4-16位数字,字母及组合)!";
$check_boolean=false;
}
if(!$this->check_user($username)){
$check_result="用户名不存在!";
$check_boolean=false;
}
if(!$this->check_passwd($username,$password)){
$check_result="密码不正确!";
$check_boolean=false;
}
if(!$check_boolean){
$check_result.=" <a href='#' onclick='javascript:history.go(-1)'>返回修改</a>";
echo $check_result;
}else{
$SQL="UPDATE user SET Host='$host' WHERE user='$username'";
$result=$MySQL->query($SQL);
$RegMsg="主机修改成功!请保存好你的用户和密码<br>";
$RegMsg.="MySQL 用户: $username <br>";
//$RegMsg.="MySQL 密码: $password <br>";
$RegMsg.="MySQL 主机: $host <br>";
$RegMsg.="MySQL 数据库: $username <br>";
$RegMsg.=$phpMyAdmin;
if ($result){
echo $RegMsg;
}
}
}
function ModifyPassword($username,$oldpasswd,$newpasswd){
global $MySQL,$phpMyAdmin;
//检查表单数据合法性
$check_boolean=true;
if(!$this->CheckEmptyString($username)||!$this->CheckPassword($newpasswd)){
$check_result="密码不合法，请确定你的密码是否(4-16位数字,字母及组合)!";
$check_boolean=false;
}
if(!$this->check_user($username)){
$check_result="用户名不存在!";
$check_boolean=false;
}
if(!$this->check_passwd($username,$oldpasswd)){
$check_result="密码不正确!";
$check_boolean=false;
}
if(!$check_boolean){
$check_result.=" <a href='#' onclick='javascript:history.go(-1)'>返回修改</a>";
echo $check_result;
}else{
$SQL="SET PASSWORD FOR $username = PASSWORD('$newpasswd')";
$result=$MySQL->query($SQL);
$RegMsg="MySQL 数据库密码修改成功!请保存好你的用户和密码<br>";
$RegMsg.="MySQL 用户: $username <br>";
$RegMsg.="新的MySQL 密码: $newpasswd <br>";
//$RegMsg.="MySQL 主机: $host <br>";
$RegMsg.="MySQL 数据库: $username <br>";
$RegMsg.=$phpMyAdmin;
if ($result){
echo $RegMsg;
}
}
}
}
?>
MySQL数据库用户在线注册系统
需积分: 50 125 浏览量
2006-03-16
00:00:00
上传
评论
收藏 26KB RAR 举报
13903_mysql.rar （26个子文件） 
mysql 
index.html 5KB images _vti_cnf 
mysql-logo.gif 362B mysql-logo.gif 3KB
mysqlmodifyhost.php 2KB mysqlmodifyhost.html 6KB mysqlgrant.php 2KB mysqlmodifypasswd.php 2KB mysqladduser.html 6KB mysqlgrant.php.bak 2KB from.js.bak 557B mysqlmodifygrant.php.bak 2KB from.js 734B mysqlmodifypasswd.html 6KB _notes include config.inc.php 1KB global.php.bak 1KB global.php 1KB language EN.inc.bak 441B HZ_CN.inc.bak 433B HZ_CN.inc 427B EN.inc 473B mysql.inc.php 4KB privileges.inc.php 5KB from.js.bak 572B privileges.inc.php.bak 5KB config.inc.php.bak 1KB _notes mysql.php.bak 4KB资源评论
