PHP MYSQL实现登陆和模糊查询两大功能

前端之家收集整理的这篇文章主要介绍了PHP MYSQL实现登陆和模糊查询两大功能前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

本文使用的软件版本如下:PHP版本 5.5.12;MysqL版本 5.6.17;Apache 2.4.9 用的wampserver

一、PHPMysqL实现登陆

一共含有两个文件

login.PHP

logincheck.PHP;

表单代码

PHP"method="post">
 Yonghu:<inputtype="text" name="username" />


Mima:


<a href="register.PHP">zhuce:

后台处理代码

PHP;"> PHP
 if(isset($_POST["submit"])&& $_POST["submit"] == "登陆")

 {

      $user= $_POST["username"];

      $psw= $_POST["password"];

      if($user== "" || $psw == "")

      {

          echo"<script>alert('请输入<a href="/tag/yonghuming/" target="_blank" class="keywords">用户名</a>或密码!'); history.go(-1);</script>";

      }

      else

      {

          $link= <a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_connect('localhost','sa','123456','account');//<a href="/tag/lianjie/" target="_blank" class="keywords">链接</a><a href="/tag/shujuku/" target="_blank" class="keywords">数据库</a>

          <a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_select_db($link,"account");

          <a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_query($link,'setname utf8');

          $<a href="/tag/sql/" target="_blank" class="keywords">sql</a>= "selectuser from zhanghu where user = '$_POST[username]'";

          $result=<a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_query($link,$<a href="/tag/sql/" target="_blank" class="keywords">sql</a>)or die("<a href="/tag/Failed/" target="_blank" class="keywords">Failed</a>".<a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>_error());

          if($num=<a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_num_rows($result))

          {

               $row= <a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_fetch_array($result);    //将数据以索引方式储存在数组中

               echo"welcome ";

               echo$row[0];

          }

          else

          {

               echo"<script>alert('<a href="/tag/yonghuming/" target="_blank" class="keywords">用户名</a>或密码不正确!');history.go(-1);</script>";

          }

      }

 }

 else

 {

      echo"<script>alert('Submit <a href="/tag/Failed/" target="_blank" class="keywords">Failed</a>!');history.go(-1);</script>";

 }

?>

Account数据库内容

二、PHPMysqL实现模糊查询

查询数据库(只给PHP代码):

PHP;"> $mysqli=newmysqli(); $mysqli->connect("localhost","sa","123456"); if(<a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_connect_errno()) { printf("Failllllll:%s\n",<a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i_connect_error()); exit(); } $<a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i->select_db("booklib"); $<a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i->query("SETNAMES utf8"); $rsbooks= $<a href="/tag/MysqL/" target="_blank" class="keywords">MysqL</a>i->query("select * from books where Name like'%$_POST[bookname]%'");

$row_rsbooks = $rsbooks->fetch_assoc();

$totalRows_rsbooks = $rsbooks->num_rows;

?> Totel

<?php echo $totalRows_rsbooks ?>books;

<table width="600"border="1">

<tr>

<td bgcolor="#99CCFF"align="center">Name</td>

<td bgcolor="#99CCFF" align="center">ISBN</td>

<td bgcolor="#99CCFF"align="center">Store</td>

<td bgcolor="#99CCFF"align="center">Do</td>

</tr>

<?php do { ?>

<tr>

<td><?php echo $row_rsbooks['Name']; ?></td>

<td><?php echo $row_rsbooks['ISBN']; ?></td>

<td><?php echo $row_rsbooks['Store']; ?></td>

<td><fontcolor="#110BAA">rent</td>

</tr>

<?php } while ($row_rsbooks = $rsbooks->fetch_assoc()); ?>

</table>

<?php

$rsbooks->close();

$MysqLi->close();

?>

数据库表的内容如下:

查询

结果:

以上就是本文的全部内容,希望对大家学习PHP程序设计有所帮助。

猜你在找的PHP相关文章