git.oblomov.eu Git - ohcount/blob - test/src_dir/php1.php

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN"
   2                       "http://www.w3.org/TR/html4/strict.dtd">
   3 <html>
   4         <head>
   5                 <script type="text/javascript">
   6                 // javascript comment
   7                 document.write("Hello World!")
   8                 </script>
   9                 <style type="text/css">
  10                 /* css comment */
  11                 h1 {
  12                         color: black;
  13                 }
  14                 </style>
  15         </head>
  16         <body>
  17         <table cellSpacing=1 cellPadding=2 bgColor=black border=0>
  18         <tr bgColor=white>
  19         <td>First</td>
  20         <td>Last</td>
  21         <td>Email<td>
  22         </tr>
  23         </table>
  24
  25 <?
  26         mysql_connect("localhost", "db user", "db pass")
  27         or die("DB CONNECT ERROR: " . mysql_error());
  28
  29         mysql_select_db("db name")
  30         or die("DB SELECT ERROR: " . mysql_error());
  31
  32         $query = "SELECT fname, lname, email FROM table ORDER BY lname";
  33
  34         $result = mysql_query($query)
  35         or die("DB SELECT ERROR: " . mysql_error());
  36
  37         while($row = mysql_fetch_array($result))
  38         {
  39                 $lname = $row['lname'];
  40                 $fname = $row['fname'];
  41                 $email = $row['email'];
  42
  43                 // Spaghetti code starts....(slopping html code in)
  44 ?>
  45
  46         <tr bgColor=white>
  47         <td><?=$fname?></td>
  48         <td><?=$lname?></td>
  49         <td><?=$email?><td>
  50         </tr>
  51         </table>
  52
  53 <?
  54         } // end while
  55         // Spaghetti code is both a source of praise and complaints
  56 ?>
  57
  58 </body>