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

basic-php-15-producttest.php / php



  <?php
  //connect to the database - either include a connection variable file or
  //type the following lines:
  connect = mysql_connect("localhost", "bp5am", "bp5ampass") or 
    die ("Hey loser, check your server connection.");
  mysql_select_db("ecommerce");
  query = "SELECT * FROM products";
  results = mysql_query(query)
    or die(mysql_error());
  
  ?>
  <html>
  <head>
  <title>Product List</title>
  </head>
  <body>
  <table>
    <tr>
      <td width="10%">Product Number</td>
      <td width="20%">Name</td>
      <td width="50%">Description</td>
      <td width="10%">Price</td>
      <td width="10%">Date Added</td>
    </tr>
  <?php
  while (row = mysql_fetch_array(results)) {
    extract(row);
    echo "<tr><td width=\"10%\">";
    echo products_prodnum;
    echo "</td><td width=\"20%\">";
    echo products_name;
    echo "</td><td width=\"50%\">";
    echo products_proddesc;
    echo "</td><td width=\"10%\">";
    echo products_price;
    echo "</td><td width=\"10%\">";
    echo products_dateadded;
    echo "</td></tr>";
  }
  ?>
  </table>
  </body>
  </html>
[] 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.