利用Medoo框架实现 增删改查
这里只贴了 显示和查询部分
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport"
content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no">
<meta name="format-detection" content="telephone=no, email=no">
<title>设备列表</title>
<script type="text/javascript" src="../public/jquery.js"></script>
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
<style type="text/css">
html body
{
}
table
{
border: 1px solid #ccc;
border-collapse: collapse;
}
td
{
border: 1px solid #ccc;
}
</style>
</head>
<body>
<label>devsn</label>
<input type="text" id="mdevsn">
<label>devRegionID</label>
<input type="text" id="mdevRegionID">
<label>devname</label>
<input type="text" id="mdevname">
<label>devID</label>
<input type="text" id="mdevID">
<label>OwnOpenID
<input type="text" id="OwnOpenID"></label>
<label>OwnName
<input type="text" id="OwnName"></label>
<div>
<input type="button" id="btnquery" value="query" onclick="querywx()">
<input type="button" id="btnadd" value="add" onclick="adddev()">
</div>
<div class="table-responsive" overflow-y:auto;">
<table class="table text-nowrap table-striped devcont">
<thead>
<tr>
<td>devsn</td>
<td>devRegionID</td>
<td>devname</td>
<td>mAddTime</td>
<td>mUpdateTime</td>
<td>devID</td>
<td>OwnOpenID</td>
<td>OwnNickname</td>
<td>cUserID</td>
<td>Pro</td>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
<div class="qurest">
<span></span>
</div>
<script type="text/javascript">
$(document).ready(function () {
getUserList("");
});
//获取设备列表
function getUserList(varemp) {
try {
// alert(sz1);
$.post("getdev.php?mtrick=cucall&"+varemp , function (result) {
// var result = JSON.parse(result);
//var data = result.data;
//var html_c = "";
//alert (result);
if (result.length > 20) {
$(".devcont tbody").html(result);
} else {
$(".devcont tbody").html("");
//$(".ta_list tbody").html("<tr><td colspan='8'>搜索结果：0条记录。</td></tr>");
}
})
} catch (e) { }
}
function querywx()
{
var szTmp;
var szcon="1=1";
szTmp = $("#mdevsn").val();
if (szTmp.length >0)
szcon = szcon +"&devsn="+szTmp;
szTmp = $("#mdevRegionID").val();
if (szTmp.length >0)
szcon = szcon +"&devRegionID="+szTmp;
szTmp = $("#mdevname").val();
if (szTmp.length >0)
szcon = szcon +"&devname="+szTmp;
szTmp = $("#mdevID").val();
if (szTmp.length >0)
szcon = szcon +"&devID="+szTmp;
szTmp = $("#OwnOpenID").val();
if (szTmp.length >0)
szcon = szcon +"&OwnOpenID="+szTmp;
szTmp = $("#OwnName").val();
if (szTmp.length >0)
szcon = szcon +"&OwnName="+szTmp;
try {
$.post("getdev.php?mtrick=cucall&"+szcon , function (result) {
// var result = JSON.parse(result);
//var data = result.data;
//var html_c = "";
//alert (result);
if (result.length > 20) {
$(".devcont tbody").html(result);
} else {
$(".devcont tbody").html("");
}
})
} catch (e) { }
}
function getaubydev(vdev)
{
queryAU(0,vdev);
}
function getaubyownopenid(vownopenid)
{
queryAU(1,vownopenid);
}
function queryAU(vitype,vvalue)
{
var szTmp;
var szcon="1=1";
szTmp = $("#mdevsn").val();
if (szTmp.length >0)
szcon = szcon +"&devsn="+szTmp;
szTmp = $("#mdevRegionID").val();
if (szTmp.length >0)
szcon = szcon +"&devRegionID="+szTmp;
szTmp = $("#mdevname").val();
if (szTmp.length >0)
szcon = szcon +"&devname="+szTmp;
szTmp = $("#mdevID").val();
if (szTmp.length >0)
szcon = szcon +"&devID="+szTmp;
try {
$.post("getAUext.php?mtrick=cucall&"+szcon , function (result) {
// var result = JSON.parse(result);
//var data = result.data;
//var html_c = "";
//alert (result);
if (result.length > 20) {
$(".devcont tbody").html(result);
} else {
$(".devcont tbody").html("");
}
})
} catch (e) { }
}
function editdev(vDevsn) {
window.location = "editdev.php?devsn="+vDevsn;
}
function deldev(vDevsn) {
try {
$.post("deldev.php",{devsn: vdevsn} , function (result) {
if (result.length > 20) {
querywx();
} else {
alert('删除失败！');
}
})
} catch (e) { }
}
</script>
</body>
</html><?php
//include_once '../conf/dbparameter.php';
//include_once '../public/connect.php';
require_once __DIR__."/../public/Medoo.php";
// use Medoo\Medoo as ddb;
$cc = [
//必填
'database_type' => 'mysql',
'database_name' => 'qrdata',
'server' => 'localhost',
'username' => 'root',
'password' => '258000',
// 可选
'charset' => 'utf8',
'port' => 3306,
];
$db = new \Medoo\Medoo($cc );
// $res = $db->select('cu_tbl_user_data',['mOpenID','mNickName']);
// //var_dump($db1);
// foreach ($res as $row)
// {
// echo print_r($row,true),'<hr>';
// }
//-----------------------------------------------------------------------------------------------
$szcon =" d.mAddTime < sysdate() ";
$openid = "";
$name = "";
$mcity = "";
$phone = "";
if(isset($_GET["devsn"]))
$szcon =$szcon." And devsn like '".$_GET["devsn"]."%' ";
if(isset($_GET["devRegionID"]))
$szcon =$szcon." And devRegionID like '".$_GET["devRegionID"]."%' ";
if(isset($_GET["devname"]))
$szcon =$szcon." And devname like '".$_GET["devname"]."%' ";
if(isset($_GET["devID"]))
$szcon =$szcon." And devID like '".$_GET["devID"]."%' ";
if(isset($_GET["OwnOpenID"]))
$szcon =$szcon." And u.mOpenID like '".$_GET["OwnOpenID"]."%' ";
if(isset($_GET["OwnName"]))
$szcon =$szcon." And u.mNickName like '".$_GET["OwnName"]."%' ";
// $conn = mysqli_connect($servername, $username, $password, $dbname);
// mysqli_set_charset($conn,'utf8');
// // connect db fail
// if (!$conn) {
// exit("Connection failed: ".mysqli_connect_error());
// }
$sortcol = "d.mUpdateTime desc";
$mysql = "Select d.devsn, d.devRegionID, d.devname, d.mAddTime, d.mUpdateTime, d.devID,u.mOpenID,u.mNickName,u.cUserID from cu_tbl_dev_data d,cu_tbl_region_data r,cu_tbl_user_data u Where d.devRegionID=r.mRegionID And r.mOpenID=u.mOpenID and ".$szcon." Order by ".$sortcol;
//echo $mysql."<br>";
$result = $db->query($mysql)->fetchAll();
//var_dump($result);
//$result = $conn->query($mysql);
//echo $result->num_rows." ".$mysql."<br>";
// if (strlen(mysqli_error($conn)) > 0)
// {
// exit("get dev list error! ".mysqli_error($conn));
// }
$szRet = "";
$itmp1 = 0;
// if ($result->num_rows > 0) // has record insert
// {
// while($row = mysqli_fetch_assoc($result)) {
foreach ($result as $row) {
$itmp1++;
$szRet = $szRet . "<tr><td>" . $itmp1 . "___" . $row["devsn"] . "</td><td>" . $row["devRegionID"] . "</td>";
$szRet = $szRet . "<td><a href='#' onclick=\"getaubydev('" . $row["devsn"] . "')\">" . $row["devname"] . "</a></td>";
$szRet = $szRet . "<td>" . $row["mAddTime"] . "</td>";
$szRet = $szRet . "<td>" . $row["mUpdateTime"] . "</td><td>" . $row["devID"] . "</td>";
$szRet = $szRet . "<td>" . $row["mOpenID"] . "</td><td><a href='#' onclick=\"getaubyownopenid('" . $row["mOpenID"] . "')\">" . $row["mNickName"] . "</a></td>";
$szRet = $szRet . "<td>" . $row["cUserID"] . "</td>";
$szRet = $szRet . "<td><a href='#' onclick=\"editdev('".$row["devsn"]."')\">编辑</a><a style='margin-left: 10px;' href='#' onclick=\"deldev('".$row["devsn"]."')\">删除</a></td></tr>";
}
//}
if (strlen($szRet) == 0)
$szRet = "{no data}";
exit($szRet);
// }
// else
// exit ("{no data}");
?>