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-cbashop.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>Comic Book Appreciation Site Product List</title>
  </head>
  <body>
  <div align="center">
  Thanks for visiting our site! Please see our list of awesome
  products below, and click on the link for more information:
  <br><br>
  <table width="300">
  <?php
  
  // Show only Name, Price and Image
  while (row = mysql_fetch_array(results)) {
    extract(row);
    echo "<tr><td align=\"center\">";
    echo "<a href=\"getprod.php?prodid=" . products_prodnum . "\">";
    echo "<em>THUMBNAIL<br>IMAGE</em></a></td>";
    echo "<td>";
    echo "<a href=\"getprod.php?prodid=" . products_prodnum . "\">";
    echo products_name;
    echo "</td></a>";
    echo "<td align=\"right\">";
    echo "<a href=\"getprod.php?prodid=" . products_prodnum . "\">";
    echo "" . products_price;
    echo "</a></td></tr>";
  }
  
  ?>
  </table>
  </div>
  </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.