I've created a database using Microsoft Azure Portal (MySQL Database).
Currently I'm using PHP to connect to the database.
$servername = "server.mysql.database.azure.com";
$username = "username@server";
$password = "password";
$dbname = "database";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname, 3306);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
SQL queries to populate data in JSON format.
$sql = "SELECT id, username, score FROM ScoreTable";
$result = $conn->query($sql);
$dbdata = array();
while ( $row = $result->fetch_assoc()) {
$dbdata[]=$row;
}
echo json_encode($dbdata);
Result (localhost/jubakee.php OR http://192.168.1.7/jubakee.php (local IP) both produce the same results).
[{"id":"1","username":"Stacey","score":"500"},
{"id":"2","username":"SJ","score":"600"}]
The issue I am having is that I want to be able to access this database from different networks e.g on 3G/4G or my friend's house.
When trying to load http://192.168.1.7/jubakee.php on my android device it will only produce the results if I'm on the same network as my PC (Same Wi-Fi Network).
When I switch my network from Wi-Fi to Mobile Data (3G) I can no longer access the database and http://192.168.1.7/jubakee.php will not load.
The purpose of this is so I can create an online database which will interact with my C# android application. The database will store the scores of the users.
How can I allow users using different networks to connect to my database?
Thank you.
You can't not access the xamp server from your cellular data or different wifi networks. You have to upload your database and files in a live server like 000webhost then you will have a url like http://YOURWEBSITE.000webhost.com/jubakee.php. Now you can access this url from anywhere, anytime and in any applications.