PHP and mysql database realize web page login verification code sharing

This article mainly brings you an example of PHP and mysql database, web page login verification in ubutu 16.04 environment. The editor thinks it is quite good, so I will share it with you now and give it as a reference for everyone. Let’s follow the editor to take a look, I hope it can help everyone.

It happened that the recent domain name registration was passed, and I suddenly wanted to create a web page, although I had registered the domain name before for this purpose.

I asked a few people and said that it is easy to build a website using PHP on Linux, so I tried to make one. Here I mainly talk about the parts related to login verification;

The Prime Minister prepared a few documents , mainly index.php, conn.php, data.php and login.php;

login.php is mainly the data comparison part during the login process; the content of include ('conn.php') is as follows There is something to say.

<?php
if(!isset($_POST[&#39;submit&#39;])){
 exit(&#39;login in error.&#39;);
}
$username = htmlspecialchars($_POST[&#39;username&#39;]);
$password = MD5($_POST[&#39;password&#39;]);
include(&#39;conn.php&#39;);
echo"$password";
$check_query = mysqli_query($result,"select USERID from USERINFO where EMAIL=&#39;$username&#39; and PASSWORD=&#39;$password&#39; limit 1");
if($ret = mysqli_fetch_array($check_query)){

 echo&#39;connect true.&#39;;
}
else
{
 echo&#39;connect false&#39;;
}
?>

Another thing to note is: $_POST targets the content in method = "post" in the form.

Because the MD5 encryption method is used, let me talk about it. When encrypting the background database, you also need to use the MD5 encryption method to update the data. The specific method is as follows:

UPDATE USERINFO SET PASSWORD = md5('root') WHERE USERID = 1000;

The table And the specific query location depends on the personal database.

conn.php is mainly related to the operations related to mysql database connection, which is divided into database connection and database selection part (pay attention to the return value of the database connection, do not use it casually, it will be used when citing later. )

<?php
try{
$result = mysqli_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;root&#39;);
mysqli_select_db($result,&#39;WEBDATAS&#39;);
}catch(Exception $e)
{
 echo $e->message;
 exit;
}
if(!$result)
{
 return false;
}
echo "ok\n";
?>

The rest is mainly index.php. This file is related to the homepage. I will only take out the login-related parts to explain (the template in boostrap is used here, for those who are interested) You can search boostrap on Baidu)

<?php
session_start();
include_once(&#39;data.php&#39;);

$handle = db_connect();
if(!$handle){
 echo &#39;Did not access to the database&#39;;
}else{
 echo&#39;connect success&#39;;
}
?>

The data.php login part contained in it is as follows:

<p class="modal fade" tabindex="-1" role="dialog" id="login">
   <p class="modal-dialog" role="document">
    <p class="modal-content">
     <p class="modal-header">
      <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
      <h3 class="modal-title">ログイン</h3>
     </p>
     <p class="modal-body">
      <form class="form-signin" action="login.php" method = "post">
       <h4 class="form-signin-heading">利用者名 パスワード 入力</h4>
       <label for="inputEmail" class="sr-only">利用者名</label>
       <input type="email" name="username" id="inputEmail" class="form-control" placeholder="利用者名を入力" required autofocus>
       <label for="inputPassword" class="sr-only">パスワード</label>
       <input type="password" name="password" id="inputPassword" class="form-control" placeholder="パスワード" required>
       <p class="checkbox">
        <label>
        <input type="checkbox" value="remember-me"> ログイン状態を保持
       </label>
       </p>
       <button class="btn btn-lg btn-primary btn-block" type="submit" name="submit">ログイン</button>
      </form>
     </p>
     <p class="modal-footer">
      <button type="button" class="btn btn-default" data-dismiss="modal">クローズ</button>
     </p>
    </p>
    <!-- /.modal-content -->
   </p>
   <!-- /.modal-dialog -->
  </p>

The basic login verification part is these, mainly for comparison with the data in the database, which was used at the beginning The symmetric encryption method has not been carefully studied yet. I will take a closer look at it later when I have the opportunity.

Related recommendations:

Implement the function of remembering username and password in web login (complete automatic login)

The above is the detailed content of PHP and mysql database realize web page login verification code sharing. For more information, please follow other related articles on the PHP Chinese website!