PHP mysql::select方法代码示例

 /**
  * Retourne une liste d'accessoires selon des paramètres donnés.
  *
  * @param array $params
  * @param boolean $count_only
  * @return object recordset/integer
  */
 public function getAccessories($params = array(), $count_only = false)
 {
     $reqPlus = '';
     if (!empty($params['id'])) {
         $reqPlus .= ' AND a.id=' . (int) $params['id'] . ' ';
     }
     if (!empty($params['product_id'])) {
         $reqPlus .= ' AND a.product_id=' . (int) $params['product_id'] . ' ';
     }
     if (isset($params['active'])) {
         if ($params['active'] == 0) {
             $reqPlus .= 'AND a.active=0 ';
         } elseif ($params['active'] == 1) {
             $reqPlus .= 'AND a.active=1 ';
         } elseif ($params['active'] == 2) {
             $reqPlus .= '';
         }
     } else {
         $reqPlus .= 'AND a.active=1 ';
     }
     if ($count_only) {
         $query = 'SELECT COUNT(a.id) AS num_accessories ' . 'FROM ' . $this->t_accessories . ' AS a ' . 'LEFT JOIN ' . $this->t_products . ' AS p ON p.id=a.product_id ' . 'WHERE 1 ' . $reqPlus;
     } else {
         $query = 'SELECT a.id, a.product_id, a.active, a.title, ' . 'p.title AS product_title ' . 'FROM ' . $this->t_accessories . ' AS a ' . 'LEFT JOIN ' . $this->t_products . ' AS p ON p.id=a.product_id ' . 'WHERE 1 ' . $reqPlus;
         if (!empty($params['order'])) {
             $query .= 'ORDER BY ' . $params['order'] . ' ';
         } else {
             $query .= 'ORDER BY p.title ASC, a.title ASC ';
         }
         if (!empty($params['limit'])) {
             $query .= 'LIMIT ' . $params['limit'] . ' ';
         }
     }
     if (($rs = $this->db->select($query)) === false) {
         if ($count_only) {
             return 0;
         } else {
             return new recordset(array());
         }
     }
     if ($count_only) {
         return (int) $rs->num_accessories;
     } else {
         return $rs;
     }
 }

 /**
  * Retourne une liste de produits selon des paramètres donnés.
  *
  * @param array $params
  * @param boolean $count_only
  * @return object recordset/integer
  */
 public function getProducts($params = array(), $count_only = false)
 {
     $reqPlus = '';
     if (!empty($params['id'])) {
         $reqPlus .= ' AND p.id=' . (int) $params['id'] . ' ';
     }
     if (isset($params['active'])) {
         if ($params['active'] == 0) {
             $reqPlus .= 'AND p.active=0 ';
         } elseif ($params['active'] == 1) {
             $reqPlus .= 'AND p.active=1 ';
         } elseif ($params['active'] == 2) {
             $reqPlus .= '';
         }
     } else {
         $reqPlus .= 'AND p.active=1 ';
     }
     if ($count_only) {
         $query = 'SELECT COUNT(p.id) AS num_products ' . 'FROM ' . $this->t_products . ' AS p ' . 'WHERE 1 ' . $reqPlus;
     } else {
         $query = 'SELECT p.id, p.active, p.title ' . 'FROM ' . $this->t_products . ' AS p ' . 'WHERE 1 ' . $reqPlus;
         if (!empty($params['order'])) {
             $query .= 'ORDER BY ' . $params['order'] . ' ';
         } else {
             $query .= 'ORDER BY p.title ASC ';
         }
         if (!empty($params['limit'])) {
             $query .= 'LIMIT ' . $params['limit'] . ' ';
         }
     }
     if (($rs = $this->db->select($query)) === false) {
         if ($count_only) {
             return 0;
         } else {
             return new recordset(array());
         }
     }
     if ($count_only) {
         return (int) $rs->num_products;
     } else {
         return $rs;
     }
 }

<?php

// a_authordetails.php -- Admin view Author Details
include './functions.php';
require_once './config/auth.php';
require './config/config.php';
include "./classes/mysql.class.php";
$mysqldb = new mysql();
$mysqldb->connect();
$mysqldb->select();
$authorid = mifi($_REQUEST[aid]);
$mysqldb->query("SELECT CONCAT(FirstName, ' ', LastName) AS name, Approved, UserName, Email, DATE_FORMAT(RegistrationDate, '%M %d, %Y') AS dr, (SELECT count(*) from articles WHERE Approved = 'N' AND AuthorID='{$authorid}') AS PendingArticles, (SELECT count(*) from articles WHERE Approved = 'Y' AND AuthorID='{$authorid}') AS ApprovedArticles, (SELECT count(*) from articles WHERE Approved = 'S' AND AuthorID='{$authorid}') AS SavedArticles FROM authors WHERE AuthorID='{$authorid}'");
$row = $mysqldb->fetchObject();
$totalarticles = $row->ApprovedArticles + $row->PendingArticles + $row->SavedArticles;
if (isset($_REQUEST['newperms'])) {
    $title = 'Permissions Updated';
} else {
    $title = 'Author details for ' . $row->name . ' (' . $row->UserName . ')';
}
$approved = $row->Approved;
if ($approved != 'Y') {
    $approved = "<a href=\"aufe2a.php?aid={$authorid}\">{$row->Approved}</a>";
}
head_page($title);
menu_options($title, $vnum, $viewop, $pid, $keys, $adfl);
contentinit($title);
echo <<<_AUTHORDETAILS
AuthorID : {$authorid}<br />
UserName : {$row->UserName}<br />
Full Name : {$row->name}<br />
Permissions : {$row->Approved}<br>

function addtag($id)
{
    if (!$id) {
        exit;
    }
    $mysqldb = new mysql();
    $mysqldb->connect();
    $mysqldb->select();
    $mysqldb->query("SELECT Keyw FROM articles WHERE FileID='{$id}'");
    $row = $mysqldb->fetchObject();
    $keystotags = $row->Keyw;
    // place keywords into tags table.
    $arrkeywords = explode(' ', $keystotags);
    foreach ($arrkeywords as $keyword) {
        if (strlen($keyword) > 4) {
            $mysqldb->query("INSERT INTO tags (fileid, tag) VALUES ('{$fileid}', '{$keyword}')");
        }
    }
}

 public static function get($table, $idFields = null)
 {
     $select = self::$select;
     self::$select = '*';
     if ($idFields === null) {
         return self::query("SELECT {$select} FROM {$table}");
     } else {
         $idString = implode(' AND ', self::quoteArray($idFields, true));
         return self::query("SELECT {$select} FROM {$table} WHERE {$idString}");
     }
 }

include_once 'classes/class.pager.php';
$db = new mysql();
$pager = new paginator();
mysql_query("SET NAMES 'utf8'");
$currentPage = $_REQUEST["page"];
$pageLimit = 200;
if ($currentPage == 0) {
    $currentPage = 1;
}
$limitFrom = $pageLimit * $currentPage - $pageLimit;
switch ($_REQUEST['f']) {
    //Save category function
    case 'save_category':
        $save_category = $db->insert_sql("INSERT INTO categories (title) VALUES ('" . $_REQUEST['category_title'] . "')");
        echo "<option value=''>Select Category</option>";
        $category_sql = $db->select("SELECT title FROM categories ORDER BY title ASC");
        while ($category = mysql_fetch_object($category_sql)) {
            echo "<option value='" . $category->title . "'>" . $category->title . "</option>";
        }
        break;
        //Save location function
    //Save location function
    case 'save_location':
        $location = array();
        $location['location'] = $_REQUEST['location_title'];
        $location['city'] = $_REQUEST['city_title'];
        $db->insert_array("locations", $location);
        echo "<span class='location_res'></span>";
        break;
        //Get locations based on the city
    //Get locations based on the city

<?php

require 'msql.class.php';
// include mysql-class
$dbObj = new mysql('mysql.metropolia.fi', 'dineshs', 'password2043', 'dineshs');
// make an object from mysql-class
// make the connection
$dbObj->connect();
$dbObj->select();
?>
 

 /**
  * @covers ITE\mysql::select
  */
 public function testSelect()
 {
     $this->assertCount(1, $this->object->select("log", "1=1", "log_id DESC LIMIT 1", false, false));
     $this->assertFalse($this->object->select("dummyTable", "1=1", "log_id DESC LIMIT 1", false, false));
 }