Subversion-Projekte lars-tiefland.content-management

Revision

Zur aktuellen Revision | Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
 
3 
    //$Id: artikelsuche.php 3931 2011-09-16 08:17:57Z tiefland $
4 
 
5 
    /**
6 
     * @author Lars Tiefland <tiefland@weban.de>
7 
     * @copyright 2009 Webagentur Niewerth
8 
     * @package Content-management
9 
     * @version $Rev: 3931 $
10 
     * @license propietary
11 
     * @filesource
12 
     *
13 
     */
14 
 
15 
    /**
16 
     *
17 
     * @author Lars Tiefland <tiefland@weban.de>
18 
     * @copyright 2009 Webagentur Niewerth
19 
     * @package Content-management
20 
     */
21 
 
22 
    require_once  "Weban_Smarty.class.php";
23 
    require_once  "../connect2.php";
24 
    session_start();
25 
    $GLOBALS["ui"] = new Weban_Smarty();
26 
 
27 
    $GLOBALS["ui"]->assign( "bg_color_links", "#" . $webs["bgcolor_links"] );
28 
    $GLOBALS["ui"]->assign( "bg_color_rechts", "#" . $webs["bgcolor_rechts"] );
29 
    $GLOBALS["ui"]->assign( "font_color_links", "#" . $webs["font_color_links"] );
30 
    $GLOBALS["ui"]->assign( "font_color_rechts", "#" . $webs["font_color_rechts"] );
31 
    if ( $_POST["mode"] == "search" )
32 
    {
33 
        unset( $_POST["mode"] );
34 
        foreach ( $_POST as $key => $value )
35 
        {
36 
            if ( $value )
37 
            {
38 
                if ( $key == "ID" || $key == "kennung" ||$key=="language")
39 
                {
40 
                    $such_sql[] = "$key='$value'";
41 
                }
42 
                else
43 
                {
44 
                    $such_sql[] = "$key LIKE '%$value%'";
45 
                }
46 
            }
47 
        }
48 
        $such_sql_str = is_array( $such_sql ) ? "AND " . implode( " AND ", $such_sql ) :
49 
            "";
50 
        $sql = "SELECT * FROM artikel WHERE Father !=-3 $such_sql_str";
51 
        $res = mysql_query( $sql );
52 
        while ( $row = mysql_fetch_assoc($res) )
53 
        {
54 
            $results[] = $row;
55 
        }
56 
        $GLOBALS["ui"]->assign("language", $_POST["language"]);
57 
    }
58 
    else
59 
    {
60 
        $GLOBALS["ui"]->assign("language", $_GET["lang"]);
61 
    }
62 
    $GLOBALS["ui"]->assign( "results", $results );
63 
    $GLOBALS["ui"]->display( "artikelsuche.tpl" );
64 
 
65 
?>