PHP Query::whereLeftJoinImageQuery Examples

Example #1

File: ShowDemos.class.php Project: rocafuerte/opus

	public function listDemos(Paging $paging){
		 while($row = mysql_fetch_assoc($paging->pagingResult)){
		 	if($row['rowid']==$_GET['demo_id']) continue;
			 // Got to make a new query beacuse of error in mysql_fetch_assoc 
			 $query = new Query($this->q->getTable());
			 $query->whereLeftJoinImageQuery("*","image_id",$row['image_id'],"rowid","ASC");
			 $image_id = $query->getResultRow("image_id");
			 $file_name=$query->getResultRow("file");
			 ?>
             
			<table border="0" cellpadding="0" cellspacing="0" class="demoTable">
			  <tr>
              <?php
				if(Helper::hasValue($image_id)){	
					?>
					<td width="80" class="noPadding" rowspan="2"><img src="image_crop.php?source=<?php echo Settings::getUploadedImages().'/'.$file_name ?>&dest=&thumb_size=80" class="flowPic" /></td>
					<?php
                }	
				?>	
				<td width="270" class="tdPadding" colspan="2"><span class="boldGrey"><?php echo $row['name']; ?></span></td>
			  </tr>
			  <tr>
				<td class="tdVertBottom"><span class="smallPink"><a href="?demo_id=<?php echo $row['rowid']; ?>">L&auml;s mer</a></span></td>
				<td align="right" class="tdVertBottom"><span class="smallGrey"><?php echo date("Y-m-d",strtotime($row['date'])); ?></span></td>
			  </tr>
			</table>
			<?		 
		 }
	}

Example #2

File: Archive.class.php Project: rocafuerte/opus_static

    public function showActual()
    {
        $id = (int) $_GET['id'];
        if (Helper::givesResult($this->table, "rowid", $id)) {
            $q = new Query($this->table);
            $q->whereLeftJoinImageQuery("*", "rowid", $id, "rowid", "DESC");
            $personal = new Query("personal");
            $personal->whereQuery("*", "username", $q->getResultRow("published_by"), "rowid", "ASC", "1");
            ?>
			 
				  <div class="newsHeader"><span class="dateAuthor">
					<?php 
            echo date("Y-m-d", strtotime($q->getResultRow("date"))) . ' ' . $personal->getResultRow("first_name") . ' ' . $personal->getResultRow("last_name");
            ?>
					</span><br /><br />
					<span class="newsHeaderFont"><?php 
            echo $q->getResultRow("title");
            ?>
</span>
				  </div>
				  <div class="newsDescActual"><span class="boldGrey"><?php 
            echo nl2br(strip_tags($q->getResultRow("description"), '<a><b><br><strong>'));
            ?>
</span></div>
				 <div class="newsPicActual">
				 <?php 
            if ($q->getResultRow("image_id") > 0) {
                ?>
						<table><tr><td>
						<?php 
                echo '<img src="image_thumb.php?source=' . Settings::getUploadedImages() . '/' . $q->getResultRow("file") . '&width=340" alt="' . $q->getResultRow("name") . '" />';
                ?>
						</td>
						</tr>
						<tr>
						<td align="right" class="smallGrey2">
						<?php 
                if ($q->getResultRow("photo") != "") {
                    echo '<span class="smallGrey">Foto: ' . $q->getResultRow("photo") . '</span>';
                }
                ?>
						</td>
						</tr>
						</table>
						<?php 
            }
            ?>
				
				 </div>
				  <?php 
            echo nl2br(strip_tags($q->getResultRow("text"), '<a><b><br><strong>'));
            ?>
					<br /><br />
			
			 <?php 
        }
    }

Example #3

File: vimmel.php Project: rocafuerte/opus_static

		<div class="thumbnailDesc"><span class="smallWhite"><?php 
        echo Helper::text($query->getResultRow("description"));
        ?>
</span><br /><br />
		</div>
	  </div>
	  <?php 
    }
    ?>
	  <br />
	  <br />  
		  <div class="thumbnailContainer">
			<?php 
    if (Helper::isInt($_GET['category'])) {
        $query = new Query("vimmel_images");
        $query->whereLeftJoinImageQuery("*", "category", $_GET['category'], "date", "DESC");
        // Dont forget the Javascript (effect.js)!!!
        $images = new ShowImages($query);
        $images->closeupVimmelThumbs($query, 50);
    }
    ?>
		  </div>
		  
	  <?php 
}
// if(isset($_GET['category']) end
$categories = new Query("vimmel_categories");
$categories->makeQuery("*", "date", "DESC", 10000);
echo '<span class="boldPink">Bildgalleri</span><span class="smallWhite"></span><br /><br />';
while ($row = mysql_fetch_object($categories->getResult())) {
    echo '<span class="boldWhite"><a href="?category=' . $row->rowid . '">' . $row->title . '</a></span><br /><br />';

Example #4

File: Review.class.php Project: rocafuerte/opus_static

    public function showReview()
    {
        if (Helper::hasValue($_GET['id'])) {
            $query = new Query($this->q->getTable());
            $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "date", "ASC");
            ?>
			<div class="newsHeader"><span class="dateAuthor"><?php 
            echo date("y-m-d", strtotime($query->getResultRow("date")));
            ?>
</span> <br />
			
			<span class="newsHeaderSmaller"><?php 
            echo $query->getResultRow("title");
            ?>
</span></div>
			  
			<div class="showImg">
			<?php 
            if (Helper::hasValue($query->getResultRow("image_id"))) {
                ?>
                 <table><tr><td>
                 <?php 
                echo Image::displayImage($query->getResultRow("file"), 340, "", $query->getResultRow("name"));
                ?>
                </td>
                </tr>
                <tr>
                <td align="right" class="smallGrey2">
				<?php 
                if ($query->getResultRow("photo") != "") {
                    echo '<span class="smallGrey">Foto: ' . $query->getResultRow("photo") . '</span>';
                }
                ?>
                </td>
                </tr>
                </table>
                <?php 
            }
            ?>
            
            
            
            
			</div>
            
			<div class="textContainer"><?php 
            echo nl2br($query->getResultRow("text"));
            ?>
			<br /><br />
		<!--	<a href="<?php 
            echo $query->getResultRow("link_url");
            ?>
"><?php 
            echo $query->getResultRow("link_url");
            ?>
</a>
			<br /><br />-->
			 
			<span class="smallGrey">
			<?php 
            $personalInfo = new Query("personal");
            $personalInfo->whereQuery("*", "username", $query->getResultRow("published_by"), "username", "ASC", 1);
            echo "Av: " . $personalInfo->getResultRow("first_name") . " " . $personalInfo->getResultRow("last_name");
            ?>
			</span> 
			</div>

<?php 
        }
    }

Example #5

File: events.php Project: rocafuerte/opus_static

$place = isset($_GET['place']) && $_GET['place'] != "" && Helper::isText($_GET['place']) ? $_GET['place'] : "%";
$artist = isset($_GET['artist']) && $_GET['artist'] != "" && Helper::isText($_GET['artist']) ? $_GET['artist'] : "%";
$pagesize = 80;
$recordstart = (int) $_GET['recordstart'];
$recordstart = isset($_GET['recordstart']) ? $_GET['recordstart'] : 0;
$query = "select * from spelningar WHERE stad LiKE '" . $city . "' AND artist LIKE '" . $artist . "' AND lokal LIKE '" . $place . "' AND datum LIKE '" . $date . "' AND datum >= NOW() ORDER BY `datum`  ";
//ASC LIMIT ".$recordstart." , ".$pagesize."
$result = mysql_query($query);
?>

<div id="centerDivBig">

<?php 
if (isset($_GET['id']) && Helper::IsInt($_GET['id'])) {
    $query = new Query("spelningar");
    $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "rowid", "ASC", 1);
    $day = Helper::sweDay(date("w", strtotime($query->getResultRow("datum"))));
    $day_no = date("j", strtotime($query->getResultRow("datum")));
    $month = Helper::sweMonth(date("n", strtotime($query->getResultRow("datum"))));
    $year = date("Y", strtotime($query->getResultRow("datum")));
    //Helper::sweDay($day).' '.date("d").' '.Helper::sweMonth(date("n")).' '.date("Y")
    echo '<span class="boldGrey">' . $query->getResultRow("artist") . '</span><br /><br />';
    if ($query->getResultRow("image_id") > 0) {
        ?>
		<table><tr><td>
		<?php 
        echo Image::displayImage($query->getResultRow("file"), 542, "", $query->getResultRow("name"));
        ?>
		</td>
		</tr>
		<tr>

Example #6

File: admin_banners_right.php Project: rocafuerte/opus

  <h4>object-code (endast f&ouml;r Flashbanners, l&auml;gg .swf filerna i mappen media/uploaded_flash)  -  Klicka på HTML och skriv in koden. (Kommer inte att synas i f&auml;ltet nedan)</h4>
  <textarea name="bannersCode" cols="50" rows="25" onKeyUp="setValue('flashShow',this.value,'text')"></textarea><br /><br />
  <input name="action" type="submit" value="Skapa"/>
  

<div id="bannersRightShow"> 
    L&auml;nkar till: <span id="linkShow" ></span> <br/>
    Ordningnummer: <span id="orderShow" ></span> <br/>
    Flashbanner: <span id="flashShow" ></span> <br/>
    <span id="imageShow" limit="1" maxWidth="250"></span> <br/>
</div>

<h2>Befintliga banners</h2>
<?php 
$rightBannerQ = new Query("banners");
$rightBannerQ->whereLeftJoinImageQuery("*", "category", "right", "order_no", "ASC", 1);
while ($row = mysql_fetch_assoc($rightBannerQ->getResult())) {
    echo "Ordningsnummer: " . $row['order_no'] . "<br />";
    if (trim($row['bannersCode']) == "") {
        ?>
    		<a href="admin_banners_edit.php?category=right&id=<?php 
        echo $row['rowid'];
        ?>
"><img src="<?php 
        echo "../" . Settings::getUploadedImages() . '/' . $row['file'];
        ?>
" width="250" /></a>
		<a href="admin_banners_action.php?category=right&action=remove&id=<?php 
        echo $row['rowid'];
        ?>
"><img src="graphics/remove.jpg" alt="Ta bort" width="10" border="0"/></a>

Example #7

File: header_inc2.php Project: rocafuerte/opus_static

</head>
<body onload="div.init()">
<div id="pageCell">
<div id="topDiv">
<iframe src="bg_sound.php" style="width:1px; height:0px; border: 0px" scrolling="no">

</iframe>

  <a href="/" target="_self"><img src="graphics/CU-logo-black-background.gif" border="0"  align="left" /></a>
  <table border="0" cellpadding="0" cellspacing="0" align="right" width="100">
<tr>
<td class="tdVertTop"><!--<img src="graphics/annonspilVertical.gif" />-->&nbsp;</td>
<td class="tdVertTop">
  <?php 
$topBannerQ = new Query("banners");
$topBannerQ->whereLeftJoinImageQuery("*", "category", "top", "date", "ASC", 1);
while ($row = mysql_fetch_assoc($topBannerQ->getResult())) {
    if (trim($row['bannersCode']) == "") {
        ?>
   	<a href="<?php 
        echo $row['link'];
        ?>
" target="<?php 
        echo $row['target'];
        ?>
">
	<img src="<?php 
        echo Settings::getUploadedImages() . '/' . $row['file'];
        ?>
" width="760" class="topBanners"/>
	</a>   

Example #8

File: Review.class.php Project: rocafuerte/opus

 public function showReview()
 {
     if (Helper::hasValue($_GET['id'])) {
         $query = new Query($this->q->getTable());
         $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "date", "ASC");
         echo '<div class="reviewActual">';
         echo '<div class="title">';
         echo Helper::text($query->getResultRow("title"));
         echo '</div>';
         echo '<div class="title2">';
         echo Helper::text($query->getResultRow("title2"));
         echo '</div>';
         if (Helper::hasValue($query->getResultRow("image_id"))) {
             echo Image::displayImage($query->getResultRow("file"), 311, "", $query->getResultRow("name"));
         }
         echo '<div class="description">';
         echo '<br/>';
         echo Helper::text($query->getResultRow("text"));
         echo '</div>';
         echo '<div class="info">';
         echo '<span class="custom">';
         echo '<span class="infoTitle">';
         echo '</span>';
         echo Helper::text($query->getResultRow("info"));
         echo '<br />';
         if ($query->getResultRow("solist")) {
             echo '<span class="infoTitle">';
             echo 'SOLIST ';
             echo '</span>';
             echo Helper::text($query->getResultRow("solist"));
             echo '<br />';
         }
         if ($query->getResultRow("dirigent")) {
             echo '<span class="infoTitle">';
             echo 'DIRIGENT ';
             echo '</span>';
             echo Helper::text($query->getResultRow("dirigent"));
             echo '<br />';
         }
         if ($query->getResultRow("sacd")) {
             echo '<span class="infoTitle">';
             echo 'SACD ';
             echo '</span>';
             echo Helper::text($query->getResultRow("sacd"));
             echo '<br />';
         }
         if ($query->getResultRow("cd")) {
             echo '<span class="infoTitle">';
             echo 'CD ';
             echo '</span>';
             echo Helper::text($query->getResultRow("cd"));
             echo '<br />';
         }
         if ($query->getResultRow("writer")) {
             echo '<span class="infoTitle">';
             echo 'F&Ouml;RFATTARE ';
             echo '</span>';
             echo Helper::text($query->getResultRow("writer"));
             echo '<br />';
         }
         if ($query->getResultRow("forlag")) {
             echo '<span class="infoTitle">';
             echo 'F&Ouml;RLAG ';
             echo '</span>';
             echo Helper::text($query->getResultRow("forlag"));
             echo '<br />';
         }
         echo '<span class="infoTitle">';
         echo 'BETYG';
         echo '</span>';
         echo '&nbsp;';
         if ($query->getResultRow("betyg") == 6) {
             for ($i = 0; $i < $query->getResultRow("betyg"); $i++) {
                 echo '<img src="graphics/filled_star_lila.gif" width="10" height="10" />';
             }
         } else {
             for ($i = 0; $i < $query->getResultRow("betyg"); $i++) {
                 echo '<img src="graphics/filled_star.gif" width="10" height="10" />';
             }
         }
         echo '<br />';
         if ($query->getResultRow("ljud")) {
             echo '<span class="infoTitle">';
             echo 'LJUDKVALITET';
             echo '</span>';
             echo '&nbsp;';
             for ($i = 0; $i < $query->getResultRow("ljud"); $i++) {
                 echo '<img src="graphics/filled_star.gif" width="10" height="10" />';
             }
             echo '</span>';
         }
         echo '<div class="author">';
         echo $query->getResultRow("published_by");
         echo '</div>';
         echo '</div>';
         echo '</div>';
     }
 }

Example #9

File: skribenter.php Project: rocafuerte/opus

<?php

include "header_inc.php";
echo '<div id="centerDiv">';
echo '<div class="newsBg">';
echo '<div class="newsHeaderActual">';
echo '<span class="newsHeaderFont">';
echo 'Skribenterna på OPUS';
echo '</span>';
echo '</div>';
echo '<br />';
if (Helper::isInt($_GET['id']) && Helper::hasValue($_GET['id']) && Helper::givesResult("personal", "rowid", $_GET['id'])) {
    $query = new Query("personal");
    $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "last_name", "DESC");
    if (Helper::hasValue($query->getResultRow("image_id"))) {
        echo '<img src="image_thumb.php?source=' . Settings::getUploadedImages() . '/' . $query->getResultRow("file") . '&width=200" />';
    }
    echo '<br />';
    echo '<br />';
    echo '<p>';
    echo '<strong>';
    echo $query->getResultRow("first_name") . " " . $query->getResultRow("last_name");
    echo '</strong>';
    echo '</p>';
    echo '<br />';
    echo '<p>';
    echo '<strong>';
    echo 'B&auml;st just nu';
    echo '</strong>';
    echo '</p>';
    echo '<ul style="list-style:decimal; margin-left:20px";>';

Example #10

File: admin_banners_edit.php Project: rocafuerte/opus

<?php

include "admin_header.php";
$banners = new Query("banners");
$banners->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "order_no", "ASC", 1);
?>

<form action="admin_banners_action.php" method="POST" name="banners" >
  <h4>L&auml;nk</h4>
  <input name="link" id="link" type="text" onKeyUp="setValue('linkShow',this.value,'link')" value="<?php 
echo $banners->getResultRow("link");
?>
"/>
  <h4>&Ouml;ppnas i</h4>
  <select name="target">
  <option value="_self" <?php 
if ($banners->getResultRow("target") == "_self") {
    echo "selected";
}
?>
>Samma f&ouml;nster</option> 
  <option value="_blank" <?php 
if ($banners->getResultRow("target") == "_blank") {
    echo "selected";
}
?>
>Nytt f&ouml;nster</option> 
  </select>
  <h4>Ordningsnummer</h4>
  <input name="order" id="order" type="text" maxlength="2" onKeyUp="setValue('orderShow',this.value,'text')" value="<?php 
echo $banners->getResultRow("order_no");

Example #11

File: tavlingar.php Project: rocafuerte/opus

<?php

include "header_inc.php";
echo '<div id="centerDiv">';
echo '<div class="newsBg">';
$id = (int) $_GET['id'];
if (Helper::givesResult("competitions", "rowid", $id)) {
    $query = new Query('competitions');
    $query->whereLeftJoinImageQuery("*", "rowid", $id, "rowid", "DESC");
    echo '<div class="newsHeader">';
    echo '<span class="newsHeaderFont">';
    echo $query->getResultRow("title");
    echo '</span>';
    echo '</div>';
    echo '<div class="newsDescActual">';
    echo '<span class="boldGrey">';
    echo Helper::text($query->getResultRow("description"));
    echo '</span>';
    echo '</div>';
    echo '<div class="newsPicActual">';
    if ($query->getResultRow("image_id") > 0) {
        echo '<table>';
        echo '<tr>';
        echo '<td>';
        echo Image::displayImage($query->getResultRow("file"), 315, "", $query->getResultRow("name"));
        echo '</td>';
        echo '</tr>';
        echo '<tr>';
        echo '<td align="right" class="smallGrey2">';
        if ($query->getResultRow("photo") != "") {
            echo '<span class="smallGrey">Foto: ' . $query->getResultRow("photo") . '</span>';