<?php
	$Set_ID = $_POST['Set_ID'];
    $dbhost = 'localhost';
    $dbuser = 'id104366_stashcardrw';
    $dbpass = 'stashcarddb';


// Create connection
    $mysqli = new mysqli($dbhost, $dbuser, $dbpass, "id104366_stashcards");
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}


    $sql = "SELECT BackText, creator, Set_ID, FrontText, Set_Rating FROM Cards WHERE Set_ID = $User_Set_ID";

    if(!$result = $mysqli->query($sql)){
        die('There was an error running the query [' . $conn->error . ']');
    }

$result = $mysqli->query($sql);
$json = array();

    while($row = $result->fetch_assoc()) {
        $bus = array(
        'BackText' => $row['BackText'];
        'Creator' => $row['creator'];
        'Set_ID' => $row['Set_ID'];
        'FrontText' => $row['FrontText'];
        'Set_Rating' => $row['Set_Rating'];
		);
		array_push($json, $bus);
    }

$json_result = json_encode($json);

echo " " . $json_result ;
$conn->close();

?>