<?php
$servername = "localhost";
$username = "root";
$password = "liferay";
$dbname = "lportal";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$emparray = array();
$sql = "SELECT uuid_, urbanatweetId, userId, userName, createDate, text_, hashtag, retweet, followers, polaridad FROM VZ_Urbanatweet";
$result = $conn->query($sql);

$output = array();

while ($row = mysqli_fetch_assoc($result)) {
   $output[] = array_map('utf8_encode', $row);
}

print(json_encode($output));

$conn->close();

?>