[Noalyss-commit] [noalyss] 70/151: sécurité Task #8 - Sécurité protection SQL

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 7ddf89bce8a6715f246d9317a4160af9ded04ee7
Author: Dany De Bontridder <address@hidden>
Date:   Sat Nov 26 11:48:58 2016 +0100

    sécurité
    Task #8 - Sécurité protection SQL
---
 include/class/class_anc_operation.php |    4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/include/class/class_anc_operation.php 
b/include/class/class_anc_operation.php
index 0276b28..bc0d5e6 100644
--- a/include/class/class_anc_operation.php
+++ b/include/class/class_anc_operation.php
@@ -901,8 +901,8 @@ class Anc_Operation
      */
     function delete_by_jid($p_jid)
     {
-        $sql="delete from operation_analytique where j_id=$p_jid";
-        $this->db->exec_sql($sql);
+        $sql="delete from operation_analytique where j_id=$1";
+        $this->db->exec_sql($sql,array($p_jid));
     }
     /*\brief Display a table with analytic accounting in
      *       detail of operation