<?
require "../connexion.php";
$liste="select id_registrar, upper(replace(replace(designation,'.',''),' ','')),upper(replace(replace(nom,'.',''),' ','')),upper(replace(replace(prenom,'.',''),' ','')) from registrar order by id_registrar";

$result = pg_query($liste) or die('echec de la requête : ' . pg_last_error());
while ($data = pg_fetch_array($result))
{
$erreur=1;
$chiffre=1;
 while ($erreur != 0)
                        {
                                $nichandle_r = substr($data[1].$data[2].$data[3],0,3).$chiffre."-MCNIC";
                                $compte="select count(nichandle) from registrar where nichandle = '".$nichandle_r."';";
                                $val=pg_query($compte) or die('echec de la requête : ' . pg_last_error());
                                $nb = pg_fetch_array($val);
                                if ($nb[0] > 0)
                                        $chiffre++;
                                else $erreur=0;
                        }

echo $data[0]." ".$nichandle_r."\n";
$maj="update registrar set nichandle='".$nichandle_r."' where id_registrar=".$data[0].";";
$res = pg_query($maj) or die('echec de la requête : ' . pg_last_error());
}