PHP/MsSQL - Checkboxes

[Bcorvus8]

I'm creating a webpage that pulls information from MsSQL server. My problem is where there is a section with few check boxes. The checkboxes are to indicate where the downpayments are from for a house. If the borrower used money from "Savings", "Checking" and "Stock" those checkboxes should be checked. In my case it is only checking whatever is on the first row of the SQL search list. So if the list has "Saving" on the first row, only the "Saving" checkbox is being checked not the rest on the list. I tried using loop to (while($r->EOF)) the end of list, but then it picks whatever is on the end of the list. Here is what I am using to pull data from the SQL server. Thank you in advance for your help. Really appreciate it! I have been looking for an answer for the last two weeks.

In PHP class

function __construct($_ldid, $_lrid)

        $this->ldid = $_ldid;
        $this->lrid = $_lrid;

SELECT * FROM Tabel_name where loan_id = 885775
$v = array($_ldid, $_lrid);
$r = $db->Execute($q, $v);
$this->downpaymenttype = $r->fields;

<input type="checkbox" name="DPS1[]" id="DPS1-{$key}" {if $loan->downpaymenttype.downpaymentsource == "Gift"} checked    {/if}/>    

[tomhath]

Are you changing what's in $loan when you get then next $key?

That's just a guess, you didn't post enough code to see what's really going on.

[Bcorvus8]

I am new to this, so be patient with my replies.

//$loan is defined in the PHP.class (which is shown below).

SELECT * FROM Tabel_name where loan_id = 885775
$v = array($_ldid, $_lrid);
$r = $db->Execute($q, $v);
$this->downpaymenttype = $r->fields; //<- I think I have this line done wrong because it is suppose to store the outputs to an array.

So wherever the "$loan" is in HTML page, it will take the outputs from the above statement.

The above code, which is in PHP.class file, outputs the following(or suppose to):

1    885775    Checking
2    885775    Saving
3    885775    Gift

In the HTML webpage, the following codes should check mark the boxes according to the outputs:

<input type="checkbox" name="DPS1[]" id="DPS1-{$key}" {if $loan->downpaymenttype.downpaymentsource == "Checking"} checked {/if}/>

<input type="checkbox" name="DPS2[]" id="DPS2-{$key}" {if $loan->downpaymenttype.downpaymentsource == "Saving"} checked {/if}/>

<input type="checkbox" name="DPS3[]" id="DPS3-{$key}" {if $loan->downpaymenttype.downpaymentsource == "Gift"} checked {/if}/>

But, only the "checking" checkbox is getting checked because that's the one on the first row.

Thank you for your reply. I hope it helps, if not, let me know I will post more info on Monday.

[tomhath]

It looks to me that you're only processing the first row from the SELECT statement, you need a loop somewhere to process the other rows.

[Bcorvus8]

Thanks tomhath. I did try to loop, but at the end it picks whatever is at the end.

Here is how I tried:

$q = ("SELECT Tabel_name FROM loan_downpaymentsource where loan_id = 885775);
$v = array($_ldid, $_lrid));
$r = $db->Execute($q, $v);
while(!$r->EOF) {
$this->downpaymenttype = $r->fields;
$r->MoveNext();
}

[bradgrafelman]

Ignoring the fact that you have a parse error in the code above, you've got a more serious (logical) error: You're overwriting the value of $this->downpaymenttype on every iteration of the while() loop without doing anything with the previous value first. In other words, you may as well just SELECT the last row and not loop at all as that would have the same effect.

[tomhath]

Try putting the HTML inside the loop, right before the MoveNext

<input type="checkbox" name="DPS1[]" id="DPS1-{$key}" {if $loan->downpaymenttype.downpaymentsource == "Checking"} checked {/if}/>

[Bcorvus8]

Thanks bradgrafelman, how do I setup an array so that each time going through the loop it will store the info into a variable. I have tried as shown below, but no luck. If I am not asking too much, would be able to point the two errors I have (parse and logical). Greatly appreciate any help.

$q = ("SELECT Tabel_name FROM loan_downpaymentsource where loan_id = 885775);
$v = array($ldid, $lrid));
$r = $db->Execute($q, $v);
while(!$r->EOF) {
$this->downpaymenttype = $r->fields;
$downpaymenttypes = array(downpaymenttype); //<-new line
$r->MoveNext();
}

[tomhath]

It should end up looking something like this (but my php is pretty rusty so there are probably errors in the following).

Pay attention to the highlighting, you were missing a quote, which is why everything was red in your post and it was obvious there was a syntax error.

$q = ("SELECT * FROM loan_downpaymentsource where loan_id = 885775");
$v = array($_ldid, $_lrid));
$r = $db->Execute($q, $v);
$downpaymenttypes = array();
while(!$r->EOF) {
  $downpaymenttypes[$r->fields.downpaymentsource] = 1;
  $r->MoveNext();
}

<input type="checkbox" name="DPS1[]" id="DPS1-{$key}" {if ($downpaymenttypes["Checking"]==1)} checked {/if}/> 
<input type="checkbox" name="DPS2[]" id="DPS2-{$key}" {if ($downpaymenttypes["Saving"]==1)} checked {/if}/>

[Bcorvus8]

Tomhath, thank you so much for your help. Everything looks fine except one part I am not sure. 6th line "$downpaymenttypes[$r->fields.downpaymentsource] = 1;" What's dowpaymentsource reffering to? Because that line is giving me a Parse error: syntax error

Warning: Illegal offset type in downpayment.class.php on line 40 Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in Property.thtml.d17.php on line 374

[tomhath]

I thought that didn't look right, but I don't remember the syntax to get a field out of the row of data you have in $r. It should be the column which has "Checking", etc.