cvs: php-master-web /fetch allusers.php

bjori Sun Jun 7 12:21:21 2009 UTC Added files: /php-master-web/fetch allusers.php Log: Add an endpoint to list all usernames+names http://cvs.php.net/viewvc.cgi/php-master-web/fetch/allusers.php?view=markup&rev=1.1 Index: php-master-web/fetch/allusers.php +++ php-master-web/fetch/allusers.php <?php // vim: et ts=4 sw=4 function error($text, $status) { switch((int)$status) { default: case 500: header("HTTP/1.0 500 Internal server error"); break; case 404: header("HTTP/1.0 404 Not Found"); break; case 401: header("HTTP/1.0 401 Unauthorized"); break; } echo json_encode(array("error" => $text)); exit; } (!isset($token) || md5($token) != "d3fbcabfcf3648095037175fdeef322f") && error("token not correct.", 401); $USERNAME = filter_input(INPUT_GET, "username", FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH); $pdo = new PDO("mysql:host=localhost;dbname=phpmasterdb", "nobody", ""); $stmt = $pdo->prepare("SELECT name, username FROM users WHERE enable AND cvsaccess"); if (!$stmt->execute()) { error("This error should never happen", 500); } $results = $stmt->fetchAll(PDO::FETCH_ASSOC); if (!$results) { error("This should never happen either", 404); } echo json_encode($results);