Ajax in codeigniter issue

Question

1.00/5 (1 vote)

See more:

I am trying to refresh / reload the page using ajax with codeigniter.
The code is working fine but it is loading my whole page [view] and i want to only load the table or some specific container but using the same view. I check a lot of question but did not find what i want, Please check the question instead of down voting. What is wrong in it? can someone please look at it.

What I have tried:

View:

      <pre lang="PHP"><!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Insert | SP</title>
      <script src="<?php echo base_url(); ?>bootstrap/js/jquery-2.1.1.min.js"></script>

<script>
        $(document).ready(function(){

            function loadNowPlaying(){
      $(this).load('<?php echo base_url().'Store/student' ;?>');
    }
    setInterval(function(){loadNowPlaying()}, 5000);
        });


        </script>

 </head>
    <body>
        <form action="<?php echo base_url();?>Store/add" method="post">
            <input type="text" name="name" id="name"><br>
            <input type="text" name="mail" id="mail"><br>
            <input type="password" name="pass" id="pass"><br>
            <input type="submit" name="submit" id="submit" value="Insert">
        </form>


        <table id="studata">
           <?php foreach ($students as $student):?>
            <tr>
               <th>Name</th>
               <th>Email</th>
               <th>Password</th>
            </tr>
               <tr>
                <td><?php echo $student->Name;?></td>
                <td><?php echo $student->Email;?></td>
                <td><?php echo $student->Password;?></td>
            </tr>
            <?php endforeach;?>
        </table>
    </body>
    </html>

My Controller code:

PHP

public function student()
    {
        $data["students"] = $this->sp->getstudent();
        $this->load->view('student',$data);
    }

My Model:

PHP

public function getstudent()
    {
         $this->db->select('*');
        $this->db->from('ex_sp');
        $query = $this->db->get();
        return $query->result();
    }

Posted 25-Aug-17 2:04am

msz900

Updated 25-Aug-17 5:34am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2017-08-25T05:34:00

Quote:

$(this).load('<?php echo base_url().'Store/student' ;?>');

.load() | jQuery API Documentation[^]:
Load data from the server and place the returned HTML into the matched element.

What do you imagine the "matched element" is in your code? (NB: You can use the debugger to find out!)

If you want to replace a specific element, then you need to match that element before calling load. For example, to replace the studata table with the content of the loaded document, use:

JavaScript

$("#studata").load('<?php echo base_url().'Store/student' ;?>');

If the page you're loading returns an entire HTML document, and you only want to load a specific part of it, pass a selector to the URL. For example, to replace the studata table on the current page with the studata table on the loaded page, use:

JavaScript

$("#studata").load('<?php echo base_url().'Store/student' ;?> #studata');