I’ve come up with the idea to have on my website a list that will let people add to it and have it show immediately. What will I need to know to make that happen? PHP and a database? JavaScript? Something else?
Thanks in advance to anyone who has an answer. ? [COLOR=White].[/COLOR]
@ray326May 29.2006 — #Some server side language and a database. PHP & MySQL would be a good, easily found pair but it could certainly be done with Perl and flat files, too.
Now, if I have a database, say Access, I think I will need an ODBC to connect to it? Will I have to pay for an ODBC and where can I get one? I'm gonig to try to start learning PHP sometime this summer. I already know a little SQL. SQL and MySQL are not the same are they?
@ray326May 30.2006 — #Access/Jet is not a database server and should never be used in a shared context. SQL is a language, MySQL is a database server. The right answer for you must take into account things like the operating system on which your web server is running and how much control you have over the supporting software like the languages and database servers.
Flat files are just text files that have a consistent format structured much like a database table. Each line is a row. Each field in the line is separated in some consistent manner, e.g. with a tab or a comma or some other character that is unused within the data.
You have to be careful when crafting your own system. SQL injections are also a worry. It would be better to implement a tried and tested system as mentioned to give your website some protection.
jimberry ,no, I'm not talking about something similar to a shout-out box (or, maybe I am ? ). I'll try to explain because I only have a vision in my head...Here is an example of what I'm talking about, I want to eventually create something similar. ([URL=http://www.petitiononline.com/aliasf05/petition-sign.html?]Example_1[/URL], [URL=http://www.petitiononline.com/mod_perl/signed.cgi?aliasf05&101]Example_2[/URL]) Now, after they fill in their information their message will show with the other posts. I want to create something similar to that.
Access/Jet is not a database server and should never be used in a shared context. [/QUOTE]
Thank you Ray. Please explain.
So, now I think I understand. I will need a database server to connect to my database and MySQL is a database server. Does anyone know of a website where I can read more about connecting to databases and what's involved?
<Eddie>, I'm not sure what you mean by real-time. Chat??? Oh, I think you mean real-time as in the message doesn't have to be approved first? Yes, I know it's probably best to try something that I know works, but I also want to learn to do it myself. Thanks.