IoT competitors and mysql to mysqli update

Today I've worked from home. I finally listed all of the competitors that has products like wireless sensors that upload things to the internet somehow. If you are interested in the small list I have, send me a mail.

From there I could see that there might be a nice place on the market for a similar produkt. Especially if you do the marketing well.

Then I worked on setting up to update the php files. I downloaded all of the files, made a backup and started a local git-repo to keep track of my changes. Then I searched the file-content for "mysql_" and found 70 files...

I need to change like 4 methods and add a line of code to each file. (I think).

I started doing it manually but then I thought of making a python-program to patch it up instead.

One mystery thing is that I tried changing a part of the files yesterday and it seemed to work. I could upload something to a mysql-server and when i tried to upload something with the same id, it gave me an error talking about uniqe ids. But when I looked through the database I couldn't find the thing I supposedly made. This concerns me... But if I get that to work, it shouldn't be a problem to fix the other files.