Modifier une valeur de la DB en additionnant le contenu d'une variable.

SET STOCK STOCK.value

<?php   
               
try{     
        
    function cleanData($dataToClean){
        $dataToClean = trim($dataToClean);
        $dataToClean = stripslashes($dataToClean);
        $dataCleaned = htmlspecialchars($dataToClean);
        return $dataCleaned;
    }
                                      
    $codeMag = cleanData($_POST["codeMag_21"]);
    $qteSortie = cleanData($_POST["qteSortie_21"]);
    $operateur = cleanData($_POST["codeOP_21"]);
    $gamme = cleanData($_POST["gamme_21"]);
    date_default_timezone_set("Europe/Paris");
    $date1 = date("Y-m-d H:i:s");
    //$date2 = date("U");

//--------------------------------------------------------------------------//
//connexion à la bdd "hydro"
//--------------------------------------------------------------------------//
require_once "../cnxbdd.php";

// MISE A JOUR TABLE "mvt_magasin"

    $requete = $connexion->prepare("INSERT INTO mvt_magasin(CODE_MAGASIN,OPERATEUR,
    GAMME,QTE_SORTIE,DATE_1)
    VALUES(:CODE_MAGASIN,:OPERATEUR,:GAMME,:QTE_SORTIE,:DATE_1)"
    );

    $requete->bindParam(':CODE_MAGASIN', $codeMag);
    $requete->bindParam(':OPERATEUR', $operateur);
    $requete->bindParam(':GAMME', $gamme);
    $requete->bindParam(':QTE_SORTIE', $qteSortie);
    $requete->bindParam(':DATE_1', $date1);

    $requete-> execute();


// MISE A JOUR STOCK DANS TABLE "cutting_tools_01"
    $sql2 = "UPDATE cutting_tools_01 SET STOCK = STOCK - $qteSortie WHERE REF_MAG = $codeMag";
    $requete2 = $connexion->prepare($sql2);

//$requete2 = $connexion->prepare("UPDATE `cutting_tools_01` SET `STOCK` = STOCK-$qteSortie WHERE 'CODE_MAGASIN' = $codeMag"
/*

UPDATE `cutting_tools_01` SET `STOCK`= `STOCK`- 5 WHERE `REF_MAG` = 45001
$requete2 = $connexion->prepare("SELECT STOCK FROM cutting_tools_01 WHERE REF_MAG = $codeMag"
);

$requete2->execute();
$oldStock = $requete2->fetchAll(PDO::FETCH_ASSOC);
$newStock = $oldStock - $qteSortie;
*/


}        
                
catch(PDOException $e){
    echo 'ECHEC  : ' .$e->getMessage();
}                           

//echo "<script language='javascript'>window.close()</script>";