本文整理汇总了PHP中Query::whereLeftJoinImageQuery方法的典型用法代码示例。如果您正苦于以下问题:PHP Query::whereLeftJoinImageQuery方法的具体用法?PHP Query::whereLeftJoinImageQuery怎么用?PHP Query::whereLeftJoinImageQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Query
的用法示例。
在下文中一共展示了Query::whereLeftJoinImageQuery方法的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: listDemos
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ä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>
<?
}
}
示例2: showActual
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
}
}
示例3: Query
<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 />';
示例4: showReview
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
}
}
示例5: isset
$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>
示例6: Query
<h4>object-code (endast för Flashbanners, lägg .swf filerna i mappen media/uploaded_flash) - Klicka på HTML och skriv in koden. (Kommer inte att synas i fä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ä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>
示例7: Query
</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" />--> </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>
示例8: showReview
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ÖRFATTARE ';
echo '</span>';
echo Helper::text($query->getResultRow("writer"));
echo '<br />';
}
if ($query->getResultRow("forlag")) {
echo '<span class="infoTitle">';
echo 'FÖRLAG ';
echo '</span>';
echo Helper::text($query->getResultRow("forlag"));
echo '<br />';
}
echo '<span class="infoTitle">';
echo 'BETYG';
echo '</span>';
echo ' ';
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 ' ';
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>';
}
}
示例9: Query
<?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äst just nu';
echo '</strong>';
echo '</p>';
echo '<ul style="list-style:decimal; margin-left:20px";>';
示例10: Query
<?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änk</h4>
<input name="link" id="link" type="text" onKeyUp="setValue('linkShow',this.value,'link')" value="<?php
echo $banners->getResultRow("link");
?>
"/>
<h4>Öppnas i</h4>
<select name="target">
<option value="_self" <?php
if ($banners->getResultRow("target") == "_self") {
echo "selected";
}
?>
>Samma fönster</option>
<option value="_blank" <?php
if ($banners->getResultRow("target") == "_blank") {
echo "selected";
}
?>
>Nytt fö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");
示例11: Query
<?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>';