简单php登录数据库源码 php数据库登录注册页面

一个简单的php+mysql用户登录验证的代码

$db=mysql_connect(连接你的数据库);

mysql_select_db('login', $db);

$u=$_POST['u'];

$p=$_POST['p'];

if($u $p){

$query=mysql_query('select * from exam where name=\''.$u.'\'',$db);

if($re=mysql_fetch_array($query,MYSQL_ASSOC)$re['password']==$p){

exit('scriptalert(\'登陆成功\');history.back();/script');

}else{

exit('scriptalert(\'用户名不存在,或密码错误\');history.back();/script');

}

}

求一个简单的php登录页面代码，只需要用户名和密码与数据库中表里面的信息相同就可以登录的页面代码

error_reporting(0);

$mysql_servername = "localhost";

$mysql_username = "数据库用户名";

$mysql_password ="密码";

$mysql_database ="数据库名";

mysql_connect($mysql_servername , $mysql_username , $mysql_password);

mysql_select_db($mysql_database);

$name=$_POST['user_name'];

$passowrd=$_POST['user_password'];

if ($name $passowrd){

$sql = "SELECT * FROM admin WHERE name = '$name' and password='$passowrd'";

$res = mysql_query($sql);

$rows=mysql_num_rows($res);

if($rows){

header("location='主页'");

exit;

}

echo "script language=javascriptalert('用户名密码错误');history.back();/script";

}else {

echo "script language=javascriptalert('用户名密码不能为空');history.back();/script";

}

求一个php的登陆源码。功能简单就行

index.php

html

head

title登录界面/title

meta http-equiv="Content-Type" content="text/html; charset=utf-8" /

/head

body

?php

//将用户提交的用户名和密码和数据库中的用户名和密码逐一比对简单php登录数据库源码，如正确简单php登录数据库源码，则进入2.php，错误则提示错误。

$username=$_post['username'];

$password=$_post['password'];

$sql="select * from userinfo where username='$username' and password='$password'";

$re=mysql_query($sql);

$row=mysql_num_rows[$re];

if(!$row){

echo "scriptalert('用户名或密码错误!');history.back(-1);/script";

}

else {

echo '用户登录成功！';

echo 'meta http-equiv=refresh content=2;url=2.php';

}

?

form name="login" method="post" action="index.php"

用户名：input type="text" name="username" /br/

密码：input type="password" name="password" /br/

input type="submit" name="submit" value="登录"

/form

/body

html

PHP+SQLserver制作一个简单的登录功能。

!-- content starts --

?php

if(isset($_POST['add']))

{

date_default_timezone_set('Etc/GMT-8');

$txtname=$_POST['username'];

$txpassword=$_POST['userpwd'];

$txtvalue=$_POST['quxnain'];

$sqlstr = "select * from T1_user where name='".$txtname."'and password=".$txpassword.";";

$conn = mysql_connect("192.168.0.3","root","root");//此处替换用户名和密码

if (!$conn)

{

die('Could not connect: ' . mysql_error());

}

$result = mysql_query($sqlstr);

$rs=mysql_fetch_array($result);

if($rs)

{

echo "scriptalert('登录成功！')/script";

if($txtvalue==1)

echo "meta http-equiv=refresh content='0;url=../face.php'";

else

echo "meta http-equiv=refresh content='0;url=welcome.htm'";

}

else

echo "scriptalert('用户名或密码错误！')/script";

}

?

body

div id="Layer1" style="position:absolute; width:100%; height:100%; z-index:-1"

img src="images/真烦人.gif" height="100%" width="100%"/img

/div

div style='height=100'/div

form name="form1" method="post" enctype="multipart/form-data" action="" onSubmit="return check()"

div style="background-image:url(images/登录小窗口.jpg);margin-left:150px;margin-top:140px;width:542px;height:220px"

table width="449" height="139" style="margin-left:50px;margin-top:55px;"

tr

td width="187"用户名: input name=username type=text class=radio0 size=19/td

td width="30" style="width:70px;"/td

td width="216"button name="add" type="submit" style="background-image:url('images/登陆按钮.jpg');width:210px;height:43px"/button/td

/tr

tr/tr

tr

td密 码：input name=userpwd type=password class=radio0 size=20/td

td/td

td/td

/tr

tr

td 权 限：select name="quxnain" style="width:90px"

option value="1"用户/option

option value="2"管理员/option

/select/td

td/td

tdbutton type="reset" style="background-image:url('images/注册按钮.jpg');width:210px;height:43px" onClick="location='register.php'"/button/td

/tr

/table

/div

/form

/body

/html

拿走用吧

怎么用php写一个简单的登陆页面，要连上数据库

数据库是SQLserver

?

if(isset($_GET['username']))

{

session_start();

$errormsg = "";

$input['username'] = strtolower(trim($_GET['username']));

if($errormsg == "")

{

include("db_link.php");//简单php登录数据库源码你自己SQL数据库所在路径

$sql = "select

user_id,

username,

status

from guestbook

where username = '".$input['username']."' and status = 1";

$result = mysql_query($sql, $link) or die('Query database failed');

$num = mysql_num_rows($result);

if($num 1)

{

$errormsg = "用户名不正确简单php登录数据库源码，请重新登录简单php登录数据库源码！";

}

else

{

$row = mysql_fetch_array($result);

if($row['username'] == $input['username'])

{

$_SESSION['s_user_id'] = $row['user_id'];

$_SESSION['s_username'] = $row['username'];

$_SESSION['s_status'] = $row['status'];

$_SESSION['time_last_load'] = time();

?

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

html

head

title管理员登录/title

style

button,input{font-size:12px;padding-top:2px;font-family : Arial, Helvetica, sans-serif;}

a:link:{color:#666666;}

a:visited:{color:#666666;}

a:hover:{color:#000000}

/style

/head

body style="font-size: 12px;"

table width="280" border="0" cellspacing="0" cellpadding="0" align="center" style="font-size: 12px;border:1px solid #639ECE;"

trtd height="10"/td/tr

trtd height="40" align="center"登录成功简单php登录数据库源码！/td/tr

trtd height="10"/td/tr

trtd height="22" align="right" bgcolor="#EFFBFF"a href="javascript:void(null);" onclick="window.close();"关闭窗口/a /td/tr

/table

/body

/html

?

}

else

{

$errormsg = "用户名不正确，请重新登录！";

}

}

}

if($errormsg "")

{

?

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

html

head

title管理员登录/title

style

button,input{font-size:12px;padding-top:2px;}

/style

/head

body style="font-size: 12px;"

table width="280" border="0" cellspacing="0" cellpadding="5" align="center" style="font-size: 12px;border:1px solid #639ECE;"

trtd height="10" colspan="2"/td/tr

form action="userlogin.php"

tr

td width="60" align="right"用户名简单php登录数据库源码：/td

td width="220"input type="text" name="username" value="?=$input['username']?"/td

/tr

tr

td/td

td align="center" input type="submit" value=" 登录 "/td

/tr

/form

tr

td height="10" colspan="2"/td

/tr

tr

td height="22" colspan="2" bgcolor="#EFFBFF"?=$errormsg?/td

/tr

/table

/body

/html

?

}

}

else

{

?

!--登录页面--

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

html

head

title管理员登录/title

style

button,input{

font-size:12px;

padding-top:2px;

}

/style

/head

body

table width="280" border="0" cellspacing="0" cellpadding="5" align="center" style="font-size: 12px;border:1px solid #639ECE;"

trtd height="10" colspan="2"/td/tr

form action="userlogin.php"

tr

td width="60" align="right"用户名：/td

td width="220"input type="text" name="username"/td

/tr

tr

td/td

td align="center" input type="submit" value=" 登录 "/td

/tr

/form

trtd height="10" colspan="2"/td/tr

/table

/body

/html

?

}

?

关于简单php登录数据库源码和php数据库登录注册页面的介绍到此就结束了，不知道你从中找到你需要的信息了吗 ？如果你还想了解更多这方面的信息，记得收藏关注本站。