php - 将表中的列名称显示为 Pascal 大小写

Question

我在 phpmyadmin 中创建了一个表，其列名如 first_name、last_name。当我使用命令显示表中的列名时，它会将它们显示为 first_name。

我想显示我的列名称，如 First Name。能否请您告诉我如何以 Pascal 大小写显示列名。

Answer 1

此代码将 some_text 转换为 Some Text:

$before = array('first_name', 'last_name', 'something');

$after = array();
foreach($before as $v){
    $after[] = ucwords(implode(' ', explode('_', $v)));
}

结果:

Array
(
    [0] => First Name
    [1] => Last Name
    [2] => Something
)

---

还有另一种方式:

// .. foreach ..
$after[] = implode(' ', array_map('ucfirst', explode('_', $v)));
// code

输出与之前相同。

---

---

以下示例显示了如何在运行 SHOW COLUMNS FROM TABLENAME 时执行此操作。我用过 PDO。看一看:

$con = new PDO('con string here', 'DB_USERNAME', 'DB_PASSWORD');
$stmt = $con->prepare('SHOW COLUMNS FROM tablename');
$stmt->execute();
$columns = array();
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
    $columns[] = array(
        'original' => $row['Field'],
        'pascal' => ucwords(implode(' ', explode('_', $row['Field'])))
    );
}

$columns 的结果将是这样的:

Array
(
    [0] => Array
        (
            [original] => first_name
            [pascal] => First Name
        )

    [1] => Array
        (
            [original] => last_name
            [pascal] => Last Name
        )

    [2] => Array
        (
            [original] => other_column
            [pascal] => Other Column
        )

    [3] => Array
        (
            [original] => something
            [pascal] => Something
        )

)