Søg
Avatar billede grk Novice
09. april 2007 - 20:00 Der er 29 kommentarer og
1 løsning

Udtrækning af checkbox

Linket vedr. spørgsmålet gik galt i det første spørgsmål, men nu skulle den være helt i orden.

Spørgsmål vedr. udtrækning af checkbox kan læses på dette link.

http://www.duo2.dk/test/
Avatar billede dkfire Nybegynder
09. april 2007 - 20:27 #1
if($_POST['mand2']){
echo "Mand";
}elseif( $_POST['kvinde2'] )
echo "Kvinde";

En checkbox vil returnere en værdi kun hvis den er krydset af, derfor kan du ved at tjekke om der findes en værdi med de tilhørende $_POST variabler se om den er tjek.
Du burde nok ændre din value for kvinde2 til 1.
Avatar billede grk Novice
09. april 2007 - 21:11 #2
Forstår ikke helt hvilken kode der skal indsættes i tabellen for mand, hvis der er sat flueben i mand, og ligeså som kvinde.

Tabellen er den side jeg udtrækker på.
Avatar billede grk Novice
09. april 2007 - 21:24 #3
Har prøvet at indsætte disse 2 php koder mand / kvinde i tabellen for udlæsning. Viser intet selvom der er sat flueben i mand, har også afprøvet med kvinde.

<?php
if($_POST['mand2']){
echo "mand";
}elseif( $_POST['kvinde2'] )
echo "Kvinde";
?>

<?php
if($_POST['kvinde2']){
echo "kvinde";
}elseif( $_POST['mand2'] )
echo "mand";
?>
Avatar billede showsource Seniormester
09. april 2007 - 21:28 #4
<input type="radio" name="koen" value="Mand"> Mand
<input type="radio" name="koen" value="Kvinde"> Kvinde

if(isset($_POST["koen"])) {
echo $_POST["koen"];
}
Avatar billede grk Novice
09. april 2007 - 21:43 #5
Det er meget fint at vise nogle koder, det som jeg søger er at få at vide hvilken kode der skal indsættes i tabellen for udtræk mand og ligeså kvinde.
Avatar billede dkfire Nybegynder
10. april 2007 - 00:47 #6
Ok
Først, har du ændret value for kvinde til 1 i din form ???
<input name="mand" type="checkbox" id="mand" value="1">
<span class="style21">Mand</span> <span class="style21">
<input name="kvinde" type="checkbox" id="kvinde" value="1">
Kvinde


dernæst, i din tabel hvor du vil have til at stå om det er mand eller kvinde som er valgt, skriver du
if($_POST['mand']){
echo "Mand";
}elseif( $_POST['kvinde'] ){
echo "Kvinde";
}else
echo "intet køn valgt";'

Men hvis vi kan se din kode for tabellen, og ikke kun formen vil det hjælpe noget.
Alle de der Print Screen kan vi ikke bruge til noget.
Avatar billede grk Novice
10. april 2007 - 18:43 #7
Har nu rettet det til sådan her.

<input name="mand" type="checkbox" id="mand" value="1>
<span class="style21">Mand</span> <span class="style21">
<input name="kvinde" type="checkbox" id="kvinde" value="0">

Indsat dette i tabellen.

<?php
if($_POST['mand']){
echo "Mand";
}elseif( $_POST['kvinde'] ){
echo "Kvinde";
}else
echo "intet køn valgt";
?>

Nu skriver den "intet køn valgt" uanset om der er sat flueben i mand eller kvinde.
Avatar billede dkfire Nybegynder
10. april 2007 - 18:57 #8
Du har ikke helt læst hvad jeg har skrevet.
Ret value i kvinde til 1.
Og så mangler du lige " ved value i mand.
Avatar billede dkfire Nybegynder
10. april 2007 - 18:58 #9
Og det vil stadig hjælpe hvis du viste side med php koden.
Avatar billede grk Novice
10. april 2007 - 19:54 #10
Hvilken side er det du gerne vil se med kode.

1: Siden hvor man indtaster oplysninger
2: Siden hvor man udlæser de indtastede oplysninger af medlemmet
Avatar billede dkfire Nybegynder
10. april 2007 - 19:57 #11
Siden hvor du udlæser de indtastede oplysninger
Avatar billede grk Novice
10. april 2007 - 19:57 #12
Koden for 2:

<?php require_once('../Connections/cms.php'); ?>
<?php
$colname_rsSubmenu_tilmelding = "1";
if (isset($_GET['mainid'])) {
  $colname_rsSubmenu_tilmelding = (get_magic_quotes_gpc()) ? $_GET['mainid'] : addslashes($_GET['mainid']);
}
mysql_select_db($database_cms, $cms);
$query_rsSubmenu_tilmelding = sprintf("SELECT * FROM tilmelding WHERE mainid = %s", $colname_rsSubmenu_tilmelding);
$rsSubmenu_tilmelding = mysql_query($query_rsSubmenu_tilmelding, $cms) or die(mysql_error());
$row_rsSubmenu_tilmelding = mysql_fetch_assoc($rsSubmenu_tilmelding);
$totalRows_rsSubmenu_tilmelding = mysql_num_rows($rsSubmenu_tilmelding);

$colname_rsTilmelding = "1";
if (isset($_GET['id'])) {
  $colname_rsTilmelding = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rsTilmelding = sprintf("SELECT * FROM tilmelding WHERE id = %s ORDER BY id DESC", $colname_rsTilmelding);
$rsTilmelding = mysql_query($query_rsTilmelding, $cms) or die(mysql_error());
$row_rsTilmelding = mysql_fetch_assoc($rsTilmelding);
$totalRows_rsTilmelding = mysql_num_rows($rsTilmelding);

$colname_rsBannertekst = "1";
if (isset($_GET['id'])) {
  $colname_rsBannertekst = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rsBannertekst = sprintf("SELECT * FROM bannertekst WHERE id = %s ORDER BY id DESC", $colname_rsBannertekst);
$rsBannertekst = mysql_query($query_rsBannertekst, $cms) or die(mysql_error());
$row_rsBannertekst = mysql_fetch_assoc($rsBannertekst);
$totalRows_rsBannertekst = mysql_num_rows($rsBannertekst);

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>cms-sh3.0</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
@import url("../css/styles.css");
body {
    background-color: #e9e9e9;
}
.style21 {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-weight: bold;
    font-size: 11px;
    color: #000099;
}
.style23 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 16px; color: #000099; }
.style25 {color: #000000}
.style29 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; color: #000000; }
.style31 {font-size: 11px}
.style32 {font-size: 14px}
.style33 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 11px; color: #000000; }
.style34 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 14px; color: #000099; }
.style9 {color: #999999; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
  if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>

<body>
<table width="890" height="23" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#FFFFFF"><img src="../img/bj1_890_23.gif" width="890" height="23"></td>
  </tr>
</table>
<table width="890" height="23" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" bgcolor="#FFFFFF"><img src="../img/bj2_203_23.gif" width="203" height="23"></td>
    <td bgcolor="#FFFFFF"><img src="../img/bj2_687_23.gif" width="687" height="23"></td>
  </tr>
</table>
<table width="890" height="122" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#FFFFFF"><div align="center"><img src="img/banner_kontaktperson.gif" width="890" height="122"></div></td>
  </tr>
</table>
<table width="890" height="27" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" bgcolor="#FFFFFF"><img src="../img/bj3_203_27.gif" width="203" height="27"></td>
    <td bgcolor="#FFFFFF"><img src="../img/bj3_687_27.gif" width="687" height="27"></td>
  </tr>
</table>
<table width="890" height="44" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" bgcolor="#FFFFFF"><img src="../img/bj4_203_44.gif" width="203" height="44"></td>
    <td width="460" bgcolor="#FFFFFF"><img src="../img/bj4_medlemsoplysning_460_44.gif" width="460" height="44"></td>
    <td width="227" bgcolor="#FFFFFF"><img src="../img/bj4_227_44.gif" width="227" height="44"></td>
  </tr>
</table>
<table width="890" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr><?php
$tekst1 = nl2br($row_rsForside['tekst1']);
$tekst2 = nl2br($row_rsForside['tekst2']);
$tekst3 = nl2br($row_rsForside['tekst3']);
$tekst4 = nl2br($row_rsForside['tekst4']);
$tekst5 = nl2br($row_rsForside['tekst5']);
$tekst6 = nl2br($row_rsForside['tekst6']);
?>
    <td width="203" valign="top" bgcolor="#FFFFFF"><div align="center">
      <p align="left">&nbsp;</p>
      <div align="left"> </div>
      <p>&nbsp;</p>
    </div></td>
    <td width="460" bgcolor="#FFFFFF"><table width="460" border="0" cellspacing="0" cellpadding="2">
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3"></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style23 style32"> Personlige Oplysninger </td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style21"><p class="style25 style31"><?php echo $row_rsTilmelding['date']; ?></p></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td width="127" class="style21"> <?php
if($_POST['mand']){
echo "Mand";
}elseif( $_POST['kvinde'] ){
echo "Kvinde";
}else
echo "intet køn valgt";
?></td>
        <td width="126" class="style21">&nbsp; </td>
        <td width="127" class="style33"><?php echo $row_rsTilmelding['alder']; ?></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style21 style25 style31"><?php echo $row_rsTilmelding['fornavn']; ?></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3"><span class="style33"><?php echo $row_rsTilmelding['efternavn']; ?></span></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style23">&nbsp; </td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3"><span class="style34">Adresse</span></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style29 style25 style31"><?php echo $row_rsTilmelding['adresse']; ?></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style33"><?php echo $row_rsTilmelding['forstad']; ?></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style33"><?php echo $row_rsTilmelding['postnummer']; ?></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style33"><?php echo $row_rsTilmelding['by']; ?></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style33"><?php echo $row_rsTilmelding['land']; ?></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style23">&nbsp;</td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3"><span class="style34">Kontakt Information </span></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style33"><?php echo $row_rsTilmelding['tlf']; ?></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style33"><?php echo $row_rsTilmelding['mobiltlf']; ?></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3"><span class="style33"><?php echo $row_rsTilmelding['emailadresse']; ?></span></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3" class="style23">&nbsp;</td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3"><span class="style34">Personlig Information </span></td>
        <td width="40">&nbsp;</td>
      </tr><?php
$tekst = nl2br($row_rsTilmelding['tekst']);
?>
      <tr bgcolor="e9e9e9">
        <td width="40">&nbsp;</td>
        <td colspan="3"><span class="style33"><?php echo $tekst; ?></span></td>
        <td width="40">&nbsp;</td>
      </tr>
      <tr bgcolor="e9e9e9">
        <td>&nbsp;</td>
        <td colspan="3">&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
    </table></td>
    <td width="227" valign="top" bgcolor="#FFFFFF"><div align="center">
      <p><br>
        <a href="adm_tilmelding.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image28','','img_link/adm_33_over.gif',0)"><img src="img_link/adm_33.gif" name="Image28" width="140" height="23" border="0"></a> <br>
        <a href="adm_administration.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image33','','img_link/adm_27_over.gif',0)"><img src="img_link/adm_27.gif" name="Image33" width="140" height="23" border="0"></a><br>
        <a href="adm_delete_submenu_tilmelding.php?id=<?php echo $row_rsSubmenu_tilmelding ['id']; ?>" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image32','','img_link/adm_34_over.gif',0)"><img src="img_link/adm_34.gif" name="Image32" width="140" height="23" border="0"></a>      </p>
      <p>&nbsp;</p>
    </div></td>
  </tr>
</table>
<table width="890" height="56" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" height="56" rowspan="2" valign="top" bgcolor="#FFFFFF"><img src="../img/banner_3.jpg" width="203" height="56"></td>
    <td width="687" height="33" valign="top" bgcolor="#FFFFFF"><img src="../img/bj5_687_33.gif" width="687" height="33"></td>
  </tr>
  <tr>
    <td width="687" height="24" valign="top" bgcolor="#FFFFFF"><img src="../img/bj6_687_24.gif" width="687" height="24"></td>
  </tr>
</table>
<br>
</body>
</html>
<?php
mysql_free_result($rsSubmenu_tilmelding);

mysql_free_result($rsTilmelding);

mysql_free_result($rsBannertekst);
?>
Avatar billede dkfire Nybegynder
10. april 2007 - 20:08 #13
Okay, den kode du lige har skrevet har jo intet med hvad du indtaster i din form. Den henter jo bare nogle værdier ud fra en database.
Kan du ikke vise mig den kode så lægger dataerne fra formen ind i databasen.
Avatar billede grk Novice
10. april 2007 - 21:29 #14
Du skrev: Siden hvor du udlæser de indtastede oplysninger

Det er den kode som er langt ind her, men det var åbenbart den anden du har ment men skrev forkert.

<?php require_once('Connections/cms.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "tilmelding")) {
  $insertSQL = sprintf("INSERT INTO tilmelding (`date`, alder, fornavn, efternavn, adresse, forstad, postnummer, `by`, land, tlf, mobiltlf, emailadresse, tekst, mainid) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                      GetSQLValueString($_POST['date'], "text"),
                      GetSQLValueString($_POST['alder'], "text"),
                      GetSQLValueString($_POST['fornavn'], "text"),
                      GetSQLValueString($_POST['efternavn'], "text"),
                      GetSQLValueString($_POST['adresse'], "text"),
                      GetSQLValueString($_POST['forstad'], "text"),
                      GetSQLValueString($_POST['postnummer'], "text"),
                      GetSQLValueString($_POST['by'], "text"),
                      GetSQLValueString($_POST['land'], "text"),
                      GetSQLValueString($_POST['tlf'], "text"),
                      GetSQLValueString($_POST['mobiltlf'], "text"),
                      GetSQLValueString($_POST['emailadresse'], "text"),
                      GetSQLValueString($_POST['tekst'], "text"),
                      GetSQLValueString($_POST['mainid'], "int"));

  mysql_select_db($database_cms, $cms);
  $Result1 = mysql_query($insertSQL, $cms) or die(mysql_error());
}

$colname_rsBannertekst = "1";
if (isset($_GET['id'])) {
  $colname_rsBannertekst = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rsBannertekst = sprintf("SELECT * FROM bannertekst WHERE id = %s ORDER BY id DESC", $colname_rsBannertekst);
$rsBannertekst = mysql_query($query_rsBannertekst, $cms) or die(mysql_error());
$row_rsBannertekst = mysql_fetch_assoc($rsBannertekst);
$totalRows_rsBannertekst = mysql_num_rows($rsBannertekst);

$colname_rsNewsubmenu_tilmelding = "1";
if (isset($_GET['id'])) {
  $colname_rsNewsubmenu_tilmelding = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rsNewsubmenu_tilmelding = sprintf("SELECT id FROM tilmelding WHERE id = %s", $colname_rsNewsubmenu_tilmelding);
$rsNewsubmenu_tilmelding = mysql_query($query_rsNewsubmenu_tilmelding, $cms) or die(mysql_error());
$row_rsNewsubmenu_tilmelding = mysql_fetch_assoc($rsNewsubmenu_tilmelding);
$totalRows_rsNewsubmenu_tilmelding = mysql_num_rows($rsNewsubmenu_tilmelding);

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
    background-color: #e9e9e9;
}
.style21 {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-weight: bold;
    font-size: 11px;
    color: #000099;
}
.style23 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 16px; color: #000099; }
.style24 {color: #000099}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
  if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>

<body>
<table width="890" height="23" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#FFFFFF"><img src="img/bj1_890_23.gif" width="890" height="23"></td>
  </tr>
</table>
<table width="890" height="23" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" bgcolor="#FFFFFF"><a href="tilmelding.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image28','','admin/img_link/adm_35_over.gif',0)"><img src="admin/img_link/adm_35.gif" name="Image28" width="90" height="23" border="0"></a><img src="img/blank_113_23.gif" width="113" height="23"></td>
    <td bgcolor="#FFFFFF"><a href="index.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image16','','img/rod_01_over.gif',0)"><img src="img/rod_01.gif" name="Image16" width="70" height="23" border="0"></a><a href="klubinfo.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image17','','img/rod_06_over.gif',0)"><img src="img/rod_06.gif" name="Image17" width="75" height="23" border="0"></a><a href="program.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image18','','img/rod_03_over.gif',0)"><img src="img/rod_03.gif" name="Image18" width="70" height="23" border="0"></a><a href="aktiviteter.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image19','','img/rod_05_over.gif',0)"><img src="img/rod_05.gif" name="Image19" width="100" height="23" border="0"></a><a href="nyheder.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image20','','img/rod_02_over.gif',0)"><img src="img/rod_02.gif" name="Image20" width="70" height="23" border="0"></a><a href="fotoalbum.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image21','','img/rod_09_over.gif',0)"><img src="img/rod_09.gif" name="Image21" width="90" height="23" border="0"></a><a href="links.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image22','','img/rod_10_over.gif',0)"><img src="img/rod_10.gif" name="Image22" width="50" height="23" border="0"></a><a href="info.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image23','','img/rod_07_over.gif',0)"><img src="img/rod_07.gif" name="Image23" width="40" height="23" border="0"></a><a href="kontakt_os.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image24','','img/rod_08_over.gif',0)"><img src="img/rod_08.gif" name="Image24" width="100" height="23" border="0"></a><img src="img/blank_22_23.gif" width="22" height="23"></td>
  </tr>
</table>
<table width="890" height="122" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td background="img/banner_1.jpg" bgcolor="#FFFFFF"><div align="center"><?php echo $row_rsBannertekst['tekst']; ?></div></td>
  </tr>
</table>
<table width="890" height="27" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" bgcolor="#FFFFFF"><img src="img/bj3_203_27.gif" width="203" height="27"></td>
    <td bgcolor="#FFFFFF"><img src="img/bj3_687_27.gif" width="687" height="27"></td>
  </tr>
</table>
<table width="890" height="44" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" bgcolor="#FFFFFF"><img src="img/bj4_203_44.gif" width="203" height="44"></td>
    <td width="460" bgcolor="#FFFFFF"><img src="img/bj4_tilmelding_460_44.gif" width="460" height="44"></td>
    <td width="227" bgcolor="#FFFFFF"><img src="img/bj4_227_44.gif" width="227" height="44"></td>
  </tr>
</table>
<table width="890" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr><?php
$tekst1 = nl2br($row_rsForside['tekst1']);
$tekst2 = nl2br($row_rsForside['tekst2']);
$tekst3 = nl2br($row_rsForside['tekst3']);
$tekst4 = nl2br($row_rsForside['tekst4']);
$tekst5 = nl2br($row_rsForside['tekst5']);
$tekst6 = nl2br($row_rsForside['tekst6']);
?>
    <td width="203" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
    <td width="460" bgcolor="#FFFFFF"><form action="<?php echo $editFormAction; ?>" method="POST" name="tilmelding" id="tilmelding">
      <table width="460" border="0" cellspacing="0" cellpadding="2">
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td class="style23">&nbsp;</td>
          <td colspan="2" class="style23">Dine Personlige Oplysninger </td>
          <td width="40" class="style23">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2" class="style21"> Skal oplyses * </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Dato:</td>
          <td width="240"><p>
            <input name="date" type="text" id="date" size="15">
            <span class="style24">*</span>           
            </p>            </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">K&oslash;n:</td>
          <td width="240"><input name="mand" type="checkbox" id="mand" value="1">           
          <span class="style21">Mand</span> <span class="style21">
<input name="kvinde" type="checkbox" id="kvinde" value="1"> 
Kvinde
  <input name="alder" type="text" id="alder" size="1">
  Alder * </span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Fornavn:</td>
          <td width="240"><input name="fornavn" type="text" id="fornavn2" size="30">
            <span class="style24">*</span> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Efternavn:</td>
          <td width="240"><input name="efternavn" type="text" id="efternavn2" size="30">
            <span class="style24">*</span> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td class="style23">&nbsp;</td>
          <td width="240" class="style23">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2"><span class="style23">Din Adresse</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">&nbsp;</td>
          <td width="240">&nbsp;            </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Adresse:</td>
          <td width="240"><input name="adresse" type="text" id="adresse2" size="30">
            <span class="style24">*</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Forstad/Stednavn:</td>
          <td width="240"><input name="forstad" type="text" id="forstad2" size="30"></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Postnummer:</td>
          <td width="240"><input name="postnummer" type="text" id="postnummer2" size="15">
            <span class="style24">*</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">By:</td>
          <td width="240"><input name="by" type="text" id="by2" size="30">
            <span class="style24">*</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140"><span class="style21">Land:</span></td>
          <td width="240"><input name="land" type="text" id="land2" size="30">
            <span class="style24">*</span> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td class="style23">&nbsp;</td>
          <td width="240" class="style23">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2"><span class="style23">Din Kontakt Information</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">&nbsp;</td>
          <td width="240">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Tlf.:</td>
          <td width="240"><input name="mobiltlf" type="text" id="mobiltlf" size="15"></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Mobil tlf.:</td>
          <td width="240"><input name="tlf" type="text" id="tlf2" size="15"></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140"><span class="style21">E-mail-adresse:</span></td>
          <td width="240"><input name="emailadresse" type="text" id="emailadresse2" size="30">
            <span class="style24">*</span> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td class="style23">&nbsp;</td>
          <td width="240" class="style23">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2"><span class="style23">Personlig Information </span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">&nbsp;</td>
          <td width="240">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140"><span class="style21">Tekst:</span></td>
          <td width="240"><textarea name="tekst" rows="5" id="textarea"></textarea> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td>&nbsp;</td>
          <td><input name="mainid" type="hidden" id="mainid" value="<?php echo $row_rsNewsubmenu_tilmelding['id']; ?>">            <?php 
  if(isset($_POST['send'])){
    $to = "Cape <".$_POST['til'].">";             
    $from = "From: Webmaster <auto@domain.dk>";                   
    $Bcc = "Bcc: Usynlig <xxxx@xxxxxx.dk>"; 
    $ReplyTo = "Reply-To: modtager@domain.dk";
    $subject = "Tak for din tilmelding";
    $message = "Velkommen i klubben";
    $headers  = "MIME-Version: 1.0\r\n";                                           
    $headers .= "$from\r\n";
    $headers .= "$Bcc\r\n";
    $headers .= "$ReplyTo\r\n";
    mail($to, $subject, $message, $headers);
    echo "<input type=\"hidden\" name=\"til\" value=\"".$row_rsEmail['email']."\">";
}
?></td>
          <td width="240"><input name="send" type="submit" id="send2" value="Send">             
            <input name="reset" type="reset" id="reset" value="Reset"></td><td width="40">&nbsp;</td>
        </tr>
      </table>
        <input type="hidden" name="MM_insert" value="tilmelding">
            </form>    </td>
    <td width="227" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
</table>
<table width="890" height="0" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td valign="top" bgcolor="#FFFFFF"><form name="form1" method="get" action="resultat.php">
      <table width="890" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="203" rowspan="2"><img src="img/banner_2.jpg" width="203" height="57"></td>
          <td width="687" height="33" colspan="3"><img src="img/bj5_687_33.gif" width="687" height="33"></td>
        </tr>
        <tr>
          <td width="528" height="24"><a href="raadgivning.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image25','','img/rod_11_over.gif',0)"><img src="img/rod_11.gif" name="Image25" width="100" height="24" border="0"></a><a href="vedtaegter.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image26','','img/rod_12_over.gif',0)"><img src="img/rod_12.gif" name="Image26" width="90" height="24" border="0"></a><a href="sponsorer.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image27','','img/rod_13_over.gif',0)"><img src="img/rod_13.gif" name="Image27" width="90" height="24" border="0"></a><a href="annoncer.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image30','','img/rod_15_over.gif',0)"><img src="img/rod_15.gif" name="Image30" width="80" height="24" border="0"></a><a href="bestyrelsen.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image29','','img/rod_14_over.gif',0)"><img src="img/rod_14.gif" name="Image29" width="90" height="24" border="0"></a><a href="klubnyt.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image31','','img/rod_04_over.gif',0)"><img src="img/rod_04.gif" name="Image31" width="70" height="24" border="0"></a><img src="img/blank_3_24.gif" width="3" height="24"></td>
          <td width="119">
              <div align="left">
                <input name="search" type="text" id="search" size="15">
              </div></td>
          <td width="40"><input name="s&oslash;g" type="submit" id="s&oslash;g" value="S&oslash;g"></td>
        </tr>
      </table>
    </form></td>
  </tr>
</table>
<br>
</body>
</html>
<?php
mysql_free_result($rsBannertekst);

mysql_free_result($rsNewsubmenu_tilmelding);
?>
Avatar billede dkfire Nybegynder
10. april 2007 - 21:35 #15
Altså så vidt jeg kan se så lægger du jo ikke kønnet ind i databasen, derfor bliver det jo lidt svært at hente det ud igen på den anden side.
Avatar billede grk Novice
10. april 2007 - 21:43 #16
Mand og kvinde er oprettet i databasen. Der er ikke oprettet en tekstfelt for mand eller kvinde, da der er indsat en checkbox for hver.
Skal en checkbox da oprettes på en anden måde ????
Avatar billede grk Novice
10. april 2007 - 21:45 #17
PS: Måske det er nemmere at oprette en tekstfelt hvor man kan sætte et kryds i.
Avatar billede dkfire Nybegynder
10. april 2007 - 21:47 #18
Nææ det er nu ikke nemmere, men hvad hedder dine felter i din tabel i databasen ?
Avatar billede grk Novice
10. april 2007 - 22:05 #19
Feltnavn Datatype
mand    varchar
kvinde  varchar
Avatar billede dkfire Nybegynder
10. april 2007 - 22:22 #20
ok, det nemmeste vil være at lave datatype om til int eller tinyint.
Så behøver vi bare at gennem 0 eller 1, lidt ligesom sandt eller falsk.

så skal vi lige rette din insert sql til, således at den sætter det rigtige ind.
Hvis vi starter med at oprette to variabler:
if( $_POST['mand'] ){
$mand = 1;
} else
$mand = 0;
if( $_POST['kvinde'] ){
$kvinde = 1;
}else
$kvinde = 0;

dernæst skal din sql opdateres

$insertSQL = sprintf("INSERT INTO tilmelding (`date`, mand, kvinde, alder, fornavn, efternavn, adresse, forstad, postnummer, `by`, land, tlf, mobiltlf, emailadresse, tekst, mainid) VALUES (%s, %d, %d, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                      GetSQLValueString($_POST['date'], "text"),
                      $mand,
                      $kvinde,
                      GetSQLValueString($_POST['alder'], "text"),
                      GetSQLValueString($_POST['fornavn'], "text"),
                      GetSQLValueString($_POST['efternavn'], "text"),
                      GetSQLValueString($_POST['adresse'], "text"),
                      GetSQLValueString($_POST['forstad'], "text"),
                      GetSQLValueString($_POST['postnummer'], "text"),
                      GetSQLValueString($_POST['by'], "text"),
                      GetSQLValueString($_POST['land'], "text"),
                      GetSQLValueString($_POST['tlf'], "text"),
                      GetSQLValueString($_POST['mobiltlf'], "text"),
                      GetSQLValueString($_POST['emailadresse'], "text"),
                      GetSQLValueString($_POST['tekst'], "text"),
                      GetSQLValueString($_POST['mainid'], "int"));

Mere skal der ikke til.
Avatar billede grk Novice
10. april 2007 - 22:35 #21
Hvor skal dette indsættes.

<?php
$insertSQL = sprintf("INSERT INTO tilmelding (`date`, mand, kvinde, alder, fornavn, efternavn, adresse, forstad, postnummer, `by`, land, tlf, mobiltlf, emailadresse, tekst, mainid) VALUES (%s, %d, %d, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                      GetSQLValueString($_POST['date'], "text"),
                      $mand,
                      $kvinde,
                      GetSQLValueString($_POST['alder'], "text"),
                      GetSQLValueString($_POST['fornavn'], "text"),
                      GetSQLValueString($_POST['efternavn'], "text"),
                      GetSQLValueString($_POST['adresse'], "text"),
                      GetSQLValueString($_POST['forstad'], "text"),
                      GetSQLValueString($_POST['postnummer'], "text"),
                      GetSQLValueString($_POST['by'], "text"),
                      GetSQLValueString($_POST['land'], "text"),
                      GetSQLValueString($_POST['tlf'], "text"),
                      GetSQLValueString($_POST['mobiltlf'], "text"),
                      GetSQLValueString($_POST['emailadresse'], "text"),
                      GetSQLValueString($_POST['tekst'], "text"),
                      GetSQLValueString($_POST['mainid'], "int"));
?>
Avatar billede grk Novice
10. april 2007 - 22:40 #22
PS: er med.
Avatar billede dkfire Nybegynder
10. april 2007 - 22:43 #23
I stedet for der hvor der ca står dert samme nu.
og de to if-sætninger sætter du ind lige før. så det bliver til:

....
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "tilmelding")) {
f( $_POST['mand'] ){
$mand = 1;
} else
$mand = 0;
if( $_POST['kvinde'] ){
$kvinde = 1;
}else
$kvinde = 0;
$insertSQL = sprintf("INSERT INTO tilmelding (`date`, mand, kvinde, alder, fornavn, efternavn, adresse, forstad, postnummer, `by`, land, tlf, mobiltlf, emailadresse, tekst, mainid) VALUES (%s, %d, %d, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                      GetSQLValueString($_POST['date'], "text"),
                      $mand,
                      $kvinde,
                      GetSQLValueString($_POST['alder'], "text"),
                      GetSQLValueString($_POST['fornavn'], "text"),
                      GetSQLValueString($_POST['efternavn'], "text"),
                      GetSQLValueString($_POST['adresse'], "text"),
                      GetSQLValueString($_POST['forstad'], "text"),
                      GetSQLValueString($_POST['postnummer'], "text"),
                      GetSQLValueString($_POST['by'], "text"),
                      GetSQLValueString($_POST['land'], "text"),
                      GetSQLValueString($_POST['tlf'], "text"),
                      GetSQLValueString($_POST['mobiltlf'], "text"),
                      GetSQLValueString($_POST['emailadresse'], "text"),
                      GetSQLValueString($_POST['tekst'], "text"),
                      GetSQLValueString($_POST['mainid'], "int"));
Avatar billede grk Novice
10. april 2007 - 22:57 #24
Får denne meddelse at intet køn valgt.

Kode for udlæsning.

<?php
if($_POST['mand']){
echo "Mand";
}elseif( $_POST['kvinde'] ){
echo "Kvinde";
}else
echo "intet køn valgt";
?>
Avatar billede grk Novice
10. april 2007 - 22:59 #25
Dette er indsat.

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "tilmelding")) {
if( $_POST['mand'] ){
$mand = 1;
} else
$mand = 0;
if( $_POST['kvinde'] ){
$kvinde = 1;
}else
$kvinde = 0;
$insertSQL = sprintf("INSERT INTO tilmelding (`date`, mand, kvinde, alder, fornavn, efternavn, adresse, forstad, postnummer, `by`, land, tlf, mobiltlf, emailadresse, tekst, mainid) VALUES (%s, %d, %d, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                      GetSQLValueString($_POST['date'], "text"),
                      $mand,
                      $kvinde,
                      GetSQLValueString($_POST['alder'], "text"),
                      GetSQLValueString($_POST['fornavn'], "text"),
                      GetSQLValueString($_POST['efternavn'], "text"),
                      GetSQLValueString($_POST['adresse'], "text"),
                      GetSQLValueString($_POST['forstad'], "text"),
                      GetSQLValueString($_POST['postnummer'], "text"),
                      GetSQLValueString($_POST['by'], "text"),
                      GetSQLValueString($_POST['land'], "text"),
                      GetSQLValueString($_POST['tlf'], "text"),
                      GetSQLValueString($_POST['mobiltlf'], "text"),
                      GetSQLValueString($_POST['emailadresse'], "text"),
                      GetSQLValueString($_POST['tekst'], "text"),
                      GetSQLValueString($_POST['mainid'], "int"));
Avatar billede dkfire Nybegynder
10. april 2007 - 23:15 #26
hvordan ser din side for indtastning ud nu.
Avatar billede grk Novice
10. april 2007 - 23:31 #27
<?php require_once('Connections/cms.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "tilmelding")) {
if( $_POST['mand'] ){
$mand = 1;
} else
$mand = 0;
if( $_POST['kvinde'] ){
$kvinde = 1;
}else
$kvinde = 0;
$insertSQL = sprintf("INSERT INTO tilmelding (`date`, mand, kvinde, alder, fornavn, efternavn, adresse, forstad, postnummer, `by`, land, tlf, mobiltlf, emailadresse, tekst, mainid) VALUES (%s, %d, %d, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                      GetSQLValueString($_POST['date'], "text"),
                      $mand,
                      $kvinde,
                      GetSQLValueString($_POST['alder'], "text"),
                      GetSQLValueString($_POST['fornavn'], "text"),
                      GetSQLValueString($_POST['efternavn'], "text"),
                      GetSQLValueString($_POST['adresse'], "text"),
                      GetSQLValueString($_POST['forstad'], "text"),
                      GetSQLValueString($_POST['postnummer'], "text"),
                      GetSQLValueString($_POST['by'], "text"),
                      GetSQLValueString($_POST['land'], "text"),
                      GetSQLValueString($_POST['tlf'], "text"),
                      GetSQLValueString($_POST['mobiltlf'], "text"),
                      GetSQLValueString($_POST['emailadresse'], "text"),
                      GetSQLValueString($_POST['tekst'], "text"),
                      GetSQLValueString($_POST['mainid'], "int"));

  mysql_select_db($database_cms, $cms);
  $Result1 = mysql_query($insertSQL, $cms) or die(mysql_error());
}

$colname_rsBannertekst = "1";
if (isset($_GET['id'])) {
  $colname_rsBannertekst = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rsBannertekst = sprintf("SELECT * FROM bannertekst WHERE id = %s ORDER BY id DESC", $colname_rsBannertekst);
$rsBannertekst = mysql_query($query_rsBannertekst, $cms) or die(mysql_error());
$row_rsBannertekst = mysql_fetch_assoc($rsBannertekst);
$totalRows_rsBannertekst = mysql_num_rows($rsBannertekst);

$colname_rsNewsubmenu_tilmelding = "1";
if (isset($_GET['id'])) {
  $colname_rsNewsubmenu_tilmelding = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_cms, $cms);
$query_rsNewsubmenu_tilmelding = sprintf("SELECT id FROM tilmelding WHERE id = %s", $colname_rsNewsubmenu_tilmelding);
$rsNewsubmenu_tilmelding = mysql_query($query_rsNewsubmenu_tilmelding, $cms) or die(mysql_error());
$row_rsNewsubmenu_tilmelding = mysql_fetch_assoc($rsNewsubmenu_tilmelding);
$totalRows_rsNewsubmenu_tilmelding = mysql_num_rows($rsNewsubmenu_tilmelding);

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
    background-color: #e9e9e9;
}
.style21 {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-weight: bold;
    font-size: 11px;
    color: #000099;
}
.style23 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 16px; color: #000099; }
.style24 {color: #000099}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
  if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>

<body>
<table width="890" height="23" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#FFFFFF"><img src="img/bj1_890_23.gif" width="890" height="23"></td>
  </tr>
</table>
<table width="890" height="23" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" bgcolor="#FFFFFF"><a href="tilmelding.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image28','','admin/img_link/adm_35_over.gif',0)"><img src="admin/img_link/adm_35.gif" name="Image28" width="90" height="23" border="0"></a><img src="img/blank_113_23.gif" width="113" height="23"></td>
    <td bgcolor="#FFFFFF"><a href="index.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image16','','img/rod_01_over.gif',0)"><img src="img/rod_01.gif" name="Image16" width="70" height="23" border="0"></a><a href="klubinfo.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image17','','img/rod_06_over.gif',0)"><img src="img/rod_06.gif" name="Image17" width="75" height="23" border="0"></a><a href="program.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image18','','img/rod_03_over.gif',0)"><img src="img/rod_03.gif" name="Image18" width="70" height="23" border="0"></a><a href="aktiviteter.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image19','','img/rod_05_over.gif',0)"><img src="img/rod_05.gif" name="Image19" width="100" height="23" border="0"></a><a href="nyheder.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image20','','img/rod_02_over.gif',0)"><img src="img/rod_02.gif" name="Image20" width="70" height="23" border="0"></a><a href="fotoalbum.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image21','','img/rod_09_over.gif',0)"><img src="img/rod_09.gif" name="Image21" width="90" height="23" border="0"></a><a href="links.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image22','','img/rod_10_over.gif',0)"><img src="img/rod_10.gif" name="Image22" width="50" height="23" border="0"></a><a href="info.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image23','','img/rod_07_over.gif',0)"><img src="img/rod_07.gif" name="Image23" width="40" height="23" border="0"></a><a href="kontakt_os.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image24','','img/rod_08_over.gif',0)"><img src="img/rod_08.gif" name="Image24" width="100" height="23" border="0"></a><img src="img/blank_22_23.gif" width="22" height="23"></td>
  </tr>
</table>
<table width="890" height="122" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td background="img/banner_1.jpg" bgcolor="#FFFFFF"><div align="center"><?php echo $row_rsBannertekst['tekst']; ?></div></td>
  </tr>
</table>
<table width="890" height="27" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" bgcolor="#FFFFFF"><img src="img/bj3_203_27.gif" width="203" height="27"></td>
    <td bgcolor="#FFFFFF"><img src="img/bj3_687_27.gif" width="687" height="27"></td>
  </tr>
</table>
<table width="890" height="44" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="203" bgcolor="#FFFFFF"><img src="img/bj4_203_44.gif" width="203" height="44"></td>
    <td width="460" bgcolor="#FFFFFF"><img src="img/bj4_tilmelding_460_44.gif" width="460" height="44"></td>
    <td width="227" bgcolor="#FFFFFF"><img src="img/bj4_227_44.gif" width="227" height="44"></td>
  </tr>
</table>
<table width="890" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr><?php
$tekst1 = nl2br($row_rsForside['tekst1']);
$tekst2 = nl2br($row_rsForside['tekst2']);
$tekst3 = nl2br($row_rsForside['tekst3']);
$tekst4 = nl2br($row_rsForside['tekst4']);
$tekst5 = nl2br($row_rsForside['tekst5']);
$tekst6 = nl2br($row_rsForside['tekst6']);
?>
    <td width="203" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
    <td width="460" bgcolor="#FFFFFF"><form action="<?php echo $editFormAction; ?>" method="POST" name="tilmelding" id="tilmelding">
      <table width="460" border="0" cellspacing="0" cellpadding="2">
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td class="style23">&nbsp;</td>
          <td colspan="2" class="style23">Dine Personlige Oplysninger </td>
          <td width="40" class="style23">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2" class="style21"> Skal oplyses * </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Dato:</td>
          <td width="240"><p>
            <input name="date" type="text" id="date" size="15">
            <span class="style24">*</span>           
            </p>            </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">K&oslash;n:</td>
          <td width="240"><input name="mand" type="checkbox" id="mand" value="1">           
          <span class="style21">Mand</span> <span class="style21">
<input name="kvinde" type="checkbox" id="kvinde" value="1"> 
Kvinde
  <input name="alder" type="text" id="alder" size="1">
  Alder * </span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Fornavn:</td>
          <td width="240"><input name="fornavn" type="text" id="fornavn2" size="30">
            <span class="style24">*</span> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Efternavn:</td>
          <td width="240"><input name="efternavn" type="text" id="efternavn2" size="30">
            <span class="style24">*</span> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td class="style23">&nbsp;</td>
          <td width="240" class="style23">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2"><span class="style23">Din Adresse</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">&nbsp;</td>
          <td width="240">&nbsp;            </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Adresse:</td>
          <td width="240"><input name="adresse" type="text" id="adresse2" size="30">
            <span class="style24">*</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Forstad/Stednavn:</td>
          <td width="240"><input name="forstad" type="text" id="forstad2" size="30"></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Postnummer:</td>
          <td width="240"><input name="postnummer" type="text" id="postnummer2" size="15">
            <span class="style24">*</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">By:</td>
          <td width="240"><input name="by" type="text" id="by2" size="30">
            <span class="style24">*</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140"><span class="style21">Land:</span></td>
          <td width="240"><input name="land" type="text" id="land2" size="30">
            <span class="style24">*</span> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td class="style23">&nbsp;</td>
          <td width="240" class="style23">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2"><span class="style23">Din Kontakt Information</span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">&nbsp;</td>
          <td width="240">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Tlf.:</td>
          <td width="240"><input name="mobiltlf" type="text" id="mobiltlf" size="15"></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">Mobil tlf.:</td>
          <td width="240"><input name="tlf" type="text" id="tlf2" size="15"></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140"><span class="style21">E-mail-adresse:</span></td>
          <td width="240"><input name="emailadresse" type="text" id="emailadresse2" size="30">
            <span class="style24">*</span> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td class="style23">&nbsp;</td>
          <td width="240" class="style23">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td colspan="2"><span class="style23">Personlig Information </span></td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140" class="style21">&nbsp;</td>
          <td width="240">&nbsp;</td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td width="40">&nbsp;</td>
          <td width="140"><span class="style21">Tekst:</span></td>
          <td width="240"><textarea name="tekst" rows="5" id="textarea"></textarea> </td>
          <td width="40">&nbsp;</td>
        </tr>
        <tr bgcolor="e9e9e9">
          <td>&nbsp;</td>
          <td><input name="mainid" type="hidden" id="mainid" value="<?php echo $row_rsNewsubmenu_tilmelding['id']; ?>">            <?php 
  if(isset($_POST['send'])){
    $to = "Cape <".$_POST['til'].">";             
    $from = "From: Webmaster <auto@domain.dk>";                   
    $Bcc = "Bcc: Usynlig <xxxx@xxxxxxx.dk>"; 
    $ReplyTo = "Reply-To: modtager@domain.dk";
    $subject = "Tak for din tilmelding";
    $message = "Velkommen i klubben";
    $headers  = "MIME-Version: 1.0\r\n";                                           
    $headers .= "$from\r\n";
    $headers .= "$Bcc\r\n";
    $headers .= "$ReplyTo\r\n";
    mail($to, $subject, $message, $headers);
    echo "<input type=\"hidden\" name=\"til\" value=\"".$row_rsEmail['email']."\">";
}
?></td>
          <td width="240"><input name="send" type="submit" id="send2" value="Send">             
            <input name="reset" type="reset" id="reset" value="Reset"></td><td width="40">&nbsp;</td>
        </tr>
      </table>
        <input type="hidden" name="MM_insert" value="tilmelding">
            </form>    </td>
    <td width="227" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
</table>
<table width="890" height="0" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td valign="top" bgcolor="#FFFFFF"><form name="form1" method="get" action="resultat.php">
      <table width="890" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="203" rowspan="2"><img src="img/banner_2.jpg" width="203" height="57"></td>
          <td width="687" height="33" colspan="3"><img src="img/bj5_687_33.gif" width="687" height="33"></td>
        </tr>
        <tr>
          <td width="528" height="24"><a href="raadgivning.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image25','','img/rod_11_over.gif',0)"><img src="img/rod_11.gif" name="Image25" width="100" height="24" border="0"></a><a href="vedtaegter.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image26','','img/rod_12_over.gif',0)"><img src="img/rod_12.gif" name="Image26" width="90" height="24" border="0"></a><a href="sponsorer.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image27','','img/rod_13_over.gif',0)"><img src="img/rod_13.gif" name="Image27" width="90" height="24" border="0"></a><a href="annoncer.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image30','','img/rod_15_over.gif',0)"><img src="img/rod_15.gif" name="Image30" width="80" height="24" border="0"></a><a href="bestyrelsen.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image29','','img/rod_14_over.gif',0)"><img src="img/rod_14.gif" name="Image29" width="90" height="24" border="0"></a><a href="klubnyt.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image31','','img/rod_04_over.gif',0)"><img src="img/rod_04.gif" name="Image31" width="70" height="24" border="0"></a><img src="img/blank_3_24.gif" width="3" height="24"></td>
          <td width="119">
              <div align="left">
                <input name="search" type="text" id="search" size="15">
              </div></td>
          <td width="40"><input name="s&oslash;g" type="submit" id="s&oslash;g" value="S&oslash;g"></td>
        </tr>
      </table>
    </form></td>
  </tr>
</table>
<br>
</body>
</html>
<?php
mysql_free_result($rsBannertekst);

mysql_free_result($rsNewsubmenu_tilmelding);
?>
Avatar billede dkfire Nybegynder
10. april 2007 - 23:37 #28
Og den virker fint ???
Så mangler vi bare den anden side.

Der hvor du vil have vist mand eller kvind skal du skrive:

if( $row_rsTilmelding['mand'] == 1 ){
echo "mand";
}elseif( $row_rsTilmelding['kvinde'] == 1){
echo "kvinde";
}else
echo "intet køn valgt";
Avatar billede grk Novice
11. april 2007 - 00:07 #29
Flot arbejde, det virker perfekt nu.
Det var en sej kamp, men du holdt ud til det sidste.
Tusing tak for din store hjælp.
Du lægger lige et svar.
Avatar billede dkfire Nybegynder
11. april 2007 - 11:04 #30
svar
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Webudvikling kurser
Vi tilbyder markedets bedste kurser inden for webudvikling
Se alle Webudvikling kurser

Flere spørgsmål fra PHP kategorien

Titel Indlæg Oprettet Seneste aktivitet
System til bordreservation Af Strawberry i PHP 3 20/07/202611:23 31/07/202620:50
Bruge PHP til at hente hjemmeside med fsockopen Af Strawberry i PHP 18 29/01/202613:08 02/02/202610:29
Hjemmeside der virker både på mobil og computer Af Strawberry i PHP 6 25/01/202620:06 30/01/202618:53
Hvordan får jeg reCAPTCHA på min hjemmeside? Af Strawberry i PHP 1 20/01/202621:11 23/01/202618:04
MS Graph vis kalenderaftaler Af dane022 i PHP 0 06/11/202508:43 -
Se alle spørgsmål i kategorien Opret spørgsmål

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Opret Log ind

Du kan også logge ind via nedenstående tjenester

Alle kategorier på Eksperten
Seneste spørgsmål Seneste aktivitet
I går 17:10 Windows 10 Home 22H2 produktnøgle Af Uvanga i Windows
I går 17:10 Windows 10 Home 22H2 produktnøgle Af Uvanga i Windows
05/0810:19 Kan jeg beholde Publisher på min maskine efter at MS stopper med support Af KurtG i Office & Kontorpakker
02/0814:53 TV4ever 3.0 Af valby i Diverse
01/0816:21 Installere Ubuntu på Virtuel Maskine Af Uvanga i Andet software
White papers
Flere white papers »