Example explanation of php and mysql database and web page login verification in ubutu 16.04 environment

The following editor will bring you an example of PHP and mysql database and web page login verification in ubutu 16.04 environment. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look.

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 previously 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 we mainly talk about the parts related to login verification;

The Prime Minister prepared several files, 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 described below.

<?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;;
}
?>

Also note that $_POST is for 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 tables and specific query locations are determined by 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 explain the login-related parts (used here It is a template in boostrap. If you are interested, you can Baidu boostrap)

<?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 included 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 id="ログイン">ログイン</h3>
     </p>
     <p class="modal-body">
      <form class="form-signin" action="login.php" method = "post">
       <h4 id="利用者名-nbsp-パスワード-nbsp-入力">利用者名 パスワード 入力</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 part about login verification is these. It is mainly to compare with the data in the database. The symmetric encryption method was used at the beginning. I have not studied the encryption method carefully. I will take a closer look later when I have the opportunity. good.

The above is the detailed content of Example explanation of php and mysql database and web page login verification in ubutu 16.04 environment. For more information, please follow other related articles on the PHP Chinese website!