请帮我，我试图使用php和mysql开发一个简单的登录页面 [英] Please help me out im trying to develop a simple login page using php and mysql
本文介绍了请帮我，我试图使用php和mysql开发一个简单的登录页面的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我已经使用phpmyadmin创建了一个数据库
它有一个名为userregistration的数据库和一个具有三个字段id，username和password的表registeredusers.
我还插入了一个示例用户danish farman，其密码为dany11.
现在我不知道我的编码缺少什么，如下所示:
I have already created a database using phpmyadmin
It has a database named userregistration and a table registeredusers with 3 fields id, username and password.
I also have inserted a sample user danish farman with password dany11.
Now i don''t know where I have lacked in my coding which is shown right below:
<?php
// 1. Create a database connection
$conn = mysql_connect("localhost","root","");
if (!$conn) {
die("Database connection failed: " . mysql_error());
}
// 2. Select a database to use
$db_select = mysql_select_db("userregistration",$conn);
if (!$db_select) {
die("Database selection failed: " . mysql_error());
}
?>
<html>
<head>
<title>Simple Logon Process71486le>
</head>
<body>
<form method="post">
Username: <input type="text" name="username" value=""></input><br /><br />
Password: <input type="password" name="password" value=""></input><br /><br />
<input type="submit" name="submit" onclick="<?php login(); ?>"></input><br />
</form>
</body>
</html>
<?php
function login() {
$un = $_POST['username'];
$pwd = $_POST['password'];
// if ($un == "danish farman" && $pwd == "dany11") {
// 3. Perform database query
$row = mysql_query("SELECT username, password FROM registeredusers WHERE username = {$un} AND password = {$pwd}",$conn);
if (!$row) {
die("Database query falied: " . mysql_error());
}
// 4. Use returned data
if(!$result) {
die("Can't display record: " . mysql_error());
}
while($result = mysql_fetch_array($row)) {
echo "Username: {$result["username"]} Password: {$result["password"]}";
echo "Hi! {$result["username"]} your login was successful!";
}
// }
}
?>
<?php
// 5. Close connection
mysql_close($conn);
?>
请帮助我，并提供一些链接，以研究有关使用PHP和MySQL创建注册页面和用户个人资料页面的主题.
Please kindly help me out and suggest some links for studying topics on creating a registration page and user profile page using PHP and MySQL.
推荐答案
conn = mysql_connect (" ，" 根"， "); 如果(！
conn = mysql_connect("localhost","root",""); if (!
conn){ die(" .mysql_error()); } // 2.选择要使用的数据库
conn) { die("Database connection failed: " . mysql_error()); } // 2. Select a database to use
db_select = mysql_select_db(" ，
db_select = mysql_select_db("userregistration",
这篇关于请帮我，我试图使用php和mysql开发一个简单的登录页面的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
