radiobutton name unknown

[ldndude]

Heya, I think I shot myself in the foot when I set this up

Overview: I have a dynamically generated page for listing pictures for a project I am working on for my boss. To put it simply...this is a picture approval page.

Each picture (belonging to a group) has two radio buttons and a submit button attached to it.

Since the number of photos listed for each group is unknown, the names of the yes and no radio buttons had to be uniquely generated....

thusly I used:
echo "<input type='radio' name='radio".$r adio."' value='yes'>Yes ";
echo "<input type='radio' name='radio".$r adio."' value='no'>No<b r>";
echo "<input type='submit' value='submit'> <br>";
inside of a loop so that the value of $radio increments by one each loop.
what I end up with is, the first yes/no radio buttons are named radio0, the second set named radio1, the third is radio2 and so on...
Here's my problem

using post, I cannot use $_POST['radio#''] since I do not know which of the radio buttons he will select. Is there a way I can run the $_POST['radio#''] through a loop to find one that is set?

OR
is there a way on the first page (with the radio buttons) I can create a variable that will take the yes or no buttons on behalf of the radio button and send it to the next page

Any thoughts? Your help is greatly appreciated.

Thanks

[ronverdonk]

This should get you on your way:
[php]
foreach ($_POST as $key => $value) {
if ($value == 'yes')
$nr = substr($key, 5); // $nr = button no that has 'yes' value
}[/php]

Ronald :cool:

[ldndude]

ok...before you laugh at my code. I am a noob. a big noob.
Let me explain what I am doing and what I have so far. Maybe you know a better way to do this.

I am trying to create a php/mysql system to list pictures that we are applicable to various job titles. For example. "Chef" might have 4 pictures listed for it. "Bartender" might have 3 pictures and so on

I am trying to make a page that prints an <hr> followed by the career. Then I have it listing the urls (stored in a database) to pictures relating to that position, accompanied by the yes and no radio buttons and a submit button.

Here is the code (don't laugh, I am very new at this) that we've developed so far.

It works, but I still don't understand what I need to do to find out which radiogroup he selected and which value from the selected group he chose.
using $_POST
Here's my code (i can hear the snickering begin)

<?php


$sector = "Processing ";

include("dbinfo .inc.php");
mysql_connect($ host,$username, $password);
@mysql_select_d b($database) or die("Unable to select database");


$query="SELECT * FROM linkpool,career list WHERE linkpool.cid =

careerlist.cid AND careerlist.Sect or='".$sector." ' AND

careerlist.fini sh ='no' AND linkpool.yeno != 'yes' AND linkpool.yeno

!= 'no' ORDER by linkpool.cid ASC;";

$result=mysql_q uery($query);
$num=mysql_numr ows($result);

mysql_close();

//$i counting loop
$i = 0;

//$radio sets unique names of the radio button groups by incrementing
$radio = 0;

//cidchecker is to check for when the cid increases to put a hr tag in
$cidchecker = 0;

echo "<form action='yeno.ph p' method='POST'>" ;

while ($i < $num) {
$cid=mysql_resu lt($result,$i," cid");
$Title=mysql_re sult($result,$i ,"Title");//name of the career
$url=mysql_resu lt($result,$i," url");// url of the picture
$lid=mysql_resu lt($result,$i," lid");//id of table that holds lid, cid, url, yeno (yes or no), final (the final stands for final approval)

/* pending on the above query, the cid numbers skip. This makes sure that the cidchecker keeps up to date with the cid */
if ($cid > $cidchecker+1) {
$cidchecker = $cid-1;
}

/* a new cid number means we reached a new career title so I would like it to end the last table. Print the new career title. And start a new table */

if ($cid > $cidchecker) {
echo "</td></tr></table>";
echo "<hr><br>";
echo $Title;
echo "<table><tr><td >";
}

echo "<img src='".$url."' height='200'

width='200'>".$ cid."/".$cidchecker." <br>";
echo "<input type='radio' name='radio".$r adio."' value='yes'>Yes ";
echo "<input type='radio' name='radio".$r adio."' value='no'>No<b r>";
echo "<input type='submit' value='submit'> <br>";
echo "</td><td>";


/* sometimes a career has more than one picture to approve. This is to help control when the table starts and stops */

if ($cid > $cidchecker) {
$cidchecker++;
}

$i++;
$radio++;
}
echo "</form>";


?>

Please help. I am very limited in my php and mysql knowledge.


Thanks

[ronverdonk]

That is a lot of code. ANd since you did not put that code between code or php tags, it is almost unreadable. So I'll ignore it. The following is an example of how to test and set the buttons clicked. It is tested and you can run this to see how it works.
[PHP]
<?php
$radio_set = array(); // setup empty array
if (isset($_POST['_submit']) ) { // is form submitted?
foreach ($_POST as $key => $value) { // if so: check posted values
if (substr($key,0, 5) == 'radio' // check if field starts with 'radio'
AND $value == 'yes' ) { // and value set to 'yes'
$radio_set[] = substr($key, 5); // if so: store button no in array
}
}
// print all the buttons that are set to 'yes'
echo "<pre>The following radio buttons are set: <br>";
for ($i=0; $i<count($radio _set); $i++)
echo "radio button $i is set to YES <br>";
}
else {
echo '<form name="MyForm" action='.$_SERV ER['PHP_SELF']. ' method="POST">' ;
// generate 10 radio butons
for ($radio=0; $radio<10; $radio++) {
echo "Click button for radio$radio";
echo "<input type='radio' name='radio$rad io' value='yes'>Yes ";
echo "<input type='radio' name='radio$rad io' value='no'>No<b r>";
}
// used to check if form is submitted
echo "<input type='hidden' name='_submit' value=1>";
echo "<input type='submit' value='submit'> <br>";
echo "</form>";
}
?>[/PHP]

Ronald :cool:

[ldndude]

That is a lot of code. ANd since you did not put that code between code or php tags, it is almost unreadable. So I'll ignore it. The following is an example of how to test and set the buttons clicked. It is tested and you can run this to see how it works.
[PHP]
<?php
$radio_set = array(); // setup empty array
if (isset($_POST['_submit']) ) { // is form submitted?
foreach ($_POST as $key => $value) { // if so: check posted values
if (substr($key,0, 5) == 'radio' // check if field starts with 'radio'
AND $value == 'yes' ) { // and value set to 'yes'
$radio_set[] = substr($key, 5); // if so: store button no in array
}
}
// print all the buttons that are set to 'yes'
echo "<pre>The following radio buttons are set: <br>";
for ($i=0; $i<count($radio _set); $i++)
echo "radio button $i is set to YES <br>";
}
else {
echo '<form name="MyForm" action='.$_SERV ER['PHP_SELF']. ' method="POST">' ;
// generate 10 radio butons
for ($radio=0; $radio<10; $radio++) {
echo "Click button for radio$radio";
echo "<input type='radio' name='radio$rad io' value='yes'>Yes ";
echo "<input type='radio' name='radio$rad io' value='no'>No<b r>";
}
// used to check if form is submitted
echo "<input type='hidden' name='_submit' value=1>";
echo "<input type='submit' value='submit'> <br>";
echo "</form>";
}
?>[/PHP]

Ronald :cool:

Thanks...I will give this a try.
Just one more question about posting code. As you can already tell, I have no formal training and am just learning. You mentioned "And since you did not put that code between code or php tags"
What should I do to make it cleaner and easier to read for future postings?

[ronverdonk]

I see that byou put the quation between quote tags som it reads easier. For the same reason, if you want to show code you are requested to put it between tags, php, code or html. If you don't do that, you run the chance that members don't look at your request because the shown code looks messy. See the related entry in this forum link http://www.thescripts.com/forum/misc.php?do=bbcode

Ronald :cool:

[ldndude]

ohhhh
I should be putting my code using the quotation tag.

So, next time I should submit like this?

place code in here

Does it colour code it on it's own like yours did above?

[ronverdonk]

No, I used the php end /php tags. That colors the code:
green for commands, blue for variables, yellow for comments and red for literals and strings.

How's your button test doing?

Ronald :cool:

[Aarchaic]

Hello i have a simular problem and need help.

i have a database of 320 pictures that i have in a Mysql Database that looks like this.

Database: Eggcraft

Tables:

Egg_imgs ( Pic_id (int and PK), Pic_name(varcha r (255)), Pic_desc(varcha r(255)),Pic_ima ge(varchar(255) ) )

Egg_cat ( Cat_id (int PK), Cat_name (varchar(255)), Cat_desc (varchar(255)) )

Egg_ImgCat ( Cat_id (int PK), Pic_id (int PK), Pic_cat (varchar (255) PK ) )

Egg_prod ( Pro_id (int PK), Pic1_name (varchar(255)), Pic1_image (varchar(255)), Pic2_name (varchar(255)), Pic2_image (varchar(255)), Word_id (varchar(255)), Word_desc (varchar(255)), Pro_qty (int) )

Word database i need to construct still but this is the key elements i need to work on now.

I want to call up all my pictures and limit them to 30 pictures per page since i almost crashed my pc calling all 320 pictures in a moment of not thinking at all.
But i want to add a radio button to select a image and send it back to the produst array whether it be picture 1 or 2 depending on the kind of product.

once i selected the radio button and click the submit button it will put the image Name into the Pic#_name and Pic#_image fields.

here is my code so far...

[PHP]

<html>

<body>
<?php
$conn = mysql_connect(' localhost','roo t','')
or die ('Unable to connect!!');

mysql_select_db ('eggcraft')
or die ('Unable to connect to database!!');

$query = 'SELECT * from egg_imgs';
$result = mysql_query($qu ery)
or die ('Error in query: $query. ' . mysql_error ());

If (mysql_num_rows ($result) > 0)
{
echo '<table width=100% cellpadding=10 cellspacing=0 border=1>';
echo '<tr><td><b>ID </b></td><td><b>Image Name</b></td><td><b>Discr iption</b></td><td><b>Image </b></td><td><b>Selec t</b></td></tr>';

while($row = mysql_fetch_row ($result))
{
echo '<tr>';
echo'<td>' . $row[0] . '</td>';
echo'<td>' . $row[1] . '</td>';
echo'<td>' . $row[2] . '</td>';
echo'<td>' . "<img src= $row[3] width=50 height=50>" . '</td>';
echo '</tr>';
}
// If i put "<img src= imgs/$row[3] width=50 height=50>" in the code it doesnt display the picture
// Only the Url reference in the properties and that ends to be http://localhost/imgs and doesnt connect the file name to the string
// But if i leave it as it is now and put the file in my imgs folder it does show the picture its not a huge problem but its something i cant understand.
echo '</table>';
}
else
{
echo 'No Rows found!!';
}

mysql_free_resu lt($result);

mysql_close($co nn);

?>
</body>
</html>

[/PHP]

Thank you very much for your time.