topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

mashup-flickr-complete-gallery-14-1.php / php



  <?php
  
  connection = mysql_connect('localhost', 'root', 'YOUR-PASSWORD-HERE');
  
  if (!connection)
  {
    die ("Cannot connect to database server");
  }
  
  ret = mysql_select_db("mashups", connection);
  
  if (!ret)
  {
    die ("Cannot access database");
  }
  
  sql = "SELECT * FROM fruit ORDER BY description ASC";
  
  res = mysql_query(sql, connection) or die("Invalid query: " . sql);
  
  ?>
  
  <table border="1">
    <tr>
      <th>Stock Code</th>
      <th>Description</th>
      <th>Price</th>
    </tr>
  
  <?php
  
  while(row = mysql_fetch_assoc(res))
  {
    print "  <tr>\n";
    print "    <td>" . row['stock_code'] . "</td>";
    print "    <td>" . row['description'] . "</td>";
    print "    <td>" . row['price'] . "</td>";
    print "  </tr>\n";
  }
  ?>
  
  </table>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.