checkbox, MySql and PHP

nogeekyet

I am populating a table through a "while" loop with usernames that come from MySql. The usernames that don't have a date associated with get a checkbox.

To check my results I use:
$box = $_POST[box];
print_r(box);
in the next script

My array gets filled when I use:
$table .= '<td><input type="checkbox" name="box[]" value="here is one"></td>';

My array has nothing, when I use:
$login = 'something';
$table .= '<input type="checkbox" name="box[]" value="<?php echo($login); ?>"></td>';

My array has nothing, when I use:
$table .= '<input type="checkbox" name="box[]" value="<?php echo($row['LoginID']; ?>"></td>';

So, what am I doing wrong?

paulnaj

Hi, both of the 'array has nothing' examples are missing the opening TD tag - whereas the first 'gets filled' example does. Could it just be that?

nogeekyet

It would have been nice it was the problem. Unfortunately it is not. I did not copy the beginning td tag for the post because I change the background color based on several conditions.

So, back to square one.

nogeekyet

I should have mentioned that when I print the array, I get the correct number of elements but no values.

Weedpacket

Are you sure $login and $row['LoginID'] have values? Are they included in the HTML received by the browser?

nogeekyet

Yup, there is data in those fields.

Here is an interesting observation: when I use the value field like this:

value="<?php echo htmlspecialchars($row[\'S_StudentLogin\']; ?>">

my result, using var dump, looks like this:
var dumparray(4) { [0]=> string(54) "" [1]=> string(54) "" [2]=> string(54) "" [3]=> string(54) "" }

54 is the number of characters between < and the first >

Weedpacket

You're looking at this dump in the browser, right? What appears in the browser's page source?

nogeekyet

Here is what is in the browser page source. As you can see, I am trying to print it different ways without much luck:

<br>while loop<?php echo htmlspecialchars($row['S_StudentLogin']; ?><br><?php echo htmlspecialchars($row['S_StudentLogin']; ?><br><?php echo htmlspecialchars($row['S_StudentLogin']; ?><br><?php echo htmlspecialchars($row['S_StudentLogin']; ?><br><br>var dumparray(4) {
[0]=>
string(54) "<?php echo htmlspecialchars($row['S_StudentLogin']; ?>"
[1]=>
string(54) "<?php echo htmlspecialchars($row['S_StudentLogin']; ?>"
[2]=>
string(54) "<?php echo htmlspecialchars($row['S_StudentLogin']; ?>"
[3]=>
string(54) "<?php echo htmlspecialchars($row['S_StudentLogin']; ?>"
}
<br>print r<br>Array
(
[0] => <?php echo htmlspecialchars($row['S_StudentLogin']; ?>
[1] => <?php echo htmlspecialchars($row['S_StudentLogin']; ?>
[2] => <?php echo htmlspecialchars($row['S_StudentLogin']; ?>
[3] => <?php echo htmlspecialchars($row['S_StudentLogin']; ?>
)
<br>box0=<?php echo htmlspecialchars($row['S_StudentLogin']; ?>;<br>box1=<?php echo htmlspecialchars($row['S_StudentLogin']; ?>;<br>box2=<?php echo htmlspecialchars($row['S_StudentLogin']; ?>;<br>box3=<?php echo htmlspecialchars($row['S_StudentLogin']; ?>;<br>box4=;<br>

Weedpacket

As you can see, the checkboxes have unevaluated PHP code for their values. This is likely because you're trying to start a <?php block inside a string when you're already inside a <?php block. Post the code that produces those checkboxes, and please use the board's formatting tags to format it. Chances are good that the nature of the problem will be manifestly obvious once you do so.

nogeekyet

OK, I can see that I am already within a string but how do I get around it? Here is the code:

        if ($S_OL237Date != null) {
              $table .= '<td bgcolor="#9AE0EA"><font size=-1>';
              $table .= $row['S_OL237'];
              $table .= '</font></td>';
              $table .= '<td bgcolor="#9AE0EA"><font size=-1>';
              $table .= $S_OL237Date;
              $table .= '</font></td>';
              $table .= '<td bgcolor="#9AE0EA"><font size=-1>&nbsp;</td>';}
           else {
            $table .= '<td bgcolor="#9AE0EA">&nbsp;</td>';
            $table .= '<td bgcolor="#9AE0EA">&nbsp;</td>';
            $table .= '<td bgcolor="#9AE0EA"><input type=checkbox name=box[] value="<?php echo htmlspecialchars($row[\'S_StudentLogin\']; ?>"></td>';
                }

nogeekyet

One problem was that I did not have the closing ) for echo. With that in place, I now get:

var dumparray(4) { [0]=> string(2) "on" [1]=> string(2) "on" [2]=> string(2) "on" [3]=> string(2) "on" } 
[/code>

So now I know which checkbox is on but where is the value?

nogeekyet

OK, I give up. Instead of filling a $table variable and echoing it when I am done, I am going to re-write everything and put it into html code going in and out of php code as necessary. I have done it partially and that works. Thanks for all your help. I guess, I phpeed a little bit too much.

Weedpacket

Well, surely it would be

$table .= '<td bgcolor="#9AE0EA"><input type=checkbox name=box[] value="'.htmlspecialchars($row['S_StudentLogin'].'"></td>';

wouldn't it?

nogeekyet

Well, I don't know. I have never tried that. The way I view it, we are putting one long string, starting with the first single quote and ending with the td>';, into $table. But, as I said, I don't know. I will try it later.

nogeekyet

I tried it. To start with I am getting a syntax error. That makes sense because we are going from html to php without a tag. Any other suggestions?

Weedpacket

nogeekyet wrote:
That makes sense because we are going from html to php without a tag.

No, you're not. You're concatenating two strings together. The fact that one of them contains HTML is irrelevant.

The typo is the missing ')' you noticed a couple of posts earlier.