function.php 1.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. require_once '../path.php';
  3. function ucenter_get($userid,$fields="username"){
  4. //打开数据库
  5. $dns = "sqlite:"._FILE_DB_USERINFO_;
  6. $dbh = new PDO($dns, "", "",array(PDO::ATTR_PERSISTENT=>true));
  7. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  8. $query = "select username from user where id= ? ";
  9. $stmt = $dbh->prepare($query);
  10. $stmt->execute(array($userid));
  11. $fUser = $stmt->fetchAll(PDO::FETCH_ASSOC);
  12. $dbh=null;
  13. if(count($fUser)>0){
  14. return($fUser[0][$fields]);
  15. }
  16. else{
  17. return("");
  18. }
  19. }
  20. function ucenter_getA($userid,$fields="nickname"){
  21. //打开数据库
  22. $dns = "sqlite:"._FILE_DB_USERINFO_;
  23. $dbh = new PDO($dns, "", "",array(PDO::ATTR_PERSISTENT=>true));
  24. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  25. $query = "select username,nickname from user where userid= ? ";
  26. $stmt = $dbh->prepare($query);
  27. $stmt->execute(array($userid));
  28. $fUser = $stmt->fetchAll(PDO::FETCH_ASSOC);
  29. $dbh=null;
  30. if(count($fUser)>0){
  31. return($fUser[0][$fields]);
  32. }
  33. else{
  34. return("");
  35. }
  36. }
  37. ?>