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-web-php-PHP-Example04.php / php


  <?php
  
  // Document header (doctype -> body tag)
  function docheader() {
  
  // If content header has not been sent,
  //   send it
  if (!headers_sent()) {
    header('Content-type: text/html');
  }
  
  print <<<HTML
  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1.dtd">
  <html>
  <head>
    <title>MySQL Query Result</title>
  </head>
  <body>
  
  HTML;
  
  } // End docheader()
  
  // Connect the DB with the given creds
  function connectDB( $server,$ user, $password,$ dbname) {
  
     $link = mysql_connect($ server,  $user,$ password)
      or die("Could not connect to server!");
    mysql_select_db( $dbname)
      or die("Could not select database!");
  
    return$ link;
  
  }  // End connectDB()
  
  // Do the query, return the result
  function doquery( $link,$ query) {
  
     $result = mysql_query($ query, $link)
      or die("Could not perform query!")
  
    return$ result;
  
  } // End doquery()
  
  // Output the results of the query in a table
  function dotable( $result) {
  
  print <<<HTML$ <table border="1" cellpadding="5">
  <tr>
  
  HTML;
  
    line = mysql_fetch_array( $result, MYSQL_ASSOC);$ headers = array_keys( $line);
  
    for ($ i=0;  $i <= count($ headers) - 1;  $i++) {
      print "$ <th>".headers[ $i]."$ </th>\n";
    }
  
    print "</tr>\n";
  
    mysql_data_seek(result,0);
    while ( $line = mysql_fetch_array($ result, MYSQL_ASSOC)) {
      print "<tr>\n";
      foreach ( $line as$ key =>  $value) {
        print "$ <td>".value."</td>\n";
      }
      print "</tr>\n";
    }
  
    print "</table>\n";
  
  } // End dotable()
  
  // Document footer (close tags and end document)
  function docfooter() {
  
  print <<<HTML
  </body>
  </html>
  
  HTML;
  
  } // End docfooter()
  
  // Main function
  function main() {
  
    // Connect the DB
     $link = connectDB("localhost","webuser","password99","mysqlsamp");$ // Set up and perform query
  query = <<<HTML
  SELECT computers.comp_id as computer_id,
         mice.mouse_model as mouse_model,
         computers.comp_location as location
    FROM computers, mice
    WHERE mice.mouse_type = "USB"
    AND computers.comp_location like "A%"
    AND mice.mouse_comp = computers.comp_id
  
  HTML;
  
     $result = doquery($ link, $query);$ // Do document header
    docheader();
  
    // Do results in table
    dotable(result);
  
    // Do document footer
    docfooter();
  
  }  // End main()
  
  // Kick it all off
  main();
  
  ?>

[] 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.