| <?php |
| $debug = true; |
| // for reference |
| // See https://dev.eclipse.org/committers/committertools/dbo_bugs_schema.php |
| // and https://dev.eclipse.org/committers/committertools/dbo_index.php |
| |
| if ($debug) |
| { |
| ini_set("display_errors", "true"); |
| error_reporting (E_ALL); |
| } |
| |
| require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_bugs_ro.class.php"; |
| |
| ?> |
| <html> |
| <head> |
| <meta |
| http-equiv="Content-Type" |
| content="text/html; charset=iso-8859-1"> |
| <link |
| rel="stylesheet" |
| href="../../../default_style.css" |
| type="text/css"> |
| <link |
| rel="stylesheet" |
| href="../../wtp.css" |
| type="text/css"> |
| <title>List of components</title> |
| </head> |
| <body> |
| <table |
| width="100%" |
| cellspacing="5" |
| cellpadding="2" |
| border="0"> |
| <tr> |
| <td |
| width="60%" |
| align="left"><font class="indextop">List of components</font> <br> |
| <font class="indexsub">List of components</font></td> |
| <td width="40%"><img |
| width="207" |
| hspace="50" |
| height="129" |
| align="middle" |
| src="../../images/wtplogosmall.jpg"></td> |
| </tr> |
| </table> |
| <table |
| width="100%" |
| cellspacing="5" |
| cellpadding="2" |
| border="0"> |
| <tr> |
| <td |
| valign="top" |
| bgcolor="#0080c0" |
| align="left" |
| colspan="2"><b> <font |
| face="Arial,Helvetica" |
| color="#ffffff">List of components</font></b></td> |
| </tr> |
| </table> |
| <table |
| align="center" |
| cellpadding="4" |
| width="80%" |
| border="1"> |
| <tr> |
| <th>Count</th> |
| <th>Component Name</th> |
| </tr> |
| <?php |
| |
| |
| # Connect to database |
| $sqlquery = "SELECT |
| components.name |
| FROM |
| components |
| INNER JOIN products |
| ON components.product_id = products.id |
| WHERE |
| products.name like '%Web Tools%' |
| ORDER BY |
| components.name"; |
| |
| $dbc = new DBConnectionBugs(); |
| $dbh = $dbc->connect(); |
| $rs = mysql_query($sqlquery, $dbh); |
| |
| if(mysql_errno($dbh) > 0) { |
| echo "There was an error processing this request <br />". |
| $dbc->disconnect(); |
| exit; |
| } |
| $rowcount = 0; |
| while($myrow = mysql_fetch_assoc($rs)) |
| { |
| $rowcount++; |
| if ($debug) { |
| echo "Debug: myrow: " ; |
| echo print_r($myrow) ; |
| echo " <br />"; |
| } |
| echo "<tr>"; |
| echo "<td align='right'>".$rowcount."</td>"; |
| |
| echo "<td align='right'>".$myrow['name']."</td>"; |
| echo "</tr>"; |
| } |
| ?> |
| </table> |
| </body> |
| </html> |