php - Try to update an sql row with android -

php - Try to update an sql row with android -

i tried update rows in sql database. php function works when applied on android code doesn't alter anything. when run application, app me "update successfull" on sql database same.

can help me or guide me solution?

thanks lot

here columns of my_table:

id | username | password | email | name

the code of php function:

<?php if(isset($_post['update'])) { $dbhost = 'localhost'; $dbuser = 'dbuser'; $dbpass = 'dbpassword'; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('could not connect: ' . mysql_error()); } $username = $_post['username']; $name = $_post['name']; $sql = "update tbl_user set name = '$name' username = '$username'"; mysql_select_db('my_table'); $retval = mysql_query( $sql, $conn ); if(! $retval ) { die('could not update data: ' . mysql_error()); } echo "updated info successfully\n"; mysql_close($conn); } else { ?>

the code of android activity:

public class profileactivity extends activity implements onclicklistener { private edittext nome, user; private button update; // progress dialog private progressdialog pdialog; // json parser class jsonparser jsonparser = new jsonparser(); //php login script private static final string update_url = "my_site/update.php"; //ids private static final string tag_success = "success"; private static final string tag_message = "message"; protected void oncreate(bundle savedinstancestate) { // todo auto-generated method stub super.oncreate(savedinstancestate); setcontentview(r.layout.activity_profile); nome = (edittext) findviewbyid(r.id.edittextnomepersona); user = (edittext) findviewbyid(r.id.edittextuserpersona); update = (button) findviewbyid(r.id.buttonupdate); update.setonclicklistener(this); } @override public void onclick(view v) { // todo auto-generated method stub new updateuserprofile().execute(); } class updateuserprofile extends asynctask<string, string, string> { boolean failure = false; @override protected void onpreexecute() { super.onpreexecute(); pdialog = new progressdialog(profileactivity.this); pdialog.setmessage(getresources().getstring(r.string.update_attempt)); pdialog.setindeterminate(false); pdialog.setcancelable(true); pdialog.show(); } @override protected string doinbackground(string... args) { // todo auto-generated method stub // check success tag int success; string name = nome.gettext().tostring(); string username = user.gettext().tostring(); seek { // building parameters list<namevaluepair> params = new arraylist<namevaluepair>(); params.add(new basicnamevaluepair("name", name)); params.add(new basicnamevaluepair("username", username)); log.d("request!", "starting"); // getting product details making http request jsonobject json = jsonparser.makehttprequest( update_url , "post", params); // check log json response log.d("update attempt", json.tostring()); // json success tag success = json.getint(tag_success); if (success == 1) { log.d(getresources().getstring(r.string.update_successfull), json.tostring()); intent = new intent(profileactivity.this, newactivity.class); finish(); startactivity(i); homecoming json.getstring(tag_message); }else{ log.d(getresources().getstring(r.string.update_failure), json.getstring(tag_message)); homecoming json.getstring(tag_message); } } grab (jsonexception e) { e.printstacktrace(); } homecoming null; } /** * after completing background task dismiss progress dialog * **/ protected void onpostexecute(string file_url) { // dismiss dialog 1 time product deleted pdialog.dismiss(); if (file_url != null){ toast.maketext(profileactivity.this, file_url, toast.length_long).show(); } } } }

and activitiy_profile.xml:

<?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" > <scrollview android:id="@+id/scrollview1" android:layout_width="match_parent" android:layout_height="match_parent" > <linearlayout android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" > <textview android:id="@+id/textviewpersona" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginleft="15dp" android:layout_margintop="25dp" android:text="textview" android:textsize="60px" /> <relativelayout android:layout_width="fill_parent" android:layout_height="fill_parent" android:layout_centerinparent="true" android:orientation="horizontal" > </relativelayout> <linearlayout android:layout_width="match_parent" android:layout_height="match_parent" android:gravity="center" android:orientation="vertical" > <textview android:id="@+id/textview1" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="nome persona" /> <edittext android:id="@+id/edittextnomepersona" android:layout_width="match_parent" android:layout_height="wrap_content" android:ems="10" > <requestfocus /> </edittext> <textview android:id="@+id/textview12" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="nome utente" /> <edittext android:id="@+id/edittextuserpersona" android:layout_width="match_parent" android:layout_height="wrap_content" android:ems="10" /> <button android:id="@+id/buttonupdate" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="update" /> </linearlayout> </linearlayout> </scrollview> <button android:id="@+id/button1" android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="button" /> </linearlayout>

i find solution! hope can help in future someone....

here working solution:

<?php require("config.inc.php"); if (!empty($_post)) { if (empty($_post['username']) || empty($_post['nameperson'])) { $response["success"] = 0; $response["message"] = "please come in fields"; die(json_encode($response)); } $query = " select 1 tbl_user username = :user"; $query_params = array( ':user' => $_post['username'] ); seek { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } grab (pdoexception $ex) { $response["success"] = 0; $response["message"] = "database error1. please seek again!"; die(json_encode($response)); } $query = "update tbl_user set name = :nameperson username = :user"; $query_params = array( ':user' => $_post['username'], ':nameperson' => $_post['nameperson'] ); seek { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } grab (pdoexception $ex) { $response["success"] = 0; $response["message"] = "database error2. please seek again!"; die(json_encode($response)); } $response["success"] = 1; $response["message"] = "username added!"; echo json_encode($response); } else { ?>

and alter in android activity:

string name = nome.gettext().tostring(); string username = user.gettext().tostring(); seek { // building parameters list<namevaluepair> params = new arraylist<namevaluepair>(); params.add(new basicnamevaluepair("name", name)); params.add(new basicnamevaluepair("username", username));

with one:

string nameperson = nome.gettext().tostring(); string user = usern.gettext().tostring(); seek { // building parameters list<namevaluepair> params = new arraylist<namevaluepair>(); params.add(new basicnamevaluepair("nameperson", nameperson)); params.add(new basicnamevaluepair("username", user));

php android sql sql-server