phpqueries/oldmisc/list-bugzilla-ids.php

<?php
	    $debug = false;
		ini_set("display_errors", "true");
    	error_reporting (E_ALL);
?>
<html>
<head>
<meta
    http-equiv="Content-Type"
    content="text/html; charset=iso-8859-1">
<title>Utility</title>
</head>
<body>
<h1>Utility List of bugzilla IDs</h1>
<table
    align="center"
    cellspacing="2"
    width="60%"
    border="1">
    <tr>
        <th>userid</th>
        <th>login_name</th>
        <th>realname</th>
    </tr>
    <?php

    require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_bugs_ro.class.php";


    # Connect to database
    $sqlquery = "SELECT * FROM profiles
    		WHERE 
    		    login_name='kaloyan.raev@sap.com' OR
    		    login_name='neil.hauge@oracle.com' OR
    		    login_name='deboer@ca.ibm.com' OR
    		    login_name='naci.dai@eteration.com' OR
    		    login_name='raghunathan.srinivasan@oracle.com' OR
    		    login_name='cbridgha@us.ibm.com' OR
                  login_name='david_williams@us.ibm.com' 
    		";

    $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;
    }

    while($myrow = mysql_fetch_assoc($rs))
    {

    	if ($debug) {
    		echo "Debug: myrow: " ; echo print_r($myrow) ; echo  " <br />";
    	}
    	echo "<tr>";
    	echo "<td>" . $myrow['userid'] . "</td>";
    	echo "<td>" . $myrow['login_name'] . "</td>";
    	echo "<td>" . $myrow['realname'] . "</td>";
    	echo "</tr>";
    }

    $dbc->disconnect();
    $rs = null;
    $dbh = null;
    $dbc = null;
    ?>
</table>
</body>
</html>