Database error: $msg
\n"); echo("MySQL error: $this->Errno ($this->Error)
\n"); die("Session halted."); } //------------------ se connect a une base de donnée function connect() { if($this->Link_ID == 0) { $this->Link_ID = mysql_connect($this->Host, $this->User, $this->Password); if (!$this->Link_ID) { $this->halt("Link_ID == false, connect failed"); } $SelectResult = mysql_select_db($this->Database, $this->Link_ID); if(!$SelectResult) { $this->Errno = mysql_errno($this->Link_ID); $this->Error = mysql_error($this->Link_ID); $this->halt("cannot select database ".$this->Database.""); } } } //------------------ excute une requette sql ------------------ function query($Query_String) { $this->connect(); $this->Query_ID = mysql_query($Query_String,$this->Link_ID); $this->Row = 0; $this->Errno = mysql_errno(); $this->Error = mysql_error(); if (!$this->Query_ID) { $this->halt("Invalid SQL ".$Query_String); } return $this->Query_ID; } //---------------------- avance dans la table de resultats est renvoi la ligne en cours function next_record() { $this->Record = mysql_fetch_array($this->Query_ID); $this->Row += 1; $this->Errno = mysql_errno(); $this->Error = mysql_error(); $stat = is_array($this->Record); if (!$stat) { mysql_free_result($this->Query_ID); $this->Query_ID = 0; } return $this->Record; } //------------------- affiche le nombre d'enregistremts trouvé function num_rows() { return mysql_num_rows($this->Query_ID); } //-------------- efface la memoire ---------------------------------- function clean_results() { if($this->Query_ID != 0) mysql_freeresult($this->Query_ID); } //-------------- avance de i enregistrement ---------------------------------------- function seek($i) { mysql_data_seek($this->Query_ID,$i); } //--------------- obtenir le numero du dernierre incrementation -------------------- function insert_id() { return mysql_insert_id(); } //---------------- ferme la base de donnée ---------------------- function close() { if($this->Link_ID != 0) mysql_close($this->Link_ID); } } ?> connect(); $query="select * from admin where pseudo='$pseudo' and pass='$pass'"; $db->query($query); if(mysql_num_rows($db->Query_ID)==0){ $message="
accès refusé ... pseudo ou mot de passe incorrect
"; } else{ session_start(); if(session_is_registered("mipi")){ header("Location:../console/quitter.php"); } else{ $val=mysql_fetch_array($db->Query_ID); session_register("mipi"); header("location:admin/ins.php"); } } } function liste_secteur() { global $total_sect,$lib_sect,$id_sect,$val; $db=new mysql; $db->connect(); $sql="select * from secteur"; $db->query($sql); $total_sect=mysql_num_rows($db->Query_ID); $i=1; while ($val=mysql_fetch_array($db->Query_ID)) { $lib_sect[$i]=$val["lib"]; $id_sect[$i]=$val["id"]; $i++; } } function liste_wil() { global $total_wil,$lib_wil,$id_wil,$val; $db=new mysql; $db->connect(); $sql="select * from wilaya"; $db->query($sql); $total_wil=mysql_num_rows($db->Query_ID); $i=1; while ($val=mysql_fetch_array($db->Query_ID)) { $lib_wil[$i]=$val["lib_w"]; $id_wil[$i]=$val["id_w"]; $i++; } } function ajouter_annuaire() { global $secteur,$type,$sigle,$nom,$nombre_adherents,$date_effective,$ref,$date_obtention,$adresse,$wilaya,$tel,$fax,$email,$site,$objet,$responsable,$activite; $db=new mysql; $db->connect(); $secteur=$_POST['secteur']; $type=$_POST['type']; $sigle=$_POST['sigle']; $nom=$_POST['nom']; $nombre_adherents=$_POST['nombre_adherents']; $date_effective=$_POST['date_effective']; $ref=$_POST['ref']; $date_obtention=$_POST['date_obtention']; $wilaya=$_POST['wilaya']; $tel=$_POST['tel']; $fax=$_POST['fax']; $email=$_POST['email']; $site=$_POST['site']; $objet=$_POST['objet']; $responsable=$_POST['responsable']; $activite=$_POST['activite']; $sql="INSERT into `organisme`(sigle,nom,responsable,date_depart,nombre_adherent,ref,date_obtention,adresse,tel,fax,site,email,objectifs,activites,wilaya,id_sect,type) VALUES('$sigle','$nom','$responsable','$date_effective','$nombre_adherents','$ref','$date_obtention','$adresse','$tel','$fax','$site','$email','$objet','$activite','$wilaya','$secteur','$type')"; $db->query($sql); } function modif_annuaire($id) { global $secteur1,$type1,$sigle1,$nom1,$nombre_adherents1,$date_effective1,$ref1,$date_obtention1,$adresse1,$wilaya1,$tel1,$fax1,$email1,$site1,$objet1,$responsable1,$activite1,$sql; $db=new mysql; $db->connect(); $id=$_GET['id']; $secteur1=$_POST['secteur1']; $type1=$_POST['type1']; $sigle1=$_POST['sigle1']; $nom1=$_POST['nom1']; $nombre_adherents1=$_POST['nombre_adherents1']; $date_effective1=$_POST['date_effective1']; $ref1=$_POST['ref1']; $date_obtention1=$_POST['date_obtention1']; $wilaya1=$_POST['wilaya1']; $tel1=$_POST['tel1']; $fax1=$_POST['fax1']; $email1=$_POST['email1']; $site1=$_POST['site1']; $objet1=$_POST['objet1']; $responsable1=$_POST['responsable1']; $activite1=$_POST['activite1']; $sql="UPDATE `organisme` set sigle='$sigle1',nom='$nom1',responsable='$responsable1',date_depart='$date_effective1',nombre_adherent='$nombre_adherents1',ref='$ref1',date_obtention='$date_obtention1',adresse='$adresse1',tel='$tel1',fax='$fax1',site='$site1',email='$email1',objectifs='$objet1',activites='$activite1',wilaya='$wilaya1',id_sect='$secteur1',type= '$type1' where id='$id'"; $db->query($sql); } function liste_annuaire($type) { global $nom,$sigle,$wilaya,$date_effective,$id,$secteur,$total,$val; $db=new mysql; $db->connect(); $sql="select * from organisme where type='$type'"; $db->query($sql); $total=mysql_num_rows($db->Query_ID); $i=1; while($val=mysql_fetch_array($db->Query_ID)) { $nom[$i]=$val["nom"]; $sigle[$i]=$val["sigle"]; $wilaya[$i]=$val["wilaya"]; $date_effective[$i]=$val["date_depart"]; $secteur[$i]=$val["id_sect"]; $id[$i]=$val["id"]; $i++; } } function det_annuaire($id) { global $secteur,$type,$sigle,$nom,$nombre_adherents,$date_effective,$ref,$date_obtention,$adresse,$wilaya,$tel,$fax,$email,$site,$objet,$responsable,$activite,$val; $db=new mysql; $db->connect(); $sql="select * from organisme where id='$id'"; $db->query($sql); $val=mysql_fetch_array($db->Query_ID); $nom=$val["nom"]; $sigle=$val["sigle"]; $wilaya=$val["wilaya"]; $date_effective=$val["date_depart"]; $secteur=$val["id_sect"]; $nombre_adherents=$val["nombre_adherent"]; $date_effective=$val["date_depart"]; $ref=$val["ref"]; $date_obtention=$val["date_obtention"]; $adresse=$val["adresse"]; $tel=$val["tel"]; $fax=$val["fax"]; $email=$val["email"]; $site=$val["site"]; $email=$val["email"]; $objet=$val["objectifs"]; $responsable=$val["responsable"]; $activite=$val["activites"]; } function liste_annuaire1() { global $nom1,$sigle1,$wilaya,$date_effective1,$id,$secteur,$total,$val,$type; $db=new mysql; $db->connect(); $sql="select * from organisme "; $db->query($sql); $total=mysql_num_rows($db->Query_ID); $i=1; while($val=mysql_fetch_array($db->Query_ID)) { $nom1[$i]=$val["nom"]; $sigle1[$i]=$val["sigle"]; $wilaya[$i]=$val["wilaya"]; $date_effective1[$i]=$val["date_depart"]; $secteur[$i]=$val["id_sect"]; $id[$i]=$val["id"]; $type[$i]=$val["type"]; $i++; } } /*function supprimer() { global $id,$tot,$cp,$idc,$sql,$c; $db=new mysql; $db->connect(); $cpt=1; while($cpt<=tot) { if($c['$cpt']=="ON") { $idc=$cp[$cpt]; $sql="DELETE from organisme where id='$idc'"; $db->query($sql); } $cpt++; } }*/ function supprimer() { global $id,$tot,$org,$idc,$sql,$c,$cpt; $db=new mysql; $db->connect(); for($i=1;$i<=$tot;$i++){ if(!empty($org[$i])){ $query="DELETE from organisme where id='$org[$i]'"; $db->query($query); } } } function lib_secteur($sect) { global $val_sect,$lib_sect; $db=new mysql; $db->connect(); $sql="select * from secteur where id='$sect'"; $db->query($sql); $val_sect=mysql_fetch_array($db->Query_ID); $lib_sect=$val_sect["lib"]; } function lib_wil($wil) { global $val_wil,$lib_wil; $db=new mysql; $db->connect(); $sql="select * from wilaya where id_w='$wil'"; $db->query($sql); $val_wil=mysql_fetch_array($db->Query_ID); $lib_wil=$val_wil["lib_w"]; } function delete_ann($id) { $id=$_GET['id']; $db=new mysql; $db->connect(); $sql="DELETE from organisme where id='$id'"; $db->query($sql); } function liste_membres() { global $nom,$prenom,$ville,$email,$pays,$statut,$annee_sortie,$date_inscription,$cotisation,$maj,$type,$dernier_acces,$total,$num,$tab,$lim,$total_general; $db=new mysql; $db->connect(); $lim=$_GET['lim']; if(empty($ordre)){$ordre="mem_nom";} if(empty($lim)){$lim="0";} $sql1="SELECT * from `membres` ORDER BY $ordre ASC"; $db->query($sql1); $total_general=mysql_num_rows($db->Query_ID); $sql="SELECT * from `membres` ORDER BY $ordre ASC LIMIT $lim,30"; $db->query($sql); $total=mysql_num_rows($db->Query_ID); $i=1; while($tab=mysql_fetch_array($db->Query_ID)) { $num[$i]=$tab["mem_numero"]; $nom[$i]=$tab["mem_nom"]; $prenom[$i]=$tab["mem_prenom"]; $ville[$i]=$tab["mem_ville"]; $email[$i]=$tab["mem_email"]; $pays[$i]=$tab["mem_pays"]; $statut[$i]=$tab["mem_statut"]; $annee_sortie[$i]=$tab["mem_anneefin"]; $date_inscription[$i]=$tab["mem_inscription"]; $cotisation[$i]=$tab["mem_cotisation"]; $maj[$i]=$tab["mem_maj"]; $dernier_acces[$i]=$tab["mem_dernier_acces"]; $i++; } } function liste_membres2() { global $nom,$prenom,$ville,$email,$pays,$statut,$annee_sortie,$date_inscription,$cotisation,$maj,$type,$dernier_acces,$total,$num,$tab,$lim,$total_general,$date_naissance,$tel_perso,$tel_por,$annee_debut,$fonction,$specialite,$entreprise; $db=new mysql; $db->connect(); if(empty($ordre)){$ordre="mem_nom";} if(empty($lim)){$lim="0";} $sql1="SELECT * from `membres` ORDER BY $ordre ASC"; $db->query($sql1); $total_general=mysql_num_rows($db->Query_ID); $sql="SELECT * from `membres` ORDER BY $ordre ASC LIMIT $lim,30"; $db->query($sql); $total=mysql_num_rows($db->Query_ID); $i=1; while($tab=mysql_fetch_array($db->Query_ID)) { $num[$i]=$tab["mem_numero"]; $nom[$i]=$tab["mem_nom"]; $prenom[$i]=$tab["mem_prenom"]; $ville[$i]=$tab["mem_ville"]; $email[$i]=$tab["mem_email"]; $pays[$i]=$tab["mem_pays"]; $statut[$i]=$tab["mem_statut"]; $annee_sortie[$i]=$tab["mem_anneefin"]; $date_inscription[$i]=$tab["mem_inscription"]; $cotisation[$i]=$tab["mem_cotisation"]; $maj[$i]=$tab["mem_maj"]; $dernier_acces[$i]=$tab["mem_dernier_acces"]; $date_naissance[$i]=$tab["mem_date_naissance"]; $tel_perso[$i]=$tab["mem_telperso"]; $tel_por[$i]=$tab["mem_telporta"]; $annee_debut[$i]=$tab["mem_anneedeb"]; $fonction[$i]=$tab["mem_fonction"]; $specialite[$i]=$tab["mem_specialite"]; $entreprise[$i]=$tab["mem_entreprise"]; $i++; } } function detail_adherent($id) { global $nom,$prenom,$ville,$email,$pays,$statut,$annee_sortie,$date_inscription,$cotisation,$maj,$type,$dernier_acces,$total,$num,$tab,$lim,$total_general,$date_naissance,$tel_perso,$tel_por,$annee_debut,$fonction,$specialite,$entreprise; $db=new mysql; $db->connect(); $sql="SELECT * from `membres` where mem_numero='$id'"; $db->query($sql); $tab=mysql_fetch_array($db->Query_ID); $num=$tab["mem_numero"]; $nom=$tab["mem_nom"]; $prenom=$tab["mem_prenom"]; $ville=$tab["mem_ville"]; $email=$tab["mem_email"]; $pays=$tab["mem_pays"]; $statut=$tab["mem_statut"]; $annee_sortie=$tab["mem_anneefin"]; $date_inscription=$tab["mem_inscription"]; $cotisation=$tab["mem_cotisation"]; $maj=$tab["mem_maj"]; $dernier_acces=$tab["mem_dernier_acces"]; $date_naissance=$tab["mem_date_naissance"]; $tel_perso=$tab["mem_telperso"]; $tel_por=$tab["mem_telporta"]; $annee_debut=$tab["mem_anneedeb"]; $fonction=$tab["mem_fonction"]; $specialite=$tab["mem_specialite"]; $entreprise=$tab["mem_entreprise"]; } function lister_inscript() { global $nom,$prenom,$ville,$email,$pays,$statut,$annee_sortie,$date_inscription,$cotisation,$maj,$type,$dernier_acces,$total,$num,$tab,$lim,$total_general,$date_ins; $db=new mysql; $db->connect(); if(empty($ordre)){$ordre="date_ins";} if(empty($lim)){$lim="0";} $sql1="SELECT * from `membres` where actif='1' ORDER BY $ordre DESC"; $db->query($sql1); $total_general=mysql_num_rows($db->Query_ID); $sql="SELECT * from `membres` where actif='1' ORDER BY $ordre DESC LIMIT $lim,30"; $db->query($sql); $total=mysql_num_rows($db->Query_ID); $i=1; while($tab=mysql_fetch_array($db->Query_ID)) { $num[$i]=$tab["mem_numero"]; $nom[$i]=$tab["mem_nom"]; $prenom[$i]=$tab["mem_prenom"]; $ville[$i]=$tab["mem_ville"]; $email[$i]=$tab["mem_email"]; $pays[$i]=$tab["mem_pays"]; $statut[$i]=$tab["mem_statut"]; $annee_sortie[$i]=$tab["mem_anneefin"]; $date_ins[$i]=$tab["date_ins"]; $cotisation[$i]=$tab["mem_cotisation"]; $maj[$i]=$tab["mem_maj"]; $dernier_acces[$i]=$tab["mem_dernier_acces"]; $i++; } } function details($id) { global $nom,$prenom,$ville,$email,$pays,$statut,$annee_sortie,$date_inscription,$cotisation,$maj,$type,$dernier_acces,$total,$num,$tab,$lim,$total_general,$date_ins,$date_naissance,$tel_perso,$tel_por,$annee_debut,$fonction,$specialite,$entreprise; $db=new mysql; $db->connect(); $sql="SELECT * from `membres` where mem_numero='$id'"; $db->query($sql); $tab=mysql_fetch_array($db->Query_ID); $num=$tab["mem_numero"]; $nom=$tab["mem_nom"]; $prenom=$tab["mem_prenom"]; $ville=$tab["mem_ville"]; $email=$tab["mem_email"]; $pays=$tab["mem_pays"]; $statut=$tab["mem_statut"]; $annee_sortie=$tab["mem_anneefin"]; $date_ins=$tab["date_ins"]; $cotisation=$tab["mem_cotisation"]; $maj=$tab["mem_maj"]; $dernier_acces=$tab["mem_dernier_acces"]; $daye_naissance=$tab["mem_date_naissance"]; $tel_perso=$tab["mem_telperso"]; $tel_por=$tab["mem_telporta"]; $annee_debut=$tab["mem_anneedeb"]; $specialite=$tab["mem_specialite"]; $fonction=$tab["mem_fonction"]; $entreprise=$tab["mem_entreprise"]; } function delete_annonce($id) { $db=new mysql; $db->connect(); $sql="delete from `membres` where mem_numero='$id'"; $db->query($sql); } function activer_annonce($id) { $db=new mysql; $db->connect(); $sql="UPDATE `membres` set actif='1' where mem_numero='$id'"; $db->query($sql); } function aff_noms() { global $nom_user,$total_nom,$val_nom; $db=new mysql; $db->connect(); $sql="SELECT DISTINCT `mem_nom` from `membres` order by mem_nom"; $db->query($sql); $total_nom=mysql_num_rows($db->Query_ID); $i=1; while($val_nom=mysql_fetch_array($db->Query_ID)) { $nom_user[$i]=$val_nom["mem_nom"]; $i++; } } function aff_ann_sortie() { global $annee_sortie,$total_annee,$val_annee; $db=new mysql; $db->connect(); $sql="SELECT DISTINCT `mem_anneefin` from `membres` order by mem_anneefin"; $db->query($sql); $total_annee=mysql_num_rows($db->Query_ID); $i=1; while($val_annee=mysql_fetch_array($db->Query_ID)) { $annee_sortie[$i]=$val_annee["mem_anneefin"]; $i++; } } function afficher_pays() { global $pays1,$total_p,$val_p; $db=new mysql; $db->connect(); $sql="SELECT DISTINCT `mem_pays` from `membres` order by mem_pays"; $db->query($sql); $total_p=mysql_num_rows($db->Query_ID); $i=1; while($val_p=mysql_fetch_array($db->Query_ID)) { $pays1[$i]=$val_p["mem_pays"]; $i++; } } function afficher_specialite() { global $specialite,$total_s,$val_s; $db=new mysql; $db->connect(); $sql="SELECT DISTINCT `mem_specialite` from `membres`"; $db->query($sql); $total_s=mysql_num_rows($db->Query_ID); $i=1; while($val_s=mysql_fetch_array($db->Query_ID)) { $specialite[$i]=$val_s["mem_specialite"]; $i++; } } function afficher_ville() { global $ville1,$total_v,$val_v; $db=new mysql; $db->connect(); $sql="SELECT DISTINCT `mem_ville` from `membres` order by mem_ville"; $db->query($sql); $total_v=mysql_num_rows($db->Query_ID); $i=1; while($val_v=mysql_fetch_array($db->Query_ID)) { $ville1[$i]=$val_v["mem_ville"]; $i++; } } function aff_pays($pays) { global $title_pays,$val; $db=new mysql; $db->connect(); $sql="SELECT * from pays where pa_id='$pays'"; $db->query($sql); $val=mysql_fetch_array($db->Query_ID); $title_pays=$val["pa_nom"]; } function aff_spec($specialite) { global $title_spec,$val; $db=new mysql; $db->connect(); $sql="SELECT * from specialite where spec_code='$specialite'"; $db->query($sql); $val=mysql_fetch_array($db->Query_ID); $title_spec=$val["spec_intitule"]; } function aff_statut($statut) { global $title_statut,$val; $db=new mysql; $db->connect(); $sql="SELECT * from statut where sta_code='$statut'"; $db->query($sql); $val=mysql_fetch_array($db->Query_ID); $title_statut=$val["sta_intitule"]; } function rech_membres() { global $nom,$prenom,$ville,$email,$pays,$statut,$annee_sortie,$date_inscription,$cotisation,$maj,$type,$dernier_acces,$total,$num,$tab,$lim,$total_general,$nom_rech,$annee_sortie,$pays_rech,$crit,$sql1,$ville2; $db=new mysql; $db->connect(); if(!empty($_POST['nom_rech'])){ $nom_rech=$_POST['nom_rech']; $crit="where mem_nom='$nom_rech'"; } if(!empty($_POST['annee_sortie'])){ $annee_sortie=$_POST['annee_sortie']; $crit="where mem_anneefin='$annee_sortie'"; } if(!empty($_POST['pays_rech'])){ $pays_rech=$_POST['pays_rech']; $crit="where mem_pays='$pays_rech'"; } if(!empty($_POST['ville2'])){ $ville2=$_POST['ville2']; $crit="where mem_ville='$ville2'"; } $lim=$_GET['lim']; if(empty($ordre)){$ordre="mem_nom";} if(empty($lim)){$lim="0";} $sql1="SELECT * from `membres` $crit ORDER BY $ordre ASC"; $db->query($sql1); $total_general=mysql_num_rows($db->Query_ID); $sql="SELECT * from `membres` $crit ORDER BY $ordre ASC"; $db->query($sql); $total=mysql_num_rows($db->Query_ID); $i=1; while($tab=mysql_fetch_array($db->Query_ID)) { $num[$i]=$tab["mem_numero"]; $nom[$i]=$tab["mem_nom"]; $prenom[$i]=$tab["mem_prenom"]; $ville[$i]=$tab["mem_ville"]; $email[$i]=$tab["mem_email"]; $pays[$i]=$tab["mem_pays"]; $statut[$i]=$tab["mem_statut"]; $annee_sortie[$i]=$tab["mem_anneefin"]; $date_inscription[$i]=$tab["mem_inscription"]; $cotisation[$i]=$tab["mem_cotisation"]; $maj[$i]=$tab["mem_maj"]; $dernier_acces[$i]=$tab["mem_dernier_acces"]; $i++; } } function rech_membres2() { global $nom,$prenom,$ville,$email,$pays,$statut,$annee_sortie,$date_inscription,$cotisation,$maj,$type,$dernier_acces,$total,$num,$tab,$lim,$total_general,$nom_rech,$annee_sortie,$pays_rech,$crit,$sql1,$ville2; $db=new mysql; $db->connect(); if(!empty($_POST['nom_rech'])){ $nom_rech=$_POST['nom_rech']; $crit="where mem_nom='$nom_rech'"; } if(!empty($_POST['annee_sortie'])){ $annee_sortie=$_POST['annee_sortie']; $crit="where mem_anneefin='$annee_sortie'"; } if(!empty($_POST['pays_rech'])){ $pays_rech=$_POST['pays_rech']; $crit="where mem_pays='$pays_rech'"; } if(!empty($_POST['ville2'])){ $ville2=$_POST['ville2']; $crit="where mem_ville='$ville2'"; } $lim=$_GET['lim']; if(empty($ordre)){$ordre="mem_nom";} if(empty($lim)){$lim="0";} $sql1="SELECT * from `membres` $crit ORDER BY $ordre ASC"; $db->query($sql1); $total_general=mysql_num_rows($db->Query_ID); $sql="SELECT * from `membres` $crit ORDER BY $ordre ASC"; $db->query($sql); $total=mysql_num_rows($db->Query_ID); $i=1; while($tab=mysql_fetch_array($db->Query_ID)) { $num[$i]=$tab["mem_numero"]; $nom[$i]=$tab["mem_nom"]; $prenom[$i]=$tab["mem_prenom"]; $ville[$i]=$tab["mem_ville"]; $email[$i]=$tab["mem_email"]; $pays[$i]=$tab["mem_pays"]; $statut[$i]=$tab["mem_statut"]; $annee_sortie[$i]=$tab["mem_anneefin"]; $date_inscription[$i]=$tab["mem_inscription"]; $cotisation[$i]=$tab["mem_cotisation"]; $maj[$i]=$tab["mem_maj"]; $dernier_acces[$i]=$tab["mem_dernier_acces"]; $i++; } } function add_user() { global $titre,$nom,$prenom,$adresse,$email,$date_naissance,$code_postal,$pays,$tel_perso,$tel_port,$tel_pro,$entreprise,$ville,$pays2,$fonction,$specialite_post,$entree,$sortie,$login,$pwd,$statut,$ville2; $db=new mysql; $db->connect(); $titre=$_POST['titre']; $no=$_POST['no']; $prenom=$_POST['prenom']; $adresse=$_POST['adresse']; $email=$_POST['email']; $date_naissance=$_POST['date_naissance']; $code_postal=$_POST['code_postal']; $ville=$_POST['ville']; $pays=$_POST['pays']; $tel_perso=$_POST['tel_perso']; $tel_port=$_POST['tel_port']; $tel_pro=$_POST['tel_pro']; $entreprise=$_POST['entreprise']; $ville2=$_POST['ville2']; $pays2=$_POST['pays2']; $fonction=$_POST['fonction']; $specialite_post=$_POST['specialite_post']; $entree=$_POST['entree']; $sortie=$_POST['sortie']; $login=$_POST['login']; $pwd=$_POST['pwd']; $statut=$_POST['statut']; $sql="INSERT into `membres` (mem_username,mem_passwd,mem_nom,mem_prenom,mem_date_naissance,mem_sexe,mem_rue,mem_cp,mem_ville,mem_pays,mem_email,mem_telperso,mem_telporta,mem_telprofe,mem_statut,mem_anneedeb,mem_anneefin,mem_fonction,mem_specialite,mem_entreprise,mem_ville_ent,mem_pays_ent,actif) VAlUES('$login','$pwd','$nom','$prenom','$date_naissance','$titre','$adresse','$code_postal','$ville','$pays','$email','$tel_perso','$tel_port','$tel_pro','$statut','$entree','$sortie','$fonction','$specialite','$entreprise','$ville2','$pays2','0')"; $db->query($sql); } function verif_acces_student() { global $user,$message,$val,$pwd; $user=$_POST['user']; $pwd=$_POST['pwd']; $db=new MYSQL; $db->connect(); $query="select * from membres where mem_username='$user' AND mem_passwd='$pwd'"; $db->query($query); if(mysql_num_rows($db->Query_ID)==0){ $message="Erreur d'authentification..."; } else{ session_start(); if(session_is_registered("identificateur")){ header("Location:log_error.php"); } else{ session_register("identificateur"); header("location:index.php"); } } } function verif_acces_student2() { global $user,$message,$val,$pwd; $user=$_POST['user']; $pwd=$_POST['pwd']; $db=new MYSQL; $db->connect(); $query="select * from membres where mem_username='$user' AND mem_passwd='$pwd'"; $db->query($query); if(mysql_num_rows($db->Query_ID)==0){ $message="Erreur d'authentification..."; } else{ session_start(); if(session_is_registered("identificateur")){ header("Location:log_error.php"); } else{ session_register("identificateur"); header("location:index.php"); } } } function verif_session_student() { session_start(); if(!session_is_registered("identificateur")) { header("Location:log_error.php"); } } function lost_email() { global $mail,$login,$password,$tab,$error,$texte,$entete,$tot,$from,$sujet,$sql,$lost_email; $db=new mysql; $db->connect(); $lost_email=$_POST['lost_email']; $sql="SELECT mem_username,mem_passwd from `membres` where mem_email='$lost_email'"; $db->query($sql); $tot=mysql_num_rows($db->Query_ID); if($tot=='0') { $error='1'; }else { $tab=mysql_fetch_array($db->Query_ID); $login=$tab["mem_username"]; $password=$tab["mem_passwd"]; $from="noreplay2alta@2alta.org"; $sujet = "Oublie de Mot de passe"; $entete = "MIME-Version: 1.0\n"; $entete .= "Content-type: text/html; charset=iso-8859-1\n"; $entete .= "From: $from\n"; $entete .= "Association 2ALTA vous fournie les informations d'identification
"; $texte = "----------------------------------------
"; $texte .= " Login : $login
"; $texte .= " Mot de passe : $password
"; $texte .= "Cordialement."; @mail($lost_email,$sujet,$texte,$entete); } } ?> industrie

Mots clé à la une

Organismes liés

Annuaire

Accueil / Annuaire

Annuaire des associations professonnelles Annuaire des entreprises Annuaire des bureaux d'études

Téléchargez le catalogue des associations professionnelles et des organisations patronales et syndicales à caractère économique. Téléchargez le Catalogue des Bureaux d’Etudes et de Consulting.
 SGP  Domaine d'activites  President  Adresse  Tel  Fax  Site Web
CABELEQ Câblerie et équipements électriques Mr ZINE Hocine 62, Rue Krim BELKACEM Télemly ALGER 021.74.35.09 021.73.38.13 www.sgp-cabeleq.dz
CEGRO Céréales Mr SOKHAL Ramdane 23, Rue des Fusillés du 17 Mai 1957 Ruisseau Alger 021.67.89.99 021.67.74.22 /
COJUB Boisson, jus et conserves Mr SEBBAH Ahmed 23, Rue des Fusillés du 17 Mai 1957 Ruisseaux Alger 021.67.56.05 021.67.56.06 www.cojub.com
CONSTRUMET Constructions métalliques Mr LAHLOU Youcef SNS Ravin Sidi Yahia Le Paradou Hydra ALGER 021.48.24.15-
021.69.21.83/82
021.48.24.15-
021.69.25.66
www.construment.dz
DIPREST Prestations Diverses Mr HAMITI Messaoud 06 , Rue Bouteldja M'hrach Hussein Dey , Alger 021.47.01.27-
021.47.00.18/34/35-
021.47.02.63-
021.47.03.20
021.47.00.03 www.sgp-diprest.dz
EQUIPAG Equipements industriels et agricoles Mr DEHIMI Bachir Pavillon 1&2 la butte des deux bassins.El Achour Alger 021.94.73.19/15 021.94.73.17 www.sgpequipag.dz
ERGTHY Travaux Hydrauliques Mr AIT DAHMANE Med Kamel 24,rue Mustapha KHALEF Ben Aknoun -ALGER- 021.91.13.55-
021.91.11.94-
021.91.12.32
021.91.13.48-
021.91.12.93
www.sgp-ergthy.com
FIDBER Transports Terrestres Mr SAID CHERIF Mahmoud 1, Rue Yahia LAYACHI Hussein Dey - Alger 021.49.62.79-
021.77.80.11
021.49.60.78 /
GENEST Etudes et Engineering Mr BOUSSAHBA Abdelkader 1, Rue Kaddour Rahim Hussein Dey , Alger 021.47.99.34-
021.49.64.64
021.47.99.33 www.genest.dz
GEPHAC Chimie et Pharmecie Mr BOUNAB Cherif 1 , Rue Yahia LAYACHI Hussein Dey Alger 021.49.60.82-
021.23.20.58
021.49.60.84 www.sgp-gephac.dz
GESTOUR Tourisme et Hotellerie Mr.MESSAID Med Lamine Site Sider -07 ,Chemin du Paradou - Alger 021.48.38.86-
021.54.95.33/26/28/34
021.54.95.30/25/33 www.sgp-gestour.com
GESTRAMAR Transports Maritimes Mr SNOUSSI Mohamed 17,Rue RAKOUBA Abdelkader - Hussein Dey - Alger 021.77.46.32 021.49.60.80 www.gestramar.dz
GICA Industries du ciment Mr AIBECHE Mokhtar 7 , Chemin AMANI Belkacem - Site SIDER- Hydra - ALGER 021.60.50.05-
021.48.25.41/84-
021.60.10.74-
021.60.28.69
021.48.25.84 www.sgp-gica.dz
IM Industrie Manufacturi?¨res Mr SAIDANI Abdelhak 131, Rue Hassiba BENBOUALI Alger 021.67.92.85 021.67.02.28 /
INDELEC Industries ?©lectro-domestiques Mr FETOUHI Ahmed 4 et Boulvard Mohamed V - Alger 021.63.76.97-
021.63.16.56-
021.63.72.97
021.63.72.48 /
INDJAB R?©alisation et Batiments Mr FASSOULI Hafid 3 , Avenue des Frères BOUADOU-BirMouradRais-ALGER 021.54.39.75-
021.56.44.75
021.54.40.11-
021.54.44.43
/
IPRS Industrie des produits rouges et sanitaires Mr BOUZID Said Site Sider Paradou Hydra Alger 021.48.46.25-
021.54.95.84/85/87-
021.54.95.86-
021.54.95.83
021.60.38.72 /
PRODA Productions Animales MR CHADI Kamel 23 Rue des Fusillés du 17 Mai 1957 , Ruisseau , Alger 021.67.88.09 021.67.40.14
021.67.74.21
www.proda.dz
SGDA Développemnt Agricole Mr BELHOUADJEB Baizid 23 , Rue des Fusillés du 17 Mai 1957 Ruisseau Alger 021.67.17.85-
021.67.18.47
021.67.44.53-
021.67.92.14
/
SGP CENTRE Entreprises locales du centre (Activités diverses) Mr BOUCHEFA Rachid Pavillon n°12 Résidence la Butte des deux bassins El Achour ,Alger 021.94.75.92-
021.94.73.37-
021.94.93.65-
021.94.93.84/85-
021.94.75.83
021.94.76.13-
021.94.73.36-
021.94.75.59
www.sgp-centre.com.dz
SGP EST / SUD EST Entreprises locales de l'Est (activités diverses) Mr.HOUFANI Djamel 03 , Rue Chenefi Mohamed , Annaba 038.80.43.59-
038.80.43.57-
038.86.08.41/42-
038.80.42.95
038.80.42.96 /
SGP OUEST Entreprises locales de l'ouest (activités diverses) Mr.ABDELSADOUK Abdelkader 4 , Rue Ferh El-Hadj , Hai Oussama (ex :Boulager) , Oran 041.32.81.76-
041.32.72.57-
041.32.64.81-
041.32.58.52
041.32.81.68 www.sgp-ouest.com
SINTRA Travaux Publics M.BENDAHMANE Sidi Mohamed 7 , Rue Abderahmane HAMANI , Paradou-hydra 021.54.93.30/31-
021.54.93.27/25/26
021.48.26.11/04 /
SOGEPORTS Ports Mr KHELIL.Fa?¯?§al 7 Chemin AMANI BelkacemSite SIDER Paradou Hydra 021.48.25.49-
021.54.79.83/85-
021.48.45.27
021.48.26.46 www.ports-de-peche-algerie.com
SOMINES Mines Mr SLOUGUI Abdelhamid 127, Bld Krim Belkacem Telemly Alger 021.74.91.86-
021.74.16.07-
021.74.68.33-
021.74.17.62
021.74.15.59 /
TRAGRAL TransformationsAgro -Alimentaires Mr BENSEGUNI Med Tahar 22,Rue des Fusillés du 17 Mai 1957 Ruisseau Alger 021.67.45.85-
021.67.74.24-
021.67.42.21
021.67.90.47/48 www.sgp-tragral.dz
TRANSLOB TransformationsSidérurgiques Mr TAHARI Slimane SNS Ravin Sidi Yahia paradou -Hydra 021.48.26.98/96-
021.48.27.06/08
021.69.44.43/37 www.translob.com