websites - Suay.Site

Alternatives for Google Domains

Posted by Alex On November 9, 2023

For the second year now, I have been using Google Domains to register domains – I really like their service: low prices, free Domain Privacy, convenient management, no restrictions, automatic verification of sites in Google Search Console. Overall, I could definitely recommend this domain registrar if it still worked... Note: Domain Privacy is the hiding of your personal data (your...

PHP Fatal error: Uncaught mysqli_sql_exception: No database selected (SOLVED)

Posted by Alex On September 6, 2023

Let's look at a small PHP code that tries to connect to a MySQL or MariaDB DBMS and execute a query with a “SELECT” statement: <?php $db_user = "root"; $db_password = ""; $mysqli = new mysqli("localhost", $db_user, $db_password); if ($mysqli->connect_errno) { printf("Somehow we failed: %s\n", $mysqli->connect_error); exit(); } $query = "SELECT * FROM TestTABLE;"; $result = $mysqli->query($query); while ($row =...

“ERROR 1366 (22007): Incorrect string value” in MySQL/MariaDB (SOLVED)

Posted by Alex On August 26, 2023

How to insert emoji into MySQL/MariaDB database On the one hand, inserting emoji into a MySQL / MariaDB database table does not require any special preparatory steps – just insert one or more emoji characters, which may contain other text. For example: INSERT INTO TestTABLE (`test_column`) VALUES ("🎫⏭️✈️ and hi 🌅"); But when executing the previous request, you may encounter...

PHP not displaying emoji from MySQL/MariaDB database (SOLVED)

Posted by Alex On August 25, 2023

When retrieving rows from a MySQL (MariaDB) database, you may encounter a situation where all the text is displayed correctly, but question marks are displayed instead of emoji. The most likely problem is an incorrectly used encoding when executing queries against the MySQL (MariaDB) DBMS. There are two ways to fix this situation. 1. Select utf8mb4_unicode_ci encoding when creating database...

Automatic code highlighting on websites

Posted by Alex On August 9, 2023

Automatic markup of code on sites In this article, you will learn how to enable syntax highlighting of the source code on your websites. Code highlighting means automatic coloring of program source code elements in different colors in accordance with the syntax of the programming language. The shown option is suitable for both WordPress sites and any other sites. Note:...