PHP Query::makeQuery方法代码示例

    public function listEntryPlaces($class)
    {
        $entryPlaces = new Query("entryPlaces");
        $entryPlaces->makeQuery("*", "pubDate", "DESC", 0);
        echo '<table class="' . $class . '">';
        echo '<th align="left">Titel</th><th align="left">Beskrivning</th>
				<th align="left">Uppdaterad senast</th><th align="left">&Auml;ndra</th><th align="left">Ta bort</th>';
        while ($row = mysql_fetch_object($entryPlaces->getResult())) {
            echo '<tr>
			<td>' . strip_tags($row->title) . '</td>
			<td>' . strip_tags($row->description) . '</td>				
			<td>' . $row->updateDate . '</td>
			<td><a href="?action=edit&entryPlaceTitle=' . $row->title . '">&Auml;ndra</a></td>
			<td><a href="?action=delete&entryPlaceTitle=' . $row->title . '">Ta bort</a></td>
			</tr>';
        }
        echo '</table>';
    }

	  <?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 />';
}
?>
  </div>
  </div>
<?php 
include "footer.php";

</a></span></p>
	</div>
    <br />
	<hr />
	<br />
	<br />
	<?php 
}
$paging;
$query = new Query("advertisement");
if (isset($_GET['category'])) {
    $query->whereQuery("*", "category", $_GET['category'], "date", "DESC", 1000);
    $paging = new Paging($query, 20);
    $paging->where("*", "category", $_GET['category'], "date", "DESC");
} else {
    $query->makeQuery("*", "date", "DESC", 100);
    $paging = new Paging($query, 20);
    $paging->makePagingQuery();
}
while ($row = mysql_fetch_assoc($paging->getResult())) {
    $getCategory = new Query("advertisement_categories");
    $getCategory->whereQuery("*", "rowid", $row['category'], "rowid", "ASC", 1000);
    ?>
	
	<table border="0" cellpadding="0" cellspacing="0" class="demoTable">
	  <tr>
	
		<td class="tdPadding" colspan="2"><span class="boldGreyLighter"><?php 
    echo $row['title'];
    ?>
</span><span class="smallGrey"> - 

<?php

include "header_inc.php";
?>
<div id="centerDiv">
<form action="subscription_action.php" method="POST">
<?php 
$pren = new Query("monthly_magazine");
$pren->makeQuery("number", "number", "DESC", 1);
$PrenFromNumber = $pren->getResultRow("number") + 1;
if ($_GET['type'] == 0) {
    ?>
	<span class="boldGrey">Betala via inbetalningskort</span>
	<br/><br />
	P&aring; grund av &auml;ndrade rutiner skickas nytt nummer av tidningen fr&aring;n tryckeriet i samband med utgivning. Best&auml;ller du prenumeration efter det att vi skickat adressetiketterna till tryckeriet - vilket &auml;r cirka tio dar innan tidningen utkommer - startar din prenumeration med N&Auml;STKOMMANDE nummer.Vi har allt&aring; INGA exemplar av nya nummer p&aring; redaktionen. Aktuellt nummer finns naturligtvis till salu i tidningshandeln. <br />
	<br />
	G&aring; in p&aring; <span class="smallPink"><a href="http://www.interpress.se">http://www.interpress.se</a></span>, v&auml;lj tidskrifter och sen titels&ouml;kning f&ouml;r att se efter var du kan k&ouml;pa Close-Up i din hemstad.
	 <br/><br/>
	 <span class="boldGrey">Fyll i nedanst&aring;ende formul&auml;r och klicka p&aring; "Prenumerera".</span>
	<br /><br />
	 
	 <?php 
    $form = new Form();
    echo "<strong>Namn</strong><br />" . $form->textField("name", $_GET['name'], "field") . "<br /><br />";
    echo "<strong>Personnummer</strong><br />" . $form->textField("personal_number", $_GET['personal_number'], "field") . "<br /><br />";
    echo "<strong>E-post</strong><br />" . $form->textField("email", $_GET['email'], "field") . "<br /><br />";
    echo "<strong>Adress</strong><br />" . $form->textField("adress", $_GET['adress'], "field") . "<br /><br />";
    echo "<strong>C/o</strong><br />" . $form->textField("co", $_GET['co'], "field") . "<br /><br />";
    echo "<strong>Ort</strong><br />" . $form->textField("city", $_GET['city'], "field") . "<br /><br />";
    echo "<strong>Postnummer</strong><br />" . $form->textField("zip", $_GET['zip'], "field") . "<br /><br />";
    echo '<input type="hidden" value="0" name="PrenFromNumber"/>';

<?php

include "admin_header.php";
?>
<h2>K&ouml;p och s&auml;lj</h2>
<?php 
$query = new Query("advertisement");
$query->makeQuery("*", "rowid", "DESC", 1000);
$paging = new Paging($query, 40);
$paging->makePagingQuery();
?>
<table border="0" cellpadding="1" cellspacing="1" width="500">
<?php 
while ($row = mysql_fetch_assoc($paging->getResult())) {
    $getCategory = new Query("advertisement_categories");
    $getCategory->whereQuery("*", "rowid", $row['category'], "rowid", "ASC", 100);
    ?>
	  <tr>
		<td align="left" ><span class="boldGreyLighter"><?php 
    echo $row['title'];
    ?>
</span><span class="smallGrey"> - 
		<?php 
    echo $getCategory->getResultRow("category");
    ?>
</span></td>
        <td align="left"><span class="smallGrey"><?php 
    echo $row['date'];
    ?>
</span></td>
        <td align="right"><a href="admin_market_action.php?action=remove&id=<?php 

"><?php 
        echo $row->description;
        ?>
</a></span><br />
		<span class="smallOrange"><a href="tavlingar.php?id=<?php 
        echo $row->rowid;
        ?>
">T&auml;vla!</a></span> <br />
		<br />
		<hr class="hr2" noshade="noshade" />
		</div>
	<?php 
    }
}
$radioQ = new Query("radio_songs");
$radioQ->makeQuery("*", "rowid", "ASC", 1);
if ($radioQ->getNumRows() > 0) {
    ?>
	<div class="rightCenterDivFlow"><a href="#" onclick="MM_openBrWindow('radio.php','Radio','width=300,height=400,resizable=no')" ><img src="graphics/radio.gif" border="0" alt=""/></a></div>
	<hr class="hr2" noshade="noshade" /><br />
	<?php 
}
$demoQ = new Query("demos");
$demoQ->whereLeftJoinImageQuery("*", "week_demo", 1, "date", "DESC", 1);
if ($demoQ->getNumRows() > 0) {
    ?>
    <div class="rightCenterDivFlow"><a href="demorecensioner.php?demo_id=<?php 
    echo $demoQ->getResultRow("rowid");
    ?>
"><img src="graphics/veckansDemoband_title.gif" border="0" alt="Veckans demoband" /></a><br />
     <?php 

<?php

include "header_inc.php";
?>

<div id="centerDiv">
<div class="newsBg">
<?php 
$tv = new Query("youtube");
$tv->makeQuery("*", "date", "DESC", 200);
$tvPaging = new Paging($tv, 6);
$tvPaging->makePagingQuery();
?>
<table width="100%"><tr><td align="left">&nbsp;
</td><td align="right" valign="bottom">
<?php 
$tvPaging->displayLinks("se", "smallPink", "smallGrey");
?>
</td></tr></table>
<br />
<hr class="hr2"/><br />
<?php 
while ($row = mysql_fetch_assoc($tvPaging->pagingResult)) {
    echo '<span class="rightCenterDivTitle">' . $row['name'] . '</span><br />';
    echo $row['code'] . "<br/><br/>";
}
$tvPaging->displayLinks("se", "smallPink", "smallGrey");
?>


</div>

    echo $query->getResultRow("album2");
    echo '</li>';
    echo '<li>';
    echo $query->getResultRow("album3");
    echo '</li>';
    echo '</ul>';
    echo '<br />';
    echo '<strong>';
    echo 'Syssels&auml;ttning';
    echo '</strong>';
    echo '</p>';
    echo '<p>';
    echo Helper::text($query->getResultRow("description"));
    echo '<br />';
}
$query = new Query("personal");
$query->makeQuery("*", "last_name", "ASC", 1000);
while ($row = mysql_fetch_assoc($query->getResult())) {
    if ($row['first_name'] != "" && $row['last_name'] != "") {
        echo '<span class="smallPink">';
        echo '<a href="?id=' . $row['rowid'] . '">';
        echo $row['first_name'] . " " . $row['last_name'];
        echo '</a>';
        echo '<br />';
        echo '<hr />';
        echo '</span>';
    }
}
echo '</div>';
echo '</div>';
include "footer.php";

    <input name="title" type="text" size="50" />
    <h4>Beskrivning</h4>
    <textarea name="description" cols="50" rows="10"></textarea><br/>
    <h4>Datum</h4>
    <input name="date" maxlength="19" type="text" value="<?php 
    echo date("Y-m-d h:i:s");
    ?>
"><br/><br/>
    <input name="action" type="submit" value="Skapa">
    </form>
<?php 
}
?>
<br/>
<br/>
<h4>G&aring; in i en grupp och l&auml;gg till bilder.</h4>
<table>
<th align="left">Kategorier</th><th>&nbsp;</th><th>&nbsp;</th>
<?php 
$vimmelQ = new Query("vimmel_categories");
$vimmelQ->makeQuery("*", "date", "DESC", 10000);
while ($row = mysql_fetch_object($vimmelQ->getResult())) {
    echo '<tr><td><a href="admin_vimmel.php?category=' . $row->rowid . '">' . $row->title . '</td><td><a href="?action=edit&id=' . $row->rowid . '">&Auml;ndra</a></td><td><a href="admin_vimmel_action.php?action=removecategory&id=' . $row->rowid . '"<img src="graphics/remove.jpg" border="0" width="10"/></td></tr>';
}
echo '</table>';
if ($_GET['action'] == "edit") {
    echo '<br/>';
    echo '<br/>';
    echo '<a href="admin_vimmel_categories.php">Tillbaka';
}
include "admin_footer.php";

 public function listEmails()
 {
     echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="POST">';
     $form = new Form();
     $q = new Query("emails");
     $q->makeQuery("*", "email", "DESC", 0);
     echo '<table><th align="left">E-mail</th><th>Ta bort</th>' . "\n";
     while ($row = mysql_fetch_object($q->getResult())) {
         echo '<tr><td align="left"><input name="emails[]" checked="checked" type="checkbox" value="' . $row->email . '"/>' . $row->email . '</td><td><a href="?entry=' . $this->entry_id . '&category=' . $this->category_id . '&action=delete&email=' . $row->email . '">Ta bort</a></td></tr>' . "\n";
     }
     echo '</table><br />';
     echo $form->hiddenField("category", $this->category_id);
     echo $form->hiddenField("entry", $this->entry_id);
     echo $form->submitButton("myClass", "Skicka");
     echo '</form>';
 }