本文整理汇总了PHP中DbHandler::getRecords方法的典型用法代码示例。如果您正苦于以下问题：PHP DbHandler::getRecords方法的具体用法？PHP DbHandler::getRecords怎么用？PHP DbHandler::getRecords使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DbHandler的用法示例。
在下文中一共展示了DbHandler::getRecords方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: array
$response['status'] = "success";
$response['message'] = "Hapus data berhasil!";
} else {
$response['status'] = "error";
$response['message'] = "Maaf, hapus data tidak berhasil!";
}
$result["result"] = array($response['status'], $response['message']);
echo json_encode($result);
});
/* END TINGKATAN */
/* BEGIN PENGGUNA */
$app->get('/pengguna', function () use($app) {
$response = array();
$db = new DbHandler();
$query = "select a.*,@rownum:=@rownum+1 as num from (select u.iduser,u.user,u.nama_lengkap,ul.userlevel from user u inner join userlevel ul on u.iduserlevel=ul.iduserlevel) a, (select @rownum:=0) r order by a.iduser";
$pengguna = $db->getRecords($query);
$result["result"] = $pengguna;
echo json_encode($result);
});
$app->get('/pengguna/:iduser', function ($iduser) use($app) {
$db = new DbHandler();
$query = "select * from user where iduser=" . $iduser;
$pengguna = $db->getOneRecord($query);
$result["result"] = array();
if ($pengguna) {
$result["result"] = array($pengguna);
}
echo json_encode($result);
});
$app->put('/pengguna/:iduser', function ($iduser) use($app) {
$response = array();示例2: DbHandler
$app->stop();
}
$db = new DbHandler();
$db->updateOneRecord("update users set teamname = '{$tn}' where name='{$tl}'");
$response["status"] = "success";
$response["message"] = "Moved '{$tl}' to '{$tn}'";
echoResponse(200, $response);
});
$app->post('/getteammates', function () use($app) {
$response = array();
$r = json_decode($app->request->getBody());
$role = $r->role;
$uid = $r->uid;
$db = new DbHandler();
if ($role == "admin") {
$result_teammates = $db->getRecords("select name,teamname from users where teamname != ''");
$result_free_teammates = $db->getRecords("select name from users where teamname = ''");
$result_tn = $db->getRecords("select teamname from users where teamname != ''");
$result_roles = $db->getRecords("SELECT user_roles.name,user_roles.role,user_roles.teamname FROM user_roles LEFT JOIN users ON user_roles.uid = users.uid WHERE users.role = 'team_member'");
$result_free_roles = $db->getRecords("SELECT users.name,users.teamname FROM users WHERE users.uid NOT IN (SELECT user_roles.uid FROM user_roles) AND users.role = 'team_member'");
$response["teammates"] = $result_teammates;
$response["free_teammates"] = $result_free_teammates;
$response["tn"] = $result_tn;
$response["roles"] = $result_roles;
$response["free_roles"] = $result_free_roles;
$response["status"] = "success";
$response["message"] = "Users Found";
echoResponse(200, $response);
} else {
$result_tn = $db->getOneRecord("select teamname from users where uid='{$uid}'");
$teamname = $result_tn['teamname'];