使用PHP/jQuery从mysql提取的每个单词的首字母大写 [英] Capitalize first letter of each word pulled from mysql with PHP/jQuery

问题描述

我已经将Names所有小写字母存储到mysql数据库中，但是我的用户希望网站上的首字母大写.但是我试图找出一种方法，无论是服务器端(PHP)还是客户端(jQuery)，都无需更改数据库中的任何内容?这可能吗?

I've stored Names all lower case into a mysql db but my users want to see them on the website as first letters capitalized. however i'm trying to figure out a way, whether server-side(PHP) or client-side (jQuery), to do this without changing anything in the database? is this possible?

代码:

$result = mysql_query("SELECT user from `users` order by user asc") or die(mysql_error());
            echo '<select name="user" class="user">';
            while ($row = mysql_fetch_array($result)) {
                echo "<option value='".$row['user']."'>".$row['user']."</option>";
            }
            echo '</select>';

推荐答案

也有

ucwords($row['user']);

如果您想将所有单词都大写.

if you want to capitalize all the words.

这篇关于使用PHP/jQuery从mysql提取的每个单词的首字母大写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！