<?php
echo "Hello World";
    $S_ID = $_REQUEST['S_ID'];
    echo $S_ID;
    echo "Im Scum";
    $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;
}
   	"SELECT BackText, Creator, Set_ID, FrontText FROM Cards WHERE Set_ID = $S_ID";


$r = $mysqli->query($sql);

$result = array();

while($row = mysqli_fetch_array($r)){
    array_push($result,array(
            'BackText' => $row['BackText'],
			'Creator' => $row['Creator'],
			'Set_ID' => $row['Set_ID'],
			'FrontText' => $row['FrontText']
    ));
}


echo json_encode(array('result'=>$result));

$mysqli->close();

?>