this my main.lua
local myNewData
local json = require (“json”)
local decodedDatalocal playerName = “sos”
local playerscore = “200”local function networkListener( event )
if ( event.isError ) then
print( “Network error!”)
else
myNewData = event.response
print ("From server: "…myNewData)
decodedData = (json.decode( myNewData))
– SaveData()
end
end
–endlocal URL = “http://1dermindstudios.comyr.com/submitscore.php?playername=” …(playerName) … “&playerscore=” …(playerscore)
network.request( URL, “GET”, networkListener )
and this is my php
<?php
$host=“mysql6.000webhost.com”;
$username=“a9679956_caps2ne”;
$password=“blabla”;
$db_name=“blabla”;$con=mysql_connect("$host", “$username”, “$password”)or die(“cannot connect”);
mysql_select_db("$db_name") or die (“cannot select DB”);mysql_select_db("$db_name") or die (“cannot select DB”);
$sql = “select * from player”; //replace with your table name
$result = mysql_query($sql);
$json = array();
$count=0;
if(mysql_num_rows($result)){
while($row=mysql_fetch_row($result)) {
$count = $count+1;
$json[“movie”.$count]=$row;
}
}
mysql_close($db_name);
echo json_encode($json);
?>