用PHP将DB字符串转换为复选框 - Convert DB string into checkbox checking with PHP

Convert DB string into checkbox checking with PHP

本文关键字：转换复选框字符串 DB PHP | 更新日期: 2023-09-27

我有以下SQL查询:

    $readNews_SQLselect = "SELECT ";
    $readNews_SQLselect .= "live, content, user, created, created_updated, user_updated ";  // rows names
    $readNews_SQLselect .= "FROM ";
    $readNews_SQLselect .= "news ";         // table name

    $readNews_SQLselect_Query = mysql_query($readNews_SQLselect);

和while循环显示来自DB的数据:

    while ($row = mysql_fetch_array($readNews_SQLselect_Query, MYSQL_ASSOC)) {
                    $LIVE = $row['live'];
                    $CONTENT = $row['content'];
                    $USER = $row['user'];
                    $CREATED = $row['created'];
                    $USER_UPDATED = $row['user_updated'];
                    $CREATED_UPDATED = $row['created_updated'];
                    echo '<input type="checkbox" value=" '.$LIVE.'" />';
                    echo '<input value=" '.$CONTENT.'" />';
                    echo '<p>'.$USER.'<p/>';
                    echo '<p>'.$CREATED.'<p/>';
                    echo '<p>'.$USER_UPDATED.'<p/>';
                    echo '<p>'.$CREATED_UPDATED.'<p/>';
                }
                mysql_free_result($readNews_SQLselect_Query);

由于我的echo '<input type="checkbox" value=" '.$LIVE.'" />';将是'0'或'1' -我如何将此字符串转换为复选框检查/取消检查PHP?

任何建议都非常感谢。

您将需要使用内联If语句。

echo '<input id="chkLive" type="checkbox"'.(($LIVE=='1') ? ' checked ' : '').'/>';

我不知道我的理解是否正确，但您只想显示哪些是选中的，对吗?

echo '<input type="checkbox" ',($LIVE ? 'checked="checked"':''),'/>';

如果$live是0或1的变量，

则可以使用:

$boxCheck = '';
if($LIVE == '1')
{
    $boxCheck = 'checked="checked"';
}
else
{
    $boxCheck = '';
}
echo '<input type="checkbox" value=" '.$LIVE.'" '.$boxCheck.'/>';

$checked = ($LIVE) ? 'checked="checked"' : '';
echo '<input type="checkbox" '.$checked.' value=" '.$LIVE.'" />';