cococo | Code Coverage Converter from Xcode 11 to SonarQube | Code Coverage Tools library

You can use this library to perform what you are trying to do manually. One line of code:

I think in the second table you would be altering the value of the "f_id" column. I think you should first evaluate if this column is auto incrementable, since what you need to do is add a record after "Name:" in a match called "Company", is not it? In any case that "f_id" is not auto incrementable the thing would be much easier.

On the other hand, I would tell you to solve it in three possible ways:

1. Truncate the table completely and re-insert the new records after successfully traversing your array through "php". This would be a later solution but effective in case you are working on the camp "f_id" a value, as I said before, self incrementable.

2. If the "f_id" column is not auto incrementable, you will have to save all records after the match found (including the last ID). Having this, you will have to delete them and then insert the "Company". Following this, you're going to have to re-update your table to insert the records you deleted.

3. If you find a match, I recommend you save the value of "f_id" in some table called, for example, "companies", where you store some "id" that you consider can relate directly to a company. In this case yes I will recommend you to investigate on the subject of relational databases.

Luck.