Hi,
I'm brand new to mySql and PHP. I'm used to MS SQL Server. I have a two machine network, a client and a server running XP Pro and 2kServer respectively.
I use Dreameaver to author my sites on the client, store them on my server (testing server) before uploading to the remote server in Dreamweaver which would be my internet-based hosting space.
I am having problems with previewing php based pages, mySql database connections and the like.
I have set up (correctly) my hosting space which is a MySQL implementation, this has a database there which has three tables that I can see if I log into the hoster's control panel (phpMyAdmin).
On the client and my server I have the latest version of php 4.3.4 and on the server I have mySql installed (I think).
I'm in the process of downloading MySQL administrator for more ease of use. I currently have mySQL Control Centre but when trying to connect to the hoster's mysql server the control centre simply closes down!
I have correct login details for the hoster's/my database, the ftp hosting space and correct login details to use from within webpages to access the database.
- Now if I try uring mysql_connect() I get host not found errors. - Is Dreamweaver getting confused as to where to look for the mysql/php stuff?
- What do I need to do and what do I need to have on my client and my server to make working with php and mysql smooth and error-free?????
- what must I enure I have and where must it be for everything to work?
I am very grateful for any help on this! Thanks...
I'm brand new to mySql and PHP. I'm used to MS SQL Server. I have a two machine network, a client and a server running XP Pro and 2kServer respectively.
I use Dreameaver to author my sites on the client, store them on my server (testing server) before uploading to the remote server in Dreamweaver which would be my internet-based hosting space.
I am having problems with previewing php based pages, mySql database connections and the like.
I have set up (correctly) my hosting space which is a MySQL implementation, this has a database there which has three tables that I can see if I log into the hoster's control panel (phpMyAdmin).
On the client and my server I have the latest version of php 4.3.4 and on the server I have mySql installed (I think).
I'm in the process of downloading MySQL administrator for more ease of use. I currently have mySQL Control Centre but when trying to connect to the hoster's mysql server the control centre simply closes down!
I have correct login details for the hoster's/my database, the ftp hosting space and correct login details to use from within webpages to access the database.
- Now if I try uring mysql_connect() I get host not found errors. - Is Dreamweaver getting confused as to where to look for the mysql/php stuff?
- What do I need to do and what do I need to have on my client and my server to make working with php and mysql smooth and error-free?????
- what must I enure I have and where must it be for everything to work?
I am very grateful for any help on this! Thanks...