Undefined when entering the value in the DB [closed]

0

It connects me perfectly all the values but when entering a part that is called incidence appears to me write what you write me appears undefined

this is the code where data is entered into the DB

                require_once ("../config/db.php");
        require_once ("../config/conexion.php");


            $incidencia = mysqli_real_escape_string($con,(strip_tags($_POST["incidencia"],ENT_QUOTES)));
            $tema = mysqli_real_escape_string($con,(strip_tags($_POST["tema"],ENT_QUOTES)));
            $detalle = mysqli_real_escape_string($con,(strip_tags($_POST["detalle"],ENT_QUOTES)));
            $imagen = ($_FILES['imagen']);

            $sql = "SELECT * FROM ticket WHERE incidencia = '" . $incidencia . "' OR tema = '" . $tema . "';";
            $query_check_incidencia = mysqli_query($con,$sql);

                $sql = "INSERT INTO ticket (incidencia, tema, detalle, imagen)
                        VALUES('".$incidencia."','".$tema."','" . $detalle . "', '" . $_FILES['imagen']['name'] . "');";
                $query_new_incidencia_insert = mysqli_query($con,$sql);



     else {
        $errors[] = "Un error desconocido ocurrió.";
    }

    if (isset($errors)){

        ?>
        <div class="alert alert-danger" role="alert">
            <button type="button" class="close" data-dismiss="alert">&times;</button>
                <strong>Error!</strong> 
                <?php
                    foreach ($errors as $error) {
                            echo $error;
                        }
                    ?>
        </div>
        <?php
        }
        if (isset($messages)){

            ?>
            <div class="alert alert-success" role="alert">
                    <button type="button" class="close" data-dismiss="alert">&times;</button>
                    <strong>¡Bien hecho!</strong>
                    <?php
                        foreach ($messages as $message) {
                                echo $message;
                            }
                        ?>
            </div>
            <?php
        }

         ?>

and this is where I enter the data

                <?php
    if (isset($con))
    {
?>

<div class="modal fade" id="myModal20" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
        <h4 class="modal-title" id="myModalLabel"><i class='glyphicon glyphicon-edit'></i> Agregar nueva incidencia</h4>
      </div>
      <div class="modal-body">
        <form class="form-horizontal" method="post" id="guardar_ticket" name="guardar_ticket" enctype="multipart/form-data">
        <div id="resultados_ajax"></div>
          <div class="form-group">
            <label for="incidencia" class="col-sm-3 control-label">Incidencia</label>
            <div class="col-sm-8">
              <input type="text" class="form-control" id="incidencia" name="incidencia" placeholder="incidencia" required>
            </div>
          </div>
                      <div class="form-group">
            <label for="tema" class="col-sm-3 control-label">Asunto</label>
            <div class="col-sm-8">
              <input type="text" class="form-control" id="tema" name="tema" placeholder="Asunto" required>
            </div>
          </div>
          <div class="form-group">
            <label for="detalle" class="col-sm-3 control-label">Detalle</label>
            <div class="col-sm-8">
              <input type="text" class="form-control" id="detalle" name="detalle" placeholder="Detalle" required>
            </div>
          </div>
          <div class="form-group">
            <label for="imagen" class="col-sm-3 control-label">Imagen</label>
            <div class="col-sm-8">
              <input id="imagen" type="file" name="imagen" > 
            </div>
          </div>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-default" data-dismiss="modal">Cerrar</button>
        <button type="submit" class="btn btn-primary" id="guardar_datos">Guardar datos</button>
      </div>
      </form>
    </div>
  </div>
</div>
<?php
    }
?>

I insert the js

                $( "#guardar_ticket" ).submit(function( event ) {
           $('#guardar_datos').attr("disabled", true);

           var incidencia = $("incidencia").val();
           var tema = $("#tema").val();
           var detalle = $("#detalle").val();

          var imagen = $("#imagen")[0].files[0];

            var parametros =  new FormData();

       parametros.append('incidencia', incidencia);            
       parametros.append('tema', tema); 
       parametros.append('detalle', detalle); 
       parametros.append('imagen', imagen);

       $.ajax({
        type: "POST",
        url: "ajax/nuevo_ticket.php",
        data: parametros,
        cache: false,
        contentType: false,
        processData: false,
         beforeSend: function(objeto){
            $("#resultados_ajax").html("Mensaje: Cargando...");
          },
        success: function(datos){
        $("#resultados_ajax").html(datos);
        $('#guardar_datos').attr("disabled", false);
        load(1);
          }
          });
         event.preventDefault();
         })
          $( "#editar_ticket" ).submit(function( event ) {
       $('#actualizar_datos2').attr("disabled", true);

           var parametros = $(this).serialize();
         $.ajax({
        type: "POST",
        url: "ajax/editar_ticket.php",
        data: parametros,
         beforeSend: function(objeto){
            $("#resultados_ajax2").html("Mensaje: Cargando...");
          },
        success: function(datos){
        $("#resultados_ajax2").html(datos);
        $('#actualizar_datos2').attr("disabled", false);
        load(1);
          }
      });
          event.preventDefault();
        })


        function get_user_Nticket(Nticket){
            $("#user_Nticket_mod").val(Nticket);
        }

function obtener_datos(Nticket){
        var incidencia = $("#incidencia"+Nticket).val(Nticket);
        var tema = $("#tema"+Nticket).val(Nticket);
        var detalle = $("#detalle"+Nticket).val(Nticket);
        var imagen = $("imagen"+Nticket).val(Nticket);

        $("#mod_Nticket").val(Nticket);
        $("#incidencia").val(incidencia);
        $("#tema").val(tema);
        $("#detalle").val(detalle);
        $("#imagen").val(imagen);
    }

    
asked by Kevin Salazar 28.09.2017 в 22:16
source

1 answer

1

Your error is in this line

var incidencia = $("incidencia").val();

As you are capturing an element for its id you must place the # as well

var incidencia = $("#incidencia").val();
    
answered by 28.09.2017 / 22:47
source