Database Question

[tdctech]

Hi all,

What I want to do is store Names and address (Just 60 or so) on a website. I want to be able to be able to edit them on the site. (Do not want to have to republish the site to change data.

 

I have:

Site hosted on Total a choice Web hosting account.

NetObjects Fusion 8 (For website development) Will connect to MySQL, PHP, ASP etc.

 

I am running Windows XP Home

 

I have set up a Database and Table on the WebServer(I think)

I cant seem to get connected to the database.

 

I have set up a test site at www.tdctech.com click on untitled6 This is the page that is supposed to connect to the Database, But all I get is this error.

 

Is the SQL Database stored in a folder I can see through FTP? I havn't been able to find it.

 

Can anyone tell me the best way to do what I want to do.

[tdctech]

Hi all,

 

What I want to do is store Names and address (Just 60 or so) on a website. I want to be able to be able to edit them on the site. (Do not want to have to republish

 

the site to change data.

 

I have:

Site hosted on Total a choice Web hosting account.

NetObjects Fusion 8 (For website development) Will connect to MySQL, PHP, ASP etc.

 

I am running Windows XP Home

 

I have set up a Database and Table on the WebServer(I think)

I cant seem to get connected to the database.

 

I have set up a test site at www.tdctech.com click on untitled6 This is the page that is supposed to connect to the Database, But all I get is this error.

 

Is the SQL Database stored in a folder I can see through FTP? I havn't been able to find it.

 

Can anyone tell me the best way to do what I want to do.

[LisaJill]

I'm not sure about NO NetFusion; someone else will have to deal with that.

 

As for the database, it is not in a folder =) You need to go to Cpanel - MySQL Manager and create the database, create the user, then ADD the user to the database (<- oft missed step) Then you can create your tables, etc.

 

I'm going to move this for organization, I'm sure someone with more information will be by soon to help fill in the holes. =)

[LisaJill]

Merged your two posts - there is no need to post twice, we read all the posts no matter where. =)

[tdctech]

Sorry about posting twice. Wasn't sure where to post. New to this Forum.

 

Thanks to you,

I now have the database and table created. Now to figure out how to connect to it.

Thumbs Up

NetObjects wants the following.

Host (How do I set this up ?)

Engine (I am assuming that this is "MySQL)

DataBase ("tdctec_parsons" Am I correct in this DOMAIN Name _ DataBase Name)

USER (This is the User Name I set up when defining the DataBase.) Correct ?

Password (Password for above user)

[LisaJill]

Normally host would be "localhost" but since NetFusion is running on YOUR computer; I'm not sure what that should be - I know remote connections can be made and there's info somewhere in the forum. I'm sure someone else can answer.

 

Database and username are both what you created, only are preceded by username_

 

Password is JUST the password you chose for that User. =)

 

I think you're right on the Engine, but I'm not 100% - it sure makes sense though, eh?

 

Sorry I can't help with some of the other specifics. =)

[tdctech]

Thanks,

I will try some thing with NetObjects to see if I can connect.

 

Thanks for your quick response.