Advertisement
Guest User

Untitled

a guest
Mar 6th, 2017
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.41 KB | None | 0 0
  1. <?php
  2.  
  3. try {
  4. $usuario = "698193_admin";
  5. $password = "1234admin";
  6. $conn = new PDO('mysql:host=fdb3.runhosting.com;dbname=698193_admin', $usuario, $password);
  7. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  8. } catch (PDOException $e) {
  9. echo "ERROR: " . $e->getMessage();
  10. }
  11.  
  12. try {
  13. $Code = $_POST['Code'];
  14. $consulta = $conn->prepare("SELECT * FROM Usuarios WHERE Code=" . $Code);
  15. $consulta->execute();
  16.  
  17. if ($consulta->rowCount() == 1) {
  18. echo 'Ya existe un Usuario con este código';
  19. } else {
  20. $sql = $conn->prepare("INSERT INTO Usuarios(Code,user,Pass,TipoUsuario) VALUES (:Code, :user, :Pass, :TipoUsuario)");
  21. $sql->bindParam(':Code', $_POST['Code']);
  22. $sql->bindParam(':user', $_POST['user']);
  23. $sql->bindParam(':Pass', $_POST['Pass']);
  24. $sql->bindParam(':TipoUsuario', $_POST['TipoUsuario']);
  25. $sql->execute();
  26.  
  27. echo 'Usuario agregado correctamente';
  28. }
  29. } catch (PDOException $e) {
  30. echo 'No se pudo agregar el Usuario ' . $e->getMessage();
  31. }
  32. ?>
  33.  
  34. private void addUsuario() {
  35.  
  36. final String Code = et1.getText().toString().trim();
  37. final String User = et2.getText().toString().trim();
  38. final String Pass = et3.getText().toString().trim();
  39. final String TipoUsuario = muestraUser.getSelectedItem().toString();
  40.  
  41. class AddUsuario extends AsyncTask<Void, Void, String> {
  42.  
  43. ProgressDialog loading;
  44.  
  45. @Override
  46. protected void onPreExecute() {
  47. super.onPreExecute();
  48. loading = ProgressDialog.show(addUsuario.this, "Adding...", "Wait...", false, false);
  49. }
  50.  
  51. @Override
  52. protected void onPostExecute(String s) {
  53. super.onPostExecute(s);
  54. loading.dismiss();
  55. Toast.makeText(addUsuario.this, s, Toast.LENGTH_LONG).show();
  56. }
  57.  
  58. @Override
  59. protected String doInBackground(Void... v) {
  60. HashMap<String, String> params = new HashMap<>();
  61. params.put(Config.KEY_USER_CODE, Code);
  62. params.put(Config.KEY_USER_USUARIO, User);
  63. params.put(Config.KEY_USER_PASS, Pass);
  64. params.put(Config.KEY_USER_TIPOUSER, TipoUsuario);
  65.  
  66. RequestHandler rh = new RequestHandler();
  67. String res = rh.sendPostRequest(Config.URL_ADD_USER, params);
  68. return res;
  69. }
  70. }
  71.  
  72. AddUsuario ae = new AddUsuario();
  73. ae.execute();
  74. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement