get.php 951 B

123456789101112131415161718192021222324252627
  1. <?php
  2. require_once '../path.php';
  3. //打开数据库
  4. $dns = "sqlite:"._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. }
  13. else if(isset($_GET["username"])){
  14. $query = "select userid as id ,username,nickname,email from user where nickname like ? limit 0,8";
  15. $stmt = $dbh->prepare($query);
  16. $username = "%".$_GET["username"]."%";
  17. $stmt->execute(array($username));
  18. $fUser = $stmt->fetchAll(PDO::FETCH_ASSOC);
  19. }
  20. else{
  21. $fUser = array();
  22. }
  23. echo json_encode($fUser, JSON_UNESCAPED_UNICODE);
  24. $dbh=null;
  25. ?>