PHP API for android using mysql

Question

So, currently i am using firebase for storing my app data online, I would like to create my own database, so i was planning to get a 100gb bandwidth hosting plan with php and mysql (is that bandwidth enought) per download, my app downloads approximately 0.4MB of data (as per firebase).

So, to create the api, i just have to encode the mysql data into json and print it ? then my android app will read it and use it ? is this the best method ?

$sth = mysqli_query("SELECT ...");
$rows = array();
while($r = mysqli_fetch_assoc($sth)) {
    $rows[] = $r;
}
print json_encode($rows);

or is there any other, more efficient method to do this ?

is this the best method there is no best method, but it should work. (is that bandwidth enought) depends on how many users you will have, and how much data they will request. In other words - nobody knows — Vladyslav Matviienko
– Vladyslav Matviienko, Commented Nov 23, 2018 at 8:57
my data is 210kb, lets consider 400kb, 2000-4000 users per month, each user downloads 10 times lets say, that sums up to 15 gb i guess (considering higher end everywhere i guess) — Femn Dharamshi
– Femn Dharamshi, Commented Nov 23, 2018 at 16:51

Ajit Maurya · Accepted Answer · 2018-11-23 08:54:59Z

1

Yes but you should send response code like 200,403 as well. here is a similar question

How to write a REST API?

answered Nov 23, 2018 at 8:54

Ajit Maurya

561 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP API for android using mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related