update text value to database with ajax in codeigniter

Question

why it is my code doesn't work? maybe I miss something.

here is my code

View admin_page.php

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>

 <script type="text/javascript">

 // Ajax post
  $(document).ready(function() {

  $(".submit").click(function(event) {

  event.preventDefault();
  var message = $("input#l_message").val();

  jQuery.ajax({
  type: "POST",
  url: "<?php echo base_url(); ?>" + "admin/user_data_submit",
  dataType: 'json',
  data: {l_message: message},
   success: function(res) {
  if (res)
  {
   // Show Entered Value
   jQuery("div#msg").show();
    jQuery("div#msg").html(res..message);
  }
  }
  });

 });
 });
 </script>
<body>
<?php echo form_open();
    echo form_label('Librarians Message');?>
    <textarea class="form-control" name="the_librarian" id="l_message"></textarea>
    <?php echo form_submit('submit', 'Update',"class='submit'");?>
 <?php echo form_close();?>
</body>

in my controller admin.php

public function user_data_submit()
{
    $data = array('message' => $this->input->post('l_message'),
 );
  $this->home_admin_database->librarian_msg_insert($data);
  //Either you can print value or you can send value to database
  echo json_encode($data);
 }

then in my model Home_admin_database.php

public function librarian_msg_insert($data) {
$message = array(
           'message' => $data,
        );
 // Query to insert data in database
  $this->db->where('lm_id', '1');
  $this->db->update('librarians_message', $message);
  if ($this->db->affected_rows() > 0) {
     return true;
    }
   else {
   return false;
   }
  }

when I click the update button nothing happen and the page refresh without changing the database. help me please...

I want to update the database without refreshing the page then display a message after the success..

Also check your network tab in the browser. Check if there are any errors being displayed. — killstreet
– killstreet, Commented Feb 3, 2016 at 10:13

Praveen Kumar · Accepted Answer · 2016-02-03 09:14:30Z

1

Replace

 var message = $("input#l_message").val();

with

var message = $("textarea#l_message").val();

Then it should work

answered Feb 3, 2016 at 9:14

Praveen Kumar

2,3981 gold badge14 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

MGB C Over a year ago

not working sir kumar, I tried to put alert('test') before the jQuery.ajax then make the jQuery.ajax as comment. when I click the button the alert popup shown but if I remove the the jQuery.ajax as comment nothing happen and my page refresh then nothing change to my database...

Praveen Kumar Over a year ago

@MGBC jQuery("div#msg").html(res..message); to jQuery("div#msg").html(res.message);

MGB C Over a year ago

doesn't work sir even I change it. I think there was a problem on the ajax syntax sir, I tried to put alert(); before the jQuery.ajax and remove the jQuery.ajax method., when I click the button the alert popup shown... maybe the ajax is the problem but dont know how to fix it...

MGB C Over a year ago

I admit, Im not expert in English language, sorry for that.

Praveen Kumar Over a year ago

@MGBC YOur ajax is working now just open your console and look for network tab and go to last and look for "user_data_submit" and add a screenshot link of that.

|

Ashish Raj · Accepted Answer · 2016-02-03 09:54:51Z

0

in your view file try using

echo form_button('submit', 'Update',"class='submit'");

instead of

echo form_submit('submit', 'Update',"class='submit'");

Try your luck with the submit event instead of click if above not working...

Also Replace

var message = $("input#l_message").val();

with

var message = $("#l_message").val();

=> Another step is to use

<form Method="Post" class="submit_form">

instead of

echo form_open();

or remove form action attribute by jquery on document load

and $(".submit_form").submit(function(event) {...}); for ajax call

edited Feb 3, 2016 at 9:54

answered Feb 3, 2016 at 9:03

Ashish Raj

4989 silver badges23 bronze badges

4 Comments

Ashish Raj Over a year ago

I have done some editing to my answer.. please try... good luck

MGB C Over a year ago

i tried but nothing happen even I change it into submit. is there any way to trace the problem like putting an alert?

Ashish Raj Over a year ago

try Another step is to use <form Method="Post" class="submit_form"> instead of echo form_open(); or remove form action attribute by jquery

MGB C Over a year ago

Sir Raj my javascript does not have any class name "submit_form" is that ok?

Freddy Sidauruk · Accepted Answer · 2016-02-03 10:02:54Z

0

Hello i guess you using tinymce, tinymce cannot get value like that you should add to get value

tinyMCE.triggerSave();

then please change your javascript

 <script type="text/javascript">

 // Ajax post
  $(document).ready(function() {

  $(".submit").click(function(event) {

  event.preventDefault();
  tinyMCE.triggerSave();
  var message = $("#l_message").val();

alert(message) //please see is it right value or not !

  jQuery.ajax({
  type: "POST",
  url: "<?php echo base_url(); ?>" + "admin/user_data_submit",
  dataType: 'json',
  data: {l_message: message},
   success: function(res) {
  if (res)
  {
   // Show Entered Value
   jQuery("div#msg").show();
    jQuery("div#msg").html(res..message);
  }
  }
  });

 });
 });
 </script>

hope this help someone using tinymce,

answered Feb 3, 2016 at 10:02

Freddy Sidauruk

2926 silver badges18 bronze badges

1 Comment

MGB C Over a year ago

not working sir,, the error is GET localhost/nmsc/js/jquery.min.js is there any problem with jquery?

Ahmad Faizal · Accepted Answer · 2016-02-03 11:06:53Z

Change your View code with this :

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
 <script type="text/javascript">

  $(document).ready(function() {
        $("#submit").click(function(){
          // get all post from form with id form-msg
            dataString = $("#form-msg").serialize(); 
            $.ajax({
            type:"POST",
            url:"<?php echo base_url(); ?>index.php/admin/user_data_submit", 
            //parsing data to your controller
            data:dataString, 

            success:function (data) {
              // Show Entered Value
            $("div#msg").show();
            $("div#msg").html(data);
                alert('Success');
            }

            });

        return false;
        }); 
    }); 
 </script>

<body>

    <?php  
    // add form id
    echo form_open('',"id='form-msg'"); 
    echo form_label('Librarians Message');?>
    <textarea class="form-control" name="the_librarian" id="l_message"></textarea>    
    <?php 
    // add button
    echo form_button('submit', 'Update',"id='submit'"); 
    ?>
    <?php echo form_close();?>

</body>

Collectives™ on Stack Overflow

update text value to database with ajax in codeigniter

4 Answers 4

8 Comments

4 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

8 Comments

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related