Exemplo n.º 1
0
			  $zResSQLUser = mysql_query($zSqlInfoUser);
			  $zResUsers = mysql_fetch_assoc($zResSQLUser);

				$civilite = CFunctions::clean($zResUsers["civilite"]);
				$nom = CFunctions::clean($zResUsers["nom"]);
				$prenom = CFunctions::clean($zResUsers["prenom"]);
				$adresse = CFunctions::clean($zResUsers["adresse"]);
				$cp = CFunctions::clean($zResUsers["cp"]);
				$ville = CFunctions::clean($zResUsers["ville"]);
				$pays = CFunctions::clean($zResUsers["pays"]);
				$email = CFunctions::clean($zResUsers["email"]);
				$telephone = trim($zResUsers["telephone"]);
				$mobile = trim($zResUsers["mobile"]);
				$societe = CFunctions::clean($zResUsers["societe"]);
				$web = CFunctions::clean($zResUsers["web"]);
				$commentaire = CFunctions::clean($zResUsers["commentaire"]);

		  //-- Enregistrement des données de la table user dans la table gr_user pour le contact d'id donné
		    $zQuery = "INSERT INTO gr_user (user_id, civilite, nom, prenom, adresse, cp, ville, pays, email, telephone, mobile, societe, web, commentaire) VALUES (
		    	'" . $zUser . "',
		    	'" . $civilite . "',
		    	'" . str_replace ("'", "''", $nom) . "',
		    	'" . str_replace ("'", "''", $prenom) . "',
		    	'" . str_replace ("'", "''", $adresse) . "',
		    	'" . $cp . "',
		    	'" . str_replace ("'", "''", $ville) . "',
		    	'" . str_replace ("'", "''", $pays) . "',
		    	'" . $email . "',
		    	'" . $telephone . "',
		    	'" . $mobile . "',
		    	'" . str_replace ("'", "''", $societe) . "',
Exemplo n.º 2
0
			$timg->delete();
	}
	else CBdd::update("UPDATE entreprise SET paiement_abo ='" . $paiement_abo . "', paiement_pre ='" . $paye_p . "',montant_v='" .$montant_vignette. "',montant_pre='" .$montant_p. "',url='" .$url_1. "',ent='" .$ent. "',resp_ent='" .CFunctions::addslashes($responsable). "', nom_ent='" .CFunctions::addslashes($societe). "', rue_adr='" .CFunctions::addslashes($adresse). "', commune_alias='" .CFunctions::addslashes($ville). "', pays_ent='" .$pays. "', mail_ent='" .$email. "', tel_ent='" .$telephone. "', web_ent='" .$web. "', etatcontact_ent='" .$etat_contact. "', idopportunite='" .$idopportunite. "', commentaire='" .$commentaire. "', dateajout_ent='" .$date. "', descr_ent='" .CFunctions::addslashes($description). "' WHERE id_ent='" . $id_ent. "'");
	
	$zSql  = " SELECT * FROM entreprise " ;
    $zSql .= " INNER JOIN cat ON id_cat = categorie_ent " ;
    $zSql .= " INNER JOIN secteur ON id_sec = secteur_cat " ;
    $zSql .= " WHERE id_ent = " . $id_ent ;
    
    $toUsers = CBdd::select_row($zSql);
	
	//print_r($toUsers['cp_adr']);
	
	
	// RDV
	if(!empty($_POST['nom_rdv'])) 		$nom_rdv 		= CFunctions::clean($_POST['nom_rdv']);
	if(isset($_POST['type_rdv'])) 		$type_rdv		= $_POST['type_rdv'];
	if(!empty($_POST['etat_rdv'])) 		$etat_rdv 		= $_POST['etat_rdv'];
	if(!empty($_POST['date_rdv'])) 		$date_rdv		= $_POST['date_rdv'];
	if(!empty($_POST['heure_rdv'])) 	$heure_rdv		= $_POST['heure_rdv'];
	

	if(!CTableUser::login_dispo($login, " AND id != $id")) {
		//erreur de type login non dispo
		$msginfo = "Login non disponible";
		$a = 5;
		break;
	}
	if(CTableUserContact::is_admin($_SESSION['idmbr'])) {
		$tuse = new CTableUserContact(array('id_ent'=>$id, 'login_ent'=>$login, 'password_ent'=>$passe, 'resp_ent'=>CFunctions::addslashes($responsable), 'commune_adr'=>CFunctions::addslashes($adresse),  'rue_adr'=>CFunctions::addslashes($adresse), 'pays_ent'=>$pays, 'mail_ent'=>CFunctions::addslashes($email), 'tel_ent'=>CFunctions::addslashes($telephone), 'nom_ent'=>CFunctions::addslashes($societe), 'web_ent'=>CFunctions::addslashes($web), 'etat_contact'=>$etat_contact, 'date_contact'=>$date_contact, 'descr_ent'=>CFunctions::addslashes($description), 'etat_ent'=>$etat, 'type'=>$type, 'idopportunite'=>$idopportunite));
	} else {
Exemplo n.º 3
0
 <h2>Informations personnelles</h2>
 <p>
   <label>Civilit&eacute;</label>
   <input type="radio" value="3" <?php echo CForm::get_checked($civilite, 3) ?> name="civilite"/>
   M.
   <input type="radio" value="1" <?php echo CForm::get_checked($civilite, 1) ?> name="civilite"/>
   Mme
   <input type="radio" value="2" <?php echo CForm::get_checked($civilite,2) ?> name="civilite"/>
   Mlle</p>
 <p>
   <label>Nom </label>
   <input name="nom" type="text" value="<?php echo  $nom?>" />
 </p>
 <p>
   <label>Pr&eacute;nom </label>
   <input name="prenom" type="text" value="<?php echo  CFunctions::clean($prenom)?>" />
 </p>
 <p>
   <label>Soci&eacute;t&eacute;</label>
   <input name="societe" type="text" value="<?php echo $societe?>" />
 </p>
 <p>
   <label>Adresse</label>
   <input name="adresse" type="text" value="<?php echo  $adresse?>" />
 </p>
 <p>
   <label>Code postal</label>
   <input name="cp" type="text" value="<?php echo  $cp?>" />
 </p>
 <p>
   <label>Ville </label>