Sending data to database server in Android

Question

hey guys i wanna ask a question about sending data to database to server using android app i am write script code by php like this .

     <?php 
            $coonect=mysql_connect("myhost of the site ","root","");
         if(!$coonect){
       echo "Data_base error";
         die(mysql_error());
         }
       ?>
       <?php
          $username=$_POST['menu_name'];
               $id=$_POST['id'];

         $db_select=mysql_select_db("TableName");
       if(!$db_select){
            die(mysql_error());
            echo" error";

     }
       $query= "INSERT INTO `DatabaseName`.`TableName` (
                   `name` ,
                    `id`
                        )
               VALUES (
                 '{$username}', '{$id}'
                        ); " ;

                  if($medo=mysql_query($query)){
             header("localhost/filename");
           exit;
               }else{
     echo"<p> Error</p>";
     die(mysql_error());
            }

               ?>

        <?php 
             mysql_close($coonect);
        ?>

and the code in the action buuton in the android like this .

           public void postData() {
// Create a new HttpClient and Post Header
   HttpClient httpclient = new DefaultHttpClient();
   HttpPost httppost = new HttpPost("http://mysite/script.php");

  try {
    // Add your data
    List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>(2);
    nameValuePairs.add(new BasicNameValuePair("menu_name", "any data"));
    nameValuePairs.add(new BasicNameValuePair("id", "0345644"));
    httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));

    // Execute HTTP Post Request
    HttpResponse response = httpclient.execute(httppost);

   } catch (ClientProtocolException e) {
    // TODO Auto-generated catch block
   } catch (IOException e) {
    // TODO Auto-generated catch block
  }
     }

i dont change any thing in Androidmainfest file to establish the connection do i have to and if i should put something what isit ?!! but the apk work fine but it dosent work at all do i making something wrong in my code or i should put any permission in the Androidmainfest i dont know what's wrong ??? any Help pleas

C_Rance · Accepted Answer · 2012-05-15 02:39:43Z

2

As far as I know, any network communication would require this

<uses-permission android:name="android.permission.INTERNET" />

in the manifest file. But I can't really tell if it is due to this prevent you from doing your thing. Maybe after doing adding this, you could do a ping test from your android device using terminal emulator or apps like that. Let me know if you need help getting these information.

answered May 15, 2012 at 2:39

C_Rance

66112 silver badges25 bronze badges

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

1 Comment

RoMedo Over a year ago

Thanks makn i will try it and tell u if every thing is alright :)

AnujAroshA · Accepted Answer · 2012-05-15 03:21:43Z

1

Yes you need to give the INTERNET permission like below in the Manifest;

<uses-permission android:name="android.permission.INTERNET"/>

If you are trying to run the Android program on API level higher than 13, you have to code the connecting to Internet part in a background thread not in the main thread.

If you are running it below API level 13 you no need to worry about where to code the connecting part.

PS. : This is an example for handling HTTP POST and HTTP GET in Android

answered May 15, 2012 at 3:21

AnujAroshA

4,8419 gold badges61 silver badges101 bronze badges

1 Comment

RoMedo Over a year ago

Thanks Man i will try it every thing seem to be good :) i hope it will work :)

Collectives™ on Stack Overflow

Sending data to database server in Android

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related