No one really want to discourage anyone. It’s more about pointing out the harsh realities, that learning difficult and complex things is an integral part of coding, like it or not.
As has been shown, there are alternatives to using a database, but these are not likely to be any simpler to do, or achieve better results.
Yes, relational databases is a very big subject that can get very complex. But like anything, it can be taken in baby steps, taking just the basics to begin with.
I believe the objective could be achieved with just a simple, single table, (with scope for future expansion).
The OP would need to learn a few basics.
How to create a database and tables.
How to establish a PDO connection.
How to run some basic queries, Insert, Select, Edit…
And how to use prepared statements for those queries.
This would cover the database side of things, putting aside the logic of the sign-up, login process.
Information on how to do these things is readily available, and help is at hand if stuck.
So it is a case of learn it, or don’t learn it.
I’m reminded of a common quest clients of a landscaping business would pursue: how to have a beautiful, zero-maintenance property? Lush full lawns, glorious planting areas, verdant gardens to enjoy but not slave in?
It’s an impossibility, of course. We can achieve the look, but it takes work to get there and to maintain it. We can relax and change our expectation, appreciate the “natural” uncontrolled look. Or we can pay someone else to do the work for us.
This is that. Firebase (and other API-based db structures) may allow a decent number of calls and interactions, but ultimately, the ease of consumption will come at another cost. Skull-sweat, or wallet. It’s simply about choices.
I think this thread may be getting too far away from the OP’s actual question.
The OP is clearly a novice, and I believe also very young. The fact he has not returned to the thread suggests the discussion is going over his head, rather than helping. Perhaps some clearer explanations for a novice would help.
yes it is going over my head can you provide any links to working with a database? or a actual visul video to help me see what is going on? And where do you create a database?
I saw in another topic you were installing XAMPP. Did you get it up and running?
That includes PhpMyAdmin, which will probably be the easiest way for you to create a database and tables, as it gives you a GUI to manage your databases.
yes but I do not know where you should create one in XAMPP
You’d have to be viewing the GUI in the browser as phpMyAdmin is a GUI based interface. Should just be localhost/phpmyadmin.
So do you have XAMPP up and running, but unsure how to create a database?
If so, first open XAMPP, start Apache and MySQL. Then, just typing localhost in your browser should open the XAMPP control panel. On the top menu you will see phpMyAdmin, open this and you can begin creating databases and tables. You need to make a note of your chosen connection parameters, as default these will be something like host=localhost, user= root, password=“” and the name of the database is up to you. Obviously these parameters are not very secure, but are fine for testing and can be changed.
Next you need to create a php file with the connection parameters and check you can connect. Then you can start creating various CRUD scripts. This is fairly simple but the main challenge will be security and validation.
I am happy to assist where possible if this is still current.
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.