首页 / PHP / php-mysql连接

php-mysql连接

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了php-mysql连接，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含5411字，纯文字阅读大概需要8分钟。

内容图文

CREATE DATABASE `dbtest` ; 2 CREATE TABLE `dbtest`.`users` ( 3 `user_id` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , 4 `username` VARCHAR( 25 ) NOT NULL , 5 `email` VARCHAR( 35 ) NOT NULL , 6 `password` VARCHAR( 50 ) NOT NULL , 7 UNIQUE (`email`) 8 ) ENGINE = MYISAM ;

 

dbconnect.php

 1 <?php
 2 if(!mysql_connect("localhost","root","root"))
 3 {
 4      die(‘oops connection problem ! --> ‘.mysql_error());
 5 }
 6 if(!mysql_select_db("dbtest"))
 7 {
 8      die(‘oops database selection problem ! --> ‘.mysql_error());
 9 }
10 ?>

 

index.php

php-mysql连接 - 文章图片php-mysql连接 - 文章图片 
 1 <?php
 2 session_start();
 3 include_once ‘dbconnect.php‘;
 4 
 5 if(isset($_SESSION[‘user‘])!="")
 6 {
 7  header("Location: home.php");
 8 }
 9 if(isset($_POST[‘btn-login‘]))
10 {
11  $email = mysql_real_escape_string($_POST[‘email‘]);
12  $upass = mysql_real_escape_string($_POST[‘pass‘]);
13  $res=mysql_query("SELECT * FROM users WHERE email=‘$email‘");
14  $row=mysql_fetch_array($res);
15  if($row[‘password‘]==md5($upass))
16  {
17   $_SESSION[‘user‘] = $row[‘user_id‘];
18   header("Location: home.php");
19  }
20  else
21  {
22   ?>
23         <script>alert(‘wrong details‘);</script>
24         <?php
25  }
26  
27 }
28 ?>
29 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
30 <html xmlns="http://www.w3.org/1999/xhtml">
31 <head>
32 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
33 <title>cleartuts - Login & Registration System</title>
34 <link rel="stylesheet" href="style.css" type="text/css" />
35 </head>
36 <body>
37 <center>
38 <div id="login-form">
39 <form method="post">
40 <table align="center" width="30%" border="0">
41 <tr>
42 <td><input type="text" name="email" placeholder="Your Email" required /></td>
43 </tr>
44 <tr>
45 <td><input type="password" name="pass" placeholder="Your Password" required /></td>
46 </tr>
47 <tr>
48 <td><button type="submit" name="btn-login">Sign In</button></td>
49 </tr>
50 <tr>
51 <td><a href="register.php">Sign Up Here</a></td>
52 </tr>
53 </table>
54 </form>
55 </div>
56 </center>
57 </body>
58 </html>
View Code

 

home.php

php-mysql连接 - 文章图片php-mysql连接 - 文章图片 
 1 <?php
 2 session_start();
 3 include_once ‘dbconnect.php‘;
 4 
 5 if(!isset($_SESSION[‘user‘]))
 6 {
 7  header("Location: index.php");
 8 }
 9 $res=mysql_query("SELECT * FROM users WHERE user_id=".$_SESSION[‘user‘]);
10 $userRow=mysql_fetch_array($res);
11 ?>
12 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
13 <html xmlns="http://www.w3.org/1999/xhtml">
14 <head>
15 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
16 <title>Welcome - <?php echo $userRow[‘email‘]; ?></title>
17 <link rel="stylesheet" href="style.css" type="text/css" />
18 </head>
19 <body>
20 <div id="header">
21  <div id="left">
22     <label>cleartuts</label>
23     </div>
24     <div id="right">
25      <div id="content">
26          hi‘ <?php echo $userRow[‘username‘]; ?>&nbsp;<a href="logout.php?logout">Sign Out</a>
27         </div>
28     </div>
29 </div>
30 </body>
31 </html>
View Code

 

register.php

php-mysql连接 - 文章图片php-mysql连接 - 文章图片 
 1 <?php
 2 session_start();
 3 if(isset($_SESSION[‘user‘])!="")
 4 {
 5  header("Location: home.php");
 6 }
 7 include_once ‘dbconnect.php‘;
 8 
 9 if(isset($_POST[‘btn-signup‘]))
10 {
11  $uname = mysql_real_escape_string($_POST[‘uname‘]);
12  $email = mysql_real_escape_string($_POST[‘email‘]);
13  $upass = md5(mysql_real_escape_string($_POST[‘pass‘]));
14  
15  if(mysql_query("INSERT INTO users(username,email,password) VALUES(‘$uname‘,‘$email‘,‘$upass‘)"))
16  {
17   ?>
18         <script>alert(‘successfully registered ‘);</script>
19         <?php
20  }
21  else
22  {
23   ?>
24         <script>alert(‘error while registering you...‘);</script>
25         <?php
26  }
27 }
28 ?>
29 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
30 <html xmlns="http://www.w3.org/1999/xhtml">
31 <head>
32 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
33 <title>Login & Registration System</title>
34 <link rel="stylesheet" href="style.css" type="text/css" />
35 
36 </head>
37 <body>
38 <center>
39 <div id="login-form">
40 <form method="post">
41 <table align="center" width="30%" border="0">
42 <tr>
43 <td><input type="text" name="uname" placeholder="User Name" required /></td>
44 </tr>
45 <tr>
46 <td><input type="email" name="email" placeholder="Your Email" required /></td>
47 </tr>
48 <tr>
49 <td><input type="password" name="pass" placeholder="Your Password" required /></td>
50 </tr>
51 <tr>
52 <td><button type="submit" name="btn-signup">Sign Me Up</button></td>
53 </tr>
54 <tr>
55 <td><a href="index.php">Sign In Here</a></td>
56 </tr>
57 </table>
58 </form>
59 </div>
60 </center>
61 </body>
62 </html>
View Code

 

logout.php

 1 <?php
 2 session_start();
 3 
 4 if(!isset($_SESSION[‘user‘]))
 5 {
 6  header("Location: index.php");
 7 }
 8 else if(isset($_SESSION[‘user‘])!="")
 9 {
10  header("Location: home.php");
11 }
12 
13 if(isset($_GET[‘logout‘]))
14 {
15  session_destroy();
16  unset($_SESSION[‘user‘]);
17  header("Location: index.php");
18 }
19 ?>

 

php-mysql连接

标签：post   des   ted   str   orm   indicator   amp   uname   select   

本文系统来源：http://www.cnblogs.com/sunziying/p/6483445.html

内容总结

以上是互联网集市为您收集整理的php-mysql连接全部内容，希望文章能够帮你解决php-mysql连接所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/475669.html

来源：【匿名】