jquery/ajax php output help

[pravaut]

hi first time posting here but have learned a lot from this site my problem is my script display html tags here is what dispalys when i run my script

and my code as follows

</div>
<div>
<button type="button" name="getdata" id="getdata">Get Data</button>
</div>
<div id="result_table"></div>
<script type="text/javascript" language="javascript" >
$('#getdata').click(function(){

    $.ajax({
            url: 'getdata.php',
            type:'POST',
            datatype: 'jason',
            success: function(output_string){
                $('#result_table').html(output_string);
            }
    });
});
</script>


</body>
</html>

and the php code

<?php 
$db = mysql_connect("localhost", "root","");
mysql_select_db("spellbook",$db) or die(mysql_error() . ": " . mysql_error() . "<br>");

//Query of database
$book = mysql_query('SELECT id, name FROM spell')
or die(mysql_error());
//Output results
if(!$book)
{
    mysql_close();
    echo json_encode('There was an error running the query: ' . mysql_error());
}
elseif(!mysql_num_rows($book))
{
    mysql_close();
    echo json_encode('No results returned');
}
else
{
    $header = false;
    $output_string = '';
    $output_string .=  '<table border="1">';
    while($row = mysql_fetch_assoc($book))
    {
        if(!$header)
        {
            $output_string .= '<tr>\n';
            foreach($row as $header => $value)
            {
                $output_string .= "<th>{$header}</th>\n";
            }
            $output_string .= '</tr>';
        }
        $output_string .= '<tr>\n';
        foreach($row as $value)
        {
            $output_string .= '<th>{$value}</th>\n';
        }
        $output_string .= '</tr>\n';
    }
    $output_string .= '</table>\n';
}
// This echo for jquery
echo json_encode($output_string);

?>

i have tried the double quotes and still the same thing happens if any can help with the script or know a script that will work better that would be great thanks in advance

[noelthefish]

ok I hope you dont mind but I would split out your Javascript into a separate file.

Therefore I would do it this way.

First off your HTML

<div>
<button type="button" name="getdata" id="getdata">Get Data</button>
</div>
<div id="result_table">
    <table id="spells" border="1">
        <thead>
            <tr>
            <th>ID</th>
            <th>Spells</th>
            </tr>
        </thead>
        <tbody>
        </tbody>
    </table>
</div>

then your PHP

<?php 
$db = mysql_connect("localhost", "root","");
mysql_select_db("spellbook",$db) or die(mysql_error() . ": " . mysql_error() . "<br>");
//Query of database
$book = mysql_query('SELECT id, name FROM spell')
or die(mysql_error());
//Output results
if(!$book)
{
    mysql_close();
    echo json_encode('There was an error running the query: ' . mysql_error());
}
elseif(!mysql_num_rows($book))
{
    mysql_close();
    echo json_encode('No results returned');
}
else
{
    $i=0;
    while($row = mysql_fetch_assoc($book))
    {
        $content = array(
        'spellid'=>(whatever you fancy here)
        'spellname'=>(whatever you fancy here)
        );
        $anarray[$i] = $content;
        $i++;
    }
}
// This echo for jquery
echo json_encode($anarray);
?>

last your jquery

$.getJSON('ajax/getspells.php', function(data)
{   
   $.each(data, function(i,data)
   {
       you can add in table format here just by adding <th> or any tag you want here.
        var elm = '<tr><td>' + data.spellid + '</td><td>' + data.spellname</td></tr>';

    });
    $('#resulttable tbody').append(elm);
});

No need to json encode your html for output.

line 12 datatype = jason.

LOL.

[pravaut]

lmao i must of spent at least 3 hours looking at my script and did not see i put jason that made me feel a stupid and thanks noelthefish i will have to try the script tomorrow @ work atm also in my data base i have about 23 columns that may be need to be display all would the script do the same thing