Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- try {
- $usuario = "698193_admin";
- $password = "1234admin";
- $conn = new PDO('mysql:host=fdb3.runhosting.com;dbname=698193_admin', $usuario, $password);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- } catch (PDOException $e) {
- echo "ERROR: " . $e->getMessage();
- }
- try {
- $Code = $_POST['Code'];
- $consulta = $conn->prepare("SELECT * FROM Usuarios WHERE Code=" . $Code);
- $consulta->execute();
- if ($consulta->rowCount() == 1) {
- echo 'Ya existe un Usuario con este código';
- } else {
- $sql = $conn->prepare("INSERT INTO Usuarios(Code,user,Pass,TipoUsuario) VALUES (:Code, :user, :Pass, :TipoUsuario)");
- $sql->bindParam(':Code', $_POST['Code']);
- $sql->bindParam(':user', $_POST['user']);
- $sql->bindParam(':Pass', $_POST['Pass']);
- $sql->bindParam(':TipoUsuario', $_POST['TipoUsuario']);
- $sql->execute();
- echo 'Usuario agregado correctamente';
- }
- } catch (PDOException $e) {
- echo 'No se pudo agregar el Usuario ' . $e->getMessage();
- }
- ?>
- private void addUsuario() {
- final String Code = et1.getText().toString().trim();
- final String User = et2.getText().toString().trim();
- final String Pass = et3.getText().toString().trim();
- final String TipoUsuario = muestraUser.getSelectedItem().toString();
- class AddUsuario extends AsyncTask<Void, Void, String> {
- ProgressDialog loading;
- @Override
- protected void onPreExecute() {
- super.onPreExecute();
- loading = ProgressDialog.show(addUsuario.this, "Adding...", "Wait...", false, false);
- }
- @Override
- protected void onPostExecute(String s) {
- super.onPostExecute(s);
- loading.dismiss();
- Toast.makeText(addUsuario.this, s, Toast.LENGTH_LONG).show();
- }
- @Override
- protected String doInBackground(Void... v) {
- HashMap<String, String> params = new HashMap<>();
- params.put(Config.KEY_USER_CODE, Code);
- params.put(Config.KEY_USER_USUARIO, User);
- params.put(Config.KEY_USER_PASS, Pass);
- params.put(Config.KEY_USER_TIPOUSER, TipoUsuario);
- RequestHandler rh = new RequestHandler();
- String res = rh.sendPostRequest(Config.URL_ADD_USER, params);
- return res;
- }
- }
- AddUsuario ae = new AddUsuario();
- ae.execute();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement