<?php
	// JSONを返すべき
	header("Content-Type: application/json; charset=utf-8");

	// 接続 
	$dbh = new PDO('mysql:host=localhost; dbname=card_game', "root", "", [PDO::ATTR_PERSISTENT => true]);
	
	// ユーザーIDを取得
	$user_id = $_POST['user_id'];
	
	// そのユーザーを持っているカードを検索
	$sql = sprintf("SELECT * FROM user_cards, cards WHERE user_id = '%s' AND user_cards.card_id = cards.id", $user_id);
	$result = $dbh->query($sql);
	
	// 返すデータを準備する
	$json["card_list"] = [];
	
	while ($record = $result->fetch())
	{
		// カード１枚に関するデータ（UnityのJObjectに合わせる）
		$card_data['card']['id']           = $record['id'];
		$card_data['card']['rank']         = $record['rank'];
		$card_data['card']['picture_id']   = $record['picture_id'];
		$card_data['card']['monster_name'] = $record['monster_name'];
		$card_data['card']['atk_value']    = $record['attack'];
		$card_data['card']['def_value']    = $record['defense'];
		$card_data['card']['hp_value']     = $record['hit_points'];
		
		$card_data['count'] = $record['count'];
		
		// 結果に追加
		array_push($json["card_list"], $card_data);
	}

	print(json_encode($json));
?>