PHP selectquery Examples

Example #1

File: content.php Project: studio-404/404

 public function load($page)
 {
     $selectquery = new selectquery();
     $fetch = $selectquery->select("*", "`studio404_invoices`", "`service`='webhosting' AND `lang`=4 AND `status`!=1", "ORDER BY `user_id` DESC", "", $fetchType = "all");
     $getusersname = new getusersname();
     $page = "pages/" . $page . ".php";
     if (file_exists($page)) {
         @(include $page);
     } else {
         @(include "pages/welcome.php");
     }
 }

Example #2

File: change.php Project: studio-404/404

<?php

$selectquery = new selectquery();
$paystatus = isset($_GET['paystatus']) && is_numeric($_GET['paystatus']) ? $_GET['paystatus'] : 2;
$id = isset($_GET['id']) && is_numeric($_GET['id']) ? $_GET['id'] : 0;
$update = $selectquery->update("`studio404_invoices`", "`paystatus`='" . $paystatus . "'", "WHERE `id`='" . $id . "'");
if ($update == "true") {
    echo "<meta http-equiv='refresh' content='0;url=http://404.ge/invoice/?page=welcome'>";
}

Example #3

File: index.php Project: alesinicio/shrtnr

 private function isAlreadyInDB($checkForCustom, $data)
 {
     $query = new selectquery();
     $query->setTable("links");
     $query->addField("lnkID");
     $query->addWhere($checkForCustom ? "lnkCustomURL" : "lnkID", "=", $data);
     $result = $query->getArrayResult(true);
     return count($result) > 0;
 }