PHP - Php+Corona sdk

local json = require( "json" )

local mime = require( "mime" )

local function handleResponse( event )

    if not event.isError then

        local response = json.decode( event.response )

        print( event.response )

    else

        print(event.response)

    end

    return

end

local headers = {}

headers["Authentication"] = mime.b64("*************")

local params = {}

params.headers = headers

network.request( "http://www.************.es/index.php", "GET", handleResponse, params )

<?php

$host="*****.****.**";

$username="********";

$password="********";

$db_name="*********";

$con=mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name") or die ("cannot select DB");

$sql = "select * from user";

$result = mysql_query($sql);

$json = array();

$count=0;

if(mysql_num_rows($result)){

while($row=mysql_fetch_row($result)) {

$count = $count+1;

$json[$count]=$row;

}

}

mysql_close($db_name);

echo json_encode($json);

?>