For a certain user UID, how can I get php to automatically create html
checkboxes listing ALL traits from PTable and check each trait based
on the UserP table on a webpage?
Try a JOIN.
First, query something like:
SELECT
`u`.`uid`,
`t`.`pid`,
`t`.`ptype`
FROM
`PTable` AS `t`
INNER JOIN
`UserP` AS `u`
ON
`t`.`pid` = `u`.`pid`
WHERE
`u`.`uid` = $userId
Then iterate over the results
<?php
//...
while( @list( $uid, $tid, $tval ) = /* ... */ )
{
echo "<p>Trait: $tid<br />";
if( '1' == $tval )
echo "<input type='checkbox' id='traits[$tid]' value='1'
checked='checke d'>Good</input><br />";
else
echo "<input type='checkbox' id='traits[$tid]' value='1'>Good</
input><br />";
if( '2' == $tval )
echo "<input type='checkbox' id='traits[$tid]' value='2'
checked='checke d'>Bad</input><br />";
else
echo "<input type='checkbox' id='traits[$tid]' value='2'>Bad</
input><br />";
if( '3' == $tval )
echo "<input type='checkbox' id='traits[$tid]' value='3'
checked='checke d'>Neutral</input>";
else
echo "<input type='checkbox' id='traits[$tid]' value='3'>Neutr al</
input>";
echo '</p>';
}
//...
?>
The output would be xHTML compliant if you were to use underscores in
the middle of the trait id instead of doing it the easy way with
square brackets. You can also JOIN in another table that has the names
of the traits so you don't have to memorize what all of the trait ids
are.
-Mike PII
