mysqli_get_charset()

The PHP mysqli_get_charset function is used to acquire information about the current MySQLi connection’s character set. This method might be useful for verifying that data is encoded and decoded correctly when it is stored or retrieved from a database.

The mysqli_get_charset function has the following syntax:

object mysqli_get_charset ( mysqli $link )

Where $link is the identification of a MySQLi link returned by mysqli_connect() or mysqli_init().

Here’s how to utilize the mysqli_get_charset_function in practice:

$link = mysqli_connect("localhost", "username", "password", "database");

if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}

$charset = mysqli_get_charset($link);

echo "Character set: " . $charset->charset . PHP_EOL;
echo "Collation: " . $charset->collation . PHP_EOL;

In this example, the script uses the mysqli connect() function to connect to a MySQL database, and then utilizes the mysqli get charset() function to collect information about the character set used for the connection. After that, the character set and collation are printed on the screen.

You may also use the mysqli get charset function to set the character set for a connection by sending the result of mysqli get charset to the mysqli set charset function.

It is vital to remember that mysqli get charset provides an object with two attributes (charset and collation) that are read-only.