Database

fplaxitup · 03-17-2009, 01:38 AM

Ok. I have a website and I want to have a username database. So people can log in and such. I know how to make input fields but not how to record the data people enter. I hear you need MS Access. Is there a way you could do that without it? Also... How can I make it so people can only view certain pages if they've logged in.
Bottom line: I need a lot of help and I'd appreciate any I can get. Thanks in advance.

conor · 03-17-2009, 02:02 AM

Ok there's a lot involved in what you are asking for. I would suggest using PHP to do so.

First, have you set up a databade and do you have all the connection details, hostname, user, pass, dbname? * don't post them here! Oh and what database are you using? MySQL?

If you have done that then let us know. There's no real way to tell you how because every CP is different. If you have problems setting up the database then contact your hosting provider.

fplaxitup · 03-20-2009, 12:00 AM

Well I've heard you can use MS Access or Excel as your database. Is that the easiest way to go?

jnjc · 03-20-2009, 01:01 AM

I think you will have problems if you use MS Access as your DB, the main one being that you will find it difficult to get a hosting company that supports it.

In short you will only make your life difficult if you try and use it. Stick with Conor's advice and look at using PHP and MySQL.

HTH,
JC

fplaxitup · 03-20-2009, 01:20 AM

ok thnx for all your help

03-17-2009, 01:38 AM	#1
fplaxitup New Member Join Date: Mar 2009 Posts: 4	Database Ok. I have a website and I want to have a username database. So people can log in and such. I know how to make input fields but not how to record the data people enter. I hear you need MS Access. Is there a way you could do that without it? Also... How can I make it so people can only view certain pages if they've logged in. Bottom line: I need a lot of help and I'd appreciate any I can get. Thanks in advance.

03-17-2009, 02:02 AM	#2
conor Gold Member Join Date: Oct 2008 Location: Ireland Posts: 349	Ok there's a lot involved in what you are asking for. I would suggest using PHP to do so. First, have you set up a databade and do you have all the connection details, hostname, user, pass, dbname? * don't post them here! Oh and what database are you using? MySQL? If you have done that then let us know. There's no real way to tell you how because every CP is different. If you have problems setting up the database then contact your hosting provider. __________________ Conor

03-20-2009, 12:00 AM	#3
fplaxitup New Member Join Date: Mar 2009 Posts: 4	Database Well I've heard you can use MS Access or Excel as your database. Is that the easiest way to go?

03-20-2009, 01:01 AM	#4
jnjc Super Moderator Join Date: Jun 2008 Posts: 493	I think you will have problems if you use MS Access as your DB, the main one being that you will find it difficult to get a hosting company that supports it. In short you will only make your life difficult if you try and use it. Stick with Conor's advice and look at using PHP and MySQL. HTH, JC __________________ www.solasit.com.au Free Online Competitions Last edited by jnjc; 03-20-2009 at 02:46 AM.

03-20-2009, 01:20 AM	#5
fplaxitup New Member Join Date: Mar 2009 Posts: 4	Database ok thnx for all your help

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode