Ok, so I'm back with a few questions on setting up a php / mysql
Actually, I'm going to need help with the whole thing, most likely... I'm searching info on it and looks like it gets complicated. I'm no where near the 'complicated' level yet. I'm having a hard time even getting out the gate...
1. For instance, it stands to reason that each page would connect to a single, separate db connection script. Then the code in that page would write to it's own table in the db. So when the page comments are displayed, they show comments for that page only (only that table).
Or, would each page connect to it's own database to simplify displaying only comments for that page? Maybe with that page's db connection, table etc, on the same page. That seems like a whole bunch of databases.
Optimization wise, which method is faster / lighter? Maybe there's a whole different way?
2. Here's another thing I'm wondering about. I think using a database will allow me to do things like have a "web site field" on the form, that when entered, turns the name of the user into a link to that site when their comment is displayed. So..., how would you write / separate that info in the table for that page, and reverse by displaying / combining? Is that where rows come in?
See what I mean? I don't have any idea where to start on this thing - I can't find a tutorial that describes, ground up - how to build a feedback form that writes and displays for that page only - over a multi-page site using php / mysql - that's written with a beginner in mind.
Not to mention I have to figure out how to add some kind of captcha, xss type protection. If anyone knows of a tutorial like this, by all means point the way!
Any insight / help is HUGELY appreciated!!! Even a nudge in the right direction would help!