CodeIgniter not executing the PHP script called by $.get()

Question

I have a sample script written using CodeIgniter and I used JQuery's $.get() function. $.get() called this PHP script: delete.php

    $id = $_GET['id'];
    $conn = mysqli_connect('localhost', 'root', '', 'table1');
    $qry = "delete from table1 where id = $id";
    $qry_result = mysqli_query($conn, $qry);

How I call delete.php in JQuery: $.get("delete.php", { id : my_id} );. My problem is that delete.php was not executed by $.get(). I am thinking if the cause was due to CodeIgniter's security that you cannot access the scripts directly?

Please help!

Look in the network tab of the Chrome Dev tools (or Safari or firefox). Are the requests actually being sent? — Alfo
– Alfo, Commented Mar 9, 2013 at 18:26
@undefined - Please ignore mysqli, my site is configured to run this version but the query / PHP script is working fine. — kagat-kagat
– kagat-kagat, Commented Mar 9, 2013 at 18:29
Okay, you are using a MVC framework, it is not how it's supposed to work, you should use your Controllers and Models, what you are doing is an anti-pattern. — Ram
– Ram, Commented Mar 9, 2013 at 18:31

Peeyush · Accepted Answer · 2013-03-09 18:42:16Z

2

First of all if you are new to this MVC framework then at least go and study the introduction & tutorial part for there user guide http://ellislab.com/codeigniter/user-guide/.

Then only you will come to know how to call a controller in that.

But if you want the answer then you can do this in this way:

1.first go and create a controller(e.g. mycontroller) & write a function inside it(e.g. myfunction) and write your code into that part & it is also better that you do not user this mysqli* stuff in MVC.

2.pass the url(e.g. http://[yourhost]/index.php/mycontroller/myfunction) inside $.get() function.

P.S. I am not sure that your CI is configured to use index.php in URL or not. It totally depends upon your configuration. So if it not work for you then try without index.php or take a look into routs.php

answered Mar 9, 2013 at 18:42

Peeyush

4,89817 gold badges67 silver badges93 bronze badges

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

1 Comment

kagat-kagat Over a year ago

I got it working before you posted your answer, but still thank you for your help.

Collectives™ on Stack Overflow

CodeIgniter not executing the PHP script called by $.get()

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related