Problema con radio button
Hola estoy haciendo un formulario que guarda los datos en una bd.
El problema es que estoy utilizando unos checkbox, pero resulta q solo me coje los valores de los checkbox q al principio estan seleccionador (en este caso los que tienen value=si).
Este es el codigo:
print "<div id=\"containerRight\">\n";
if (isset($varDay) && isset($varLocation) && isset($varCity) && isset($varArtists) && isset($varNextDates) && isset($varHeaderDates)) {
function dayNew($varDay){
list($d,$m,$a)=explode(".",$varDay);
return $a."-".$m."-".$d;
};
$dayMySQL=dayNew($varDay);
$query = "INSERT INTO dates (day, location, city, artists, title, nextDates, headerDates) VALUES ('$dayMySQL', '$varLocation', '$varCity', '$varArtists', '$varTitle', '$varNextDates', '$varHeaderDates')";
if (mysql_query($query)) {
print "The date was inserted.";
print "$varNextDates, $varHeaderDates";
} else {
print "CAUTION!<br />\n";
print "The date has NOT been inserted.";
}
print "</div>
\n";
} else {
print "<form method=\"post\">\n";
print "
<div style=\"float:left; background-color:#cfccca; margin-bottom:10px; padding:20px;\">\n";
print "
<div class=\"titoloForm\">Day</div>
\n";
print "<input class=\"textField\" type=\"text\" name=\"varDay\"/>\n";
print "
<div class=\"titoloForm\">Location</div>
\n";
print "
<div class=\"titoloFormRight\">City</div>
\n";
print "<input class=\"textField\" type=\"text\" name=\"varLocation\" />\n";
print "<input class=\"textFieldRight\" type=\"text\" name=\"varCity\" />\n";
print "
<div class=\"titoloForm\">Artists</div>
\n";
print "<input class=\"textField\" style=\"width:283px;\" type=\"text\" name=\"varArtists\" />\n";
print "
<div class=\"titoloForm\">Title</div>
\n";
print "<input class=\"textField\" style=\"width:283px; margin-bottom:20px;\" type=\"text\" name=\"varTitle\" />\n";
/* INSERT NEXT DATES */
print "
<div class=\"titoloForm\" style=\"width:285px;\">Is it a next date?</div>
\n";
print "
<div class=\"titoloForm\" style=\"clear:none; width:25px; margin-bottom:20px;\">Si</div>
\n";
print "<input class=\"radioButton\" name=\"varNextDates\" type=\"radio\" value=\"si\" checked />\n";
print "
<div class=\"titoloForm\" style=\"clear:none; width:25px;\">No</div>
\n";
print "<input class=\"radioButton\" name=\"varNextDates\" type=\"radio\" value=\"no\" />\n";
/* INSERT HEADER DATES */
print "
<div class=\"titoloForm\" style=\"width:285px;\">Is it a header date?</div>
\n";
print "
<div class=\"titoloForm\" style=\"clear:none; width:25px;\">Si</div>
\n";
print "<input class=\"radioButton\" name=\"varHeaderDates\" type=\"radio\" value=\"si\" checked />\n";
print "
<div class=\"titoloForm\" style=\"clear:none; width:25px;\">No</div>
\n";
print "<input class=\"radioButton\" name=\"varHeaderDates\" type=\"radio\" value=\"no\" />\n";
print "</div>
\n";
print "<input type=\"submit\" class=\"insertDate\" value=\"\" />\n";
print "</form>\n";
}
print "</div>
\n";
Y esto es el resultado: http://www.eribertocaria.com/monorecords/backsite.php?page=dates
Gracias.
Un saludo
eribertocaria
Bueno, mejor os paso el codigo de toda la pagina:
<?php
include("db_connect.php");
include("query.php");
/*echo "<pre>";
print_r($_REQUEST);
echo "</pre>";*/
?>
<!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>Mono Records // Backsite</title>
<link rel="stylesheet" type="text/css" href="script/reset-min.css">
<link rel="stylesheet" href="script/estilo.css" type="text/css" media="screen">
<script type="text/javascript" src="script/jquery-1.js"></script>
<script type="text/javascript" src="script/myscripts.js"></script>
<script type="text/javascript">
function seeIshome(pantalla_ancho){
var isHome = 'true';
if (isHome == "true"){
$("#sliderContent").css("width",pantalla_ancho+"px");
$("#openCloseWrap").css("width",pantalla_ancho+"px");
}
}
</script>
<script type="text/javascript" src="script/swfobject.js"></script>
<script type="text/javascript" src="script/cufon-yui.js"></script>
<script type="text/javascript" src="script/Aachen_400.font.js"></script>
<script type="text/javascript">
Cufon.replace(['h1','h2','h3','h4','ul','li', 'p.dataDatesHeader', 'span.localeDatesHeader', 'span.artistiDatesHeader', 'span.titoloReleaseHeader', 'div.piepaginaLeft', 'a#menuTopAbrir', 'p.menuBacksite', 'span.localeDates', 'span.artistiDates', 'p.dataDates', 'div.titoloForm', 'div.titoloFormRight', 'div.nextDate', 'div.headerDate']);
</script>
</head>
<body>
<div class="container">
<?php include("header.php"); ?>
<div id="titulos">
<div id="containerLeft">
<h1><span class="testoH1">Backsite</span></h1>
</div>
<div id="containerCenter">
<h2><span class="testoH2"><?php
if (isset($page)) {
if ($page=="dates" OR $page=="editDates") {
print "Dates";
} else if ($page=="newsletter") {
print "Newsletter";
}
}
?></span></h2>
</div>
<div id="containerRight">
<h2><span class="testoH2"><?php
if (isset($page)) {
if ($page=="dates") {
print "Insert date";
}
}
?></span></h2>
</div>
</div>
<!-- MENU BACKSITE -->
<div id="containerLeft">
<p class="menuBacksite"><a href="backsite.php?page=dates">Dates</a></p>
<p class="menuBacksite"><a href="backsite.php?page=newsletter">Newsletter</a></p>
</div>
<?php
if (isset($page)) {
if ($page=="dates") {
/* LIST DATES*/
print "<div id=\"containerCenter\">\n";
if (isset($idDelete)){
$sql = "DELETE FROM dates WHERE idDates='$idDelete'";
if (mysql_query($sql)) {
print "The date was deleted.";
} else {
print "CAUTION!<br />\n";
print "The date has NOT been deleted.";
}
} else {
while($rowPages = mysql_fetch_array($queryLastDates)){
print "<div style=\"float:left; clear:left; background-color:#cfccca; margin-bottom:5px; width:325px;\">\n";
print "<p class=\"dataDates\">$rowPages[dayNewFormat]</p>\n";
print "<p class=\"locationDates\"><span class=\"localeDates\">$rowPages[location]</span> // $rowPages[city]</p>\n";
print "<span class=\"artistiDates\">$rowPages[artists]</span>\n";
print "<p class=\"titoloDates\">$rowPages[title]</p>\n";
print "</div>\n";
if ($rowPages[nextDates]=="si") {
print "<div class=\"nextDate\">It is a next date</div>\n";
}
if ($rowPages[headerDates]=="si") {
print "<div class=\"headerDate\">It is a header date</div>\n";
}
print "<a class=\"editDates\" href=\"backsite.php?page=editDates&idEdit=$rowPages[idDates]\" ><img src=\"img/editDates.gif\" widht=\"40px\" height=\"20px\"/></a>\n";
print "<a class=\"deleteDate\" href=\"backsite.php?page=dates&idDelete=$rowPages[idDates]\" ><img src=\"img/deleteDate.gif\" widht=\"60px\" height=\"20px\"/></a>\n";
}
}
print "</div>\n";
/* INSERT DATE*/
print "<div id=\"containerRight\">\n";
if (isset($varDay) && isset($varLocation) && isset($varCity) && isset($varArtists) && isset($varNextDates) && isset($varHeaderDates)) {
function dayNew($varDay){
list($d,$m,$a)=explode(".",$varDay);
return $a."-".$m."-".$d;
};
$dayMySQL=dayNew($varDay);
$query = "INSERT INTO dates (day, location, city, artists, title, nextDates, headerDates) VALUES ('$dayMySQL', '$varLocation', '$varCity', '$varArtists', '$varTitle', '$varNextDates', '$varHeaderDates')";
if (mysql_query($query)) {
print "The date was inserted.";
print "$varNextDates, $varHeaderDates";
} else {
print "CAUTION!<br />\n";
print "The date has NOT been inserted.";
}
print "</div>\n";
} else {
print "<form method=\"post\">\n";
print "<div class=\"containerFormDates\">\n";
print "<div class=\"titoloForm\">Day</div>\n";
print "<input class=\"textField\" type=\"text\" name=\"varDay\"/>\n";
print "<div class=\"titoloForm\">Location</div>\n";
print "<div class=\"titoloFormRight\">City</div>\n";
print "<input class=\"textField\" type=\"text\" name=\"varLocation\" />\n";
print "<input class=\"textFieldRight\" type=\"text\" name=\"varCity\" />\n";
print "<div class=\"titoloForm\">Artists</div>\n";
print "<input class=\"textField\" style=\"width:283px;\" type=\"text\" name=\"varArtists\" />\n";
print "<div class=\"titoloForm\">Title</div>\n";
print "<input class=\"textField\" style=\"width:283px; margin-bottom:20px;\" type=\"text\" name=\"varTitle\" />\n";
/* INSERT NEXT DATES */
print "<div class=\"titoloForm\" style=\"width:285px;\">Is it a next date?</div>\n";
print "<div class=\"titoloForm\" style=\"clear:none; width:25px; margin-bottom:20px;\">Si</div>\n";
print "<input class=\"radioButton\" name=\"varNextDates\" type=\"radio\" value=\"si\" checked />\n";
print "<div class=\"titoloForm\" style=\"clear:none; width:25px;\">No</div>\n";
print "<input class=\"radioButton\" name=\"varNextDates\" type=\"radio\" value=\"no\" />\n";
/* INSERT HEADER DATES */
print "<div class=\"titoloForm\" style=\"width:285px;\">Is it a header date?</div>\n";
print "<div class=\"titoloForm\" style=\"clear:none; width:25px;\">Si</div>\n";
print "<input class=\"radioButton\" name=\"varHeaderDates\" type=\"radio\" value=\"si\" checked />\n";
print "<div class=\"titoloForm\" style=\"clear:none; width:25px;\">No</div>\n";
print "<input class=\"radioButton\" name=\"varHeaderDates\" type=\"radio\" value=\"no\" />\n";
print "</div>\n";
print "<input type=\"submit\" class=\"insertDate\" value=\"\" />\n";
print "</form>\n";
}
print "</div>\n";
/* EDIT DATES */
} else if ($page=="editDates") {
if (isset($varDay) && isset($varLocation) && isset($varCity) && isset($varArtists) && isset($varTitle) && isset($varNextDates) && isset($varHeaderDates)) {
print "<div id=\"containerCenter\">\n";
function dayNew($varDay){
list($d,$m,$a)=explode(".",$varDay);
return $a."-".$m."-".$d;
};
$dayMySQL=dayNew($varDay);
$query = "UPDATE dates SET day='$dayMySQL', location='$varLocation', city='$varCity', artists='$varArtists', title='$varTitle', nextDates='$varNextDates', headerDates='$varHeaderDates' WHERE idDates='$idEdit'";
if (mysql_query($query)) {
print "The date was changed.";
print "$varNextDates, $varHeaderDates";
} else {
print "CAUTION!<br />\n";
print "The date has NOT been modified.";
}
print "</div>\n";
} else {
print "<form method=\"post\">\n";
print "<div id=\"containerCenter\">\n";
print "<div class=\"containerFormDates\">\n";
print "<div class=\"titoloForm\">Day</div>\n";
print "<input class=\"textField\" type=\"text\" name=\"varDay\" value=\"$resultEditDates[dayNewFormat]\"/>\n";
print "<div class=\"titoloForm\">Location</div>\n";
print "<div class=\"titoloFormRight\">City</div>\n";
print "<input class=\"textField\" type=\"text\" name=\"varLocation\" value=\"$resultEditDates[location]\"/>\n";
print "<input class=\"textFieldRight\" type=\"text\" name=\"varCity\" value=\"$resultEditDates[city]\"/>\n";
print "<div class=\"titoloForm\">Artists</div>\n";
print "<input class=\"textField\" style=\"width:283px;\" type=\"text\" name=\"varArtists\" value=\"$resultEditDates[artists]\"/>\n";
print "<div class=\"titoloForm\">Title</div>\n";
print "<input class=\"textField\" style=\"width:283px; margin-bottom:20px;\" type=\"text\" name=\"varTitle\" value=\"$resultEditDates[title]\"/>\n";
/* EDIT NEXT DATES */
print "<div class=\"titoloForm\" style=\"width:285px;\">Is it a next date?</div>\n";
$varNextDates=$resultEditDates[nextDates];
print "<div class=\"titoloForm\" style=\"clear:none; width:25px; margin-bottom:20px;\">Si</div>\n";
print "<input class=\"radioButton\" name=\"varNextDates\" type=\"radio\" value=\"si\" ";
if ($varNextDates=="si") print "checked";
print " />\n";
print "<div class=\"titoloForm\" style=\"clear:none; width:25px;\">No</div>\n";
print "<input class=\"radioButton\" name=\"varNextDates\" type=\"radio\" value=\"no\" ";
if ($varNextDates=="no") print "checked";
print " />\n";
/* EDIT HEADER DATES */
print "<div class=\"titoloForm\" style=\"width:285px;\">Is it a header date?</div>\n";
$varHeaderDates=$resultEditDates[headerDates];
print "<div class=\"titoloForm\" style=\"clear:none; width:25px;\">Si</div>\n";
print "<input class=\"radioButton\" name=\"varHeaderDates\" type=\"radio\" value=\"si\" ";
if ($varHeaderDates=="si") print "checked=\"checked\"";
print " />\n";
print "<div class=\"titoloForm\" style=\"clear:none; width:25px;\">No</div>\n";
print "<input class=\"radioButton\" name=\"varHeaderDates\" type=\"radio\" value=\"no\" ";
if ($varHeaderDates=="no") print "checked=\"checked\"";
print " />\n";
print "</div>\n";
print "</div>\n";
print "<div id=\"containerRight\">\n";
print "<img id=\"imgDates\" src=\"dates/121109.jpg\" width=\"323\" height=\"457\" /> \n";
print "</div>\n";
print "<div style=\"margin:10px 0px 50px 235px;\">\n";
print "<input type=\"hidden\" name=\"idEdit\" value=\"$resultEditDates[idDates]\" />";
print "<input type=\"submit\" class=\"updateDate\" value=\"\" />\n";
print "</div>\n";
print "</form>\n";
}
} else if ($page=="newsletter") {
/* ELENCO NAME/EMAIL */
print "<div id=\"containerCenter\">\n";
print "<div id=\"containerBacksite\">\n";
while ($select_newsletter = mysql_fetch_array($queryNewsletter)) {
print "<p class=\"testoNewsletterName\">$select_newsletter[name]</p>\n";
print "<p class=\"testoNewsletterEmail\">$select_newsletter[email]</p>\n";
}
print "</div>\n";
print "</div>\n";
/* ELENCO EMAIL */
print "<div id=\"containerRight\">\n";
print "<div id=\"containerBacksite\">\n";
while ($select_mail = mysql_fetch_array($queryEmailNewsletter)) {
print "$select_mail[email], ";
}
print "</div>\n";
print "</div>\n";
}
}
?>
</div>
</div>
</body>
</html>
<?php include("db_close.php"); ?>