Member Avatar for 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

431832741e23dc48f183316772bc6daf

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

  • 4 Contributors
  • 4 Replies
  • 608 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by pravaut
Member Avatar for 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); });
Member Avatar for diafol

No need to json encode your html for output.

Member Avatar for iamthwee

line 12 datatype = jason.

LOL.

Member Avatar for 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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.