i'm try send data android server(database) using outputstreamwriter cant see result in database , logcat fine. tried solutions posted on stackoverflow no luck. here codes:-
private class sentfeedback extends asynctask<string,void,string>{ @override protected string doinbackground(string... params) { if(isnetworkavailable()){ try{ url feedback = new url("http:.../setfeedback.php"); httpurlconnection conn = (httpurlconnection) feedback.openconnection(); conn.setdooutput(true); conn.setrequestmethod("post"); outputstreamwriter wr = new outputstreamwriter(conn.getoutputstream()); string data = getdata(params); wr.write(data); wr.flush(); } catch (malformedurlexception e) { e.printstacktrace(); } catch (ioexception e) { e.printstacktrace(); } }else{ return "no internet connection"; } return null; } public string getdata(string... params) throws unsupportedencodingexception { string data = "id" + "=" + urlencoder.encode(params[0], "utf-8"); data += "&" + "rating" + "=" + urlencoder.encode(params[1], "utf-8"); data += "&" + "message" + "=" + urlencoder.encode(params[2], "utf-8"); return data; } }
php code:-
$id = $_post['id']; $rating = (double)$_post['rating']; $message = $_post['message']; $feedbackquery = "insert feedback(message, id, rating) values ('$message', '$id', '$rating')"; $feedbackqueryresult = $mysqli->query($feedbackquery); $mysqli->close();
currently i'm using free 000webhost account. reason can send data back?
thanks in advance!!
in php file replace tablenname
dbname.tablename
in query string example if db name mydb
$feedbackquery = "insert mydb.feedback(message, id, rating) values ('$message', '$id', '$rating')";
and test again,in 1 project problem solve this