php - MySQL connection failure from Android application -

-

i have android project, in use code above connect remote mysql database. should handle login request, user should authenticated in database stored information.

private class asynclogin extends asynctask<string, string, string>     {         progressdialog pdloading = new progressdialog(mainactivity.this);         httpurlconnection conn;         url url = null;          @override         protected void onpreexecute() {             super.onpreexecute();              //this method running on ui thread             pdloading.setmessage("\tloading...");             pdloading.setcancelable(false);             pdloading.show();          }         @override         protected string doinbackground(string... params) {             try {                  // enter url address php file resides                 url = new url("http://remote.host/test/login.inc.php");              } catch (malformedurlexception e) {                 // todo auto-generated catch block                 e.printstacktrace();                 return "exception";             }             try {                 // setup httpurlconnection class send , receive data php , mysql                 conn = (httpurlconnection)url.openconnection();                 conn.setreadtimeout(read_timeout);                 conn.setconnecttimeout(connection_timeout);                 conn.setrequestmethod("post");                  // setdoinput , setdooutput method depict handling of both send , receive                 conn.setdoinput(true);                 conn.setdooutput(true);                  // append parameters url                 uri.builder builder = new uri.builder()                         .appendqueryparameter("username", params[0])                         .appendqueryparameter("password", params[1]);                 string query = builder.build().getencodedquery();                  // open connection sending data                 outputstream os = conn.getoutputstream();                 bufferedwriter writer = new bufferedwriter(                         new outputstreamwriter(os, "utf-8"));                 writer.write(query);                 writer.flush();                 writer.close();                 os.close();                 conn.connect();              } catch (ioexception e1) {                 // todo auto-generated catch block                 e1.printstacktrace();                 return "exception";             }

i got error message, when try send data android application. connection refused see message in android monitor section. permissions in manifest file ok network connection.

config.inc.php file:

<?php  $servername = "localhost"; $username = "root"; $password = "root"; $dbname = "dbname";  try {         $conn = new pdo("mysql:host=$servername;dbname=$dbname", $username, $password);         $conn->setattribute(pdo::attr_errmode, pdo::errmode_exception);     } catch(pdoexception $e)     {         die("oops went wrong");     }  ?>

i error message in application:

oops! went wrong.


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more