send data from android to php and php store a Sequence of ? in mysql

Question

I am using the following code to send data from my application to a PHP script on my server:

postList.add(new BasicNameValuePair("PType", TxtWeight.getText().toString()));

String StrURL="http://chacho.comuv.com/android/insert_pistachio_sell.php";
myJsonObject=JP.store_And_Feedback("PType",SpnPistachio.getSelectedItem().toString()));
DefaultHttpClient DHC=new DefaultHttpClient();
HttpPost httpPost=new HttpPost("StrURL");
httpPost.setEntity(new UrlEncodedFormEntity(postList));

The following PHP code will store the received data in my database:

<?php
    require_once "./includes/DB_Connect.php"
    $PType=$_POST['PType'];

    $SQL="INSERT INTO  sell (ptype)VALUES ('".mysql_real_escape_string($PType)."')";
    $Result=mysql_query($SQL);
?>

But data is saved in the database like "??????????"

I have searched a lot but I have not found a way to make this work properly.

I don't see in your code that you add the Ptype key-value pair to the postList list. Are you writing the PWeight to the database? If so does that get sent via the POST request correctly? — elitechief21
– elitechief21, Commented Jan 7, 2014 at 19:16
Are all characters being converted to ? or just non-ASCII ones? For consistent Unicode support you should use UTF-8 on both sides: use new UrlEncodedFormEntity(postList, "UTF-8") at the client, mysql_set_charset('utf-8') at the app server and UTF-8-collated tables at the db server. — bobince
– bobince, Commented Jan 7, 2014 at 23:37
thank you a lot @bobince; new UrlEncodedFormEntity(postList, "UTF-8") slove my Problem and every thing work OK — HamidTB
– HamidTB, Commented Jan 8, 2014 at 4:30

HamidTB · Accepted Answer · 2014-01-08 04:39:21Z

2

first i'm thank you from @bobince for help

1- in mysql set collection of field to "utf8_persian_ci"

2- in php code after connect to db run this code

mysql_query("SET NAMES 'UTF8'");

3- in android code use UTF-8 encode like this code

new UrlEncodedFormEntity(postList, "UTF-8")

data will save correctly on your mysql database

answered Jan 8, 2014 at 4:39

HamidTB

1,5213 gold badges13 silver badges16 bronze badges

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

3 Comments

bobince Over a year ago

Prefer mysql_set_charset('utf-8') over SET NAMES. The latter does not correctly update the encoding information used by mysql_real_escape_string, making it effectively the same as mysql_escape_string.

HamidTB Over a year ago

@bobince thank you again;i am just use mysql_query("SET NAMES 'UTF8'"); in php script and use new UrlEncodedFormEntity(postList, "UTF-8") in android application and remove mysql_real_escape_string from php script; every thing work perfect :)

bobince Over a year ago

Don't remove mysql_real_escape_string, you need it to avoid SQL injection vulnerabilities! (In general, you are better off using mysqli or PDO together with parameterised queries so that you don't have to use mysql_real_escape_string explicitly each time, but if you are sticking with mysql then this SQL-escaping is essential.)

Collectives™ on Stack Overflow

send data from android to php and php store a Sequence of ? in mysql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related