Re: PHP on 2K / MySQL on LINUX

I'm myself am just new to this. However; the first thing to do is setup your SQL to allow the Win2k server to connect to the linux SQL Server. Do this by setting up a host in your SQL server that matches the hostname of your Win2K box. Tim Wall ----- Original Message ----- From: "Daniel Guerrier" <dan_guerrier@yahoo.com> To: <php-general@lists.php.net> Sent: Sunday, September 03, 2000 6:48 PM Subject: [PHP] PHP on 2K / MySQL on LINUX > What is the procdure for getting my php page on W2K to > connect to my Linux MySQL database on a seperate box, > ona local network. > > If I have this page with the following on the local > LINUX with apache, it work OK. But if I try the same > page on W2K with IIS 5 it will not connect. > > <HTML> > <HEAD> > <TITLE>PHP SQL CODE TESTER</TITLE> > </HEAD> > <BODY> > <!-- query.php --> > > <?php > $host="192.168.0.1"; > $user="string"; > $password="string"; > ?> > > <FORM ACTION="mysql_test.php" METHOD=POST> > Please select the database for the query:<BR><BR> > <SELECT NAME=database SIZE=1 > > > <?php > mysql_connect($host, $user, $password); > $db_table = mysql_list_dbs(); > > for ($i = 0; $i < mysql_num_rows($db_table); $i++) > { > echo("<OPTION>" . mysql_tablename($db_table, $i)); > } > ?> > > </SELECT><BR><HR> > > Please input the SQL query to be executed:<BR><BR> > <TEXTAREA NAME="query" COLS=50 ROWS=10></TEXTAREA> > <BR><BR> > <INPUT TYPE=SUBMIT VALUE="Execute query"!> > </FORM> > > </BODY> > </HTML> > > __________________________________________________ > Do You Yahoo!? > Yahoo! Mail - Free email you can access from anywhere! > http://mail.yahoo.com/ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >