PHP ucwords on echo of MySQL variable

Question

I have the following php echo from a MySQL query that works fine except that the city is all uppercase in database.

Referencing the PHP manual here, it appears ucwords should fit the bill?

Works:

echo ($row['City']);

I tried this but it still shows the city as all uppercase?

echo ucwords($row['City']);

score 4 · Accepted Answer · answered Mar 23 '14 at 21:52

4

How about

echo ucwords(strtolower($row['City']));

answered Mar 23 '14 at 21:52

steffen

16,138
4
42
81

score 1 · Answer 2 · answered Mar 23 '14 at 21:53

You can lowercase the string before you use ucwords():

$test = 'HELLO WORLD';

echo ucwords(strtolower($test)); // Hello World

Demo: https://eval.in/125365

Note: this specific example is actually in the PHP manual, always pays to check the manual first.

score 1 · Answer 3 · answered Mar 23 '14 at 21:55

Source: http://www.php.net/manual/de/function.ucwords.php

See the docs!

 <?php
      $foo = 'hello world!';
      $foo = ucwords ($foo);          // Hello World!

      $bar = 'HELLO WORLD!';
      $bar = ucwords($bar);             // HELLO WORLD!
      $bar = ucwords(strtolower($bar)); // Hello World!
 ?>

aashnisshah · Answer 4 · 2014-03-23T23:04:06.063

-1

I'm not sure why you have the ?> at the end of the line. Try the following:

$word = $row['City'];
echo ucwords(strtolower($word));

edited Mar 23 '14 at 23:04

answered Mar 23 '14 at 21:54

aashnisshah

468
4
10

thanks for pointing that out - I forgot the strtolower in the code I had provided – aashnisshah Mar 23 '14 at 23:04

PHP ucwords on echo of MySQL variable

4 Answers4