php-windows Digest 12 Aug 2002 01:38:30 -0000 Issue 1284
Topics (messages 15205 through 15208):
Newbie needs help.
15205 by: Steve Jackson
15206 by: Grampy
15207 by: Jim Hunter
15208 by: Ross Fleming
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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.
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?
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.
PHP - can you configure IIS to run PHP? if so how?
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!
Thanks in advance.
Steve.
--- End Message ---
--- Begin Message ---
a.. This should help you get php installed on IIS.
a..
a.. http://www.php.net/downloads.php
a.. PHP 4.2.2 installer [913Kb]- 22 July 2002
(CGI only, MySQL support built-in, packaged as Windows installer to install
and configure PHP, and automatically configure IIS, PWS and Xitami, with
manual configuration for other servers. N.B. no external extensions
included)
There are few graphic tools for MySQL but here is a link to MySQL Front that
helps some in familiarization with MySQL. http://www.anse.de/mysqlfront/
If you installed MySql, there should be MySQLAdmin in the fast start tray.
If not check for ..\mysql\bin\winmysqladmin.exe and click on it. There
should be a short start up form.
Best of luck.
--
Grampy Glenn
Owensboro, Kentucky
**
Proverbs are the literature of reason, or the statements of absolute truth,
without qualification. Like the sacred books of each nation, they are the
sanctuary of its intuitions. - Ralph Waldo Emerson
**
"Steve Jackson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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.
>
> 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?
>
> 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.
>
> PHP - can you configure IIS to run PHP? if so how?
>
> 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!
>
> Thanks in advance.
> Steve.
>
--- End Message ---
--- Begin Message ---
Another good tool for administering MySQL databases is phpMyAdmin. It is a
browser based admin tool and you can get it from www.phpMyAdmin.org . I have
been using it for about a year and I really like it.
Jim Hunter
Diamond Computing
-------Original Message-------
From: Steve Jackson
Date: Sunday, August 11, 2002 02:36:51 PM
To: Php-Windows
Subject: [PHP-WIN] Newbie needs help.
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.
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?
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.
PHP - can you configure IIS to run PHP? if so how?
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!
Thanks in advance.
Steve.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.
--- End Message ---
--- Begin Message ---
You searched online for these answers??
http://www.php.net/manual/en/install.iis.php to install IIS
Where did you install mysql to? If you went with the default installation,
it will be in c:\mysql right? Run the program mysql.exe in the /lib folder
and learn how to do the commands that create databases. It's by far the
easiest manner to do it in. As for connecting to the mysql from php (which
I assume you wish to do), then see the mysql functions in the php manual
(http://www.php.net/manual/en/ref.mysql.php). First off, learn SQL though.
You'll find it's similar to just about any query language (SQL - Structured
Query Language: quote from their website "the most common standardised
language user to access databases").
Honestly, once you've got the hang of doing database queries through a
command line, moving to php to do it is a doddle (basically you just get php
to execute these same queries, meaning there is no new learning to be done)
Good luck :)
Ross
> -----Original Message-----
> From: Steve Jackson [mailto:[EMAIL PROTECTED]]
> Sent: 11 August 2002 22:35
> To: Php-Windows
> Subject: [PHP-WIN] Newbie needs help.
>
>
> 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.
>
> 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?
>
> 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.
>
> PHP - can you configure IIS to run PHP? if so how?
>
> 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!
>
> Thanks in advance.
> Steve.
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--- End Message ---
