sql_query_mco

🔧 construct_query

Construction de la requête sql

function construct_query(array $table, array $condition, array $attribut, $join): string
    {
        $recherche="";
        foreach ($condition as $value) {

            if ($value != "") {
                if (is_array($value)){
                    $recherche .= ($recherche !== "" ? " AND " : " WHERE "). $value." IN (";
                    $rechercheV="";
                    foreach ($value as $v) {
                        $rechercheV .= ($rechercheV !== "" ? " , " : " ") . "'{$v}'";
                    }
                    // ... (truncated)

⚙️ Parameters

$table (array)
$condition (array)
$attribut (array)

↩️ Returns

(string)

🔧 query_mco

Envoi de la requête sql

function query_mco(){

        $sql = $this->construct_query;
        $result = mysqli_query($this->connexion, $sql);
        if($result){
            $this->result = $result;
        }else{
            error_log("Erreur Mysqli : ".mysqli_error($this->connexion));
            die("Erreur". mysqli_error($this->connexion));
        }
    }

↩️ Returns

(void)

🔧 traitement_resultat

Traitement des résultats

function traitement_resultat(): ?array
    {
        if ($this->result && mysqli_num_rows($this->result) > 0) {
            echo " Nombre de lignes : " . mysqli_num_rows($this->result)."\n";
            $resultat = array();
            while ($row = mysqli_fetch_assoc($this->result)) {
                $resultat[] = $row;
            }
            // création du fichier csv

            $csv_file = "mco_data_".$this->env.".csv";
            $file = fopen($csv_file, "w");
            // ... (truncated)

↩️ Returns

(array|) null

🔧 deconnexion

Appel de la méthode déconnexion

function deconnexion(){
        mysqli_free_result($this->result);
        mysqli_close($this->connexion);
        echo "deconnexion -> ". $this->env."\n";
    }

↩️ Returns

(void)