Advertisement
Guest User

Untitled

a guest
Apr 7th, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. //データをPHP経由でMySQLに格納
  2. <?php
  3.  
  4. $username = "MySQL ユーザー名";
  5. $password = "MySQL パスワード";
  6.  
  7. $name = (string)filter_input(INPUT_POST,'name');
  8. $score = (int)filter_input(INPUT_POST,'score');
  9.  
  10. try{
  11.  
  12. $pdo = new PDO("mysql:host=ホスト名;dbname=データベース名;charset=utf8",$username,$password);
  13. $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
  14.  
  15. }catch(PDOException $e){
  16.  
  17. exit("接続失敗".$e->getMessage());
  18.  
  19. }
  20.  
  21. if($name == null){
  22.  
  23. $name = "GUEST";
  24.  
  25. }
  26.  
  27. $stmt = $pdo->prepare("insert into user_data(name,score) value (:name,:score)");
  28. $stmt->bindParam(':name',$name,PDO::PARAM_STR);
  29. $stmt->bindParam(':score',$score,PDO::PARAM_INT);
  30. $stmt->execute();
  31.  
  32. ?>
  33.  
  34. //データをUnity側へ出力
  35. <?php
  36.  
  37. $username = "MySQL ユーザー名";
  38. $password = "MySQL パスワード";
  39.  
  40. try{
  41.  
  42. $pdo = new PDO("mysql:host=ホスト名;dbname=データベース名;charset=utf8",$username,$password);
  43. $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
  44.  
  45. }catch(PDOException $e){
  46.  
  47. exit("接続失敗".$e->getMessage());
  48.  
  49. }
  50.  
  51. $stmt = $pdo->prepare("select * from user_data order by score desc limit 3"); //スコア降順3行のみ
  52. $stmt->execute();
  53. $ranking = $stmt->fetchAll(PDO::FETCH_ASSOC);
  54.  
  55. echo json_encode($ranking); //json形式にキャストして出力
  56.  
  57. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement