Advertisement
Guest User

Untitled

a guest
Mar 14th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. <?php
  2. try{
  3. $usuario = "ABCDEFGHIJKLM";
  4. $password = "1234567890";
  5. $conn = new PDO('mysql:host=fdb3.runhosting.com;dbname=DataBaseName', $usuario, $password);
  6. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  7. }catch(PDOException $e){
  8. echo "ERROR: " . $e->getMessage();
  9. }
  10. $user=$_POST['user'];
  11. $Pass=$_POST['Pass'];
  12. $TipoUsuario=$_POST['$TipoUsuario'];
  13. $Code=$_GET['Code'];
  14. $sql="UPDATE Usuarios SET user=?,Pass=?,TipoUsuario=? WHERE Code =?";
  15. $stp=$conn->prepare($sql);
  16. $pdoexect=$stp->execute(array($user,$Pass,$TipoUsuario,$Code));
  17. if($pdoexect)
  18. {
  19. echo "Actualización exitosa";
  20. }else{
  21. echo "no se pudo actualizar";
  22. }
  23.  
  24. ?>
  25.  
  26. private void updateUsuario(){
  27.  
  28. final String Code = et1.getText().toString().trim();
  29. final String User = et2.getText().toString().trim();
  30. final String Pass = et3.getText().toString().trim();
  31. final String TipoUsuario=tipUser.getSelectedItem().toString();
  32.  
  33. class UpdateUsuario extends AsyncTask<Void,Void,String>{
  34. ProgressDialog loading;
  35. @Override
  36. protected void onPreExecute() {
  37. super.onPreExecute();
  38. loading = ProgressDialog.show(buscarUpdateUser.this,"Updating...","Wait...",false,false);
  39. }
  40.  
  41. @Override
  42. protected void onPostExecute(String s) {
  43. super.onPostExecute(s);
  44. loading.dismiss();
  45. Toast.makeText(buscarUpdateUser.this,s,Toast.LENGTH_LONG).show();
  46. }
  47.  
  48. @Override
  49. protected String doInBackground(Void... params) {
  50. HashMap<String,String> hashMap = new HashMap<>();
  51. hashMap.put(Config.KEY_USER_CODE,Code);
  52. hashMap.put(Config.KEY_USER_USUARIO,User);
  53. hashMap.put(Config.KEY_USER_PASS,Pass);
  54. hashMap.put(Config.KEY_USER_TIPOUSER,TipoUsuario);
  55.  
  56. RequestHandler rh = new RequestHandler();
  57.  
  58. String s = rh.sendPostRequest(Config.URL_UPDATE_USER,hashMap);
  59. return s;
  60. }
  61. }
  62. UpdateUsuario ue = new UpdateUsuario();
  63. ue.execute();
  64. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement