Thanks all for your help, you all have probably saved me a lot of time. I now have IIS running PHP and XP running MySQL. I am using MySQLFront to develop the database etc. Thanks again.
> -----Original Message----- > From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] > Sent: 13 August 2002 11:36 > To: Steve Jackson > Cc: Harrison Fisk; Zak Greant; David Axmark; Jeremy Cole; Olof Tjernren; > Jim Winstead; Bertrand Matthelié; Kaj Arnö; Rasmus > Subject: Re: [PHP-WIN] Newbie needs help. > > > Hallo Steve! > > As an addendum: a very easy way to install Apache/MySQL/PHP on a > Windows platform ist to use PHPTriad at > > http://sourceforge.net/projects/phptriad > > It installs smoothly and gives you a full working WAMP > installation with very few clicks. The MySQL version is quite > old, though, but this is no problem as you can simply overwrite > it with a new one. > > Note that the popular browser based managing tool phpMyAdmin is > included as well, which has its advantages over tools like MyCC > and MySQLFront as you have to connect to a remote server via > TCP/IP with those, which will not be possible with most ISPs due > to security considerations, whereas phpMyAdmin works on the > server machine in any case, so it conncets from localhost. It > doesn't look that pretty, though. > > > Harrison Fisk schrieb am Montag, 12. August 2002, 19:48:08: > > > Hello Steve, > > > Please find my answers underneath your questions. > > >>Hello all. > > >>I am new to PHP having used ASP for some time. (Seems a lot of us are > >>moving this way) What I'm stuck on is this; > > >>I need to build a DB in MySQL and then use PHP to display it. > >>My question is how you get a test environment working on XP Pro. > > >>I understand how to call up a database table from say Access because you > >>can develop the DB using Office then use SQL strings to call it using > >>ADODB connections. > > > MySQL natively connects using TCP/IP or named pipes on windows directly. > > There are many different API's built over it though that you can connect > > to MySQL with. > > > In PHP you will normally connect to it using the PHP API which is > > described in great detail at http://www.php.net/manual/en/ref.mysql.php > > Basically you will issue a mysql_connect() call then issue a > mysql_query() > > and get the results back with mysql_fetch_row() or something similar. > > There are some examples in the documentation that I listed. > > > There are also many other API's available, such as the C API, and JDBC > > that you may want to use to connect to MySQL for other purposes. Since > > you are on windows, one common one to use is MyODBC, which is the > > available at > http://www.mysql.com/downloads/api-myodbc-3.51.html This will > > allow you to connect to MySQL from various programs, including Access or > > Excel if you so desire. > > >>How though do you make a MySQL database in a windows environment? Can it > >>be done or is it done in Unix or Linux? If so are there any > windows based > >>programs to develop a MySQL database? > > > MySQL can run under windows or under a UNIX/Linux environment > as a native > > application. There are only a few very small differences > between the two, > > so it is perfectly normal for people to develop applications > under windows > > and then deploy them on Linux with little problem! There are a few more > > issues with PHP differences between windows and UNIX/Linux, and they are > > detailed in the documentation relating to the functionality. > > > For a GUI based application to connect to MySQL I recommend MyCC, > > http://www.mysql.com/downloads/gui-mycc.html > > It is multi-platform and is becoming better and better rapidly with each > > release. Another program that others have used with success is > > mysqlfront, this is a third party application that can be found at > > www.mysqlfront.de > > >>I've been to www.mysql.com and downloaded the software for XP. > >>So how do I use it? I ran the set-up prog and nothing seemed to happen. > > > There are a couple of steps you need to take on windows XP in > order to get > > MySQL running after you run the installer. It is recommended that you > > first install MySQL as a service and then you can run it from your > > services menu or at startup time. All of that information and > more is at > > http://www.mysql.com/doc/en/Windows_installation.html and > > http://www.mysql.com/doc/en/NT_start.html > > >>PHP - can you configure IIS to run PHP? if so how? > > > Yes, PHP can run under IIS as two different types, either as a CGI or as > > an ISAPI module. Here is the documentation that describes how to do > > either method: > > http://www.php.net/manual/en/install.iis.php#install.iis.iis4 > > I also believe that they distribute a Windows install which will can > > automatically install PHP as a CGI for IIS, you can get that > off of their > > downloads page. > > >>Sorry if these questions are totally obvious to you all but I've been > >>online searching for a couple of hours without any answer to these > >>questions. I might be asking the wrong questions. I hope I am anyway! > > > The manuals for both products (MySQL and PHP) are quite good. The urls > > for them are www.mysql.com/doc and http://www.php.net/manual/en/ > > The one nice feature is that they both are searchable as well, > which aids > > in finding what you want, even if you don't know where to get > it exactly! > > >>Thanks in advance. > >>Steve. > > > Hope that helps you solve some of your dilemmas! > > > Regards, > > > Harrison > > > > > Mit freundlichen Grüßen > Werner Stürenburg > > -- > MySQL schlägt Microsoft: > http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Dr.math. W. Stürenburg <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB/GmbH, Consultant, Trainer > /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany > <___/ www.mysql.de +49-5224-997-407, GSM +49-172-938 0 238 > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
