Forms: Assigning Values to Variables

jjfletch

I'm very much a newbie to this and hope someone can help.

I have a form that uses radio buttons. Depending on the option a user selects, I want my script to query a mysql database. How do I this?

My form will look something like this:

And what I want FormNameProcess.php to do is retrieve specific data from my database, if RadioGroup1 = A. Can I do this?

Thanks!

fizzwizz

I would start with an if statement

if ($_POST['radiogroup1']=="A")
{
//retrieve data from DB
}

there are many ways of doing this ...
What exactly do u need to know. How to connect to a db or how to use if statements etc?

jjfletch

Originally posted by fizzwizz
I would start with an if statement

if ($_POST['radiogroup1']=="A")
{
//retrieve data from DB
}

there are many ways of doing this ...
What exactly do u need to know. How to connect to a db or how to use if statements etc?

Hi, thanks for the help. Let me try to clarify: I have multiple radio button groups and I was hoping that I could define a variable like:

$fc = (whatever the value of this selected radio button is)
$sc = (whatever the value of this selected radio button is)
$hc = (whatever the value of this selected radio button is)

And then query my database:

$Query = "SELECT FieldName FROM dbname WHERE FieldFC='$fc' AND FieldSC='$sc' AND FieldHC='$hc'"

Thanks again!

dnast

Yes, you can do that.

Form:

<form name="FormName" method="post" action="FormNameProcess.php">
    <input type="radio" name="fc" value="A">
    <input type="radio" name="fc" value="B">
    <input type="radio" name="fc" value="C">

<input type="radio" name="sc" value="A">
<input type="radio" name="sc" value="B">
<input type="radio" name="sc" value="C">

<input type="radio" name="hc" value="A">
<input type="radio" name="hc" value="B">
<input type="radio" name="hc" value="C">
</form>

FormNameProcess.php (or whatever):

$fc = $_POST['fc'];
$sc = $_POST['sc'];
$hc = $_POST['hc'];

$query = "SELECT FieldName FROM dbname WHERE FieldFC='$fc' AND FieldSC='$sc' AND FieldHC='$hc'"
$result = mysql_query($query)
    or die(mysql_error());

jjfletch

Okay, below is my HTML/PHP page and I can't seem to get it to print the results of my query. I'm not getting any error messages or anything. Can anyone see what the problem is?

<p class="style7">This Form </p>
  	</div></td>

    <tr><td width="48"><select name="DropDwnAAA">
    <option value="" selected></option>
    <option value="A">A</option>
	    <option value="B">B</option>
    <option value="C">C</option>
    </select></td>

      <td width="84"><div align="right"><span class="style3">
      <label>
      <input type="radio" name="Radio1" value="YYY">
      YYY</label>
      </span></div></td>
      <td width="79"><div align="right"><span class="style3">
      <input type="radio" name="Radio1" value="ZZZ">
  ZZZ</span></div></td>

<tr>

<td colspan="4">&nbsp;</td>

<tr>
<td colspan="4"><span class="style5">RadioGpB</span> <table width="200">

    <tr>
      <td class="style3"><label>
        <input type="radio" name="RadioGpB" value="B1">
        B1</label></td>
    </tr>

    <tr>
      <td class="style3"><label>
        <input type="radio" name="RadioGpB" value="B2">
        B2</label></td>
    </tr>

    <tr>
      <td class="style3"><label>
        <input type="radio" name="RadioGpB" value="B3">
        B3</label></td>
    </tr>

    <tr>
      <td class="style3"><label>
        <input type="radio" name="RadioGpB" value="B4">
        B4</label></td>
    </tr>

    <tr>
      <td class="style3"><label>
        <input type="radio" name="RadioGpB" value="B5">
        B5</label></td>
    </tr>
  </table></td>

<tr>
<td colspan="4"> </td>
<tr>
<td colspan="4"><span class="style5">RadioGpC</span>
<table width="200">
<tr>
<td class="style3"><label>
<input type="radio" name="RadioGpC" value="NO">
NO</label></td>
</tr>
<tr>
<td class="style3"><label>
<input type="radio" name="RadioGpC" value="YES">
YES</label></td>
</tr>
</table></td>
<tr>
<td colspan="4"> </td>
<tr>
<td colspan="4"><div align="center">
<input type="submit" name="Submit" value="Submit">
</div></td></tr>

    <!-- RETURN RESULT HERE -->

<?php

$Host = "localhost";
$User = "JoeBlow";
$Password = "JoeBlowPWD";
$DBName = "JoeBlowDB";

$link = mysql_connect ($Host, $User, $Password);

    if (isset ($_POST['submit'])) {

    $dda = $_POST['DropDwnAAA'];
    $ddb = $_POST['DropDwnBBB'];
    $r1 = $_POST['Radio1'];
    $rgb = $_POST['RadioGpB'];

if ($_POST['RadioGpC']=="NO")
{
$Query = "SELECT Field1A FROM dbname WHERE Field2='$dda' AND Field3='$ddb' AND Field4='$r1' AND Field5='$rgb'";

                            $Result = mysql_db_query ($DBName, $Query, $link);
                            while ($Row = mysql_fetch_array ($Result, MYSQL_ASSOC)) {

F74
print "<tr><td>";
print $Row["Field1"];
print "</td><td>\n";
}
}
elseif ($_POST['RadioGpC]=="YES")

    {
    $Query = "SELECT Field1B FROM dbname WHERE Field2='$dda' AND Field3='$ddb' AND Field4='$r1' AND Field5='$rgb'"; 
                            $Result = mysql_db_query ($DBName, $Query, $link);
                            while ($Row = mysql_fetch_array ($Result, MYSQL_ASSOC)) {

                            print "<tr><td>";
                            print $Row["Field1B"];
                            print "</td><td>\n";
                                                                       }  
    }

}

mysql_close($link);
?>

</table>
</form>
<p> </p>
</body>
</html>

dnast

 if (isset ($_POST['submit'])) {

It doesn't match the submit name in your form ("Submit"). Just change one or the other so they match case 😉

jjfletch

Originally posted by dnast
 if (isset ($_POST['submit'])) { 
It doesn't match the submit name in your form ("Submit"). Just change one or the other so they match case 😉 [/B]

You are my hero, and if I ever meet you, I shall shower your big toe with kisses. 😃