Inserting result from Radio Button

FantasyLink

<?php
include ('header.php');
include ('./includes/includefile.php');


if($action=="insert") {
$strSQL = "INSERT INTO userncaapredict (nwb1, nwb2, nwb3, nwb4, nwb5, nwb6, nwb7, nwb8) VALUES ('Ken','$nwb2','$nwb3','$nwb4','$nwb5','$nwb6','$nwb7','$nwb8')";
$result = mysql_query($strSQL) or die(mysql_error());
}
echo $strSQL;

echo $nwb1;
echo $nwb2;
echo $nwb3;
echo $nwb4;
echo $nwb5;
echo $nwb6;
echo $nwb7;
echo $nwb8;
?>

Does this INSERT code looks right? I assign a hardcore value (Ken) just to test the code and it doesn't get through so something must be wrong? I am seeing right result when I echo $nwb1 - $nwb8 but it is just not inserting into the database.

Drakla

Are you getting an error?
Where is $action coming from, and is it set?

FantasyLink

<form action="process1stround.php" method="POST">
<table width="90" cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="86"><?php echo $nw1; ?></td>
<td width="4" align="right"><INPUT TYPE="RADIO" NAME="nwb1" VALUE="<?php echo $nw1; ?>"></td>
</tr>
<tr>
<td width="86"><?php echo $nw2; ?></td>
<td width="4" align="right"><INPUT TYPE="RADIO" NAME="nwb1" VALUE="<?php echo $nw2; ?>"></td>
</tr>
<tr>
<td width="86"><?php echo $nw3; ?></td>
<td width="4" align="right"><INPUT TYPE="RADIO" NAME="nwb2" VALUE="<?php echo $nw3; ?>"></td>
</tr>
<tr>
<td width="86"><?php echo $nw4; ?></td>
<td width="4" align="right"><INPUT TYPE="RADIO" NAME="nwb2" VALUE="<?php echo $nw4; ?>"></td>
</tr>
</table>
<input type="submit" name="Submit" value="SUBMIT"></form>

The HTML code above is shorter than original to make it easier to read and anaylyze what I am doing. There was no error message and I am seeing correct result, but it is just not posting.

I thought that $action would be because the result is being submitted from previous page?

Houdini

No matter what your code says when you have a form with radio buttons they all have the same name but different buttons, you are not allowed to check mor than one redio button on a form, to get the desired result you should use the checkbox instead and with checkboxes they all have the same name as well but each will have a different value, these name values go into a multidimensional array as $name[] and whatever you select wil be called $name[1], $name[2], $name[3] .

FantasyLink

Houdini,

I am not sure I understand what you are trying to say? But just to be sure that we are on same page. You are saying that no matter how many radio buttons with different name, php will not be able to recognize different name value??

But let me ask you how? You see <Input Type="radio" Name="column_value" Value="field_value"> "Name" would tell which column to insert and "Value" would be the desired result.

I have successfully created multiple radio buttons using UPDATE command with multiple elseif statement.

Now I wish to create a simple multiple radio buttons with INSERT and not too many elseif. :bemused:

msk_1980

Ok again where is $action variable comming from. I cant find anything in the form.

so it could be the if condition thats not being executed, so the values are not being inserted into the database. try to echo some value in the if and see if "if" condition is being executed.

One more thing, i hope you are receiving the values of variables in processing as $_POST ( just because i cant see that code anywhere).

FantasyLink

So instead of this:

if($action=="insert") {
$strSQL = "INSERT INTO userncaapredict (nwb1, nwb2, nwb3, nwb4, nwb5, nwb6, nwb7, nwb8) VALUES ('Ken','$nwb2','$nwb3','$nwb4','$nwb5','$nwb6','$nwb7','$nwb8')";
$result = mysql_query($strSQL) or die(mysql_error());
}

Should use this:

if($nwb1, $nwb2, $nwb3, $nwb4, $nwb5, $nwb6, $nwb7, $nwb8=="insert") {
$strSQL = "INSERT INTO userncaapredict (nwb1, nwb2, nwb3, nwb4, nwb5, nwb6, nwb7, nwb8) VALUES ('Ken','$nwb2','$nwb3','$nwb4','$nwb5','$nwb6','$nwb7','$nwb8')";
$result = mysql_query($strSQL) or die(mysql_error());
}

msk_1980

If you got the form and processing in two different pages and if you want to only insert values, dont worry about the if condition.

try this:

$strSQL = "INSERT INTO userncaapredict (nwb1, nwb2, nwb3, nwb4, nwb5, nwb6, nwb7, nwb8) VALUES ('Ken','$nwb2','$nwb3','$nwb4','$nwb5','$nwb6','$nwb7','$nwb8')";
$result = mysql_query($strSQL) or die(mysql_error());

if you dont want null values to go into you can check if they have been checked or not before inserting into the database.

sapoxgn

you can try something like this:

$radio = "nwb";
$query = "INSERT INTO table (";
$query2 = "VALUES(";
for($i=0; $i < 10; $i++) {
  if(isset($_POST[$radio . $i]) {
     $query .= $radio . $i . ",";
     $query2 .= addslashes($_POST[$radio . $i]) . ",";
  }
}
$query .= substr($query, 0, strlen($query) - 1);
$query .= ") ";
$query2 .= substr($query2, 0, strlen($query2) - 1);
$query .= ")";

$query .= $query2;

btw.. i didnt test it ok? use it at your own risk 😃