~ebnerbenoit/gestion.enseignants/trunk

« back to all changes in this revision

Viewing changes to referentiel/valid_trt_cloture.php

  • Committer: Benoit Ebner
  • Date: 2010-01-12 17:48:09 UTC
  • Revision ID: ebnerbenoit@teledisnet.be-20100112174809-rgw95ua5kdp7y8cz
Changement de DB -> DBi
Nettoyage du code

Show diffs side-by-side

added added

removed removed

Lines of Context:
29
29
        $TypePage = $_GET["TypePage"];
30
30
        $numCloture = $_GET["id"];
31
31
        
32
 
        $SQL_C = new DB();
 
32
        $SQL_C = new DBi();
33
33
        
34
34
        require_once "gestion_valid_cloture.php";
35
35
        
46
46
                switch ($TypePage)
47
47
                {
48
48
                        case NOUVEAU:
49
 
                                $request = 'INSERT INTO TypeClotureCandidature (DescrTypeCloture) VALUES ("'.$_REQUEST["description"].'");';
50
 
                                $SQL_C->query($request);
 
49
                                $request = 'INSERT INTO TypeClotureCandidature (DescrTypeCloture) VALUES (?)';
 
50
                                $SQL_C->query($request,$_REQUEST["description"]);
51
51
                                break;
52
52
                        case MODIFICATION:
53
 
                                $request = 'UPDATE TypeClotureCandidature SET DescrTypeCloture = "'.$_REQUEST["description"].'" WHERE idTypeCloture = '.$numCloture.';';
54
 
                                $SQL_C->query($request);
 
53
                                $request = 'UPDATE TypeClotureCandidature SET DescrTypeCloture = ? WHERE idTypeCloture = ?';
 
54
                                $SQL_C->query($request, $_REQUEST["description"], $numCloture);
55
55
                                break;
56
56
                        default:
57
57
                                echo " Ce type n'est pas reconnu";