What are the potential pitfalls of using mysqli extension in PHP 4.3.11 and how can compatibility issues be addressed?

The potential pitfalls of using mysqli extension in PHP 4.3.11 include compatibility issues as mysqli extension was introduced in PHP 5.0. To address these compatibility issues, you can switch to using the older mysql extension or upgrade your PHP version to at least 5.0.

// Using the older mysql extension in PHP 4.3.11
$connection = mysql_connect('localhost', 'username', 'password');
mysql_select_db('database_name', $connection);

// Perform queries using mysql functions
$result = mysql_query("SELECT * FROM table_name", $connection);
while ($row = mysql_fetch_assoc($result)) {
    echo $row['column_name'] . "<br>";
}

// Close the connection
mysql_close($connection);