2
0

get.php 960 B

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