<?php
    $servername = "localhost";
    $username =  "root";
    $password =
    $dbName = "twitchheroes";

	//passed variables
	$query = $_POST["queryPost"];
	$action = $_POST["action"];

	if (action == "initialize) {

    //Make Connection
    $conn = new mysqli($servername, $username, $password, $dbName);


    //Check Connection
    if(!$conn){
        die("Connection Failed. ". mysqli_connect_error());
    }

	}

	if (action == "queryItems") {

    $result = mysqli_query($conn, $query);

    if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo $row["item_id"];
        echo "|";
        echo $row["item_name"];
        echo "|";
        echo $row["armor_type"];
        echo "|";
        echo $row["item_level"];
        echo "|";
        echo $row["damage"];
        echo "|";
        echo $row["health"];
        echo "|";
        echo $row["armor"];
        echo "|";
        echo $row["crit"];
        echo "|";
        echo $row["lifesteal"];
        echo "&";
    }
} else {
    echo "no items";
}

 }

?>