|
![]()
I have found while reasearching on how a database works, that people make things way to complicated and hard for a new person to undertand, but my question is simple....I have a site that I would like to be able to have members subscribe to. Now I know that I need a database, my hosting company has MS SQL. I was able to create a table on it after just messing around, but I need to know from my website, how do I call for that info back. I know the stinkin commands, but do I write it in a .html .asp ect. now one ever says, they all say well you just "type in"
INSERT INTO contacts (first_name,
last_name,
email)
VALUES ('John',
'Smith',
'jsmith@huh.com');
Just an example, but WHERE DO I PUT THAT! (sorry alittle frustrated)
Can anyone help or maybe know where I can get a sample script. and please I do not need to know how it works, I just need to know how to turn it on! Thanks
How do I get data from a database from my site!?!?!?
In order to get data from the database into a Web page, you will have to use a server-side scripting language to communicate with the database and generate HTML with the data. If your hosting provider has database support, then they will also support at least one such language, probably PHP (which is easy to learn and powerful), and maybe another such as ASP or ColdFusion/CFML. Just find out how the language of your choice works, and how it talks to the database.
And take a look at Fusebox ( http://www.fusebox.org ). It's a very nice application framework available for all three languages I mentioned, as well as others. It will help you write better code faster.
|
