topical media & game development

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) _

basic-php-07-gallery.php / php


  <?php
  
  //connect to the database
   $link = mysql_connect("localhost", "bp5am", "bp5ampass")
    or die("Could not connect: " . msql_error());
  mysql_select_db("moviesite",$ link) 
    or die (mysql_error());
  
   $ImageDir = "images";$ ImageThumb =  $ImageDir . "/thumbs/";
  ?>$ <html>
  <head>
  <title>Welcome to our Photo Gallery</title>
  </head>
  <body>
  <p align="center">Click on any image to see it full sized.</p>
  <table align="center">
    <tr>
      <td align="center">Image</td>
      <td align="center">Caption</td>
      <td align="center">Uploaded By</td>
      <td align="center">Date Uploaded</td>
    </tr>
  
  <?php
  //get the thumbs
  getpic = mysql_query("SELECT * FROM images")
    or die(mysql_error());
  while ( $rows = mysql_fetch_array($ getpic)) {
    extract( $rows);
    echo "$ <tr>\n";
    echo "<td><a href=\"".ImageDir .  $image_id . ".jpg\">";
    echo "$ <img src=\"" . ImageThumb .  $image_id . ".jpg\" border=\"0\">";
    echo "$ </a></td>\n";
    echo "<td>" . image_caption . "</td>\n";
    echo "<td>" .  $image_username . "$ </td>\n";
    echo "<td>" . image_date . "</td>\n";
    echo "</tr>\n";
  }
  
  ?>
  
  </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) _

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.