Autant pour moi, désolé, de plus, je dois pas être révéillé, je cherche le bouton éditer ! ( il à du être kidnappé dans la nuit). Promis, la prochaine fois, je n’oublierai pas.
Voici mon probléme,
j’ai un code qui me récupére dans la base les infos d’un véhicule, dans la foulée, ces infos sont envoyées dans un pdf qui s’affiche à l’écran.
Mon probléme est le suivant, le pdf est bien généré, mais je récupére seulement les variables suivantes :
‘Bjour’ => $stored_day,
‘Bmois’ => $stored_month,
‘Bannee’ => $stored_year,
‘D1’ => $model,
‘E’ => $vin,
Je ne récupére rien d’autre…
Voici le code :
<?php
include('../../include/ErrorHandler/error_handler.php');
include('../../include/global.php');
include('../include/auth.php');
include('../../include/connection.php');
include('../../include/functions.php');
include('../../include/validation.php');
if(!isset($HTTP_GET_VARS["id"]) || $HTTP_GET_VARS["id"]=="")
die(header('location: index.php'));
$error_msg = "";
$msg = "";
if($HTTP_SERVER_VARS['REQUEST_METHOD']=="POST")
{
/**** SERVER VALIDATION ****/
if(!(chk($HTTP_POST_VARS['year'],"IsNotEmpty,IsNumber")))
$error_msg.= "- Please enter a Year<br>";
if(!(chk($HTTP_POST_VARS['model'],"IsNotEmpty")))
$error_msg.= "- Please enter a Make<br>";
if(!(chk($HTTP_POST_VARS['type'],"IsNotEmpty")))
$error_msg.= "- Please enter a Model<br>";
if(!(chk($HTTP_POST_VARS['engine'],"IsNotEmpty")))
$error_msg.= "- Please enter an Engine<br>";
if(!(chk($HTTP_POST_VARS['trans'],"IsNotEmpty")))
$error_msg.= "- Please enter a Trans<br>";
if(!(chk($HTTP_POST_VARS['drive'],"IsNotEmpty")))
$error_msg.= "- Please enter a Drive<br>";
if(!(chk($HTTP_POST_VARS['color'],"IsNotEmpty")))
$error_msg.= "- Please enter a Color<br>";
if(!(chk($HTTP_POST_VARS['millage'],"IsNotEmpty,IsNumber")))
$error_msg.= "- Please enter a valid numeric value for Mileage<br>";
if(!(chk($HTTP_POST_VARS['price'],"IsMoney")))
$error_msg.= "- Please enter a valid money value for Price<br>";
/*
if(!(chk($HTTP_POST_VARS['low'],"IsMoney")))
$error_msg.= "- Please enter a valid money value for Low Book<br>";
if(!(chk($HTTP_POST_VARS['high'],"IsMoney")))
$error_msg.= "- Please enter a valid money value for High Book<br>";
*/
if(!(chk($HTTP_POST_VARS['certified'],"IsSelected")))
$error_msg.= "- Please select an option for Certified<br>";
if(isset($HTTP_POST_VARS['special']))
$special="Y";
else
$special="N";
if($error_msg == "")
{
#############################################################################
# IF MAGIC QUOTE IN PHP.INI IS SET OFF ADD SLASHES TO SUBMITED VARIABLES #
#############################################################################
$sql = "UPDATE ".$db_prefix."cars SET
stored='".$HTTP_POST_VARS['stored_year']."-".$HTTP_POST_VARS['stored_month']."-".$HTTP_POST_VARS['stored_day']."',
year='".add_slashes($HTTP_POST_VARS['year'])."',
model='".add_slashes($HTTP_POST_VARS['model'])."',
type='".add_slashes($HTTP_POST_VARS['type'])."',
engine='".add_slashes($HTTP_POST_VARS['engine'])."',
trans='".add_slashes($HTTP_POST_VARS['trans'])."',
drive='".add_slashes($HTTP_POST_VARS['drive'])."',
color='".add_slashes($HTTP_POST_VARS['color'])."',
millage='".add_slashes($HTTP_POST_VARS['millage'])."',
vin='".add_slashes($HTTP_POST_VARS['vin'])."',
price='".add_slashes(strip_out($HTTP_POST_VARS['price']))."',
low='".add_slashes(strip_out($HTTP_POST_VARS['low']))."',
high='".add_slashes(strip_out($HTTP_POST_VARS['high']))."',
features='".add_slashes($HTTP_POST_VARS['features'])."',
comments='".add_slashes($HTTP_POST_VARS['comments'])."',
certified='".add_slashes($HTTP_POST_VARS['certified'])."',
special= '".$special."',
datedevente='".$HTTP_POST_VARS['datedevente_year']."-".$HTTP_POST_VARS['datedevente_month']."-".$HTTP_POST_VARS['datedevente_day']."',
immatriculation='".add_slashes($HTTP_POST_VARS['immatriculation'])."',
typeduvehicule='".add_slashes($HTTP_POST_VARS['typeduvehicule'])."',
genre='".add_slashes($HTTP_POST_VARS['genre'])."',
carrosserie='".add_slashes($HTTP_POST_VARS['carrosserie'])."',
cv='".add_slashes($HTTP_POST_VARS['cv'])."',
kms_certifies='".add_slashes($HTTP_POST_VARS['kms_certifies'])."',
nom_acheteur='".add_slashes($HTTP_POST_VARS['nom_acheteur'])."',
adresse_acheteur='".add_slashes($HTTP_POST_VARS['adresse_acheteur'])."',
cp_acheteur='".add_slashes($HTTP_POST_VARS['cp_acheteur'])."',
ville_acheteur='".add_slashes($HTTP_POST_VARS['ville_acheteur'])."'
WHERE id=".$HTTP_GET_VARS["id"];
if(@mysql_query($sql))
die(header("Location: index.php?status=update"));
else
$error_msg = "Record was not updated because of invalid data posted.<br>- Stock must be unique.";
}
else//if($error_msg == "")
$error_msg = "Record was not updated because of invalid data posted.<br>".$error_msg;
$member_id = $HTTP_POST_VARS["member_id"];
$stock = $HTTP_POST_VARS["stock"];
$stored_month = $HTTP_POST_VARS["stored_month"];
$stored_day = $HTTP_POST_VARS["stored_day"];
$stored_year = $HTTP_POST_VARS["stored_year"];
$year = $HTTP_POST_VARS["year"];
$model = $HTTP_POST_VARS["model"];
$type = $HTTP_POST_VARS["type"];
$engine = $HTTP_POST_VARS["engine"];
$trans = $HTTP_POST_VARS["trans"];
$drive = $HTTP_POST_VARS["drive"];
$color = $HTTP_POST_VARS["color"];
$millage = $HTTP_POST_VARS["millage"];
$vin = $HTTP_POST_VARS["vin"];
$price = $HTTP_POST_VARS["price"];
$low = $HTTP_POST_VARS["low"];
$high = $HTTP_POST_VARS["high"];
$features = $HTTP_POST_VARS["features"];
$comments = $HTTP_POST_VARS["comments"];
$certified = $HTTP_POST_VARS["certified"];
$datedevente_month = $HTTP_POST_VARS["datedevente_month"];
$datedevente_day = $HTTP_POST_VARS["datedevente_day"];
$datedevente_year = $HTTP_POST_VARS["datedevente_year"];
$immatriculation = $HTTP_POST_VARS["immatriculation"];
$typeduvehicule = $HTTP_POST_VARS["typeduvehicule"];
$genre = $HTTP_POST_VARS["genre"];
$carrosserie = $HTTP_POST_VARS["carrosserie"];
$cv = $HTTP_POST_VARS["cv"];
$kms_certifies = $HTTP_POST_VARS["kms_certifies"];
$nom_acheteur = $HTTP_POST_VARS["nom_acheteur "];
$adresse_acheteur = $HTTP_POST_VARS["adresse_acheteur "];
$cp_acheteur = $HTTP_POST_VARS["cp_acheteur"];
$ville_acheteur = $HTTP_POST_VARS["ville_acheteur"];
}
else
{
$sql = "SELECT * FROM ".$db_prefix."cars
WHERE id=".$HTTP_GET_VARS["id"]."
AND member_id=".$HTTP_SESSION_VARS['ses_mem_id'];
$rs = @mysql_query($sql) or trigger_error('Error on executing '.$sql, E_USER_ERROR);
if(mysql_num_rows($rs)==0)
die(header("location: index.php"));
list($id,
$member_id,
$stock,
$stored,
$year,
$model,
$type,
$engine,
$trans,
$drive,
$color,
$millage,
$vin,
$price,
$low,
$high,
$features,
$comments,
$certified,
$special) = mysql_fetch_array($rs);
list($stored_year,$stored_month,$stored_day) = explode("-",$stored);
list($datedevente_year,$datedevente_month,$datedevente_day) = explode("-",$datedevente);
$typeduvehicule;
$genre;
$carrosserie;
$cv;
$kms_certifies;
$nom_acheteur;
$adresse_acheteur;
$cp_acheteur;
$ville_acheteur;
}
// adresse ou se trouve le fichier pdf
$form = 'http://www.doublet-automobiles.com/search/cession.pdf';
function create_fdf ($pdffile, $strings, $keys)
{
$fdf = "%FDF-1.2\n%????\n";
$fdf .= "1 0 obj \n<< /FDF << /Fields [\n";
foreach ($strings as $key => $value)
{
$key = addcslashes($key, "\n\r\t\\()");
$value = addcslashes($value, "\n\r\t\\()");
$fdf .= "<< /T ($key) /V ($value) >> \n";
}
foreach ($keys as $key => $value)
{
$key = addcslashes($key, "\n\r\t\\()");
$fdf .= "<< /T ($key) /V /$value >> \n";
}
$fdf .= "]\n/F ($pdffile) >>";
$fdf .= ">>\nendobj\ntrailer\n<<\n";
$fdf .= "/Root 1 0 R \n\n>>\n";
$fdf .= "%%EOF";
return $fdf;
}
// listage
$strings = array(
'nom1' => 'DOUBLET AUTOMOBILES',
'nom2' => '',
'adresse' => 'ZA LE PRE DROUE',
'codepostal' => '88150',
'ville' => 'CHAVELOT',
'Bjour' => $stored_day,
'Bmois' => $stored_month,
'Bannee' => $stored_year,
'D1' => $model,
'E' => $vin,
'numeroimmatriculation' => $immatriculation,
'D2' => $typeduvehicule,
'J1' => $genre,
'J3' => $carrosserie,
'P6' => $cv,
'anomprénom' => $nom_acheteur,
'adresse1' => $adresse_acheteur,
'codepostal1' => $cp_acheteur,
'ville1' => $ville_acheteur,
'lieu' => 'CHAVELOT',
'date' => '16/06/2006'
);
// listage des cases a cocher / boutons radios
$keys = array('
gender' => 'male',// bouton radio
'transformation' => 'on',// case a cocher
'vendu' => 'on',// case a cocher
'urgent' => 'On'// case a cocher
);
// Output du formulaire
header('Content-type: application/vnd.fdf');
echo create_fdf($form, $strings, $keys);
?>
Merci pour votre aide