<?
//include_once("inc/auth.inc.php");
include_once("inc/conn.php");
include_once("inc/utility_all.php");
include_once("inc/utility_file.php");
include_once("inc/utility_sms1.php");
include_once("inc/utility_cache.php");
$HTML_PAGE_TITLE = _("猜一猜");
include_once("inc/header.inc.php");
//联系qq 874689017
echo "查询测试:"."<br>";
//查询演示
$row = TD::DB()->select(TD::tableFix("td_user"), ["USER_NAME","DEPT_ID"], ['USER_ID' => 'admin']);
if(is_array($row) && !empty($row))
{
$FROM_NAME=$row[0]["USER_NAME"];
$DEPT_ID=$row[0]["DEPT_ID"];
echo $FROM_NAME.$DEPT_ID."<BR>";
}
//循环查询演示
$row1 = TD::DB()->select(TD::tableFix("td_user"), ["USER_NAME","DEPT_ID"]);
// print_r($row1);
foreach($row1 as $k=>$v){
//print_r($v);
//echo $v["USER_NAME"]."<BR>";
//echo "<br>";
}
//多条件查询
$row = TD::DB()->select(TD::tableFix("td_user"), ["USER_NAME","DEPT_ID"], ["AND"=>['USER_ID' => 'admin',"UID"=>'1']]); //多条件查询 注意中括号
if(is_array($row) && !empty($row))
{
$FROM_NAME=$row[0]["USER_NAME"];
$DEPT_ID=$row[0]["DEPT_ID"];
echo $FROM_NAME.$DEPT_ID."<BR>";
}
//原生的连表查询
$query="select a.USER_NAME,b.USER_ID from td_user as a,user_ext as b where a.UID=b.UID and a.USER_ID='admin'"; //原生的连表查询
echo $query."<br>";
$row2= TD::DB()->prepareQuery($query);
foreach($row2 as $k=>$v){
print_r($v);
//echo $v["USER_NAME"]."<BR>";
//echo "<br>";
}
//新增测试
//在sys_1og表中插入一条数据
TD::DB()->insert(TD::tableFix("sys_log"),[
"USER_ID"=>'admin',
"TIME" =>"2020-08-18 15:07:51",
"IP" =>"127.0.0.1","TYPE"=>"10",
"REMARK"=>"测试插入操作"
]);
//获取插入的id
$id = TD::DB()->id();
echo $id."<br>";
//修改id为1s8的数据
$res = TD::DB()->update(TD::tableFix("sys_log"),[
"user_id"=>'changbai',"remark"=>'更新操作测试'],[
"AND"=>[
"user_id"=>'admin',"log_id"=> 18
]
]);
//获取受影响的行数
echo $res->rowcount();
echo "<hr>";
//删除id为19的数据
$res = TD::DB()->delete(TD::tableFix("sys_log"),[
"AND"=>[
"user_id" =>'admin',"log_id"=>19]
]);
//获取受影响的行数
echo $res->rowCount();
?>
<body>
</body>
</html>