<?
require "../connexion.php";
$liste="select id_contact, upper(replace(replace(replace(nom,'.',''),' ',''),'''','')),upper(replace(replace(replace(prenom,'\.',''),' ',''),'''','')),upper(replace(replace(replace(societe,'.',''),' ',''),'''','')) from contact order by id_contact";

$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_c = substr($data[1].$data[2].$data[3],0,3).$chiffre."-MCNIC";
                                $compte="select count(nichandle) from contact where nichandle = '".$nichandle_c."';";
                                $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 
					{
						$compte="select count(nichandle) from registrar where nichandle = '".$nichandle_c."';";
						$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_c."\n";
$maj="update contact set nichandle='".$nichandle_c."' where id_contact=".$data[0].";";
$res = pg_query($maj) or die('echec de la requête : ' . pg_last_error());
}