Context: I'm creating a website from scratch, using no plugins aside from jQuery, trying to get comfortable with the basics of how things are done. My website has content that should be managed through a small database ( i think at least ). For you to get an idea, it will have a homepage with news, a portfolio and a submission form for redirecting e-mails to my inbox.

Problem: I've been trying to read about some possibilities for database integration, but it's a vast world, I'm currently trying to learn PHP using phpMyAdmin and WAMP and running a few tests with a simple .php file, but it seems a bit unstable, sometimes queries work, sometimes they don't (maybe i'm still a newbie).

Question: If you had to pick a DBMS for a case like this, what would you go for and why? I'm looking for something simple to set up and access.

  • 2
    Question includes answer: what database does phpMyAdmin support? Only one, MySQL/MariaDB. Did I miss something? ;) – Izzy Jul 18 '19 at 18:38
  • Any one of those will do. I have used all and have no real preference. – Mawg says reinstate Monica Jul 23 '19 at 13:44
  • "it seems a bit unstable, sometimes queries work, sometimes they don't " That's not PHP, that's you ;-) Test them out in PhpMyAdmin. Btw, which IDE do you use to develop PHP? And which database are you currently using & how does your code connect to it & query it? – Mawg says reinstate Monica Jul 23 '19 at 13:46
  • 1
    @Mawg Yes you're right, i still have to learn a lot from mySQLi. I'm writing php in raw notepad, and testing it with a small database with phpMyAdmin. Supposedly my website will use XMLHttpRequests to populate the website with all the data, though I'm still figuring out the best way to approach all this. – João Drake Jul 30 '19 at 10:37
  • I prefer PDO to MySqli, but it's your choice. It's not clear if you will be coding browser, server, or both. Simplest, for leaning purposes, is to learn PHP & use that to access your database & generate HTML. that worked for me for over 10 years before I got round to teaching myself (Angular)JS. YMMV – Mawg says reinstate Monica Jul 30 '19 at 11:44

I would use a PHP framework like Laravel or similar. It takes care of a bunch of under the hood work like security for you.

Mariadb (formerly mysql) is one of the most common databases out there. Almost everything supports it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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