usu | Ultimate SEO URL | Search Engine Optimization library

Your script has the following happening:

You set $countlinha = 1;

Which means the condition if ($countlinha > 1) is false on first iteration of foreach($linhas as $linha). I.e. the first 'record' inside $linhas is not processed.

Then you increment $countlinha++; it becomes 2

So on second iteration of foreach($linhas as $linha) the code inside the if ($countlinha > 1) is executed.

The second 'record' inside $linhas is echoed and written to database.

However, return $stmt; now terminates your script.

So all in all you only got one 'record' processed.

If you want to get all 'records' inside $linhas processed, you should drop the if ($countlinha > 1) condition, and do NOT return inside the loop as it will terminate your script prematurely.

I am replicating here the observation of @andrewjames. Since it is not a problem, I could notice this because of this observation. So, it is the solution.

Not an answer - just an observation: The message is still valid JSON. The \u00e1 string is how JSON stores Unicode-escaped characters. So, for example your á is represented by that sequence. So, not only is the message valid, but it is equivalent to your original text. Any consumer of this JSON should itself use a JSON library, which should handle these escape sequences correctly - for example, if the JSON needs to be parsed and its text needs to be displayed to users. – andrewjames May 13 at 22:01

It's generally not a good idea to store the navigation state in Redux.

You can access data from the react-router context using the hooks useHistory, useLocation, useParams, and useRouteMatch.

Probably this is what you want, it returns the current path like "/users/joe":

It seems that you want to use the action woocommerce_subscriptions_updated_users_role

Description: When a subscription is activated, suspended, cancelled or expired, the user’s role will also be changed, which triggers the 'woocommerce_subscriptions_updated_users_role' hook.

Source: https://docs.woocommerce.com/document/subscriptions/develop/action-reference/

The problem I usually run into when trying to do stuff like that in EF is that EF often doesn't know how to translate complex checks into SQL. On the bright side, the query isn't executed until the 'ToListAsync' call. Since that's the case, we can instead perform our null checks prior to EF taking over and doing its magic. This is the pattern I typically follow for something like this since I've had problems with it in the past. However, I'm not sure if this is the best practice, or if EF can handle more complex stuff like this nowadays..

Use a pattern matcher with the regex pattern:

Wrong encoding, as comment pointed out. File is encoded in ASCII

I finally solve the problem. It referred to put @Transactional annotation to loadUserByUsername method, an override one from UserDetailsService, implemented on UserService. @ChristopherSchneider thanks again for your help! :)