[insert_php]
$userid = $_POST[last_name];
global $pict_file;
global $modtrad_page;
global $comid;
global $connect;
$connect = mysqli_connect( ’emanetorg.mysql.db’, ’emanetorg’, ‘Xt6PsTNdS2′, ’emanetorg’ ) or die ( “Connexion au serveur sql impossible” );
$req = mysqli_query( $connect, “SELECT created_on,first_name,last_name, gender, website,occupation,otheroccupation,enrolement,active,otheractivity,specialisation, specificcompetence,research,language,language2,language3,language4,language5,address,city,zip,country,phone,consulted,eu_projects,repres_ema,ema_journal,special_interest,special_interest2,special_interest3,address_p,city_p,zip_p,country_p,phone_p,publish,userid,email,other_specialisation,other_specific_competences FROM SaveContactForm7_8 WHERE userid = ‘$userid'” ) or die( ‘Erreur SQL84zz !’ . mysqli_error() );
while ($res = mysqli_fetch_array($req)) {
$first_name = $res[first_name];
$last_name = $res[last_name];
$gender = $res[gender];
$occupation = $res[occupation];
$website = $res[website];
$otheroccupation = $res[otheroccupation];
$enrolement = $res[enrolement];
$active = $res[active];
$otheractivity = $res[otheractivity];
$specialisation = $res[specialisation];
$other_specialisation = $res[other_specialisation];
$specificcompetence = $res[specificcompetence];
$other_specific_competences = $res[other_specific_competences ];
$research = $res[research];
$special_interest = $res[special_interest];
$special_interest2 = $res[special_interest2];
$special_interest3 = $res[special_interest3];
$language = $res[language];
$language2 = $res[language2];
$language3 = $res[language3];
$language4 = $res[language4];
$language53 = $res[language5];
$address = $res[address];
$city = $res[city];
$zip = $res[zip];
$country = $res[country];
$phone = $res[phone];
$consulted = $res[consulted];
$eu_projects = $res[eu_projects];
$repres_ema = $res[repres_ema];
$ema_journal = $res[ema_journal];
$address_p = $res[address_p];
$city_p = $res[city_p];
$zip_p = $res[zip_p];
$country_p = $res[country_p];
$phone_p = $res[phone_p];
$email = $res[email];
}
$modtrad_page = “
Doctor data\’s |
| First name : ‘.$first_name.’ |
| Last name : ‘.$last_name.’ |
| Email : ‘.$email.’ |
| Gender : ‘.$gender.’ |
| Occupation : ‘.$occupation.’ |
| Other occupation : ‘.$otheroccupation.’ |
| Nr. of enrollment on the professional register : ‘.$enrolement.’ |
| Active in : ‘.$active.’ |
| Other activity: ‘.$otheractivity .’ |
| Specialisation / sub-specialisation : ‘.$specialisation.’ |
| Other specialisation : ‘.$other_specialisation.’ |
| Specific competence : ‘.$specificcompetence.’ |
| Other specific competences : ‘.$other_specific_competences.’ |
| Research in which you are involved : ‘.$research.’ |
| Area of special interest 1: ( not mentioned above ) : ‘.$special_interest.’ |
| Area of special interest 2: ( not mentioned above ) : ‘.$special_interest2.’ |
| Area of special interest 3: ( not mentioned above ) : ‘.$special_interest3.’ |
| Languages 1: ‘.$language.’ |
| Languages 2: ‘.$language2.’ |
| Languages 3: ‘.$language3.’ |
| Languages 4: ‘.$language4.’ |
| Languages 5: ‘.$language5.’ |
| Do I accept to be consulted?: ‘.$consulted.’ |
Location : |
| Address : ‘.$address.’ |
| City : ‘.$city.’ |
| Post code : ‘.$zip.’ |
| Country : ‘ . $country . ‘ |
| Phone : ‘.$phone.’ |
Documents : |
| Copy of state license of the right to run medical practice for internal use only |
| Copy of state license of the right to run medical practice for internal use only |
| Copy of accreditation certificates issued by national or international accreditation bodies for internal use only |
| List of scientific articles, publications and teaching activities (scanned copies/links to online versions) published |
| Feedback from patients and publications (if there are available ) published |
| Statistical data (if there are available ) published |
“;
echo $modtrad_page;
[/insert_php]