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-06-index.php / php


  <?php
     $link = mysql_connect("localhost", "bp5am", "bp5ampass") 
      or die("Could not connect: " . mysql_error()); 
    mysql_select_db('moviesite',$ link) 
      or die(mysql_error()); 
  ?>
  <html>
  <head>
  <title>Movie database</title>
  <style type="text/css">
  TD{color:#353535;font-family:verdana}
  TH{color:#FFFFFF;font-family:verdana;background-color:#336699}
  </style>
  </head>
  <body>
  <table border="0" width="600" cellspacing="1" cellpadding="3" 
         bgcolor="#353535" align="center">
    <tr>
      <td bgcolor="#FFFFFF" colspan="2" align="center">
        Movies <a href="movie.php?action=add&id=">[ADD]</a> 
      </td>
    </tr>
  <?php
     $moviesql = "SELECT * FROM movie";$ result = mysql_query( $moviesql) 
      or die("Invalid query: " . mysql_error()); 
    while ($ row = mysql_fetch_array( $result)) {
  ?>$ <tr>
      <td bgcolor="#FFFFFF" width="50%">
        <?php echo row['movie_name']; ?>
      </td>
      <td bgcolor="#FFFFFF" width="50%" align="right">
        <a href="movie.php?action=edit&id=<?php 
          echo  $row['movie_id']; ?>">[EDIT]$ </a> 
        <a href="delete.php?type=movie&id=<?php 
          echo row['movie_id']?>">[DELETE]</a>
      </td>
    </tr>
  <?php
    }
  ?>
    <tr>
      <td bgcolor="#FFFFFF" colspan="2" align="center">
        People <a href="people.php?action=add&id=">[ADD]</a> 
      </td>
    </tr>
  <?php
     $moviesql = "SELECT * FROM people";$ result = mysql_query( $moviesql) 
      or die("Invalid query: " . mysql_error()); 
    while ($ row = mysql_fetch_array( $result)) {
  ?>$ <tr>
      <td bgcolor="#FFFFFF" width="50%">
        <?php echo row['people_fullname']; ?>
      </td>
      <td bgcolor="#FFFFFF" width="50%" align="right">
        <a href="people.php?action=edit&id=<?php 
          echo  $row['people_id']; ?>">[EDIT]$ </a> 
        <a href="delete.php?type=people&id=<?php 
          echo row['people_id']; ?>">[DELETE]</a>
      </td>
    </tr>
  <?php
    }
  ?>
  </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.