mista | downloadable urls of the Instagram posts | Scraper library

This is what you have to do to get the text of each .spName and .zPr using a jQuery .each function in li first and then from there .each all the p to get the desired text and data via their .children and class-names

Read more about .each jQuery function here

Read more about .children jQuery function here

I have also changed your HTML a little bit as it was correctly added and to each elements and span.

Run snippet below to see it working.

AUTO INCREMENT is set at the server level within MySQL, and can be overwritten if assigned manually within a CSV or other import. If you simply exclude the entire column from your import, you'll allow MySQL to do what is set as default for that column, and automatically assign ID's, since it doesn't think you want to assign them yourself.

Also as a side note, if you import more than once without using TRUNCATE TABLE -- MySQL will pick up on the last inserted ID and move on from there, even if the table is empty. So if you ever want to start over from 1 you'll have to trucate the table.

Note: you forgot to close a section processo before the ending revista

The problem is you didn't adapt the code to the structure of the xml file.

You get a \n because node.find('despachos').text gives you the text contained in despachos. Yet, there is no real text in it, just \n followed by spaces. Pandas will display that as it is, without any parsing. You have to apply node.find('despachos').text.rstrip() to avoid that.

Furthermore, in despachos, you have one child node called despacho, which is a closed tag so again there is not text. It has however two attributes codigo and nome that you could use as for processo. For example:

Your MISRA checker is unable to determine that these are your boolean type.

In case you are stuck with C90 and only then: you need to inform your tool somehow about which custom bool type you are using. Otherwise it won't be able to tell what these macros are for.

Otherwise, simply use stdbool.h. There are very few excuses not to in the year 2019.

Assuming your array name is $arr you can try something like this:

PHP does have an alternative syntax format for control statements that work well within HTML, although it is generally recommended to use templates and keep logic out of your view as much as possible. That being said, you could do something like: