Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more  

Go Back   Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more > Web Programming > Databases - MySQL, SQL, Oracle, Access and others
User Name
Password

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 03-19-2006, 05:26 PM   #1 (permalink)
drew22299
Junior Member
 
Join Date: Mar 2006
Location: Wilts / Bristol
Posts: 54
Default How do you setup an sql database?

Can someone answer this question? How do you set up databases ie once they have been arranged with the hosting?

Is it as simple as this?

1) Get an sql database from your hosting,
2) Create your php/cgi code for a forum/copy and paste code for a forum and put it into your webspace

3) Once you have done that, will the forum operate? What needs to be done? How does the code relate to the database?

Also, is this similiar to having online shopping software - having a basket and browsing items?

I would appresiate it if some could give an description of how this all works, as searching the Internet for hours has not given me the answers!

Thanx,
__________________
www.hotlista.co.uk
drew22299 is offline   Reply With Quote
Sponsored Links
Old 05-03-2007, 06:05 PM   #2 (permalink)
Krishnaswamy
Junior Member
 
Join Date: May 2007
Posts: 29
Default Re: How do you setup an sql database?

The ISP provider gives you access to some space on his server. You need to setup a database on this server. Once you setup a database, you need to add tables to your database. The tables contains the data you want to pull out. For example, the table cotains your product information, customer information, etc. This is one side of the story.
You want your clients(who sits infront of their browser) to see what products you have. But you will not let the client to go to the database server (also this is not a good practice). So you will allow him to send a request to the web server. The web server in turn send this to the SQL server. The SQL server processes this information and sends a result to the web server which will package this into an HTML page for you to see. This is what generally happenning.

HTH
Krishnaswamy is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Points Per Thread View: 1.00
Points Per Thread: 11.00
Points Per Reply: 5.00



» Sponsors

» Links

» Affiliates
Web Hosting
Marketing Find
Merchant Select
SiteMap Builder
Host Compare
Dedicated Servers

» Links

» Sports Network
Paintball Forum
Football Forum
Hockey Forum
Golf Forum
Boxing Forum
Lacrosse Forum
Baseball Forum
SnowBoarding Forum
Soccer Forum
MMA Forum


All times are GMT -4. The time now is 06:22 PM.



LinkBacks Enabled by vBSEO 3.0.0 RC8
Webmaster Forums