<?php
   
    function encrypt($database, $serveurbase, $loginbase, $passwordbase, $idutilisateur, $key)
    {
      $link = mysql_connect($serveurbase, $loginbase, $passwordbase) or die ("Impossible de se connecter : " . mysql_error());
      mysql_select_db($database, $link); 
 
      $crypt = new encryption_class;  

      $tpatients = 'patients'.$idutilisateur;
      $query = "SELECT ID, Nom, Prenom, DateDeNaissance FROM $tpatients LIMIT 0,30000";
  
      $result = mysql_query($query);
      
      $result2 = mysql_num_rows($result);
      
      if ($result2 > 0) 
      {    
        while($data = mysql_fetch_assoc($result))  
        {            
          $idpatient = $data['ID'];
           
          $nom_c = $data['Nom']; 
          $prenom_c = $data['Prenom']; 
          $datedenaissance_c = $data['DateDeNaissance'];
 
          $nom = $crypt->encrypt($key, $nom_c);
          $prenom = $crypt->encrypt($key, $prenom_c);
          $datedenaissance = $crypt->encrypt($key, $datedenaissance_c);
        
          $query2 = "UPDATE $tpatients SET Nom='$nom', Prenom='$prenom', DateDeNaissance='$datedenaissance' WHERE ID=$idpatient";

          $result3 = mysql_query($query2); 
        }        
      }
    }
    
?>