I have just finished building my site, and now it's time to finally put a database in it and actually connect it to a database. So far I have downloaded Xampp and installed everything and tested it.

As I was starting to use MySQL, I was told that i should not use it and actually use MySQLi. I tried to find some tutorials but everything is very confusing.

I have found these on YouTube:

Do you guys think this is the way to go to create a small database? Or could anyone recommend any other good tutorials around this area to create a login and reg database?

All my database would be doing is allowing people to reg and login, and send some queries etc back to the user. So I am not sure if i should use MySQLi.


Going off the links that you provided, I would suggest looking into PHP's PDO (PHP Data Object). The reason for this is because the mysqli way is getting pretty old at this point. PDO is relatively simple to use and it has different drivers for different database vendors. So if you want to switch out your database system for something else, then it is easier to switch with PDO.

Here is a couple tutorials:

The second tutorial is a little more involved and shows more detail and the first is probably what you're looking for.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.