Check Box Problems.

MitchEvans

I have a database that I call from with 2 tables, one is paragraph and the other called text. I have put all the paragraph fields as check boxes. When my users check certain boxes I want them to be able to click submit and then the correct text for the paragraphgs chosen is shown to them on the screen. How do I get this to work?!?!? my code is shown below:

$connection=mysql_connect($host,$user,$password)
or die("couldn't connect to server");
$db=mysql_select_db($database,$connection)
or die ("Couldn't select database");
$query = "select * from paragraph"
or die ("Couldn't execute query.");
$result = mysql_query($query)
or die ("Couldn't execute query.");

echo "<div style='margin-left:.3in'>
<p> 
<p><b>Which paragraphs do you want?</b>
<p>Choose as many paragraphs as you like:\n";

/form for checkboxes/
echo "<form action='page3.php' method='post'>\n";

while ($row=mysql_fetch_array($result))
{
extract($row);
echo"<input type='checkbox' name='interest[$Paragraph]'
value='$Paragraph'>$Paragraph\n";
echo"<br>\n";
}
echo "<p><input type='submit' value='Submit final documentation'>
</form>\n";
foreach ($_post as $field =>$value)
{
echo "$field, $value<br>";
}
?>

bogu

And the problem is? what is not working?

MitchEvans

My check boxes are fine, what I can't get working is when the user clicks submit I can't get any details to come on the screen depending on what the user has chosen. For example if they chose the "fish" and "dog" options I want fish and dog and the details to come on the screen when submit is clicked. If you could help please?

bogu

So your POST array is empty, after u submit?

MitchEvans

Yes I would imagine it is, my code only allows for all the checkboxes to have the correct names. I want my users to choose many of my options and get lots of information on their screen depending on their choices. Thankyou so much for getting back to me.

bogu

Add this lines of code:

<!-- add a hidden field on your form so u could know when u submit the form -->
<input type='hidden' name='hdnAction' />

if (isset($_POST['hdnAction'])) {
    foreach ($_POST as $field =>$value)
    {
        echo "$field, $value<br>";
    }
}

and tell me what is showing u ...

MitchEvans

I get the following message:

hdnAction, Submit final documentation

And if I choose some of the options, I get this message:

interest, Array
hdnAction, Submit final documentation

I think maybe I need some kind of if statement so it knows which check boxes have been chosen.

bogu

It means your checkbox don't appear on the form, or are not checked, before submit ...

MitchEvans

I've got the message "array" coming up. I don't know how to show this data on screen when a user clicks on certain check boxes. There must be some code missing, do you think I need another query?

cgraz

How is this problem any different than what you posted here? Please don't double post.

bogu

Change your code like this:

if (isset($_POST['hdnAction'])) { 
    if (!empty($_POST['interest']))
        foreach ($_POST['interest'] as $field =>$value) 
        { 
            echo "$field, $value<br>"; 
        } 
    } else echo "There are no checkbox's selected ...";
}

MitchEvans

I've added this code under where my original code (at top of screen) is. I just get given a blank page as there must be some error with it.

bogu

Add error_reporting (E_ALL) on top of your script or ini_set ('error_reporting', E_ALL).

MitchEvans

echo "<div style='margin-left:.3in'>
<p> 
<p><b>Which paragraphs do you want?</b>
<p>Choose as many paragraphs as you like:\n";

/form for checkboxes/
echo "<form action='page3.php' method='post'>\n";

I still get a blank screen from running error reports

HalfaBee

$_POST needs to be in uppercase.

MitchEvans

Now I actually get a message which says:

"interest, array"

Any ideas what to do now?

HalfaBee

heh, now I have to read the code

MitchEvans

This code has been added and my results are being input:

if(isset($POST['interest']))
{
//print '<pre>';
print $value1 . ' ';
print_r($POST['interest']);
//print '</pre>';

// loop.
foreach($_POST['interest'] as $value1)

My only problem now is the layout of the results, I would like a gap between each one like the HTML <p> tags, any ideas?