Hello, I was wondering if anyone can help me out. I am having trouble having my app update/add information to my database. I fill out the log in page and I keep getting my toast message "can not sign in" and no info is added to mysql database. Can anyone see what I am missing in my code that is causing this? Thanks in advance for any help
This is my login code import java.io.InputStream; import java.util.ArrayList; import java.util.List; import org.apache.http.HttpResponse; import org.apache.http.NameValuePair; import org.apache.http.client.HttpClient; import org.apache.http.client.ResponseHandler; import org.apache.http.client.entity.UrlEncodedFormEntity; import org.apache.http.client.methods.HttpPost; import org.apache.http.impl.client.BasicResponseHandler; import org.apache.http.impl.client.DefaultHttpClient; import org.apache.http.message.BasicNameValuePair; import android.app.Activity; import android.content.Intent; import android.content.SharedPreferences; import android.os.Bundle; import android.preference.PreferenceManager; import android.view.View; import android.widget.Button; import android.widget.CheckBox; import android.widget.EditText; import android.widget.TextView; import android.widget.Toast; public class LoginJ extends Activity { Button login; String name="",pass="", EMAIL=""; EditText username,password, email; TextView tv; byte[] data; HttpPost httppost; StringBuffer buffer; HttpResponse response; HttpClient httpclient; InputStream inputStream; SharedPreferences app_preferences ; List<NameValuePair> nameValuePairs; CheckBox check; public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.login); app_preferences = PreferenceManager.getDefaultSharedPreferences(this); username = (EditText) findViewById(R.id.username); password = (EditText) findViewById(R.id.password); email = (EditText) findViewById(R.id.email); login = (Button) findViewById(R.id.login); check = (CheckBox) findViewById(R.id.check); String Str_user = app_preferences.getString("username","0" ); String Str_pass = app_preferences.getString("password", "0"); String Str_EMAIL = app_preferences.getString("email", "0"); String Str_check = app_preferences.getString("checked", "no"); if(Str_check.equals("yes")) { username.setText(Str_user); password.setText(Str_pass); email.setText(Str_EMAIL); check.setChecked(true); } login.setOnClickListener(new View.OnClickListener() { public void onClick(View v) { name = username.getText().toString(); pass = password.getText().toString(); EMAIL = email.getText().toString(); String Str_check2 = app_preferences.getString("checked", "no"); if(Str_check2.equals("yes")) { SharedPreferences.Editor editor = app_preferences.edit(); editor.putString("username", name); editor.putString("password", pass); editor.putString("email", EMAIL); editor.commit(); } if(name.trim().equals("") || pass.trim().equals("") || EMAIL.trim().equals("")) { Toast.makeText(LoginJ.this, "Blank Field..Please Enter", Toast.LENGTH_LONG).show(); } else{ try{ httpclient = new DefaultHttpClient(); httppost = new HttpPost("http:// 10.0.2.2/AppConnection/main.php"); // Add your data nameValuePairs = new ArrayList<NameValuePair>(3); nameValuePairs.add(new BasicNameValuePair("UserName", name.trim())); nameValuePairs.add(new BasicNameValuePair("Password", pass.trim())); nameValuePairs.add(new BasicNameValuePair("email", pass.trim())); httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs)); // Execute HTTP Post Request response = httpclient.execute(httppost); inputStream = response.getEntity().getContent(); ResponseHandler<String> responseHandler = new BasicResponseHandler(); String response = httpclient.execute(httppost, responseHandler); System.out.println("Response : " + response); // check the string from the php side... if(response.equalsIgnoreCase("Y")){ Toast.makeText(LoginJ.this, "login successfull", Toast.LENGTH_LONG).show(); }else{ Toast.makeText(LoginJ.this, "Cannot Log In", Toast.LENGTH_LONG).show(); } data = new byte[256]; buffer = new StringBuffer(); int len = 0; while (-1 != (len = inputStream.read(data)) ) { buffer.append(new String(data, 0, len)); } inputStream.close(); } catch (Exception e) { Toast.makeText(LoginJ.this, "error"+e.toString(), Toast.LENGTH_LONG).show(); } if(buffer.charAt(0)=='Y') { Toast.makeText(LoginJ.this, "login successfull", Toast.LENGTH_LONG).show(); } else { Toast.makeText(LoginJ.this, "Can not Log in", Toast.LENGTH_LONG).show(); } } } }); check.setOnClickListener(new View.OnClickListener() { public void onClick(View v) { // Perform action on clicks, depending on whether it's now checked SharedPreferences.Editor editor = app_preferences.edit(); if (((CheckBox) v).isChecked()) { editor.putString("checked", "yes"); editor.commit(); } else { editor.putString("checked", "no"); editor.commit(); } } }); } public void Move_to_next() { startActivity(new Intent(this, TheClassReviewActivity.class)); } } And this is my PHP code $hostname_localhost = "localhost"; $database_localhost = "logindatabase"; $username_localhost = "root"; $localhost = mysql_connect($hostname_localhost,$username_localhost) or trigger_error(mysql_error(),E_USER_ERROR); require_once('Connections/localhost.php'); mysql_select_db($database_localhost,$localhost); $UserName = $_POST['UserName']; $Password = $_POST['Password']; $email = $_POST['email'] mysql_query("INSERT INTO tbl_users (UserName, Password, email) VALUES ('".$UserName."', '".$Password."', '".$email."')"; $query_exec = mysql_query($query_insert) or die (mysql_error()); $rows = mysql_num_rows($query_exec); if($rows !==0) {echo "Y"}; else {echo "N"}; ?> -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en