首页 >后端开发 >php教程 >ajax+php+mysql 读取数据库的简单示例

ajax+php+mysql 读取数据库的简单示例

不言原创: 2018-04-17 09:18:243510浏览

这篇文章介绍的内容是关于ajax+php+mysql 读取数据库的简单示例，有着一定的参考价值，现在分享给大家，有需要的朋友可以参考一下

1.创建数据库

create database ajaxdemo default charset utf8;

切换到当前数据库

use ajaxdemo;

创建表并插入数据

CREATE TABLE `ajaxtest` (
  `userid` int(11) NOT NULL AUTO_INCREMENT COMMENT &#39;用户id&#39;,
  `username` varchar(50) NOT NULL COMMENT &#39;用户名&#39;,
  `userpass` varchar(50) NOT NULL COMMENT &#39;密码&#39;,
  `userage` int(11) NOT NULL COMMENT &#39;年龄&#39;,
  `usersex` varchar(1) NOT NULL COMMENT &#39;性别&#39;,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `ajaxtest` VALUES (&#39;1&#39;, &#39;李四&#39;, &#39;lisi&#39;, &#39;15&#39;, &#39;男&#39;);
INSERT INTO `ajaxtest` VALUES (&#39;2&#39;, &#39;张三&#39;, &#39;lisi&#39;, &#39;20&#39;, &#39;女&#39;);
INSERT INTO `ajaxtest` VALUES (&#39;3&#39;, &#39;王五&#39;, &#39;lisi&#39;, &#39;25&#39;, &#39;男&#39;);
INSERT INTO `ajaxtest` VALUES (&#39;4&#39;, &#39;韩梅梅&#39;, &#39;lisi&#39;, &#39;25&#39;, &#39;男&#39;);
INSERT INTO `ajaxtest` VALUES (&#39;5&#39;, &#39;张莉&#39;, &#39;lisi&#39;, &#39;25&#39;, &#39;女&#39;);

2.创建index.php，查询数据库中的信息并展示给用户

<html>
	<head>
		<meta charset="utf-8"/>
		<title>ajax实例</title>
		<link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
	</head>
	<body style="height: 800px;">
		<p class="container">
			<p class="panel panel-default" style="margin-top: 100px;text-align: center;">
				<p class="panel-heading">
					Ajax实例
				</p>
				<p class="panel-body">
					<form class="navbar-form navbar-center" role="search" name="myform">
						<p class="form-group">
							<label>
								年龄:<input type="number" class="form-control" placeholder="Age" name="userage" id=&#39;userage&#39;/>
							</label>
						</p>
						<select class="form-control" id="usersex" name="usersex">
							<option value="男">男</option>
							<option value="女">女</option>
						</select>
						<button type="button" class="btn btn-default" onclick=&#39;ajaxFunction()&#39;>提交</button>
					</form>
					
					<table class="table table-condensed table-bordered" id="ajaxp"></table>
					<p>SQL语句：<pre id="sql">

3.创建ajaxtest.php来响应index.php的请求

<?php
    error_reporting(0);//不显示警告信息
    $dbhost="localhost";
    $dbuser="root";
    $dbpass="root";
    $dbname="ajaxdemo";

$mysqli=new mysqli($dbhost,$dbuser,$dbpass,$dbname);
$mysqli->query("SET NAMES &#39;UTF8&#39; ");

$userage=$_GET[&#39;userage&#39;];
$usersex=$_GET[&#39;usersex&#39;];

$userage=$mysqli->real_escape_string($userage);
$usersex=$mysqli->real_escape_string($usersex);

$query="select * from ajaxtest where usersex=&#39;$usersex&#39;";

if(is_numeric($userage))
{
    $query .="AND userage <= $userage;";
}
$qry_result=$mysqli->query($query);

if($qry_result->num_rows==0)
{
    echo json_encode([&#39;data&#39;=>&#39;<h2>未找到符合条件的记录</h2>&#39;,&#39;sql&#39;=>$query]);
    return ;
}

$display_string ="<tr>";
$display_string .="<td>用户名</td>";
$display_string .="<td>年龄</td>";
$display_string .="<td>性别</td>";
$display_string .="</tr>";

//insert a new row in the table for each person returned
while($row=mysqli_fetch_object($qry_result)){
    $display_string.="<tr>";
    $display_string.="<td>$row->username</td>";
    $display_string.="<td>$row->userage</td>";
    $display_string.="<td>$row->usersex</td>";
    $display_string.="</tr>";
}

echo json_encode([&#39;data&#39;=>$display_string,&#39;sql&#39;=>$query]);//返回json数据格式
?>

结果：

ajax+php+mysql 读取数据库的简单示例

相关文章