Beiträge von cottton

SELECT 
    COUNT(*) AS `number`
FROM 
    `db`.`rechnungen` AS `r`
JOIN 
    bestellungen b 
WHERE
    `r`.`spalte` = 1
    AND b.preis > 0




-- usw ...

<?
...
    }} // Ende




    $stmt->execute();
                header("Location: http://$host$uri/$extra");
                        }
                else {
                        echo $mysqli -> error;
                    }
    };

<?




    if(isset($_POST['abschicken']) && empty($errors)) {

        $test = $l_header;
        $test1 = $l_teaser_img;




        if(isset($_GET['leistungID'])) {




            // Titel Bild löschen
            if($_POST['del_bild'] == 'ja') {
                $h_bild_pfad  = 'img/header/' . $l_header;    
                @unlink($h_bild_pfad);    
                $l_header = $test = "";
            }

            if ($nmb->file_dst_name != ''){
                $test = $nmb->file_dst_name;                
            }




            // Teaser Bild löschen
            if($_POST['del_bild_teaser'] == 'ja') {
                $h_bild_teaser  = 'img/teaser/' . $l_teaser_img;    
                @unlink($h_bild_teaser);    
                $l_teaser_img = $test1 = "";
            }

            if ($nmb_f->file_dst_name != ''){
                $test1 = $nmb_f->file_dst_name;                
            }




            if ($stmt = $mysqli->prepare("
                Update web_leistungen 
                SET 
                    l_startseite=?,
                    l_titel=?,
                    l_teaser=?
                    l_titel_url=?,
                    l_header=?,
                    l_header_titel=?,
                    l_teaser_img=?,
                    l_inhalt=?,
                    l_sort=?,
                    l_status=?
                WHERE l_id = ?
                ")
            ) {    
                $l_startseite   = $_POST["l_startseite"];
                $l_titel        = $_POST["titel"];
                $l_teaser       = $_POST["l_teaser"];
                $l_titel_url    = $_POST["titel_url"];
                $l_header       = $test;
                $l_header_titel = $_POST["l_header_titel"];
                $l_teaser_img   = $test2;
                $l_inhalt       = $_POST["l_inhalt"];
                $l_sort         = $_POST["l_sort"];
                $l_status       = $_POST["l_status"];

                $stmt->bind_param("sssssssssss",    
                    $l_startseite,
                    $l_titel,
                    $l_teaser,
                    $l_titel_url,
                    $l_header,
                    $l_header_titel,
                    $l_teaser_img,
                    $l_inhalt,
                    $l_sort,
                    $l_status,
                    $l_id
                );
                $stmt->execute();   
            } // /if ($stmt = $mysqli->prepare(
        } // /if(isset($_GET['leistungID']))




        
        /* -> weiß ich nicht wohin damit -> */header("Location: http://$host$uri/$extra");




    }
    else {
        echo $mysqli -> error; // <- warum so viel leerzeichen? 
    }
}; // die klammer ist "single" =)

<?
function leistungenStartseite($mysqli) {
    return leistungen($mysqli,'WHERE `l_startseite`="1"');
}
function leistungenNochNeAndereVariante($mysqli) {
    return leistungen($mysqli,'WHERE `l_startseite`="2"');
}
function leistungenUswUsw($mysqli) {
    return leistungen($mysqli,'WHERE `l_startseite`="3"');
}
function leistungen($mysqli, $selector='') { 
    $stmt = $mysqli->prepare("
        SELECT 
            l_startseite, 
            l_titel, 
            l_teaser, 
            l_titel_url, 
            l_header, 
            l_header_titel, 
            l_teaser_img, 
            l_inhalt, 
            l_sort 
        FROM 
            web_leistungen
        " . $selector
    );
    $stmt->execute();
 
    $stmt->bind_result(
        $l_startseite, 
        $l_titel, 
        $l_teaser, 
        $l_titel_url, 
        $l_header, 
        $l_header_titel, 
        $l_teaser_img, 
        $l_inhalt, 
        $l_sort
    );
 
    while ($stmt->fetch()){
        $leistungen_frontend[] = array(
            'l_startseite'  => $l_startseite,
            'l_titel'       => $l_titel, 
            'l_teaser'      => $l_teaser, 
            'l_titel_url'   => $l_titel_url, 
            'l_header'      => $l_header, 
            'l_header_titel'=> $l_header_titel, 
            'l_teaser_img'  => $l_teaser_img, 
            'l_inhalt'      => $l_inhalt,
            'l_sort'        => $l_sort
        );
    }
    return $leistungen_frontend;
}

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Audiotest</title>
    <script type="text/javascript">




// NEU START
        function changeTitle(bool){
            document.title = (bool === true) ? "FOCUS" : "NOT FOCUS";
        }
        if(window.addEventListener){
            window.addEventListener("focus",function(){changeTitle(true);});
            window.addEventListener("blur",function(){changeTitle(false);});
        }else if(window.attachEvent){
            window.attachEvent("focus",function(){changeTitle(true);});
            window.attachEvent("blur",function(){changeTitle(false);});
        }
// NEU ENDE




...
...

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Console</title>
    <script type="text/javascript">
        var Console =
        {
            list_title:"Console",
            btn_start_name:"startScroll",
            btn_stop_name:"stopScroll",
            list_style:{
                "backgroundColor"   : "#000",
                "color"             : "#ccc",
                "width"             : "100%",
                "height"            : "400px",
                "border"            : "1px solid black",
                "overflow"          : "scroll",
            },
            max_list_size_len:10000,
            list_line_element:"div",
            wrap:null,
            title:null,
            list:null,
            btn_start:null,
            btn_stop:null,
            scroll_interval:null,
            _:null,
            init:function(wrap_element_id)
            {
                if(this._ === true){return;}
                this.wrap       = document.getElementById(wrap_element_id);
                this.list       = document.createElement("div"),
                this.title      = document.createElement("h3"),
                this.btn_start  = document.createElement("button"),
                this.btn_stop   = document.createElement("button");
                for(var attr in this.list_style){
                    this.list.style[attr] = this.list_style[attr];
                }
                this.btn_start.appendChild(document.createTextNode(this.btn_start_name)),
                this.btn_start.addEventListener(
                    'click', function(){ Console.startScroll(); }, false
                ),
                this.btn_stop.appendChild(document.createTextNode(this.btn_stop_name)),
                this.btn_stop.addEventListener(
                    'click', function(){ Console.stopScroll(); }, false
                ),
                this.title.appendChild(document.createTextNode(this.list_title)),
                this.wrap.appendChild(this.title),
                this.wrap.appendChild(this.btn_start),
                this.wrap.appendChild(this.btn_stop),
                this.wrap.appendChild(this.list);
                this._ = true;
                return;
            },
            startScroll:function()
            {
                this.scroll_interval === null && (this.scroll_interval=setInterval(function(){
                        Console.list.scrollTop = Console.list.scrollHeight;
                    }, 200
                ));
                return;
            },
            stopScroll:function()
            {
                this.scroll_interval !== null && clearInterval(this.scroll_interval);
                this.scroll_interval = null;
                return;
            },
            log:function(str)
            {
                var row = document.createElement(this.list_line_element);
                    row.appendChild(document.createTextNode(str));
                this.list.appendChild(row);




                while(this.list.innerHTML.length > this.max_list_size_len){
                    var list = this.list.getElementsByTagName(this.list_line_element);
                    (list.length > 0) && list[0].parentNode.removeChild(list[0]);
                }
                return;
            }
        }




    </script>
</head>
<body>
    <pre id="console"></pre>




    <script type="text/javascript">
        Console.init("console");
        Console.startScroll();




        var nr = 0;
        for(var i = 0; i < 1000; i++){
            setTimeout(
                function(){
                    var lines = Console.list.getElementsByTagName(Console.list_line_element).length;
                    var max_len = Console.max_list_size_len;
                    Console.log("writing line nr " + (nr++) + " (lines in list: " + lines + ")");
                }, i*10
            );
        }
    </script>
</body>
</html>

$test_var = false;
if($test_var === true){
    $ausgabe = 'true'; 
}
else{
    $ausgabe = 'false';
}
echo §ausgabe;







// tipp: kurzschreibweise
echo ($test_var === true) ? 'true' : 'false' ;
// echo (WENN) ? DANN : SONST ;

// search:
if (parent::authUser($userRecord)) { 
    if (!empty($this->login['uident_text'])) {
        if ($this->login['uident'] && $this->login['uname'])   {




// replace:
if (is_bool($checkResult = parent::authUser($userRecord)) && $checkResult) {
    if ((string)$this->login['uident_text'] !== '') {
        if ((string)$this->login['uident'] !== '' && $this->login['uname'])    {

if(parent::authUser($userRecord) === true){
    if(
        isset($this->login['uident_text'])and is_string($this->login['uident_text'])and strlen($this->login['uident_text']) > 0
        and isset($this->login['uident'])and is_string($this->login['uident'])and strlen($this->login['uident']) > 0
        and isset($this->login['uname'])and is_string($this->login['uname'])and strlen($this->login['uname']) > 0
    ){
        // OK
    } 
}




// oder noch besser




if(parent::authUser($userRecord) === true){
    $e = 0;
    foreach(array('uident_text', 'uident', 'uname') as $offset){
        if(
            !isset($this->login[$offset])
            or !is_string($this->login[$offset])
            or strlen($this->login[$offset]) < 1
        ){
            $e++;
            break;
        }
    }
    if($e === 0){
        // OK
    }
    // ...
}

// warum ist das schlecht (vor dem fix):
if (parent::authUser($userRecord)) {
// weil es kann alles ausser "", 0, false, null sein kann




// warum das (nach dem fix) quark:
if (is_bool($checkResult = parent::authUser($userRecord)) && $checkResult) {
// weil das so ziemlich das gleiche wie das ist:
if (parent::authUser($userRecord) === true){







// warum ist das schlecht (vor dem fix):
if (!empty($this->login['uident_text'])) {
// weil empty() "schwammig" ist - siehe vorige posts




// warum ist das schlecht (vor dem fix):
if ($this->login['uident'] && $this->login['uname'])   {
// weil [uident] und [uname] alles ausser "", 0, false, null sein kann