get_setting.php 910 B

123456789101112131415161718192021222324252627282930
  1. <?php
  2. require_once '../path.php';
  3. if(!isset($_COOKIE["userid"])){
  4. $setting = array();
  5. }
  6. else{
  7. $setting=json_decode(file_get_contents("../ucenter/default.json"),TRUE);
  8. //打开数据库
  9. $dns = "sqlite:"._FILE_DB_USERINFO_;
  10. $dbh = new PDO($dns, "", "",array(PDO::ATTR_PERSISTENT=>true));
  11. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  12. $query = "select setting from user where userid = ? ";
  13. $stmt = $dbh->prepare($query);
  14. $stmt->execute(array($_COOKIE["userid"]));
  15. $fUser = $stmt->fetchAll(PDO::FETCH_ASSOC);
  16. $dbh=null;
  17. if(isset($fUser[0]["setting"])){
  18. $my_setting=json_decode($fUser[0]["setting"],TRUE);
  19. foreach ($setting as $key => $value) {
  20. if(isset($my_setting[$key])){
  21. $setting[$key] = $my_setting[$key];
  22. }
  23. }
  24. }
  25. }
  26. echo json_encode($setting, JSON_UNESCAPED_UNICODE);
  27. ?>