Connect Android to MySQL Database Tutorial

[swissmade]

I have a MYSQL Database where I like to get some info from.
When I copy the php source to the webroot and connect with the app.
Then I get in the LogCat the source of the php file.
I have a connection to the database when I debug the php Script.
What i'm doing wrong here
Server is Xampp.

[Erel]

Your server should run the PHP script. For some reason it now treats it as a text file.

[swissmade]

Originally Posted by Erel

Your server should run the PHP script. For some reason it now treats it as a text file.

Erel,

Thanks again for your fast respond.
Found the error the Script started with <? and not with <?php

[Reemj]

maybe this question is not suitable

but I create DB and PHP file

this error is appear

Compiling code. Error
Error parsing program.
Error description: Unknown type: httpclient
Are you missing a library reference?
Occurred on line: 2
Dim hc As HttpClient

what is mistake??
I need to answer
Thanks

[Erel]

You should add a reference to the Http library. It is done in the Libraries tab in the right pane. Note that it can only be done with the full version.

[Hans Scholten]

Is there someone in this group who can change this part of php code in asp code

$query = file_get_contents("php://input");
$sth = mysql_query($query);

if (mysql_errno()) {
header("HTTP/1.1 500 Internal Server Error");
echo $query.'\n';
echo mysql_error();
}
else
{
$rows = array();
while($r = mysql_fetch_assoc($sth)) {
$rows[] = $r;
}
print json_encode($rows);
}

[Reemj]

if I change the line 40 to

req.InitializePost2("C:\xampp\htdocs\countries.php ", query.GetBytes("UTF8"))

this error appears

An error has occured in sub: main excuteremotequery
(B4A line:40)
req.InitializePost2("C:\xampp\htdocs\countries.php " , query.GetBytes("UTF8"))
java.lang
IllegalArgumentException:
Illegal character in schemeSpecificPart at index 2:
C:\xampp\htdocs\countries.php

Thanks a lot

[Reemj]

I edit php file to this

$databasehost = "localhost";
$databasename = "android";
$databaseusername ="root";
$databasepassword = "1234";

the type of ID is VARCHAR (5)
population is INT (5)
name VARCHAR (20)

[Erel]

The PHP script should be located in a server that can execute the script. It cannot be accessed as a regular file.

[Reemj]

thank you ,

I changed the link to this http://localhost/countries.php

and change type of populaion from VARCHAR to text



another problem appears,

in java.lang.exception: sub
hc_responceerror signture dose not match expected signuter.
continued?




tahnks for the help