fetch_db.php

   1 <?php
   2 // Make a MySQL Connection
   3 mysql_connect("localhost", "root", "baxter") or die(mysql_error());
   4 mysql_select_db("moodle") or die(mysql_error());
   5
   6 // Retrieve data from the lesson "answers" table
   7 $result = mysql_query("SELECT id, lessonid, pageid, jumpto, answer, response FROM mdl_lesson_answers")
   8 or die(mysql_error());
   9
  10 $fields_num = mysql_num_fields($result);
  11
  12 //echo "<div id='dbresult' style='display:none'>";
  13 echo "<h1>Table: {$table}</h1>";
  14 echo "<table id = 'mdl_lesson_answers' border='1'><tr>";
  15 // printing table headers
  16 for($i=0; $i<$fields_num; $i++)
  17 {
  18     $field = mysql_fetch_field($result);
  19     echo "<td>{$field->name}</td>";
  20 }
  21 echo "</tr>\n";
  22 // printing table rows
  23 while($row = mysql_fetch_row($result))
  24 {
  25     echo "<tr>";
  26
  27     // $row is array... foreach( .. ) puts every element
  28     // of $row to $cell variable
  29     foreach($row as $cell)
  30         echo "<td>$cell</td>";
  31
  32     echo "</tr>\n";
  33 }
  34 //echo "</div>";
  35 mysql_free_result($result);
  36
  37 // Retrieve data from the lesson "pages" table
  38 $result = mysql_query("SELECT id, nextpageid FROM mdl_lesson_pages")
  39 or die(mysql_error());
  40
  41 $fields_num = mysql_num_fields($result);
  42
  43 //echo "<div id='dbresult1' style='display:none'>";
  44 echo "<h1>Table: {$table}</h1>";
  45 echo "<table id = 'mdl_lesson_pages' border='1'><tr>";
  46 // printing table headers
  47 for($i=0; $i<$fields_num; $i++)
  48 {
  49     $field = mysql_fetch_field($result);
  50     echo "<td>{$field->name}</td>";
  51 }
  52 echo "</tr>\n";
  53 // printing table rows
  54 while($row = mysql_fetch_row($result))
  55 {
  56     echo "<tr>";
  57
  58     // $row is array... foreach( .. ) puts every element
  59     // of $row to $cell variable
  60     foreach($row as $cell)
  61         echo "<td>$cell</td>";
  62
  63     echo "</tr>\n";
  64 }
  65 //echo "</div>";
  66 mysql_free_result($result);
  67 ?>