backupecrypt.php 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. <?php
  2. function encrypt($database, $serveurbase, $loginbase, $passwordbase, $idutilisateur, $key)
  3. {
  4. $link = mysql_connect($serveurbase, $loginbase, $passwordbase) or die ("Impossible de se connecter : " . mysql_error());
  5. mysql_select_db($database, $link);
  6. $crypt = new encryption_class;
  7. $tpatients = 'patients'.$idutilisateur;
  8. $query = "SELECT ID, Nom, Prenom, DateDeNaissance FROM $tpatients LIMIT 0,30000";
  9. $result = mysql_query($query);
  10. $result2 = mysql_num_rows($result);
  11. if ($result2 > 0)
  12. {
  13. while($data = mysql_fetch_assoc($result))
  14. {
  15. $idpatient = $data['ID'];
  16. $nom_c = $data['Nom'];
  17. $prenom_c = $data['Prenom'];
  18. $datedenaissance_c = $data['DateDeNaissance'];
  19. $nom = $crypt->encrypt($key, $nom_c);
  20. $prenom = $crypt->encrypt($key, $prenom_c);
  21. $datedenaissance = $crypt->encrypt($key, $datedenaissance_c);
  22. $query2 = "UPDATE $tpatients SET Nom='$nom', Prenom='$prenom', DateDeNaissance='$datedenaissance' WHERE ID=$idpatient";
  23. $result3 = mysql_query($query2);
  24. }
  25. }
  26. }
  27. ?>