Question

是否有可能从数据库值中弹出一个复选列表? 如果是的话, 请建议如何这样做。

$query2 = "select * from Products where CategoryID =  $CategoryName  ";
 mysql_query($query2) or die(mysql_error());
 $array = array();

while($row = mysql_fetch_assoc($query2)){
$array[] = $row;}

foreach($array as $val)
 {
 if($val == the checkbox value )

Answer 1

<form>
<input type="checkbox" name="vehicle" value="Bike" /> I have a bike<br />
<input type="checkbox" name="vehicle" value="Car" /> I have a car
</form>

These are the few steps you have to do. 1.Fetch the values from database. 2. Covert the values in array as they are stored as string by (,) separated. 3. Then

foreach($values as $val)
     {
          if($val == Bike )
             {
                   $bikeflag =  1 ;
             }
            if($val == Car )
             {
                   $carflag =  1 ;
             }

    }
<form>
<input type="checkbox" name="vehicle" value="Bike"  <?php if(isset($bikeflag ) == 1 ){ ?>checked = checked <?php } ?>/> I have a bike<br />
<input type="checkbox" name="vehicle" value="Car"   <?php if(isset($carflag) == 1 ){ ?>checked = checked <?php } ?>/> I have a car
</form>

希望这能帮到你

Answer 2

Get values from database with the appropriate SQL query
Loop through results echoing out a checkbox element

历山山

Make sure each one has a unique name unless you want them to be an array. Then use array syntax for their name (e.g. name[])
Make sure to give each one a unique value

Answer 3

是的,它非常可能:

获取要装入结构的文档 :

Id and value

如上文所述,将复选框列表的数据源作为获取的结构化列表提供。

Now define the value field of the checkboxlist as "Id" and text as "value"

友情链接