{"id":58110,"date":"2023-02-20T03:01:42","date_gmt":"2023-02-19T17:01:42","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/ITblog\/?p=58110"},"modified":"2023-02-19T19:18:34","modified_gmt":"2023-02-19T09:18:34","slug":"php-mysql-select-query-utf-8-return-values-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/php-mysql-select-query-utf-8-return-values-tutorial\/","title":{"rendered":"PHP MySql Select Query UTF-8 Return Values Tutorial"},"content":{"rendered":"
\"PHP<\/a>

PHP MySql Select Query UTF-8 Return Values Tutorial<\/p><\/div>\n

Yes, ever since embracing emojis, we’re on the lookout for gobbledegook. And yes, a lot of the strategies we found on the “stumbled upon” Reading UTF-8 Content from MySql Table<\/a> we were familiar with, but one we weren’t, which was the one we discovered as gobbledegook in our Landing Page’s major dropdown outlining all the blog posts we’ve written at the RJM Programming WordPress Blog Website we’re running here, and you are reading now.<\/p>\n

The, was …<\/p>\n


\nJust Javascript Five Hundred Card Game Open Mis\ufffdre Progress Bar Tutorial (20210507)
\n<\/code><\/p>\n

… anti gobbledegook initiative scenario, with our changed tutorial_options.php cronatb\/curl morning scheduled Landing Page modifier, becomes …<\/p>\n


\nJust Javascript Five Hundred Card Game Open Mis\u00e8re Progress Bar Tutorial (20210507)
\n<\/code><\/p>\n

… improvement, came about from a consideration we have not thought about before … what about if MySql data contains UTF-8 data, and is part of a WordPress blog title, which ends up on the Landing Page big dropdown, already covered by a …<\/p>\n


\n<meta http-equiv=\"Content-Type\" content=\"text\/html; charset=UTF-8\">
\n<\/code><\/p>\n

… was inspired by checking off the excellent “already catered for” anti gobbledegook (emoji) checklist measures, leaving the PHP …<\/p>\n

<?php
\n
\n $res = mysql_query(\"set names 'utf8'\");
\n<\/code>
\n?><\/p>\n

… initiative, before any SQL SELECT type queries, idea, presented at Reading UTF-8 Content from MySql Table<\/a>, which fixed our issue very nicely, thanks, in our changed<\/a> tutorial_options.php<\/a> PHP crontab\/curl PHP helper.<\/p>\n

If this was interesting you may be interested in this<\/a> too.<\/p>\n