Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. $records = array();
  2.  
  3. if($results = $db->query("SELECT * FROM cust_tbl")) {
  4. if($results->num_rows) {
  5. while($row = $results->fetch_object()) {
  6. $records[] = $row;
  7. }
  8.  
  9. echo json_encode($records);
  10.  
  11. $results->free();
  12. }
  13.  
  14. }
  15.  
  16. function show() {
  17. clear();
  18. $.ajax({
  19. type: "POST",
  20. dataType: "json",
  21. url: "process.php",
  22. data: "action=show",
  23. success: function(data) {
  24. $.each(data, function(index, data) {
  25. $('#tablebody').append('<tr>');
  26. $('#tablebody').append('<td>' + data.JL_JOB_DATE + '</td>');
  27. $('#tablebody').append('<td>' + data.JL_YR + '</td>');
  28. $('#tablebody').append('</tr>');
  29. });
  30. }
  31. });
  32. }
  33.  
  34. $.each(data, function() {
  35. //use data.<column name>
  36. });
  37.  
  38. $.each(data, function() {
  39. $('#tablebody').append( '' +
  40. '<tr>' +
  41. '<td>' + data.<column name> + '</td>' +
  42. '<td>' + data.<column name> + '</td>' +
  43. '</tr>' +
  44. '');
  45. });
  46.  
  47. escape_.escape(string)
  48. Escapes a string for insertion into HTML, replacing &, <, >, ", and ' characters.
  49.  
  50. _.escape('Curly, Larry & Moe');
  51. => "Curly, Larry & Moe"
  52.  
  53. $.each(data, function(index, data) {
  54. $('#tablebody').append('<tr>');
  55. $('#tablebody').append('<td>' + escape(data.JL_JOB_DATE) + '</td>');
  56. $('#tablebody').append('<td>' + escape(data.JL_YR) + '</td>');
  57. $('#tablebody').append('</tr>');
  58. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement