如何在php中显示来自数据库的多个复选框值

gopyfrb3 于 2021-06-20 发布在 Mysql

关注(0)|答案(2)|浏览(259)

请看数据库的图片也我想显示我的复选框值从数据库。

Example : my value is 25,26.
So, How can i display it one by one ?
such as,
-- 1st value is : 25.
--2nd Value is : 26.

我的代码：

$db = new mysqli("localhost","paroshic_paroshic","kxmcwQzLTrTR","paroshic_matri2018jl");
    $sql = "select * from tbldatingusermaster order by userid desc";
    $result = $db->query($sql);

    while($data = $result->fetch_object()){
    echo $data->education; //My value is 25,26

}
谢谢。

mysql php

来源：https://stackoverflow.com/questions/52633333/how-to-show-multiple-checkbox-values-from-database-in-php

2条答案

按热度按时间

8i9zcol21#

我想你要找的那块拼图可能是 explode 从给定字符串创建整数数组 $data->educationid （即：25,26）

$db = new mysqli("localhost","paroshic_paroshic","kxmcwQzLTrTR","paroshic_matri2018jl");
$sql = "select * from tbldatingusermaster order by userid desc";
$result = $db->query( $sql );

if( $result ){
    while( $data = $result->fetch_object() ){
        /* explode the string into little integers */
        $ids=explode( ',', $data->educationid );

        /* iterate through the pieces and generate an input[checkbox] element */
        foreach( $ids as $id )printf('<input type="checkbox" name="UNKNOWN[]" value="%s" />',$id);
    }
}

赞(0）回复(0）举报 2021-06-20

ggazkfy82#

你知道，你可以用echo把html标记写到页面上。所以基本上是这样的：

while($data = $result->fetch_object()){
    echo '<input type="checkbox" name="check" value="'.$data->educationid.'">'.$data->educationid.'<br>';
}

赞(0）回复(0）举报 2021-06-20

我来回答

如何在php中显示来自数据库的多个复选框值

2条答案

相关问题

热门标签

最新问答