Walking Trip …

Walking Trip

Walking Trip

Offenbach's Suite ... Warts 'n All

Offenbach's Suite ... Warts 'n All

 📅  

If this was interesting you may be interested in this too.

Posted in Photography, Trips | Tagged , , | 34 Comments

Window Object Function Equals Function Primer Tutorial

Window Object Function Equals Function Primer Tutorial

Window Object Function Equals Function Primer Tutorial

In keeping with yesterday’s Web Browser Brand Roles Primer Tutorial‘s KISS lead in, there’s a subtle difference between what happens with the two tabulated links below …

KISS KISS

… using (from within the clientside realms of the coding of this WordPress.org blog’s) Javascript …


function scrollIntoViewExactly(inob) {
if (document.getElementById('nest' + inob.id) || 4 == 4) {
// var ninob=document.getElementById('nest' + inob.id);
// ninob.style.width='' + inob.width + 'px';
// ninob.style.height='' + inob.height + 'px';
//inob.style.display='inline-block';
// ninob.style.display='inline-block';
// forceVerticalOverflow(ninob);
//document.body.style.whiteSpace='nowrap';
// document.body.style.overflow='scroll';// Safely sets horizontal scroll across all modern browsers
var inobr=inob.getBoundingClientRect();
//alert('' + inobr.width + ',' + inobr.height);
//alert('' + document.body.scrollLeft);
//alert('' + eval('' + inobr.left) + ',' + eval('' + inobr.top));
//alert('{ left:' + Math.floor(eval('' + inobr.left) + eval('' + document.body.scrollLeft)) + ', top:' + Math.floor(eval('' + inobr.top) + eval('' + document.body.scrollTop)) + ", behavior: 'smooth' }");
// ninob.style.overflowX='scroll';
// ninob.style.maxWidth='' + ninob.style.width;
//inob.innerHTML+=' ';
//ninob.style.maxHeight='200px';
// ninob.style.overflowY='scroll';
// alert(ninob.outerHTML);
//var innardsare='{ left:' + Math.floor(eval('' + inobr.left) + eval('' + document.body.scrollLeft)) + ', top:' + Math.floor(eval('' + inobr.top) + eval('' + document.body.scrollTop)) + ", behavior: 'smooth' }";
// left: Math.floor(eval('' + inobr.left) + eval('' + document.body.scrollLeft)),
var ioffis=eval(eval(screen.width - eval('' + document.getElementById('content').getBoundingClientRect().width)) / 2);
thenx=Math.floor(eval('' + inobr.left) + eval('' + document.body.scrollLeft) + eval('' + document.body.offsetLeft) + ioffis);
const innardsare = {
top: eval(120 + Math.floor(eval('' + inobr.top) + eval('' + document.body.scrollTop))),
behavior: 'smooth'
};
const xinnardsare = {
left: Math.floor(eval('' + inobr.left) + eval('' + document.body.scrollLeft) + eval('' + document.body.offsetLeft) + ioffis),
behavior: 'auto'
};
if (7 == 7) {
location.href='#' + inob.id;
} else {
// alert(isScrollable(ninob));
forceVerticalOverflow(document.body);
//alert(isScrollable(document.body));
//alert(innardsare);
window.scrollTo(innardsare);
//alert(Math.floor(eval('' + inobr.left) + eval('' + document.body.scrollLeft)));
//setTimeout(function(){ document.body.style.overflowX = 'auto'; document.body.scrollBy(xinnardsare); }, 8000);
//setTimeout(function(){ alert(thenx); document.scrollingElement.scrollLeft='' + thenx + ''; }, 8000);
}
setTimeout(function(){
//document.body.overflowX='scroll';
document.body.style.cursor='progress';
document.body.style.marginLeft='-' + thenx + 'px'; //inob.scrollLeft=thenx;
inob.setAttribute('data-cb', '25');
setTimeout(countback, 1000);
setTimeout(function(){
document.body.style.cursor='pointer';
document.body.style.marginLeft='0px'; //inob.scrollLeft=thenx;
}, 25000);
}, 1000);
if (3 == 5) {
setTimeout(function(){
//document.body.style.whiteSpace='nowrap';
//document.body.style.overflow='scroll';// Safely sets horizontal scroll across all modern browsers
if (document.scrollingElement) {
document.scrollingElement.scrollLeft = thenx;
} else {
// Fallback for older browsers
document.documentElement.scrollLeft = thenx;
document.body.scrollLeft = thenx;
}
}, 5000);
}
} else {
window.scrollIntoView(inob);
}
}


Previous relevant Web Browser Brand Roles Primer Tutorial is shown below.

Web Browser Brand Roles Primer Tutorial

Web Browser Brand Roles Primer Tutorial

With a job, the day to day organization can be important, and is likely to be crucial to achieving goals.

We spend a lot of time around web browser applications, being into I.T. and creating web applications, in particular.

We’ve organized macOS MacBook Air usage mainly, around one major disk folder and four brands of web browser, the folder being, for us is …


/Applications/MAMP/htdocs

Huh?! Well, being into PHP as our “all things server” programming language, and having installed (many versions) of MAMP, as our Apache/PHP/MySql local web server brand of choice, and by default /Applications/MAMP/htdocs is MAMP’s Document Root (and defaulting to port 8888) corresponding to URL …


http://localhost:8888

Even with compiling language work, we’ll often use subfolders off /Applications/MAMP/htdocs … working to a KISS principle!

Turning to web browsers, the four we tabulate below are all very good products, and can all work well for you, especially on macOS, but a consideration to do with how you organize work, there is the consideration of what work life will be like if you have to, say, clear all web browser cookies and data, for instance. As such, in the list below, we’ve organized Google Chrome and/or Firefox as the two web browsers we can tolerate that with (but prefer to just clear Last Hour or Last 15 Minutes or Last 24 Hours usually), in our (web browser) Organization Table below …

Opera
  • RJM Programming website email … opened as this web browser’s home page
Safari
  • RJM Programming website WHM and cPanel login to domain related configurations and monitoring functionality
  • MAMP (opened when MacBook Air (re-)boots) based Animated GIF creation executions
  • Crazy Domains web hosting login to payments and Live Chat support
Firefox
  • Web application testing for tests that need to ignore Google Chrome
Google Chrome
  • RJM Programming *.php lately changed list report … opened as this web browser’s home page
  • Norton Safe Search of RJM Programming webpage … opened also when web browser loads up
  • Gmail via URL personal and work emails
  • WordPress.org blog Content Management System work
  • Web application Research and Development
  • Web application executions
  • Web application Web Inspector debugging

When there are jobs requiring command line needing to be seen next to a web browser rendition, macOS Terminal application windows can easily be arranged to not overlap any web browser brand window from the list above.

Screenshots on macOS have moved on from good ol’ Grab with the very easy keyboard shortcut …


control-command-shift-3

… working really well with good ol’ macOS version of PaintBrush‘s File->New from Clipboard functionality. Preview is good for PDF creation and compilation functionality. Gimp is good for blurring and other filtering requirements.

More and more we’ll use AirDrop to transfer from iPad or iPhone to the macOS MacBook Air, or use that iOS device’s Mail sharing option to download to the macOS MacBook Air Downloads folder usually, and then, usually, this will be copied to good ol’ /Applications/MAMP/htdocs (or a subfolder off this, especially if what is copied is a *.zip file (extracted)).

Crontab on the macOS MacBook Air has an “every minute” check of good ol’ /Applications/MAMP/htdocs changed (within last minute) *.png (primarily coming out of Paintbrush File->Save As… functionality) or *.[Hh][Ee][Ii][Cc] (off iPhone or iPad Camera app usage) ready for (PHP calling of) ImageMagick‘s convertion to versions of *.[Jj][Pp]*[Gg] images.

Uploads to (and downloads from) the RJM Programming domain are all conducted via sftp connections using the FileZilla macOS desktop application.

TextWrangler is our favourite text editor by a very large margin!

If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.

Posted in eLearning, Event-Driven Programming, OOP, Tutorials | Tagged , , , , , , , , , , , | Leave a comment

Screen Co-ordinates Helper Primer Tutorial

Screen Co-ordinates Helper Primer Tutorial

Screen Co-ordinates Helper Primer Tutorial

There’s a really good macOS keyboard shortcut we’d like to discuss today. It’s …


shift-command-4

To take a screenshot of part of the screen, press Shift-Command-4 and then drag the cursor to outline the area you want to capture. If you want to capture a specific window, press Shift-Command-4. Hit the spacebar.

But it’s the “half-way” point with this we particularly noticed using web browsers. In the past when we’ve constructed HTML image maps we’ve often relied on Mobilefish.Com and its excellent Image Map Creation software to help us out, but this shift-command-4 keyboard shortcut’s way of displaying screen pixel co-ordinates could be another option here. Or it could be used in overlay position:absolute; left:[X]px; top:[Y]px; positioning scenarios, to good effect, we can envisage.

Mind you, other environments have their equivalents, too!

The woooooorrrrrllllllddd’s your better X and Y positioned oyyyyyyyster!

If this was interesting you may be interested in this too.

Posted in eLearning, Operating System, Tutorials | Tagged , , , , , , , , , , , , | Leave a comment

PHP MySql WordPress Blog Apache Restart Watchdog Tutorial

PHP MySql WordPress Blog Apache Restart Watchdog Tutorial

PHP MySql WordPress Blog Apache Restart Watchdog Tutorial

A couple of days before yesterday’s PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial you may recall we started with four PHP MySql WordPress Blog Performance Primer Tutorial “Performance enhancement” ideas, and today, start down the side-road adding two more ideas into the mix …

  • MySql slow queries
  • PHP slow processing
  • inhouse watchdog resurrections
  • blog image loading priorities
  • caching ideas
  • PHP-FPM (Multi PHP Manager) settings

These two new ideas we think can value add to our “Performance enhancement” endeavours here regarding our AlmaLinux WHM cPanel Apache/PHP/MySql mainly WordPress.org blog and other RJM Programming domain parts.

We’ve already developed an “inhouse watchdog” regarding crontab Korn Shell command line scripting means by which, under compromised MySql database conditions (when we last presented MySql Watchdog Migration Transition Solution Tutorial), we can perform the equivalent of …


WHM cPanel -> Restart Services -> Database Server

Today’s work uses that same crontab “every minute” Korn Shell …


* * * * * /etc/init.d/cron_is_working.ksh

… mentioned in Linux CentOS Web Server Domlogs Diskspace Automating Solution Tutorial inserting these Korn Shell scripting codelines …


curl -v --max-time 5 https://www.rjmprogramming.com.au/Links.html
cret="`echo \$?`"
if [ "`echo \$cret`" == "28" ]; then
/usr/local/cpanel/scripts/restartsrv_httpd --restart --hard
cret="-7"
fi

… to add to the “inhouse watchdog” smarts by, given an adverse website connection test, we can perform the equivalent of …


WHM cPanel -> Restart Services -> HTTP Server (Apache)

… both as a resurrection measure and a “buying us more time” measure to relax more working on “Performance enhancement” ideas into the future.

Regarding help here we got enormous help from …

… thanks.


Previous relevant PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial is shown below.

PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial

PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial

Moving on from yesterday’s PHP MySql WordPress Blog Performance Primer Tutorial‘s Performance monitoring theory 1 regarding our AlmaLinux Apache/PHP/MySql mainly WordPress.org blog, involving …

  • MySql slow queries … today, we move on to logging and monitoring …
  • PHP slow processing

… and it pans out to log and monitor the PHP this way we got advice from on almalinux where is a log that would detect php performance issues? …

β€’ PHP-FPM Slow Log: Captures backtraces of PHP scripts that exceed a defined time limit, helping pinpoint slow code or blocking functions.

β€’ Default / Common Path: /var/log/php-fpm/www-slow.log (or /var/log/php8.x-fpm-slow.log depending on your PHP version)

β€’ cPanel Path: /opt/cpanel/ea-phpXX/root/usr/var/log/php-fpm/error.log

… thanks … getting us to change the PHP-FPM configuration settings for the rjmprogramming.com.au domain specific PHP-FPM configuration settings in, for us, being in our WHM cPanel Terminal, going …


vi /opt/cpanel/ea-php81/root/etc/php-fpm.d/rjmprogramming.com.au.conf

… by appending …


request_slowlog_timeout = 5s
slowlog = /opt/cpanel/ea-php81/root/etc/php-fpm.d/www-slow.log

… and saving within the vi session, then in our WHM cPanel …


Restart Services -> HTTP Server (Apache)

… link click, and a Restart button click, to log to, for us start logging to …


/opt/cpanel/ea-php81/root/etc/php-fpm.d/www-slow.log

… pointing out to us two major pinchpoints exemplified by …

Codex loop.php WordPress error 404 event PHP
Overuse of file_get_contents Rearrange use of file_get_contents …
passing more work to crontab/curl overnight run

… as two logging detection types of use to us, as we continue on our “Performance quest”.


Previous relevant PHP MySql WordPress Blog Performance Primer Tutorial is shown below.

PHP MySql WordPress Blog Performance Primer Tutorial

PHP MySql WordPress Blog Performance Primer Tutorial

To our minds, when thinking about the performance of this blog, which we think could do with some attention given more traffic lately, it being an AlmaLinux Apache/PHP/MySql WordPress.org one, we know of four avenues of research we’d say are …

  • MySql slow queries
  • PHP slow processing
  • caching ideas
  • PHP-FPM (Multi PHP Manager) settings

… the last of which we’ll leave to last, but some of that can be got to via WHM cPanel options.

With the first two, you will probably need to consider the information web server logging can provide you. By default, we’re finding, AlmaLinux Apache/PHP/MySql web servers of any recent times do not by default log for either of the first two above.

And so, today’s start down our road examining “performance”, we’ll outline how to set up logging to start investigating whether slow MySql database (further to PHP MySql Select Query UTF-8 Return Values Tutorial) queries are “too adversely” affecting your Apache/PHP/MySql web server’s creation of your (perhaps WordPress blog) webpage(s).

Here we got great advice from on almalinux where is a log that would detect slow mysql queries? … thanks … gleaning …

By default, MySQL’s slow query log is turned off on AlmaLinux. If it has been enabled, you can find the file path by running a quick SQL command, or you can configure it manually.

… leading us to …

  1. accessed WHM cPanel -> Edit Database Configuration
  2. set the Slow Query logging to enabled
  3. Saved that change
  4. accessed WHM cPanel -> Restart Services -> Database Server
  5. click Restart button
  6. then, accessing WHM cPanel -> Terminal, from then on, at it’s command line …

    ls -l /var/lib/mysql/*.log
    cat /var/lib/mysql/65-254-93-2-slow.log # as relevant, in our RJM Programming domain's case, if above not showing zero length log

    … were our means of knowing if slow MySql queries are a major issue

… and after a day of logging? We think this is not the major “performance” concern for our RJM Programming domain, that slow log still showing no issues. And so, tomorrow, the quest continues.


Previous relevant PHP MySql Select Query UTF-8 Return Values Tutorial is shown below.

PHP MySql Select Query UTF-8 Return Values Tutorial

PHP MySql Select Query UTF-8 Return Values Tutorial

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 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.

The, was …


Just Javascript Five Hundred Card Game Open MisοΏ½re Progress Bar Tutorial (20210507)

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


Just Javascript Five Hundred Card Game Open Misère Progress Bar Tutorial (20210507)

… 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 …


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

… was inspired by checking off the excellent “already catered for” anti gobbledegook (emoji) checklist measures, leaving the PHP …

<?php

$res = mysql_query("set names 'utf8'");

?>

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

If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.

Posted in Database, eLearning, Operating System, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial

PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial

PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial

Moving on from yesterday’s PHP MySql WordPress Blog Performance Primer Tutorial‘s Performance monitoring theory 1 regarding our AlmaLinux Apache/PHP/MySql mainly WordPress.org blog, involving …

  • MySql slow queries … today, we move on to logging and monitoring …
  • PHP slow processing

… and it pans out to log and monitor the PHP this way we got advice from on almalinux where is a log that would detect php performance issues? …

β€’ PHP-FPM Slow Log: Captures backtraces of PHP scripts that exceed a defined time limit, helping pinpoint slow code or blocking functions.

β€’ Default / Common Path: /var/log/php-fpm/www-slow.log (or /var/log/php8.x-fpm-slow.log depending on your PHP version)

β€’ cPanel Path: /opt/cpanel/ea-phpXX/root/usr/var/log/php-fpm/error.log

… thanks … getting us to change the PHP-FPM configuration settings for the rjmprogramming.com.au domain specific PHP-FPM configuration settings in, for us, being in our WHM cPanel Terminal, going …


vi /opt/cpanel/ea-php81/root/etc/php-fpm.d/rjmprogramming.com.au.conf

… by appending …


request_slowlog_timeout = 5s
slowlog = /opt/cpanel/ea-php81/root/etc/php-fpm.d/www-slow.log

… and saving within the vi session, then in our WHM cPanel …


Restart Services -> HTTP Server (Apache)

… link click, and a Restart button click, to log to, for us start logging to …


/opt/cpanel/ea-php81/root/etc/php-fpm.d/www-slow.log

… pointing out to us two major pinchpoints exemplified by …

Codex loop.php WordPress error 404 event PHP
Overuse of file_get_contents Rearrange use of file_get_contents …
passing more work to crontab/curl overnight run

… as two logging detection types of use to us, as we continue on our “Performance quest”.


Previous relevant PHP MySql WordPress Blog Performance Primer Tutorial is shown below.

PHP MySql WordPress Blog Performance Primer Tutorial

PHP MySql WordPress Blog Performance Primer Tutorial

To our minds, when thinking about the performance of this blog, which we think could do with some attention given more traffic lately, it being an AlmaLinux Apache/PHP/MySql WordPress.org one, we know of four avenues of research we’d say are …

  • MySql slow queries
  • PHP slow processing
  • caching ideas
  • PHP-FPM (Multi PHP Manager) settings

… the last of which we’ll leave to last, but some of that can be got to via WHM cPanel options.

With the first two, you will probably need to consider the information web server logging can provide you. By default, we’re finding, AlmaLinux Apache/PHP/MySql web servers of any recent times do not by default log for either of the first two above.

And so, today’s start down our road examining “performance”, we’ll outline how to set up logging to start investigating whether slow MySql database (further to PHP MySql Select Query UTF-8 Return Values Tutorial) queries are “too adversely” affecting your Apache/PHP/MySql web server’s creation of your (perhaps WordPress blog) webpage(s).

Here we got great advice from on almalinux where is a log that would detect slow mysql queries? … thanks … gleaning …

By default, MySQL’s slow query log is turned off on AlmaLinux. If it has been enabled, you can find the file path by running a quick SQL command, or you can configure it manually.

… leading us to …

  1. accessed WHM cPanel -> Edit Database Configuration
  2. set the Slow Query logging to enabled
  3. Saved that change
  4. accessed WHM cPanel -> Restart Services -> Database Server
  5. click Restart button
  6. then, accessing WHM cPanel -> Terminal, from then on, at it’s command line …

    ls -l /var/lib/mysql/*.log
    cat /var/lib/mysql/65-254-93-2-slow.log # as relevant, in our RJM Programming domain's case, if above not showing zero length log

    … were our means of knowing if slow MySql queries are a major issue

… and after a day of logging? We think this is not the major “performance” concern for our RJM Programming domain, that slow log still showing no issues. And so, tomorrow, the quest continues.


Previous relevant PHP MySql Select Query UTF-8 Return Values Tutorial is shown below.

PHP MySql Select Query UTF-8 Return Values Tutorial

PHP MySql Select Query UTF-8 Return Values Tutorial

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 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.

The, was …


Just Javascript Five Hundred Card Game Open MisοΏ½re Progress Bar Tutorial (20210507)

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


Just Javascript Five Hundred Card Game Open Misère Progress Bar Tutorial (20210507)

… 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 …


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

… was inspired by checking off the excellent “already catered for” anti gobbledegook (emoji) checklist measures, leaving the PHP …

<?php

$res = mysql_query("set names 'utf8'");

?>

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

If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.

Posted in Database, eLearning, Operating System, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

PHP MySql WordPress Blog Performance Primer Tutorial

PHP MySql WordPress Blog Performance Primer Tutorial

PHP MySql WordPress Blog Performance Primer Tutorial

To our minds, when thinking about the performance of this blog, which we think could do with some attention given more traffic lately, it being an AlmaLinux Apache/PHP/MySql WordPress.org one, we know of four avenues of research we’d say are …

  • MySql slow queries
  • PHP slow processing
  • caching ideas
  • PHP-FPM (Multi PHP Manager) settings

… the last of which we’ll leave to last, but some of that can be got to via WHM cPanel options.

With the first two, you will probably need to consider the information web server logging can provide you. By default, we’re finding, AlmaLinux Apache/PHP/MySql web servers of any recent times do not by default log for either of the first two above.

And so, today’s start down our road examining “performance”, we’ll outline how to set up logging to start investigating whether slow MySql database (further to PHP MySql Select Query UTF-8 Return Values Tutorial) queries are “too adversely” affecting your Apache/PHP/MySql web server’s creation of your (perhaps WordPress blog) webpage(s).

Here we got great advice from on almalinux where is a log that would detect slow mysql queries? … thanks … gleaning …

By default, MySQL’s slow query log is turned off on AlmaLinux. If it has been enabled, you can find the file path by running a quick SQL command, or you can configure it manually.

… leading us to …

  1. accessed WHM cPanel -> Edit Database Configuration
  2. set the Slow Query logging to enabled
  3. Saved that change
  4. accessed WHM cPanel -> Restart Services -> Database Server
  5. click Restart button
  6. then, accessing WHM cPanel -> Terminal, from then on, at it’s command line …

    ls -l /var/lib/mysql/*.log
    cat /var/lib/mysql/65-254-93-2-slow.log # as relevant, in our RJM Programming domain's case, if above not showing zero length log

    … were our means of knowing if slow MySql queries are a major issue

… and after a day of logging? We think this is not the major “performance” concern for our RJM Programming domain, that slow log still showing no issues. And so, tomorrow, the quest continues.


Previous relevant PHP MySql Select Query UTF-8 Return Values Tutorial is shown below.

PHP MySql Select Query UTF-8 Return Values Tutorial

PHP MySql Select Query UTF-8 Return Values Tutorial

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 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.

The, was …


Just Javascript Five Hundred Card Game Open MisοΏ½re Progress Bar Tutorial (20210507)

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


Just Javascript Five Hundred Card Game Open Misère Progress Bar Tutorial (20210507)

… 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 …


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

… was inspired by checking off the excellent “already catered for” anti gobbledegook (emoji) checklist measures, leaving the PHP …

<?php

$res = mysql_query("set names 'utf8'");

?>

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

If this was interesting you may be interested in this too.


If this was interesting you may be interested in this too.

Posted in Database, eLearning, Operating System, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment