Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //データをPHP経由でMySQLに格納
- <?php
- $username = "MySQL ユーザー名";
- $password = "MySQL パスワード";
- $name = (string)filter_input(INPUT_POST,'name');
- $score = (int)filter_input(INPUT_POST,'score');
- try{
- $pdo = new PDO("mysql:host=ホスト名;dbname=データベース名;charset=utf8",$username,$password);
- $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
- }catch(PDOException $e){
- exit("接続失敗".$e->getMessage());
- }
- if($name == null){
- $name = "GUEST";
- }
- $stmt = $pdo->prepare("insert into user_data(name,score) value (:name,:score)");
- $stmt->bindParam(':name',$name,PDO::PARAM_STR);
- $stmt->bindParam(':score',$score,PDO::PARAM_INT);
- $stmt->execute();
- ?>
- //データをUnity側へ出力
- <?php
- $username = "MySQL ユーザー名";
- $password = "MySQL パスワード";
- try{
- $pdo = new PDO("mysql:host=ホスト名;dbname=データベース名;charset=utf8",$username,$password);
- $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
- }catch(PDOException $e){
- exit("接続失敗".$e->getMessage());
- }
- $stmt = $pdo->prepare("select * from user_data order by score desc limit 3"); //スコア降順3行のみ
- $stmt->execute();
- $ranking = $stmt->fetchAll(PDO::FETCH_ASSOC);
- echo json_encode($ranking); //json形式にキャストして出力
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement