从所有列名和值中获取数据属性的更短方法

Question

表 users 有 14 列 - id, src link, title...

function get_atitles(){

    global $db;

    $st = $db->query("select * from users order by name asc");

    $arr = $st->fetchAll();

    $ht = '';

    foreach($arr as $el){

        $ht .= "<div class='atitle' data-id= " . $el['id'] . " data-src='" . $el['src'] . "... and so on for all of the 14 columns...>" . $el['title'] . "</div>\n";

    }

    echo $ht;

}

有没有更短的方法，像这样：

foreach($arr as $el){

            $ht .= "<div class='atitle' 

                 //foreach column in users $ht .= "data-" . column_name = column_value

            $ht .= ">" . $el['title'] . "</div>\n";

        }

Answer 1

也许是这样的：

function get_atitles(){

    global $db;

    $st = $db->query("select * from users order by name asc");

    $arr = $st->fetchAll(PDO::FETCH_ASSOC);

    $ht = '';

    foreach($arr as $el){

        $ht = $ht . "<div class='atitle' ";

        foreach($el as $key=>$col)

            if($key != 'title')

                $ht .= "data-".$key.'="'.$col.'" '; 

        $ht.= '>'.$el['title'] . "</div>\n";

    }

    echo $ht;

}