public static function getAllUser()
{
$db = new DB();
$data = $db->getObjListBySql("SELECT * FROM user");
if (count($data) != 0) {
return $data;
} else {
return null;
}
}
<?php
$db = new DB();
$user = $_POST['user'];
$oldPassword = $_POST['oldPassword'];
$newPassword = $_POST['newPassword'];
$oldPassword = $db->escapeStringTODb($oldPassword);
$newPassword = $db->escapeStringTODb($newPassword);
$user = $db->escapeStringTODb($user);
$oldPassword = md5($oldPassword);
$newPassword = md5($newPassword);
$arr = array();
$sql = "select * from admin where username='******' and password='******'";
$row = $db->getObjListBySql($sql);
if (!$row) {
$arr = array('statusCode' => 200, 'message' => "密码错误", 'navTabId' => "", 'rel' => "", 'callbackType' => "closeCurrent", "forwardUrl" => "");
} else {
//$sql="update admin set password='******' where username='******' and password='******'";
$columns[0] = "password";
$values[0] = $newPassword;
$row = $db->updateParamById("admin", $columns, $values, "username", $user);
$arr = array('statusCode' => 200, 'message' => "修改成功", 'navTabId' => "", 'rel' => "", 'callbackType' => "closeCurrent", "forwardUrl" => "");
}
echo json_encode($arr);