ASP Databse How To:

Hey,
I am creating my website and I got stuck when my friend told me how will I update 100s of pages instantly. I started looking into some ideas and found out that I could use javascript and that way all I will have to do is make change to one file and everything thing will be updated instantly. But then javascript code was not efficient and the code kept getting corrupted whenever I tried to do some editing.
So now I am thinking more towards ASP database. I am planning to run this database on redhat servers.

Can anyone tell me what application or program should I use to create this database.

What kinda of updating method is kirupa.com using. Thanks.

ASP only runs on Windows servers. If the web site is on a UNIX box then I’d recommend using PHP for your server side scripting to interface with the database.

Yeah sorry for the mistake. I meant to say PHP but accidently put ASP. Does anyone have any links on how to create a database from scratch? What programs to use? And how to run a database? Thanks.

First step is to find out what database software is supported by the web host. That will determine what you need to do to create a new database on the server. It may be as simple as creating the file using a copy of the database software on your local machine to create the new database, then simply uploading it to a specified location on the server. Most likely you’ll need to do so using the proper remote management program to create the new database directly on the server.

Once that’s done, then you are finally ready to write your PHP pages to interface between web pages and the database.

Have you ever done any PHP or ASP coding? If not I think you may be biting off a bit more than you can chew at this point.

< ------------------ [BEGIN COPY AND PASTE] ----------------------- >

If you are really trying to learn PHP and you’re serious about it, then get these two books:

PHP: http://www.amazon.com/exec/obidos/tg/detail/-/0764535617/qid=1053751242/sr=8-1/ref=sr_8_1/002-2551283-1162431?v=glance&s=books&n=507846

mySQL: http://www.amazon.com/exec/obidos/tg/detail/-/0764516922/qid=1053751276/sr=1-2/ref=sr_1_2/002-2551283-1162431?v=glance&s=books

They are priceless. They have helped me so much. All of my knowledge of PHP and mySQL manipulation pretty much began with that and in just a week or so I was create full control panels for websites. Together the price is about $50 but don’t whine about spending the money because they are worth every penny. mdipicom bought the PHP after I recommended it to him and he loved it. If you have 3/4 of a brain cell you will understand PHP when you get done with those books.

Actually the first one is all you really need because it actually explains the basics of php/mysql all in one, but the second book helps with more specific areas of the mysql.

:slight_smile:
< ------------------ [END COPY AND PASTE] ----------------------- >

Ok, now that that is out of the way. Yeah, what abzoid said, pretty much. Most hosts (pay hosts) offer mySQL databases, and support PHP that you can use to interact with it (because the best pay hosts are run on *nix servers. :)) As far as being able to help you, I would suggest looking into those books (you can find them for $18 on amazon.com), because what you are asking is going to be a pretty comprehensive project. Not something you would want to take on unless you knew what you were dealing with… if you can give me specifics I can try to help you, but you’re going to have to learn the basics on your own…