Estoy tratando de verificar si existe valor en la base de datos en mi sitio web CodeIgniter usando AJAAX. He escrito el siguiente código:
<input id="username" name="pincode" type="text" class="form-control" placeholder="Enter Pincode"> <input id="prodid" name="prodid" value="<?php echo $prodid;?>" type="hidden"> <button type="button" onclick="check_if_exists();" class="btn btn-primary">Check</button> function check_if_exists() { var username = $("#username").val(); var prodid = $("#prodid").val(); $.ajax({ type: "post", url: "<?php echo base_url(); ?>index.php/homecontroller/filename_exists", data: { username: username, prodid: prodid }, success: function(response) { if (response == true) { $('#msg').html('<span style="color: green;">' + msg + "</span>"); } else { $('#msg').html('<span style="color:red;">Delivery Not Available at ' + username + '</span>'); } } }); } function filename_exists() { $username = $this->input->post('pincode'); $prodid = $this->input->post('prodid'); $exists = $this->product->filename_exists($prodid); if ($exists) { return true; } else { return false; } } function filename_exists($prodid) { $this->db->select('*'); $this->db->where('id', $prodid); $this->db->from('product'); $query = $this->db->get(); $result = $query->result_array(); return $result; }Solo recibo el mensaje de que el valor no existe, incluso si el valor está en la base de datos.
function check_if_exists() { var username = $("#username").val(); var prodid = $("#prodid").val(); var transfer = [username,prodid]; $.ajax({ type: "post", url: "<?php echo base_url(); ?>index.php/homecontroller/filename_exists", data: {result: JSON.stringify(transfer)}, success: function(response) { if (response) { $('#msg').html('<span style="color: green;">' + msg + "</span>"); } else { $('#msg').html('<span style="color:red;">Delivery Not Available at ' + username + '</span>'); } } }); }Controlador
function filename_exists() { $post = json_decode($_POST['result']); $username = $post[0]; $prodid = $post[1]; $exists = $this->product->filename_exists($prodid); echo $exists; }Modal
function filename_exists($prodid) { $this->db->select('id'); $this->db->where('id', $prodid); $this->db->from('product'); $query = $this->db->get(); if($query->num_rows()) return true; } enter code here