PHP Sql_Query::whereの例

コード例 #1

ファイル: search.php プロジェクト: BackupTheBerlios/molecms

$fields = array("produktname", "herstellername", "name_" . LC_LANG);
$map_cols = array("produktname" => $lang->translate('productname'), "herstellername" => $lang->translate('manufacturer'), "name_" . LC_LANG => $lang->translate('category'));
$searchable_fields = array($cfg['table']['product'] . ".name" => $lang->translate('productname'), "t_manufacturer.name" => $lang->translate('manufacturer'), "name_" . LC_LANG => $lang->translate('category'));
if (!isset($sql)) {
    $sql = new Sql_Query();
    $sql->conditions = 1;
    $sql->method = 'get';
    $sql->translate = "on";
    $sql->container = "on";
    $sql->variable = "on";
    $sql->module = 'product';
    $sql->action = 'search';
    $sql->lang = LC_LANG;
}
if (isset($x)) {
    $abfrage = $sql->where("x", 1);
    $from = 0;
}
$tpl->setVariable("UEBERSCHRIFT", $lang->translate('productsearch'));
$content["ABFRAGEBOX"] = $sql->form("x", $searchable_fields, "searchbox", url(array('module' => 'product', 'action' => 'search')));
if (!isset($order)) {
    $order = "name";
}
if ($abfrage) {
    require_once 'mms_tablepager.php';
    $table['firma'] = $cfg['table']['company'];
    $table['produkt'] = $cfg['table']['product'];
    $table['produktkat'] = $cfg['table']['cat_product'];
    $tabpage = new PageTable($cfg['database']['dsn'], "overview");
    $tabpage->url_view = url(array('module' => 'product', 'action' => 'details'));
    // echo $abfrage;