php如何连接mysql实现简单注册登陆页面PHP如何连接mysql实现简单注册登陆页面,
php mysql教程栏目介绍实现简单注册登陆页面。
推荐:php myql教程
登陆页面index.html
注册页面 register.html
安装Mysql数据库后,用MySQL数据库管理页面phpmyadmin创建数据库和表单
浏览器输入:域名/phpmyadmin,没有域名输入:ip/phpmyadmin或者127.0.0.1/phpmyadmin(127。0 .0 .一为本机地址)
在数据库里创建表单
代码如下:
index.html
!DOCTYPE htmlhtmlhead
meta charset=’UTF-8 ‘
标题登录/title/head dy
p
b登录/b
表单操作=’login.php ‘方法=’post ‘
pspan用户名:/span put type=’ text ‘ name=’ user ‘ required=’ ‘ ‘ ‘ ‘ ‘//p
pspan密码:/spaninput type=’ password ‘ name=’ pass ‘/required=’ ‘/p
pinput类型=’reset’ name=”/input类型=’submit’ name=”//p
/form
a href=’register.html ‘新用户注册/a
/p/body/htmllogin.php
meta charset=’utf-8 ‘?php
$ conn=MySQL _ connect(‘ localhost ‘,’ root ‘,’ password ‘,’ db_name ‘)或’ die(‘数据库连接失败);
$ conn-查询(“设置名称”UTF8 ‘ ‘);
$ user=$ _ POST[‘ user ‘];
$ pass=$ _ POST[‘ pass ‘];
$sql=’SELECT * FROM ‘用户,其中用户='{$user} ‘和pass=’ { $ pass }
$ result=$ conn-query($ SQL);
$ row=MySQL _ num _ rows($ result);
//若表中存在输入的用户名和密码,row=1;若表中用户名不存在或密码错误,则row=0
if($row==1){
echo $row[‘user’].’登陆成功!”;
{}
else{
“回声”登录失败,请重新登录!”;
}?register.html
!DOCTYPE htmlhtmlhead
meta charset=’UTF-8 ‘
标题注册/title/head dy
p
b注册/b
表单操作=’register.php ‘方法=’post ‘
pspan用户名:/span put type=’ text ‘ name=’ user ‘ required=’ ‘ ‘ ‘ ‘ ‘//p
pspan密码:/spaninput type=’ password ‘ name=’ pass ‘ required=’ ‘ ‘ ‘ ‘ ‘//p
pspan联系:/spaninput type=’ text ‘ name=’ connect ‘ value=’ ‘ required=’ ‘ ‘ ‘ ‘ ‘//p
p
输入类型=’重置’名称=”/输入类型=’提交’名称=”/
/p
/form
a href=’index.html ‘已注册/a
/p/body/htmlregister.php
?php头(‘内容类型:文本/html;charset=utf-8 ‘);
$ conn=MySQL _ connect(‘ localhost ‘,’ root ‘,’ password ‘,’ db_name ‘)或’ die(‘数据库连接失败);
$ conn-set _ charset(‘ utf8 ‘);
$ user=$ _ POST[‘ user ‘];
$ pass=$ _ POST[‘ pass ‘];
$ connect=$ _ POST[‘ connect ‘];
$ SQL=’ INSERT INTO user(id,user,pass,connect)
VALUES (null,’ {$user} ‘,’ {$pass} ‘,’ { $ connect } ‘)’;
MySQL _ query($ conn,$sql)或die(MySQL _ error($ conn));
回声(‘)注册成功!br/a href=’index.html ‘点击登录/a ‘)?3354——33543543354335435435435435435435435435435435435435435435435435435435435435435-435435-435435-435435-435435-435435-435435-435435-435435-435435-435435-435435-435-44445
补充:(踩过的坑)
1. PHP7连接数据库的方式:使用mysqli或PDO
使用mysqli _ connect()时地址用本地主机而不是ip,否则连接不上服务器。参考:https://博客。csdn。net/zw梁98/article/details/82997349
2. php输出执行sql语句的错误信息:
MySQL _ query($ conn,$sql)或die(MySQL _ error($ conn));3. bugbug 1:Incorrect integer value: ‘’ for column ‘id’ at row 1php5以上的版本如果是空值应该要写NULL
#错误
$ SQL=’ INSERT INTO user(id,user,pass,connect) VALUES(‘,’ {$user} ‘,’ {$pass} ‘,’ { $ connect } ‘)’;#改为
$ SQL=’ INSERT INTO user(id,user,pass,connect) VALUES (null,’ {$user} ‘,’ {$pass} ‘,’ { $ connect } ‘)’;bug 2:Incorrect string value: ‘\xE7\x94\xB7’ for column ‘sex’ at row 1链接:MySQL插入中文错误问题方法