1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| $query = "INSERT INTO `jos_contact_details` ";
$query = $query. " ( `id` , `firstname` , `name` , `con_position` , `address` , `suburb` , `state` ";
$query = $query. " ,`country` , `postcode` , `telephone` , `fax` , `anneeDiplome1` , `ecole1` , `diplome1` ";
$query = $query. " , `anneeDiplome2` , `ecole2` , `diplome2` , `anneeDiplome3` , `ecole3` , `diplome3` ";
$query = $query. " , `anneeDiplome4` , `ecole4` , `diplome4` , `competence1`, `competenceNiveau1` ";
$query = $query. " , `competence2`, `competenceNiveau2` , `competence3`, `competenceNiveau3` ";
$query = $query. " , `competence4`, `competenceNiveau4` , `competence5`, `competenceNiveau5` ";
$query = $query. " , `competence6`, `competenceNiveau6` , `competence7`, `competenceNiveau7` ";
$query = $query. " , `competence8`, `competenceNiveau8` , `competence9`, `competenceNiveau9` ";
$query = $query. " , `competence10`, `competenceNiveau10` ";
$query = $query. " , `experience1` , `langueNiveau1` , `langue1` , `langueNiveau2` , `langue2` , `langueNiveau3` ";
$query = $query. " , `langue3` , `langueNiveau4`, `langue4`, `image` , `imagepos` , `email_to` , `default_con` ";
$query = $query. " , `published` , `checked_out` , `checked_out_time`, `ordering` , `user_id` ";
$query = $query. " , `catid` , `access` ) ";
$query = $query. " VALUES ( NULL, `$firstname`, `$name`, `$con_position`, `adress`, `$suburb`, `$state` , ";
$query = $query. " `$country`, `$postcode`, `$telephone`, `$fax`, `$anneeDiplome1` , `$ecole1` , `$diplome1` , ";
$query = $query. " `$anneeDiplome2` , `$ecole2` , `$diplome2` , `$anneeDiplome3` , `$ecole3` , `$diplome3` , ";
$query = $query. " `$anneeDiplome4` , `$ecole4` , `$diplome4` , `$competence1`, `$_POST[competenceNiveau1]` , ";
$query = $query. " `$competence2`, `$_POST[competenceNiveau2]`, `$competence3`, `$_POST[competenceNiveau3]` , ";
$query = $query. " `$competence4`, `$_POST[competenceNiveau4]`, `$competence5`, `$_POST[competenceNiveau5]` , ";
$query = $query. " `$competence6`, `$_POST[competenceNiveau6]`, `$competence7`, `$_POST[competenceNiveau7]` , ";
$query = $query. " `$competence8`, `$_POST[competenceNiveau8]`, `$competence9`, `$_POST[competenceNiveau9]` , ";
$query = $query. " `$competence10`, `$_POST[competenceNiveau10]` , ";
$query = $query. " `$experience1`, `$_POST[niveauLangue1]`, `$langue1`, `$_POST[niveauLangue2]`, `$langue2` , ";
$query = $query. " `$_POST[niveauLangue3]`, `$langue3`, `$_POST[niveauLangue4]`, `$langue4`, NULL, NULL, `$email_to`, `0`, `0`, `0` , ";
$query = $query. " `0000-00-00 00:00:00`, `0`, `0`, `$_POST[catid]`, `0` ) "; |
Partager