由于需要,我需要用php和mysql语言制作一个简单的用户登录界面(提示登录成功即可),但我一点这方面的基础没有,我就知道要三个东西(html表单,php,mysql),就会用C编程,我想问一下,这需要用什么软件,并且大概是什么样的程序代码,分别用什么写?请哪位大哥解释一下,非常感谢!
软件:dreamwaver 记事本 也可以
mysql.php----数据库创建文件;
login.php----前台用户登陆文件;
check.php----连接数据库验证文件;
mysql.php文件代码:
程序代码
<?php
$db = mysql_connect("localhost","root","") or die("连接数据库失败!");
if(!mysql_query("create database if not exists `user`"))
{
echo "创建数据库失败<br>";
}else
{
echo "创建数据库成功!<br>";
}
mysql_query("use user;");
$sql ="Create TABLE if not exists `user` ("
." `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,"
." `name` VARCHAR(10) NOT NULL,"
." `password` VARCHAR(16) NOT NULL"
." )";
if(!mysql_query($sql))
{
echo "创建数据表失败!<br>";
}else
{
echo "创建数据表成功!<br>";
}
$sql = "Insert INTO `user` ( `name`, `password`) VALUES ( 'php-fish', '123');";
if(mysql_query($sql))
echo "插入用户成功!<br>";
else
echo "插入失败!<br>";
mysql_close($db);
?>
前台登陆文件login.php
程序代码
<form method="post" action="check.php">
<table cellpadding="0" cellspacing="0" border="0" width="25%">
<tr>
<td>用户名:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>密码:</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td><input type="submit" value="提交"></td>
<td><input type="reset" value="清除"></td>
</tr>
</table>
</form>
用户名:<b>php-fish</b>
<br>
密码:<b>123<br>
验证文件check.php
程序代码
<?php
if($_POST['name'] == "")
{
echo "请填写用户名<br><a href='login.php'>返回</a>";
}elseif($_POST['password'] == "")
{
echo "请填写密码<br><a href='login.php'>返回</a>";
}else
{
$conn = mysql_connect("localhost","root","")
or die("不能连接数据库".mysql_error());
mysql_select_db("user")
or die ("不能连接到user".mysql_error());
$sql = "select * from user where id=3";
$result = mysql_query($sql);
$query = mysql_fetch_array($result);
mysql_close($conn);
if(($query['name'] == $_POST['name']) && ($query['password'] == $_POST['password']))
{
echo "验证成功!<br>";
}else
echo "密码错误<br>";
echo "<a href='login.php'>返回</a>";
}
?>
mysql.php----数据库创建文件;
login.php----前台用户登陆文件;
check.php----连接数据库验证文件;
mysql.php文件代码:
程序代码
<?php
$db = mysql_connect("localhost","root","") or die("连接数据库失败!");
if(!mysql_query("create database if not exists `user`"))
{
echo "创建数据库失败<br>";
}else
{
echo "创建数据库成功!<br>";
}
mysql_query("use user;");
$sql ="Create TABLE if not exists `user` ("
." `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,"
." `name` VARCHAR(10) NOT NULL,"
." `password` VARCHAR(16) NOT NULL"
." )";
if(!mysql_query($sql))
{
echo "创建数据表失败!<br>";
}else
{
echo "创建数据表成功!<br>";
}
$sql = "Insert INTO `user` ( `name`, `password`) VALUES ( 'php-fish', '123');";
if(mysql_query($sql))
echo "插入用户成功!<br>";
else
echo "插入失败!<br>";
mysql_close($db);
?>
前台登陆文件login.php
程序代码
<form method="post" action="check.php">
<table cellpadding="0" cellspacing="0" border="0" width="25%">
<tr>
<td>用户名:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>密码:</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td><input type="submit" value="提交"></td>
<td><input type="reset" value="清除"></td>
</tr>
</table>
</form>
用户名:<b>php-fish</b>
<br>
密码:<b>123<br>
验证文件check.php
程序代码
<?php
if($_POST['name'] == "")
{
echo "请填写用户名<br><a href='login.php'>返回</a>";
}elseif($_POST['password'] == "")
{
echo "请填写密码<br><a href='login.php'>返回</a>";
}else
{
$conn = mysql_connect("localhost","root","")
or die("不能连接数据库".mysql_error());
mysql_select_db("user")
or die ("不能连接到user".mysql_error());
$sql = "select * from user where id=3";
$result = mysql_query($sql);
$query = mysql_fetch_array($result);
mysql_close($conn);
if(($query['name'] == $_POST['name']) && ($query['password'] == $_POST['password']))
{
echo "验证成功!<br>";
}else
echo "密码错误<br>";
echo "<a href='login.php'>返回</a>";
}
?>
温馨提示:答案为网友推荐,仅供参考