$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) . "',
$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 {
<h2>Informations personnelles</h2> <p> <label>Civilité</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énom </label> <input name="prenom" type="text" value="<?php echo CFunctions::clean($prenom)?>" /> </p> <p> <label>Société</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>