Alleen velden weergeven die ingevuld zijn - Forum

M Mitchell

26-05-2008 13:46

Crispijn schreef op 26.05.2008 13:44
Juist, indd

Wat ik doe is de post array uit elkaar trekken. Voor elke variabele binnen dit array ga je kijken of er inhoud is. Dus in jou geval een aantal.

Trim zorgt ervoor dat spaties ook weggehaald worden, en ook een 0 is niet mogelijk... handig ofnie :D

[edit]En zo'n code monkey ben ik nou ook weer niet hoor... Maar ervaring leert... [/edit]

[offtopic]
Wow, ik begin php te leren, creepy.. O.o'
[/offtopic]

P Pong Zor

26-05-2008 13:47

Crispin nu krijg ik idd wel wat ik wil maar toch nog niet helemaal.

Een output is b.v;

voornaam : d
achternaam : d
adres : [email protected]
email : d
mc_fm_43 : 2
mc_fm_60 : 2
mc_fm_64 : 2
mc_fm_76 : 2
mc_fm_78 : 2
mc_fm_83 : 2
mc_fm_85 : 2
mc_fm_93 : 2
mc_fm_133 : 2
mc_fm_136 : 2
mc_fm_137 : 2
MM_insert : form1

eigenlijk zou dat mc_fm_ vervangen moeten worden door Mannen Classic, is dat ook nog mogelijk?

Crispijn -

26-05-2008 13:47

Ehm, je zit ook op een php forum he... Wat doe je hier anders :P

M Mitchell

26-05-2008 13:51

Dennis schreef op 26.05.2008 13:47
Crispin nu krijg ik idd wel wat ik wil maar toch nog niet helemaal.

Een output is b.v;

voornaam : d
achternaam : d
adres : [email protected]
email : d
mc_fm_43 : 2
mc_fm_60 : 2
mc_fm_64 : 2
mc_fm_76 : 2
mc_fm_78 : 2
mc_fm_83 : 2
mc_fm_85 : 2
mc_fm_93 : 2
mc_fm_133 : 2
mc_fm_136 : 2
mc_fm_137 : 2
MM_insert : form1

eigenlijk zou dat mc_fm_ vervangen moeten worden door Mannen Classic, is dat ook nog mogelijk?

Ik neem aan dat de id/naam is, dan haal je toch gewoon die weer door een filter van je mysql en vertaald ze opdezelfde manier die je gebruikt bij waar je de hoeveelheden moet invullen? ;]

Crispijn schreef op 26.05.2008 13:47
Ehm, je zit ook op een php forum he... Wat doe je hier anders :P

Kom anders vaak genoeg reviews/css fouten tegen hier en daar ben ik wel weer heel goed in. ;]

P Pong Zor

26-05-2008 13:55

Ik heb het nu zo:


if ($key == "MM_insert")
{
  $key = "";
  $value = "";
}

Oftewel ik zie nu die waarde


MM_insert : form1

Niet meer, dit is ook goed!
Even kijken of dat ook lukt met mc_fm_

Oke, dat lukt dus niet is er een manier om te checken of de $key mc_fm_ bevat en als hij dat bevat mc_fm te veranderen in Mannen Classic?

Crispijn -

26-05-2008 14:00

nu geef je voorbeelden die echt totaal onduidelijk zijn. Ik wordt nu wel nieuwsgierig naar je formulier afhandeling... Kan je die eens posten?

Hipska BE

26-05-2008 14:03

maak een array aan met de vertaling van die keys..

<?php

$vertaling = array('mc_fm_43' => 'boter', 'mc_fm_43' => 'kaas', ... );

foreach($_POST as $key => $value){
$value = trim($value);
if($key == 'MM_insert') $value = '';

if(!empty($value)){
echo $vertaling[$key].' => '. $value.'<br />';
}
}
?>

P Pong Zor

26-05-2008 14:05

Oke nou zet je maar schrap dan, dit is alle code van het bestelformulier


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>FM&#8211;Parfumshop.nl &#8211; Bedankt voor uw bestelling!</title>
<link href="include/style_popup.css" rel="stylesheet" type="text/css" />
</head>

<body class="contenttekst">
<?php 
require_once('Connections/parfumshop.php');
include("include/class.phpmailer.php");


if(empty($_POST['voornaam']) || empty($_POST['achternaam']) || empty($_POST['adres']) ||  empty($_POST['email']))
{
	echo "Je hebt niet alle verplichte velden ingevuld!";
}
else {
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO bestellen (voornaam, achternaam, adres, email, mc_fm_43, mc_fm_52, mc_fm_54, mc_fm_56, mc_fm_57, mc_fm_60, mc_fm_64, mc_fm_66, mc_fm_68, mc_fm_70, mc_fm_76, mc_fm_78, mc_fm_82, mc_fm_83, mc_fm_84, mc_fm_85, mc_fm_86, mc_fm_87, mc_fm_91, mc_fm_93, mc_fm_107, mc_fm_110, mc_fm_133, mc_fm_134, mc_fm_135, mc_fm_136, mc_fm_137, mc_fm_138, mc_fm_139, mc_fm_140, mc_fm_188, mc_fm_189, mc_fm_190, mc_fm_191, mi_fm_92, mi_fm_94, mi_fm_120, me_fm_151, me_fm_152, me_fm_153, me_fm_154, me_fm_155, me_fm_156, me_fm_157, me_fm_158, me_fm_159, me_fm_160, me_fm_166, me_fm_167, me_fm_168, me_fm_169, me_fm_170, mf_fm_52, mf_fm_56, mf_fm_92, mf_fm_94, mf_fm_120, mf_fm_134, msg_fm_52, msg_fm_56, msg_fm_68, msg_fm_94, msg_fm_107, msg_fm_110, msg_fm_120, msg_fm_134, msg_fm_135, msg_fm_152, mbb_fm_52, ma_50_fm_52, ma_50_fm_56, ma_50_fm_94, ma_50_fm_120, ma_50_fm_134, ma_50_fm_156, ma_100_fm_52, ma_100_fm_56, ma_100_fm_94, ma_100_fm_120, ma_100_fm_134, ma_100_fm_156, msf_fm_52, mdr_fm_52, mdr_fm_56, mdr_fm_94, mdr_fm_107, mdr_fm_120, mdr_fm_134, mdr_fm_152, vrc_fm_02, vrc_fm_04, vrc_fm_05, vrc_fm_06, vrc_fm_07, vrc_fm_09, vrc_fm_10, vrc_fm_11, vrc_fm_12, vrc_fm_17, vrc_fm_18, vrc_fm_21, vrc_fm_23, vrc_fm_24, vrc_fm_25, vrc_fm_26, vrc_fm_32, vrc_fm_33, vrc_fm_34, vrc_fm_40, vrc_fm_44, vrc_fm_46, vrc_fm_48, vrc_fm_53, vrc_fm_58, vrc_fm_59, vrc_fm_80, vrc_fm_81, vrc_fm_84w, vrc_fm_97, vrc_fm_101, vrc_fm_109, vrc_fm_121, vrc_fm_122, vrc_fm_123, vrc_fm_124, vrc_fm_125, vrc_fm_126, vrc_fm_127, vrc_fm_128, vrc_fm_129, vrc_fm_130, vrc_fm_131, vrc_fm_132, vrc_fm_179, vrc_fm_180, vrc_fm_181, vrc_fm_182, vrc_fm_183, vrc_fm_184, vrc_fm_185, vrc_fm_186, vrc_fm_187, vi_fm_171, vi_fm_172, vi_fm_173, vi_fm_174, vi_fm_175, vi_fm_176, vi_fm_177, vi_fm_178, ve_fm_141, ve_fm_142, ve_fm_143, ve_fm_144, ve_fm_145, ve_fm_146, ve_fm_147, ve_fm_148, ve_fm_149, ve_fm_150, ve_fm_161, ve_fm_162, ve_fm_163, ve_fm_164, ve_fm_165, ve_fm_192, ve_fm_193, vf_fm_18, vf_fm_23, vf_fm_33, vf_fm_81, vf_fm_98, vf_fm_127, vf_fm_128, vf_fm_171, vsg_fm_05, vsg_fm_06, vsg_fm_09, vsg_fm_18, vsg_fm_21, vsg_fm_23, vsg_fm_25, vsg_fm_32, vsg_fm_33, vsg_fm_34, vsg_fm_81, vsg_fm_98, vsg_fm_121, vsg_fm_127, vsg_fm_129, vsg_fm_141, vsg_fm_142, vsg_fm_143, vsg_fm_147, vsg_fm_171, vbb_fm_05, vbb_fm_21, vbb_fm_23, vbb_fm_33, vbb_fm_81, vbb_fm_127, vbb_fm_129, vbb_fm_141, vbb_fm_143, vdr_fm_02, vdr_fm_23, vdr_fm_33, vdr_fm_81, vdr_fm_129, vdr_fm_141, vdr_fm_143, vdr_fm_147, vdr_fm_171, vdeo_fm_21, vdeo_fm_23, vdeo_fm_33, vdeo_fm_81, vdeo_fm_127, vdeo_fm_129, vdeo_fm_132, vdeo_fm_171, vlg_fm_88, vhf_fm_81, vhf_fm_141, vhf_fm_147, vhc_fm_33, vhc_fm_81, vhc_fm_98, vms_fm_33b, vms_fm_33g, vms_fm_81, vfc_fm_200, vfc_fm_201, vfc_fm_202, vfc_fm_203, vfc_fm_204, jc_fm_90, jsg_fm_90, aa_fm_23, aa_fm_33, aa_fm_81, aa_fm_141, aa_fm_147, mc_fm_88, msg_fm_88) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['voornaam'], "text"),
                       GetSQLValueString($_POST['achternaam'], "text"),
                       GetSQLValueString($_POST['adres'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['mc_fm_43'], "int"),
                       GetSQLValueString($_POST['mc_fm_52'], "int"),
                       GetSQLValueString($_POST['mc_fm_54'], "int"),
                       GetSQLValueString($_POST['mc_fm_56'], "int"),
                       GetSQLValueString($_POST['mc_fm_57'], "int"),
                       GetSQLValueString($_POST['mc_fm_60'], "int"),
                       GetSQLValueString($_POST['mc_fm_64'], "int"),
                       GetSQLValueString($_POST['mc_fm_66'], "int"),
                       GetSQLValueString($_POST['mc_fm_68'], "int"),
                       GetSQLValueString($_POST['mc_fm_70'], "int"),
                       GetSQLValueString($_POST['mc_fm_76'], "int"),
                       GetSQLValueString($_POST['mc_fm_78'], "int"),
                       GetSQLValueString($_POST['mc_fm_82'], "int"),
                       GetSQLValueString($_POST['mc_fm_83'], "int"),
                       GetSQLValueString($_POST['mc_fm_84'], "int"),
                       GetSQLValueString($_POST['mc_fm_85'], "int"),
                       GetSQLValueString($_POST['mc_fm_86'], "int"),
                       GetSQLValueString($_POST['mc_fm_87'], "int"),
                       GetSQLValueString($_POST['mc_fm_91'], "int"),
                       GetSQLValueString($_POST['mc_fm_93'], "int"),
                       GetSQLValueString($_POST['mc_fm_107'], "int"),
                       GetSQLValueString($_POST['mc_fm_110'], "int"),
                       GetSQLValueString($_POST['mc_fm_133'], "int"),
                       GetSQLValueString($_POST['mc_fm_134'], "int"),
                       GetSQLValueString($_POST['mc_fm_135'], "int"),
                       GetSQLValueString($_POST['mc_fm_136'], "int"),
                       GetSQLValueString($_POST['mc_fm_137'], "int"),
                       GetSQLValueString($_POST['mc_fm_138'], "int"),
                       GetSQLValueString($_POST['mc_fm_139'], "int"),
                       GetSQLValueString($_POST['mc_fm_140'], "int"),
                       GetSQLValueString($_POST['mc_fm_188'], "int"),
                       GetSQLValueString($_POST['mc_fm_189'], "int"),
                       GetSQLValueString($_POST['mc_fm_190'], "int"),
                       GetSQLValueString($_POST['mc_fm_191'], "int"),
                       GetSQLValueString($_POST['mi_fm_92'], "int"),
                       GetSQLValueString($_POST['mi_fm_94'], "int"),
                       GetSQLValueString($_POST['mi_fm_120'], "int"),
                       GetSQLValueString($_POST['me_fm_151'], "int"),
                       GetSQLValueString($_POST['me_fm_152'], "int"),
                       GetSQLValueString($_POST['me_fm_153'], "int"),
                       GetSQLValueString($_POST['me_fm_154'], "int"),
                       GetSQLValueString($_POST['me_fm_155'], "int"),
                       GetSQLValueString($_POST['me_fm_156'], "int"),
                       GetSQLValueString($_POST['me_fm_157'], "int"),
                       GetSQLValueString($_POST['me_fm_158'], "int"),
                       GetSQLValueString($_POST['me_fm_159'], "int"),
                       GetSQLValueString($_POST['me_fm_160'], "int"),
                       GetSQLValueString($_POST['me_fm_166'], "int"),
                       GetSQLValueString($_POST['me_fm_167'], "int"),
                       GetSQLValueString($_POST['me_fm_168'], "int"),
                       GetSQLValueString($_POST['me_fm_169'], "int"),
                       GetSQLValueString($_POST['me_fm_170'], "int"),
                       GetSQLValueString($_POST['mf_fm_52'], "int"),
                       GetSQLValueString($_POST['mf_fm_56'], "int"),
                       GetSQLValueString($_POST['mf_fm_92'], "int"),
                       GetSQLValueString($_POST['mf_fm_94'], "int"),
                       GetSQLValueString($_POST['mf_fm_120'], "int"),
                       GetSQLValueString($_POST['mf_fm_134'], "int"),
                       GetSQLValueString($_POST['msg_fm_52'], "int"),
                       GetSQLValueString($_POST['msg_fm_56'], "int"),
                       GetSQLValueString($_POST['msg_fm_68'], "int"),
                       GetSQLValueString($_POST['msg_fm_94'], "int"),
                       GetSQLValueString($_POST['msg_fm_107'], "int"),
                       GetSQLValueString($_POST['msg_fm_110'], "int"),
                       GetSQLValueString($_POST['msg_fm_120'], "int"),
                       GetSQLValueString($_POST['msg_fm_134'], "int"),
                       GetSQLValueString($_POST['msg_fm_135'], "int"),
                       GetSQLValueString($_POST['msg_fm_152'], "int"),
                       GetSQLValueString($_POST['mbb_fm_52'], "int"),
                       GetSQLValueString($_POST['ma_50_fm_52'], "int"),
                       GetSQLValueString($_POST['ma_50_fm_56'], "int"),
                       GetSQLValueString($_POST['ma_50_fm_94'], "int"),
                       GetSQLValueString($_POST['ma_50_fm_120'], "int"),
                       GetSQLValueString($_POST['ma_50_fm_134'], "int"),
                       GetSQLValueString($_POST['ma_50_fm_156'], "int"),
                       GetSQLValueString($_POST['ma_100_fm_52'], "int"),
                       GetSQLValueString($_POST['ma_100_fm_56'], "int"),
                       GetSQLValueString($_POST['ma_100_fm_94'], "int"),
                       GetSQLValueString($_POST['ma_100_fm_120'], "int"),
                       GetSQLValueString($_POST['ma_100_fm_134'], "int"),
                       GetSQLValueString($_POST['ma_100_fm_156'], "int"),
                       GetSQLValueString($_POST['msf_fm_52'], "int"),
                       GetSQLValueString($_POST['mdr_fm_52'], "int"),
                       GetSQLValueString($_POST['mdr_fm_56'], "int"),
                       GetSQLValueString($_POST['mdr_fm_94'], "int"),
                       GetSQLValueString($_POST['mdr_fm_107'], "int"),
                       GetSQLValueString($_POST['mdr_fm_120'], "int"),
                       GetSQLValueString($_POST['mdr_fm_134'], "int"),
                       GetSQLValueString($_POST['mdr_fm_152'], "int"),
                       GetSQLValueString($_POST['vrc_fm_02'], "int"),
                       GetSQLValueString($_POST['vrc_fm_04'], "int"),
                       GetSQLValueString($_POST['vrc_fm_05'], "int"),
                       GetSQLValueString($_POST['vrc_fm_06'], "int"),
                       GetSQLValueString($_POST['vrc_fm_07'], "int"),
                       GetSQLValueString($_POST['vrc_fm_09'], "int"),
                       GetSQLValueString($_POST['vrc_fm_10'], "int"),
                       GetSQLValueString($_POST['vrc_fm_11'], "int"),
                       GetSQLValueString($_POST['vrc_fm_12'], "int"),
                       GetSQLValueString($_POST['vrc_fm_17'], "int"),
                       GetSQLValueString($_POST['vrc_fm_18'], "int"),
                       GetSQLValueString($_POST['vrc_fm_21'], "int"),
                       GetSQLValueString($_POST['vrc_fm_23'], "int"),
                       GetSQLValueString($_POST['vrc_fm_24'], "int"),
                       GetSQLValueString($_POST['vrc_fm_25'], "int"),
                       GetSQLValueString($_POST['vrc_fm_26'], "int"),
                       GetSQLValueString($_POST['vrc_fm_32'], "int"),
                       GetSQLValueString($_POST['vrc_fm_33'], "int"),
                       GetSQLValueString($_POST['vrc_fm_34'], "int"),
                       GetSQLValueString($_POST['vrc_fm_40'], "int"),
                       GetSQLValueString($_POST['vrc_fm_44'], "int"),
                       GetSQLValueString($_POST['vrc_fm_46'], "int"),
                       GetSQLValueString($_POST['vrc_fm_48'], "int"),
                       GetSQLValueString($_POST['vrc_fm_53'], "int"),
                       GetSQLValueString($_POST['vrc_fm_58'], "int"),
                       GetSQLValueString($_POST['vrc_fm_59'], "int"),
                       GetSQLValueString($_POST['vrc_fm_80'], "int"),
                       GetSQLValueString($_POST['vrc_fm_81'], "int"),
                       GetSQLValueString($_POST['vrc_fm_84w'], "int"),
                       GetSQLValueString($_POST['vrc_fm_97'], "int"),
                       GetSQLValueString($_POST['vrc_fm_101'], "int"),
                       GetSQLValueString($_POST['vrc_fm_109'], "int"),
                       GetSQLValueString($_POST['vrc_fm_121'], "int"),
                       GetSQLValueString($_POST['vrc_fm_122'], "int"),
                       GetSQLValueString($_POST['vrc_fm_123'], "int"),
                       GetSQLValueString($_POST['vrc_fm_124'], "int"),
                       GetSQLValueString($_POST['vrc_fm_125'], "int"),
                       GetSQLValueString($_POST['vrc_fm_126'], "int"),
                       GetSQLValueString($_POST['vrc_fm_127'], "int"),
                       GetSQLValueString($_POST['vrc_fm_128'], "int"),
                       GetSQLValueString($_POST['vrc_fm_129'], "int"),
                       GetSQLValueString($_POST['vrc_fm_130'], "int"),
                       GetSQLValueString($_POST['vrc_fm_131'], "int"),
                       GetSQLValueString($_POST['vrc_fm_132'], "int"),
                       GetSQLValueString($_POST['vrc_fm_179'], "int"),
                       GetSQLValueString($_POST['vrc_fm_180'], "int"),
                       GetSQLValueString($_POST['vrc_fm_181'], "int"),
                       GetSQLValueString($_POST['vrc_fm_182'], "int"),
                       GetSQLValueString($_POST['vrc_fm_183'], "int"),
                       GetSQLValueString($_POST['vrc_fm_184'], "int"),
                       GetSQLValueString($_POST['vrc_fm_185'], "int"),
                       GetSQLValueString($_POST['vrc_fm_186'], "int"),
                       GetSQLValueString($_POST['vrc_fm_187'], "int"),
                       GetSQLValueString($_POST['vi_fm_171'], "int"),
                       GetSQLValueString($_POST['vi_fm_172'], "int"),
                       GetSQLValueString($_POST['vi_fm_173'], "int"),
                       GetSQLValueString($_POST['vi_fm_174'], "int"),
                       GetSQLValueString($_POST['vi_fm_175'], "int"),
                       GetSQLValueString($_POST['vi_fm_176'], "int"),
                       GetSQLValueString($_POST['vi_fm_177'], "int"),
                       GetSQLValueString($_POST['vi_fm_178'], "int"),
                       GetSQLValueString($_POST['ve_fm_141'], "int"),
                       GetSQLValueString($_POST['ve_fm_142'], "int"),
                       GetSQLValueString($_POST['ve_fm_143'], "int"),
                       GetSQLValueString($_POST['ve_fm_144'], "int"),
                       GetSQLValueString($_POST['ve_fm_145'], "int"),
                       GetSQLValueString($_POST['ve_fm_146'], "int"),
                       GetSQLValueString($_POST['ve_fm_147'], "int"),
                       GetSQLValueString($_POST['ve_fm_148'], "int"),
                       GetSQLValueString($_POST['ve_fm_149'], "int"),
                       GetSQLValueString($_POST['ve_fm_150'], "int"),
                       GetSQLValueString($_POST['ve_fm_161'], "int"),
                       GetSQLValueString($_POST['ve_fm_162'], "int"),
                       GetSQLValueString($_POST['ve_fm_163'], "int"),
                       GetSQLValueString($_POST['ve_fm_164'], "int"),
                       GetSQLValueString($_POST['ve_fm_165'], "int"),
                       GetSQLValueString($_POST['ve_fm_192'], "int"),
                       GetSQLValueString($_POST['ve_fm_193'], "int"),
                       GetSQLValueString($_POST['vf_fm_18'], "int"),
                       GetSQLValueString($_POST['vf_fm_23'], "int"),
                       GetSQLValueString($_POST['vf_fm_33'], "int"),
                       GetSQLValueString($_POST['vf_fm_81'], "int"),
                       GetSQLValueString($_POST['vf_fm_98'], "int"),
                       GetSQLValueString($_POST['vf_fm_127'], "int"),
                       GetSQLValueString($_POST['vf_fm_128'], "int"),
                       GetSQLValueString($_POST['vf_fm_171'], "int"),
                       GetSQLValueString($_POST['vsg_fm_05'], "int"),
                       GetSQLValueString($_POST['vsg_fm_06'], "int"),
                       GetSQLValueString($_POST['vsg_fm_09'], "int"),
                       GetSQLValueString($_POST['vsg_fm_18'], "int"),
                       GetSQLValueString($_POST['vsg_fm_21'], "int"),
                       GetSQLValueString($_POST['vsg_fm_23'], "int"),
                       GetSQLValueString($_POST['vsg_fm_25'], "int"),
                       GetSQLValueString($_POST['vsg_fm_32'], "int"),
                       GetSQLValueString($_POST['vsg_fm_33'], "int"),
                       GetSQLValueString($_POST['vsg_fm_34'], "int"),
                       GetSQLValueString($_POST['vsg_fm_81'], "int"),
                       GetSQLValueString($_POST['vsg_fm_98'], "int"),
                       GetSQLValueString($_POST['vsg_fm_121'], "int"),
                       GetSQLValueString($_POST['vsg_fm_127'], "int"),
                       GetSQLValueString($_POST['vsg_fm_129'], "int"),
                       GetSQLValueString($_POST['vsg_fm_141'], "int"),
                       GetSQLValueString($_POST['vsg_fm_142'], "int"),
                       GetSQLValueString($_POST['vsg_fm_143'], "int"),
                       GetSQLValueString($_POST['vsg_fm_147'], "int"),
                       GetSQLValueString($_POST['vsg_fm_171'], "int"),
                       GetSQLValueString($_POST['vbb_fm_05'], "int"),
                       GetSQLValueString($_POST['vbb_fm_21'], "int"),
                       GetSQLValueString($_POST['vbb_fm_23'], "int"),
                       GetSQLValueString($_POST['vbb_fm_33'], "int"),
                       GetSQLValueString($_POST['vbb_fm_81'], "int"),
                       GetSQLValueString($_POST['vbb_fm_127'], "int"),
                       GetSQLValueString($_POST['vbb_fm_129'], "int"),
                       GetSQLValueString($_POST['vbb_fm_141'], "int"),
                       GetSQLValueString($_POST['vbb_fm_143'], "int"),
                       GetSQLValueString($_POST['vdr_fm_02'], "int"),
                       GetSQLValueString($_POST['vdr_fm_23'], "int"),
                       GetSQLValueString($_POST['vdr_fm_33'], "int"),
                       GetSQLValueString($_POST['vdr_fm_81'], "int"),
                       GetSQLValueString($_POST['vdr_fm_129'], "int"),
                       GetSQLValueString($_POST['vdr_fm_141'], "int"),
                       GetSQLValueString($_POST['vdr_fm_143'], "int"),
                       GetSQLValueString($_POST['vdr_fm_147'], "int"),
                       GetSQLValueString($_POST['vdr_fm_171'], "int"),
                       GetSQLValueString($_POST['vdeo_fm_21'], "int"),
                       GetSQLValueString($_POST['vdeo_fm_23'], "int"),
                       GetSQLValueString($_POST['vdeo_fm_33'], "int"),
                       GetSQLValueString($_POST['vdeo_fm_81'], "int"),
                       GetSQLValueString($_POST['vdeo_fm_127'], "int"),
                       GetSQLValueString($_POST['vdeo_fm_129'], "int"),
                       GetSQLValueString($_POST['vdeo_fm_132'], "int"),
                       GetSQLValueString($_POST['vdeo_fm_171'], "int"),
                       GetSQLValueString($_POST['vlg_fm_88'], "int"),
                       GetSQLValueString($_POST['vhf_fm_81'], "int"),
                       GetSQLValueString($_POST['vhf_fm_141'], "int"),
                       GetSQLValueString($_POST['vhf_fm_147'], "int"),
                       GetSQLValueString($_POST['vhc_fm_33'], "int"),
                       GetSQLValueString($_POST['vhc_fm_81'], "int"),
                       GetSQLValueString($_POST['vhc_fm_98'], "int"),
                       GetSQLValueString($_POST['vms_fm_33b'], "int"),
                       GetSQLValueString($_POST['vms_fm_33g'], "int"),
                       GetSQLValueString($_POST['vms_fm_81'], "int"),
                       GetSQLValueString($_POST['vfc_fm_200'], "int"),
                       GetSQLValueString($_POST['vfc_fm_201'], "int"),
                       GetSQLValueString($_POST['vfc_fm_202'], "int"),
                       GetSQLValueString($_POST['vfc_fm_203'], "int"),
                       GetSQLValueString($_POST['vfc_fm_204'], "int"),
                       GetSQLValueString($_POST['jc_fm_90'], "int"),
					   GetSQLValueString($_POST['jsg_fm_90'], "int"),
                       GetSQLValueString($_POST['aa_fm_23'], "int"),
                       GetSQLValueString($_POST['aa_fm_33'], "int"),
                       GetSQLValueString($_POST['aa_fm_81'], "int"),
                       GetSQLValueString($_POST['aa_fm_141'], "int"),
                       GetSQLValueString($_POST['aa_fm_147'], "int"),
                       GetSQLValueString($_POST['mc_fm_88'], "int"),
					   GetSQLValueString($_POST['msg_fm_88'], "int"));

  mysql_select_db($database_parfumshop, $parfumshop);
  $Result1 = mysql_query($insertSQL, $parfumshop) or die(mysql_error());
  
  $mail = new PHPMailer();

	$mail->IsHTML(true);
	
	$mail->From     = "[email protected]";
	$mail->FromName = "FM-Parfumshop.nl";
	
	$mail->AddAddress($_POST['email'], $_POST['voornaam']);
	
	$mail->Subject     = "Bestelling via FM-parfumshop.nl";
	
	$mail->Body     = "<p>Beste " . $_POST['voornaam'] . " " . $_POST['achternaam'] . ",</p>
	<p>U heeft zojuist een bestelling geplaatst.</p><p>Uw gegevens:<br />Voornaam: " . $_POST['voornaam'] . "<br />Achternaam: " . $_POST['achternaam'] . "<br />Adres: " . $_POST['adres'] . "<br />Emailadres: " . $_POST['email'] . "</p>
	<p>Uw artikelen:<br />";
	
	
	$mail->AltBody     = "Beste " . $_POST['voornaam'] . " " . $_POST['achternaam'] . ", \n\n Bij deze stuur ik u de beloofde geurenlijst toe. Veel succes met bestellen! \n\n Met vriendelijke groet, \n W.H. Polinder.";
	
	$mail->WordWrap = 50;
	
	if(!$mail->Send())
	{
	   echo 'Er ging iets mis tijdens het versturen, namelijk:<br>';
	   echo $mail->ErrorInfo;
	}
	else
	{
	   echo 'Bedankt voor het plaatsen van uw bestelling! Binnen enkele minuten ontvangt u deze in uw mailbox. Hieronder vindt u uw gegevens en bestelde artikelen terug: <br /><br />';
	   	foreach($_POST as $key => $value)
		{
			if ($key == "MM_insert")
			{	
				$key = "";
				$value = "";
			}
			if ($key == "voornaam")
			{
				$key = "Voornaam";
			}
			if ($key == "achternaam")
			{
				$key = "Achternaam";
			}
			if ($key == "adres")
			{
				$key = "Adres";
			}	
			if ($key == "email")
			{
				$key = "Emailadres";
			}
			
       		$value = trim($value);
			if(!empty($value)){
				echo $key.': '. $value.' <br />';
			}
		
   		}
	}
}
}
?>
</body>
</html>

M Mitchell

26-05-2008 14:22

Are you kiddin' me? -_-'

J Jacco Engel

26-05-2008 14:24

http://www.vandale.nl/vandale/opzoeken/woordenboek/?zoekwoord=relevant