Exemplo n.º 1
0
"
        . $query_title;
//        echo $query . '::';
        $resource=mysql_query($query);
        if($resource) {
        	$i=0;
            while($row=mysql_fetch_array($resource)) {
                //fetch owner info
                $owner=$row['ownerId'];
                $query_owner="SELECT * FROM Users WHERE studentId=$owner";
                $resource2=mysql_query($query_owner);
                if($resource2) {
                    $row2=mysql_fetch_array($resource2);
                    $addClass = "";
		            $i++; if ($i%2==0) $addClass = " color2"; //alternate colors in display
		            $newcode = "<div class='item$addClass'>" . generateListing_S($row['ISBN'], mappedTitle($row['ISBN']),
                            $row['price'], $row['post'], $row['descr'],
                            $row2['email'], $row2['studentId'], $row2['firstName'],
                            $row2['lastName']);
		            echo $newcode;
		            ?>
<form action="util/trackBook.php" method="post">
            <input type="hidden" name='list_id' value=<? echo '"' .
            $row['listingId'] . '"' ?> />
            <input type="hidden" name='oper' value='1' />
            <input type="submit" value="Track" class="track"/>
        </form></div> <?
                }
            }
        }
//        $resource=mysql_query($query_title);
Exemplo n.º 2
0
            </table>
        <?php 
require_once "util/listing.php";
$query = "SELECT * FROM Listings WHERE ownerId='{$id}'";
$resource = mysql_query($query);
if (!$resource) {
    echo 'Error: ' . mysql_error();
}
echo '<hr class="title-line"/>';
$i = 0;
// this code is similar to that in browse.php and trackedBooks. One day we should make a function that does it
while ($row = mysql_fetch_array($resource)) {
    $addClass = "";
    $i++;
    if ($i % 2 == 0) {
        $addClass = " color2";
    }
    //alternate colors in display
    $newcode = "<div class='item{$addClass}'>" . generateListing($row['ISBN'], mappedTitle($row['ISBN']), $row['price'], $row['post'], $row['descr']) . "</div>";
    echo $newcode;
}
?>
        <? require("util/footer.php"); ?>
    </body>
</html>

<!--
    Authors: Derek Leung
    Project BellBook - 1.0
    Bellarmine College Preparatory, 2011
-->
Exemplo n.º 3
0
        $i=0;
        while($row=mysql_fetch_array($resource)) {
            $listId=$row['listingId'];
            $tr_query="SELECT * FROM Listings WHERE listingId=$listId";
            $tr_rsrc=mysql_query($tr_query);
            if($tr_rsrc) {
                while($tr_row=mysql_fetch_array($tr_rsrc)) {
                    $owner=$tr_row['ownerId'];
                    $owner_query="SELECT * FROM Users WHERE studentId=$owner";
                    $own_rsrc=mysql_query($owner_query);
                    if($own_rsrc) {
                        $own_row=mysql_fetch_array($own_rsrc);
                        $addClass = "";
			            $i++; if ($i%2==0) $addClass = " color2"; //alternate colors in display
			            $newcode = "<div class='item$addClass'>" . generateListing_S($tr_row['ISBN'], 
			            	mappedTitle($tr_row['ISBN']),
                            $tr_row['price'], $tr_row['post'], $tr_row['descr'],
                            $own_row['email'], $row2['studentId'], $own_row['firstName'],
                            $own_row['lastName']);
			            echo $newcode;
                        ?>
			<form action="util/trackBook.php" method="post">
	            <input type="hidden" name='list_id' value=<? echo '"' .
	            $row['listingId'] . '"' ?> />
	            <input type="hidden" name='oper' value='0' />
	            <input type="submit" value="Remove" class="remove"/>
	        </form>
	        </div> <!-- end item -->
                        <?
                    } //end if
                } //end while