hey i have a question i have been struggling with a php script that will take the value of radio groups and submit them to mysql through phpmyadmin. i have searched the net for answers and cant seem to find anything. my goal is to have users select between four radio groupd who they wish elected for positions then have that data sent to mysql. any help here would be awesome. i am new to php btw.
oh yea and the text portion will shop up in mysql if filled out but no other data is sent
Code:
<form id="form1" name="form1" method="post" action="process.php">
<p>President</p>
<p>
<label>
<input type="radio" name="president[]" value="field11" id="president" />
Me</label>
<br />
<label>
<input type="radio" name="president[]" value="field12" id="president" />
You</label>
<br />
<label>
<input type="radio" name="president[]" value="field13" id="president" />
Other </label>
<label>
<input type="text" name="president" id="president" value="" size="25" />
</p>
<p>
</label>
</p>
<p>VicePresident</p>
<p>
<label>
<input type="radio" name="vp" value="field21" id="vp" />
John</label>
<br />
<label>
<input type="radio" name="vp" value="field22" id="vp" />
Marty</label>
<br />
<label>
<input type="radio" name="vp" value="field23" id="vp" />
Other</label>
<input type="text" name="vp" id="vp" value="" size="25" />
</label>
</p>
<p> </p>
<p>Treasurer</p>
<p>
<label>
<input type="radio" name="tr" value="field31" id="tr" />
Bob</label>
<br />
<label>
<input type="radio" name="tr" value="field32" id="tr" />
Rob</label>
<br />
<label>
<input type="radio" name="tr" value="field33" id="tr" />
Other</label>
<input type="text" name="tr" id="tr" value="" size="25" />
</label>
</p>
<p>Sectretary</p>
<p>
<label>
<input type="radio" name="sect" value="field41" id="sect" />
Richard</label>
<br />
<label>
<input type="radio" name="sect" value="field42" id="sect" />
Bella</label>
<br />
<label>
<input type="radio" name="sect" value="field43" id="sect" />
Other</label>
<label>
<input type="text" name="sect" id="sect" value="" size="25" />
</label>
</p>
<p>
<label>
<input type="reset" name="reset" id="reset" value="Reset" />
<input type="submit" name="Submit" id="Submit" value="Submit" />
</label>
<br />
</p>
</form>
<?php
//Show all $_POST variables the page is receiving.
echo '<pre>Debugging:'; print_r($_POST); echo '</pre>';
reset($_POST); //print_r() moves the array pointer to the last value, this resets it to number one.
//OR,
var_dump($_POST);
$president=$_POST['field11'];
$vp=$_POST['field21'];
$tr=$_POST['field31'];
$sect=$_POST['field41'];
mysql_connect("localhost", "root", "kungfu") or die(mysql_error());
mysql_select_db("membership") or die(mysql_error());
mysql_query("INSERT INTO `data` VALUES ('$president', '$vp', '$tr', '$sect')");
Print "Your information has been successfully added to the database.";
?>
Comment