PHP MySQL and Android connection

Question

I'm trying to connect my android app with an online database server that uses MySQL and phpMyAdmin.

But problem I am having is that I'm unable to access my database (which is online) using Java code for android.

It get the following error:

java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:187)

I already loaded the driver and external JAR of MySQL but it is still showing this exception.

The code is :

Class.forName("com.mysql.jdbc.Driver").newInstance();

Connection con = DriverManager.getConnection(
        "jdbc:mysql:http://www.demo.com:2082/",
        "usernme", "password"); //username and password of cpanel access
PreparedStatement statement = con
        .prepareStatement("SELECT * FROM users WHERE userName = '"
                + userName + "'");

ResultSet result = statement.executeQuery();

while (result.next()) {
    retrievedUserName = result.getString("username");
    Log.e("data username:", retrievedUserName);
    retrievedPassword = result.getString("password");
}

Nambi · Accepted Answer · 2014-01-20 11:37:14Z

1

Use the Webservice to make the Connection to Mysql from your android app through json or xml.you can use SQlite database to connect the android app internally by the use of this package android.database.sqlite classes

answered Jan 20, 2014 at 11:37

Nambi

12k4 gold badges40 silver badges50 bronze badges

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

4 Comments

Himanshu Agarwal Over a year ago

can you provide a sample code or link to any basic connectivity with MySQL?

Nambi Over a year ago

refer this link androidhive.info/2012/05/how-to-connect-android-with-php-mysql

Himanshu Agarwal Over a year ago

But can we connect without using PHP?

Nambi Over a year ago

@Himanshu refer this link to create json 9lessons.info/2012/08/java-json-jquery-display-records.html

Collectives™ on Stack Overflow

PHP MySQL and Android connection

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related