<?php

$username = "prevod";
$password = "Pr3V0Dd!18";
$hostname = "prevod.db.10770226.hostedresource.com";

//Establishing connection

$conn = mysql_connect ($hostname, $username, $password)

or die ("Unable to connect to the database");

echo "Konekcija uspesna<br>";

//selekcija baze

$selected = mysql_select_db ("prevod", $conn)
or die ("Ne mogu da nadjem bazu. Kude si gu sakrio?");

//fetchovanje podataka iz bazu

$result = mysql_query("SELECT order_item_id, order_item_name, order_item_type, order_id FROM wp_woocommerce_order_items");
$rows =array();
while ($r = mysql_fetch_assoc($result)) {

  $rows['object_name'][] = $r;

}

print json_encode($rows);

?>