public function oauth()
{
if (isset($_REQUEST["pageIndex"])) {
$this->pageIndex = intval($_REQUEST["pageIndex"]);
}
$rss = simple_mysqli_sp_execute("call sp_get_user_oauth_list(" . $this->pageIndex . "," . $this->pageSize . ",@totalRows,@totalPages);", "select @totalRows totalRows, @totalPages totalPages;");
$this->assign("list", $rss[0]);
$simplePage = new SimplePage($this->pageIndex, $this->pageSize, $rss[1][0]["totalPages"], $rss[1][0]["totalRows"]);
$this->assign("page", $simplePage->get_page_info());
$this->display();
}
public function dologin()
{
if (IS_AJAX) {
$rs = simple_mysqli_sp_execute("call sp_user_login('" . $_REQUEST["loginId"] . "', '" . $_REQUEST["password2"] . "')");
session("uid", $rs[0]["uid"]);
session("username", $rs[0]["username"]);
session("roleid", $rs[0]["roleid"]);
$this->ajaxReturn(array("resultCode" => $rs[0]["resultCode"], "resultInfo" => $rs[0]["resultInfo"]));
} else {
$this->ajaxReturn(array("resultCode" => 3, "resultInfo" => "非法请求"));
}
}
public function getoperaterecorddata()
{
if (isset($_REQUEST["pageIndex"]) || isset($_REQUEST["pageSize"])) {
$this->pageIndex = intval($_REQUEST["pageIndex"]);
$this->pageSize = intval($_REQUEST["pageSize"]);
}
simple_mysqli_log("pageIndex=" . $this->pageIndex);
simple_mysqli_log("pageSize=" . $this->pageSize);
$rss = simple_mysqli_sp_execute("call sp_get_domain_operate_list(0,1," . $this->pageIndex . "," . $this->pageSize . ",@totalRows,@totalPages);", "select @totalRows totalRows, @totalPages totalPages;");
$data = array("list" => $rss[0], "pageIndex" => $this->pageIndex, "pageSize" => $this->pageSize, "totalCount" => intval($rss[1][0]["totalRows"]), "totalPageCount" => intval($rss[1][0]["totalPages"]));
echo json_encode($data);
}
public function cleardata()
{
simple_mysqli_sp_execute("call sys_trc_log()");
}
<?php
/**
* Created by PhpStorm.
* User: Applexiang
* Date: 15/9/22
* Time: 12:56
*/
require_once '../Application/Common/Common/function.php';
simple_mysqli_sp_execute("call sp_add_smt('http://aasfdas.com','111.jpg','',0.0,'')", null);
