Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 17th, 2012  |  syntax: None  |  size: 1.04 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. AJAX enabled web form
  2. $.post("GetData.php", function(data) {
  3.         if(data==false)
  4.             var tpl = '<p>no record found<p>'
  5.         else
  6.             var tpl = DrawTableRowsforSection(data);
  7.             $("#result").append($(tpl));
  8. },"json");
  9.  
  10.  
  11. function DrawTableRowsforSection(p)
  12. {
  13.     alert(p.id[0]);
  14.     var o = '<table>';
  15.     for (var i = 0; i < p.length; i++)
  16.         alert(p.id[i]);
  17.         o += '<tr><td>'+p.id[i]+'</td><td>'+p.section_name[i]+'<td></tr>';
  18.  
  19.         o+='</table>'
  20.         return O;
  21. }
  22.        
  23. header('Content-Type: application/json');
  24. mysql_connect('localhost','root','') ;
  25. mysql_select_db('news');
  26. session_start();
  27.  
  28. $query = 'select id,section_name from section';
  29.  
  30. if ($result = mysql_query($query)) {
  31.     if (!mysql_num_rows($result)==null) {
  32.         $myArray = array();
  33.         while ($row = mysql_fetch_assoc($result)) {
  34.             $id =  ToSring($row['id']);
  35.             $myArray[] = $row;
  36.         }
  37.  
  38.         echo json_encode($myArray);
  39.     }
  40. }
  41.        
  42. id            int(11)
  43. section_name  varchar(20)
  44.        
  45. $("#result").append(tpl);