trouble having a javascript code retrieve data from mysql

Question

I am in a little bit of a predicament. I am writing a programme where a user can make a search. Then the search returns a possible list of results. If you move your mouse over the results it highlights them. When you select one of the items from the result, it replaces the list with the item you selected. The problem I am having is that I can't get the item to replace the list. I am using CodeIgniter.

Steps

In my model, I pass the id (VenueID) of item through onclick function to my javascript function.

venue_model.php:

$output .= '<li><a href="#self" class="menulink" class=&{ns4class};
               onClick="changeDiv(\''.
                 $venue_details->**VenueID**.

               '\')">

The javascript function takes the javascript id and then passes it to a function in the controller to retrieve the item from a MySQL database.

divUpdater.php:

<script type="text/javascript">
base_url = '<?= base_url();?>index.php/';
</script>

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

function changeDiv(venueID){
  $.get(base_url+'home/get_venue_description/' + venueID , function(data) {
    $('#venue_description').html(data);
    document.getElementById('venue_description').innerHTML=data;
  });

}

here is the function from the controller that retrieves the data from the database

home.php (controller)

    function get_venue_description($venueID){
       echo $this->venue_model->retrieveData($venueID);
      }

The problem is in the model and the divUpdater.php. When I click on one of the item from the list, it gives me this url

http://localhost/Counter/index.php#self

And this is becasue of the anchor tag in the model (<a href="#self"...). I was wondering if it was possible to get the code in the divUpdater.php to execute and retrieve the data in the background without having the url change.

Please does anyone know how to do that?

possible duplicate of Troubles using jquery get to retrieve data from the server and place in a div — Your Common Sense
– Your Common Sense, Commented Nov 7, 2010 at 18:47
you can't access mysql database from JS. Lack of understanding is your real trouble — Your Common Sense
– Your Common Sense, Commented Nov 7, 2010 at 18:49
I am using the controller to get access to the database. Is there an alternative way of doing what I am doing? — user455699
– user455699, Commented Nov 7, 2010 at 19:42
This might sound pedantic, but my first suggestion is to write proper English in your post. Reading it as it was would probably turn a lot of people away from this question. Secondly, begin to accept answers for your questions, and perhaps you will get more replies. — treeface
– treeface, Commented Nov 7, 2010 at 21:47

Dan Grossman · Accepted Answer · 2010-11-07 18:45:20Z

1

If you do not want the default click behavior of a link to occur (going to #self when clicking a link with href="#self"), then your onclick handler should return false.

onClick="changeDiv(stuff); return false;"

I don't know if that will help with anything else.

answered Nov 7, 2010 at 18:45

Dan Grossman

52.5k10 gold badges115 silver badges101 bronze badges

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

Collectives™ on Stack Overflow

trouble having a javascript code retrieve data from mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related