apache mysql 登陆_Apache站点，注册登陆功能的实现
$loginmsg = '去登陸...';//賬戶驗證
if ($_POST['userName']) {
$host= "127.0.0.1";//mysql主機地址
$user = "root"; //mysql 登錄賬戶
$pwd = "949969709"; //mysql登錄密碼//連接數據庫
$conn =mysqli_connect($host, $user, $pwd);//判斷
if (!$conn) {
die('連接數據庫失敗:'. mysqli_connect_error());
}else{//echo "mysql 連接成功！
";
mysqli_select_db($conn, "userMsg"); //連接具體的庫
mysqli_query($conn, "SET NAMES UTF8"); //設置編碼格式
$query = "SELECT * FROM msg"; //查詢庫里面的具體的某個文件 比如：一個表名
$result = mysqli_query($conn, $query); //返回查詢結果集
while (!!$row = mysqli_fetch_array($result)) { //以數組方式遍歷
if ($row['username'] == $_POST['userName']) {if ($row['userpassword'] === $_POST['userPassword']) {
$loginmsg= '去登陸...';
header("location:./www/");
$ip= getenv("REMOTE_ADDR");
file_put_contents('./ip.txt', $ip . ';', FILE_APPEND);
}else{//echo "";
$loginmsg = '密碼錯誤，請重新輸入';
mysqli_close($conn);//斷開數據庫連接//echo '密碼錯誤,請重新輸入
3秒后跳轉';//header("refresh:3 ; url=./index.php");
break;
}
}if ($row['username']!=$_POST['userName']) {//echo "";
$loginmsg = '賬戶名錯誤，請重新輸入';
mysqli_close($conn);//斷開數據庫連接//echo '賬戶名錯誤或不存在,請重新輸入或者注冊
3秒后跳轉';//header("refresh:3 ; url=./index.php");
break;
}
}
}
}//注冊 部分
if ($_POST['username']) {
$host= "127.0.0.1";//mysql主機地址
$user = "root"; //mysql 登錄賬戶
$pwd = "949969709"; //mysql登錄密碼
$username = $_POST['username'];
$userpassword= $_POST['userpassword'];
$name= $_POST['name'];
$class = $_POST['class'];
$ip= getenv("REMOTE_ADDR");if ($class == 1) {
$class = '前端';
}else if ($class == 2) {
$class = 'Python';
}else if ($class == 3) {
$class = 'Java';
}//連接數據庫
$conn =mysqli_connect($host, $user, $pwd);//判斷
if (!$conn) {
die('連接數據庫失敗:'. mysqli_connect_error());
}else{
echo"mysql 連接成功！
";
mysqli_select_db($conn,"userMsg"); //連接具體的庫
mysqli_query($conn, "SET NAMES UTF8"); //設置編碼格式
};//插入數據 到數據庫的表中//格式: $insertdata = "insert into 表名(id,name,password) values('9','pick','8888')";
$insertdata = "insert into msg(username,userpassword,name,class,ip) values('$username','$userpassword','$name','$class','$ip')"; //插入
if ($conn->query($insertdata) == true) { //判斷表中是否有了這個數據
echo "注冊成功"; //存在了 返回插入成功
} else{
echo"Error insert data:" . $conn->error; //不存在 返回插入失敗
};
mysqli_close($conn);
}?>
Title*{
margin:0;
padding:0;
text-decoration: none;
}
body {
background-color: rgba(29, 78, 128, .8);
}
form {
position: absolute;
top:50%;
left:50%;
transform: translate(-50%, -50%);
background-image: linear-gradient(
45deg,
blue,
skyblue,
green
);
padding: 10px 30px;
border-radius: 12px;
width: 400px;
text-align: center;
box-shadow: 0 10px 35px #000;
z-index: 1;
}
h2 {
color: white;
}
.inputBox {
overflow: auto;
position: relative;
}
input {
width: 280px;
padding: 10px 10px;
border: 1px solid #fff;
margin: 20px;
outline: none;
font-size: 16px;
border-radius: 6px;
}
label {
position: absolute;
top: 28px;
left: 66px;
transition: .5s;
color: #FF6666;
pointer-events: none;
}
input:focus~label,
input:valid~label {
top:-6px;
font-size: 14px;
color: #67ff4a;
}
.button {
display: block;
width: 80px;
height: 36px;
padding:0;
line-height: 36px;float: left;
border-radius: 8px;
margin: 5px 60px;
text-align: center;
border:0;
color: orange;
font-size: 16px;
cursor: pointer;
background-color: rgba(0, 0, 0, .5);
opacity: .8;
}
.login-box {
position: absolute;
top:0;
left:-100%;/*left: 0;*/width:100%;
height: 100vh;
transition: .5s;
background-image: linear-gradient(
45deg, darkslategray, skyblue, salmon
);
}
.close-login-btn {
position: absolute;
top: 40px;
right: 40px;
color: white;
font-size: 30px;
transform: rotate(45deg);
cursor: pointer;
width: 40px;
height: 40px;
text-align: center;
line-height: 40px;
}
.show-login-btn {
color: white;
position: absolute;
top:50%;
left:50%;
transform: translate(-50%, -50%);
border: 1px solid #fff;
padding: 10px;
cursor: pointer;
border-radius: 4px;
}
.show-login-btn:hover {
background-color: rgba(0, 0, 0, .5);
color: #e33333;
z-index: 1;
}
.to-show {
left:0;
}
.mask {
position: absolute;
top:0;
width:100%;
height:100%;
margin:0;
padding:0;
background-color: rgba(0, 0, 0, .6);
display: none;
transition: .8s;
}
.form {
width: 460px;
height: 459px;
}select{
width: 280px;
height: 30px;
border: 1px solid #fff;
margin: 20px;
outline: none;
font-size: 16px;
border-radius: 6px;
}
option {
text-align: center;
}
input[type=submit] {
cursor: pointer;
}
.massage {
position: absolute;
left:50%;/*top: 160px;*/top:0;
transform: translateX(-50%);
width: 460px;
height: 50px;
color: white;
line-height: 50px;
background-color: darkgreen;
border-radius: 12px;
z-index: 0;
padding-left: 10px;
box-sizing: border-box;
display: block;
}
.massage span {
display: inline-block;
width: 200px;
color: white;
height: 50px;
line-height: 50px;
margin-left: 40px;
text-align: center;
}
->Show Login Form
+
Login
Username
password
sign in
Login In
用戶名：密 碼：
姓 名：
類 別：
前端
Python
Java
Massage: <?php echo $loginmsg;?>//這里是引入的jquery 部分文件 為實現后面的功能//相當于引入了jquery 文件
function hasClass(element, clssname) {return element.className.match(new RegExp('(\\s|^)' + clssname + '(\\s|$)'))
}
function addClass(element, clssname) {if (!this.hasClass(element, clssname)) element.className += ' ' +clssname
}
function removeClass(element, clssname) {if(hasClass(element, clssname)) {var reg = new RegExp('(\\s|^)' + clssname + '(\\s|$)')
element.className= element.className.replace(reg, ' ')
}
}
function toggleClass(element, clssname) {if(hasClass(element, clssname)) {
removeClass(element, clssname)
}else{
addClass(element, clssname)
}
}//功能區
var loginBox = document.getElementsByClassName('login-box')var showBtn = document.getElementsByClassName('show-login-btn')var hideBtn = document.getElementsByClassName('close-login-btn')var loginIn = document.querySelector('form a')var mask = document.querySelector('.mask')var login = document.querySelectorAll('.button')[1]var msg = document.querySelector('.massage')
showBtn[0].addEventListener('click', function () {
toggleClass(loginBox[0], 'to-show')
msg.style.display= 'none'})
hideBtn[0].addEventListener('click', function () {
toggleClass(loginBox[0], 'to-show')
msg.style.display= 'block'f()
})
loginIn.addEventListener('click', function () {
mask.style.display= 'block'})var span = msg.querySelector('span')
window.addEventListener('load', function () {//msg.style.display = 'block'//msg.style.top = '160px'
f()
})
function f() {if (span.innerHTML !='去登陸...') {
msg.style.background= 'orangered'msg.style.color= '#000'span.style.color= '#000'}
animate(msg,188)
setTimeout(function () {
animate(msg,488,function () {
msg.style.display= 'none'})
},2000)
}//注冊驗證
var yz = document.querySelectorAll('.yz')var reg = new RegExp(/^[0-9a-zA-Z-\W]{6,16}$/)var tj = document.querySelector('.tj');
yz[0].addEventListener('change',function () {if (reg.test(this.value)&®.test(yz[1].value)) {
tj.disabled= falsetj.style.color= 'green'}
})
yz[1].addEventListener('change',function () {if (reg.test(this.value)&®.test(yz[1].value)) {
tj.disabled= false;
tj.style.color= 'green'}
})
創作挑戰賽新人創作獎勵來咯，堅持創作打卡瓜分現金大獎總結
以上是生活随笔為你收集整理的apache mysql 登陆_Apache站点，注册登陆功能的实现的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： create用法java_Java Ac
- 下一篇： php对象魔术方法,php学习之类与对象