join_construct

🔧 build_join

Construit SQL LEFT JOIN clause si les 4 paramètres existent.

function build_join(): string
    {
        if( !empty($this->table_base) && !empty($this->att_base) && !empty($this->table_join) && !empty($this->att_join)) {
            $join = " LEFT JOIN " . $this->table_join . " ON " . $this->table_base . "." . $this->att_base . " = " . $this->table_join . "." . $this->att_join . " ";
            return $join;
        }
        else{
            var_dump("erreur dans le join");
            return "";
        }

    }

⚙️ Parameters

$parameter (array)

↩️ Returns

(string) SQL LEFT JOIN.