Jquery, Ajax, PHP and Mysql function returns data in HTML code?

Question

As above I am using a function to search a MySql database and display the results in a designated table but the return information is being displayed in HTML code instead (as below)

<style type="text/css">
.style39 {font-family: Geneva, Arial, Helvetica, sans-serif}
.style92 {font-size: 12px}
</style>
<table width="100%" border="1" cellspacing="2" cellpadding="2">
<tbody>
<tr class="PartListHeader">

My JavaScript:

$('input#PartNumber_Submit').on('click', function() {
    var PartNumber = $('input#PartNumber').val();
    if ($.trim(PartNumber) != ''){
        $.post('small-displays/PartSearchResults.php', {PartNumber: PartNumber}, function(data) {
            $('div#name-data').text(data);
        });
    }
});

I've been tinkering with the data . text but I'm well and truely lost and my mind has even lost with what to do. 1 hour and 50 minutes starring at the same small script! ARGH!

Something simple no doubt!

Any help would be much appreciated!

Thanks in advance,

Marc B · Accepted Answer · 2014-09-11 16:05:24Z

6

You're using .text() which takes the passed in argument and places it into a text node within the specified element. If it's html, it won't render as html - you'll get the raw html source code. You want .html() instead:

        $('div#name-data').html(data);
                           ^^^^

answered Sep 11, 2014 at 16:05

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

1 Comment

Earunder Over a year ago

Ahhhhhh! You've just released a stress valve from my head!

Chillar Anand · Accepted Answer · 2015-03-03 07:50:14Z

0

Use this

 $('div#name-data').html(data);

instead of this statement

$('div#name-data').text(data);

edited Mar 3, 2015 at 7:50

Chillar Anand

29.8k10 gold badges126 silver badges144 bronze badges

answered Sep 11, 2014 at 16:08

Bokul

3941 silver badge9 bronze badges

Collectives™ on Stack Overflow

Jquery, Ajax, PHP and Mysql function returns data in HTML code?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related