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.

closed as off-topic by mustaccio, Mat, Philᵀᴹ, Julien Vavasseur, Tom V Jan 27 '16 at 8:09

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – mustaccio, Mat, Philᵀᴹ, Julien Vavasseur, Tom V
If this question can be reworded to fit the rules in the help center, please edit the question.


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.

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