Looking for a littl guidance, for a seemingly not such a complicated project for a website. Maybe y'all could assist me with the optics of this?
I want a page on my site to have some input bottons, that will access an astrological database, for some end-user basic information, which will render their information results locally (within the same page). The information I am looking for it to render will not be of the usual free astrological birth chart variety. I am looking for the information that is entered to display some more specific/general than that type.
And of course, this information will have the option to be saved into a profile space (via a database or dataset(?) .. But this functionality can just be displayed (for the time being) on the page without being saved (initially), as well. I also don't see this arrangement needing any sophisticated conditionals (I think).
To my gesticulating, this project does not seem to need the website to have its own database, but maybe just require a connection (socket) to the astrological database itself. To this developer's thinking, though, I'm leaning on the astrological database being part of the actual domain (I like the backend for Wordpress that Laughing Squid provides).
Guidance for a database for a site,...
You’ll want a simple server-side setup (e.g., PHP + MySQL) to handle the button clicks, run parameterized queries against your astrology tables, and return just the fields you need as JSON or an HTML snippet; start by sketching the schema (what inputs users give and what outputs they get), create indexed columns for the lookup keys (date/time/place, sign, etc.), build a single PHP endpoint that validates input and queries with PDO prepared statements, and wire your page’s buttons to fetch() that endpoint so results render without reloading; avoid client-side database access, keep any heavy calculations server-side or precomputed, and add simple rate limits and input validation.
Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.