problem with radiobutton

roshanjameer

hi,

i have a table.it's structure is like this
itemno--itemname--price
1--abc--200
2--djh--300
3--eee-400

i want to dynamically create 3 radio buttons for prices and to display these records on web page and when a user click radio button of any one the selected values should be stored in some other table.how to do this.i know how to display and store in db.problem is with dynamically creating radio buttons.please any of your help is appreciated.

thanks
mrjameer

void_function

Hope this helps:


$res= mysql_select ('SELECT itemno, itemname, price FROM thetable');
$num= mysql_num_rows($res);

for ($i=0; $i<$num; $i++) {
    $fields= mysql_fetch_array($res);
    echo "<input type=\"radio\" name=\"radiogroup\" value=\"{$fields['itemno']}\" /> {$fields['itemname']} - {$fields['price']}";
}

The above outputs the radio buttons and assumes it does so within a form. When you submit the form, the selected button will pass its value (itemno in this case) into $POST['radiogroup'] (or $GET if you used metod="get").

roshanjameer

hi void function

thank you very much.it works

thanks
mrjameer

yien23

how do you make a code wherein when a radiobutton is clicked it will output data fetched from the database into a table in the same form...can somebody help me?

ryneaux

It sounds like you will be wanting to use some javascripting... for example:

<?php
$myradios='
<div id="radiooutput"></div>
<form>
<input type="radio" name="products" value="1" onclick="radout(1);" />abc 200<br />
<input type="radio" name="products" value="2" onclick="radout(2); />dgh 300<br />
<input type="radio" name="products" value="3" onclick="radout(3); />eee 400<br />
</form> 
<script type="text/javascript">
function radout(pid){
     var productoutputs=Array("","1. abc - 200","2. dgh - 300","3. eee - 400");
     document.getElementById("radiooutput").innerHTML=productoutputs[pid];
}
</script>';
echo $myradios;
?>

yien23

This is what i've got...

<body>
//code
<?php
//connect to server..code here...

$name=$_POST['name'];
$radiobutton=$_POST['activity'];

switch($radiobutton)
{
case "deposit":
$query=Select*from 'table' where 'db_column' ='$name';
echo "<table border='2' align='center'>";
   echo "<tr> <th>Activity</th> <th>Amount</th> <th>Date last deposited</th><th>Cash in bank</th> </tr>";

   // keeps getting the next row until there are no more to get
   while($row = mysql_fetch_array( $result )) {

   // Print out the contents of each row into a table
    echo "<tr><td align='center'>";
    echo $row['Activity'];
    echo "</td><td align='center'>";
    echo $row['Amount'];;
    echo "</td><td align='center'>";
    echo $row['Activity'];;
    echo "</td><td align='center'>";
    echo $row['Date'];
    echo "</td><td align='center'>";
    echo $row['CIB'];;
    echo "</td></tr>";
    }

   echo "</table>";

break;

case "withdraw":
$query=Select*from 'table' where 'db_column' ='$name';
echo "<table border='2' align='center'>";
   echo "<tr> <th>Activity</th> <th>Amount</th> <th>Date last deposited</th><th>Cash in bank</th> </tr>";

   // keeps getting the next row until there are no more to get
   while($row = mysql_fetch_array( $result )) {

   // Print out the contents of each row into a table
    echo "<tr><td align='center'>";
    echo $row['Activity'];
    echo "</td><td align='center'>";
    echo $row['Amount'];;
    echo "</td><td align='center'>";
    echo $row['Activity'];;
    echo "</td><td align='center'>";
    echo $row['Date'];
    echo "</td><td align='center'>";
    echo $row['CIB'];;
    echo "</td></tr>";
    }

   echo "</table>";



<form>
Name:
    <label>
    <input type="text" name="name" />
    </label>
    <br />
    <br />
    <label>
<input name="activity" type="radio" value="deposit" />deposit 
<input name="activity" type="radio" value="withdraw" />withdraw

</form>
</body>

..my problem is that when i input a name in the textfield and click one of the radio buttons it will move on to the switch statements..i want the output of the conditions under the switch statements to appear in the same when i click the radio button without using the submit button...i would very much appreciate your help..thanks ahead

johanafm

If you do a form submit then the browser issues either a get or post request and the previous document (page) is removed as a new one is created. You'd lose all your contents.

You could issue a request using javascript's XMLHttpRequest, but then you'd also need javascript to handle the response to make anything appear on the page. I suppose the simples way to do is really is echoing html code from your php script and using innerHTML attribute to change page contents, but I really recommend against innerHTML as it's implementation across browsers isn't that solid. Also, if you ever want to update parts later on, you will encounter problems. And, I suppose you're once again moving into mixing data, logic and display.
Rather just fetch the data you need, jsonencode it, and echo the jsonencoded data. Then jsondecode the response in the browser and use the DOM to insert contents wherever you need it.

ryneaux

johanafm wrote:
...but I really recommend against innerHTML as it's implementation across browsers isn't that solid...

As a curiosity... I was not aware of any cross browser compatibility issues with innerHTML, could you elaborate? Which browsers and which issues?

johanafm

I'm no longer entirely certain. I remember encountering problems 3+ years ago and decided to stick to DOM instead of the then non-standard innerHTML (it's in the draft for HTML5).

But as I recall, there were issues with inserting innerHTML without having the new contents modify the DOM tree, thus forcing you to decide on either one or the other (or keeping track of where DOM was to be used and where innerHTML was used), form data not updating other than visually, events not being added like they were on regular page load (onclick="someFunc()").

And since I havn't used innerHTML for a long time, it's entirely possible that the problems I encountered no longer exists, or that they are limited to IE6 should you still need to support it. It may even have been addressed in IE6 updates for all I know though.

It's also possible that some of my code failed due invalid markup and I failed to realize that back then.

Anyway, I'm glad you asked. It could be that my knowledge or preconceptions are outdated and that I should give innerHTML another try. If it works for you, then by all means use it.

ryneaux

Thank you for the clarification... I will look into it more thoroughly... I have not experienced any problems, but since it isn't possible for me to check my code in every browser (and browser version) I will see about making sure that the most common browsers and versions haven't a problem with it. I simply never had any problems nor heard any mention of it until now... and being that it is the only method I have used for updating content... well... it put me in a bit of a cold sweat. Thanks again.