get.php 853 B

123456789101112131415161718192021222324
  1. <?php
  2. require_once '../path.php';
  3. //打开数据库
  4. $dns = "" . _FILE_DB_USERINFO_;
  5. $dbh = new PDO($dns, "", "", array(PDO::ATTR_PERSISTENT => true));
  6. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  7. if (isset($_GET["id"])) {
  8. $query = "select userid as id ,username,nickname from user where userid = ? ";
  9. $stmt = $dbh->prepare($query);
  10. $stmt->execute(array($_GET["id"]));
  11. $fUser = $stmt->fetchAll(PDO::FETCH_ASSOC);
  12. } else if (isset($_GET["username"])) {
  13. $query = "select userid as id ,username,nickname,email from user where nickname like ? limit 0,8";
  14. $stmt = $dbh->prepare($query);
  15. $username = "%" . $_GET["username"] . "%";
  16. $stmt->execute(array($username));
  17. $fUser = $stmt->fetchAll(PDO::FETCH_ASSOC);
  18. } else {
  19. $fUser = array();
  20. }
  21. echo json_encode($fUser, JSON_UNESCAPED_UNICODE);
  22. $dbh = null;