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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
|
$out0 = convertDate ($_POST['rencDate']);
$out1 = 55.665*intval ($_POST['latt']);
$out2 = 55.665*intval ($_POST['longt']);
$out3 = testNull ($_POST['nbPlacesMax']);
return <<<OUT
INSERT INTO rencontres
(membId,
title,
active,
inscriptions,
rencDate,
rencHeure,
adresse,
ville,
codePostal,
Pays,
latt,
longt,
zoom,
deltaLatt,
deltaLongt,
rencUrl,
lieu,
Tel,
courriel,
nbPlacesMax,
summary,
description,
compteRendu,
image ,
align ,
withLegend,
withFrame,
infos ,
links,
docs,
diapos,
avecConjoint,
option1,
option2,
option3,
option4,
option5
)
VALUES
({$_POST['membId']},
'{$_POST['title']}',
{$_POST['active']},
{$_POST['inscriptions']},
$out0,
'{$_POST['rencHeure']}',
'{$_POST['adresse']}',
'{$_POST['ville']}',
'{$_POST['codePostal']}',
'{$_POST['Pays']}',
'{$_POST['latt']}',
'{$_POST['longt']}',
{$_POST['zoom']},
$out1,
$out2,
'rencUrl',
'{$_POST['lieu']}',
'{$_POST['Tel']}',
'{$_POST['courriel']}',
$out3,
'{$_POST['summary']}',
'{$_POST['description']}',
'{$_POST['compteRendu']}',
image ,
'align' ,
withLegend,
withFrame,
'infos' ,
'links',
'docs',
'diapos',
{$_POST['avecConjoint']},
'{$_POST['option1']}',
'{$_POST['option2']}',
'{$_POST['option3']}',
'{$_POST['option4']}',
'{$_POST['option5']}'
)
OUT; |