<?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");

//selekcija baze

$selected = mysql_select_db ("prevod", $conn)
or die ("Can't find database.");

//fetchovanje podataka iz bazu

$result = mysql_query("SELECT IF(post_type='attachment',guid,''), post_content, post_title, post_excerpt FROM wp_posts WHERE post_type='product' OR post_mime_type='image/jpeg'");
$rows =array();
while ($r = mysql_fetch_assoc($result)) {

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

}
header("Content-Type: application/json; charset=utf-8", true);
print json_encode($rows);


?>