Security Issue

[DolUnity]

Hello Timy,
I've found some security issues in your methods. First of all mysqli is outdated, for new webapplications you should use pdo or an orm like doctrine. Next you are not using prepared statements. Like you have done it an SQL injection is quite easy.
Also why are you creating always a new connection for each method and dont just create the connection in the construct method and safe it as an private variable in your class.

[TimyStream]

First, Why is mysqli outdated ?
Second, this with the prepared statements i can understand an will change it in the Future
Third, the point with the Private variable is not an bad idea :)

[DolUnity]

Well, the mysqli connector isn't completely outdated. Its just that PDO is featuring more functions then mysqli and will be the new primary connector. For example: with PDO you can return directly an array of your selectet entities and must not create a loop to put them into an array.

[TimyStream]

Sure but this is not directly the purpose of this Libary

[DolUnity]

You could save up some line of code?

[TimyStream]

I can, but like i said the purpose of this Libary is to easy work with a database. I can update it to the PDO but i would make a second branch explicit for PDO. Then we can Cover both the "Mysqli" and the "PDO" Connector 😄 👍