Adapt MYSQL Queries from PHP5 to PHP7+

I have old mysql queries and this have to be adapted to php7+ This is the source: // connect and select database $conn = mysql_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD) or die("Could not connect to database"); mysql_select_db(DATABASE_NAME, $conn); if($country == 'GB') $sql = "select * from bank_identifier where bank_bic like '" . $code . "%' and country_code='" . $country ."'"; else $sql = "select * from bank_identifier where bank_code='" . $code . "' and country_code='" . $country ."'"; $result = mysql_query($sql); if (mysql_num_rows($result) > 0) { $row = mysql_fetch_assoc($result); $description = $row["bank_description"]; } // close recordset mysql_free_result($result); // close db mysql_close($conn); // free mem unset($conn); unset($sql);unset($row); return $description; } function get_bank_bic_code($code, $country) { $bic=""; if(trim($code) == "" || trim($country) == "" ) return $bic; // connect and select database $conn = mysql_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD) or die("Could not connect to database"); mysql_select_db(DATABASE_NAME, $conn); if($country == 'GB') $sql = "select bank_bic from bank_identifier where bank_bic like '" . $code . "%' and country_code='" . $country ."'"; else $sql = "select bank_bic from bank_identifier where bank_code='" . $code . "' and country_code='" . $country ."'"; $result = mysql_query($sql); if (mysql_num_rows($result) > 0) { $row = mysql_fetch_assoc($result); $bic = $row["bank_bic"]; } // close recordset mysql_free_result($result); // close db mysql_close($conn); // free mem unset($conn); unset($sql);unset($row); return $bic; }