Access, ASP and PHP, MySQL confussion

[Susan]

I know PHP can be used with FP and then MySQL used with PHP. But if one
sticks with MS products would Access correspond to the MySQL and PHP to
ASP?

Are there advantages in sticking with the MS products in that after one has
a database created, the other products could be used to generate
user-friendly reports? In other words if one has a database created with
MySQL, how would one generate user-friendly printed reports?

I know this does not address FP issue but I know that Thomas Rowe knows PHP
and others use Access and ASP with FP.

Thank you for any information.
Susan

 

[Thomas A. Rowe]

Correction, I work only with Classic ASP and MS Access which requires the site to be hosted on a
Windows IIS web server.

Under Windows you can also
- use PHP with MS Access with IIS
- use Classic ASP / ASP.net with MySQL

FP directly supports working with Classic ASP / ASP.net / MS Access and MS SQL server.
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Paul C]

Hi Susan
Here are some articles there are many more on the web
http://www.webpronews.com/expertarticles/2005/12/22/asp-vs-php

http://www.builderau.com.au/program/web/soa/PHP-ASP-or-ASP-NET-/0,339024632,320283074,00.htm

Paul M

 

[Susan]

Thanks Thomas, sorry I got it wrong but I knew you had knowledge about PHP
though.

I am working on creating a database with MySql and PHP. I abandoned FP
because I could log into the hosting site from a couple locations and use
free FTP tool and not be dependent upon FP being installed on PCs. How easy
it is to create printed reports from a MySQL database. I began to wonder if
I should have stayed with Microsoft products. If I had created database
with Access, then are reports easy to generate?

So I could have used the PHP to create Access database without depending on
FrontPage? Then with Access, the other Microsoft applications could be used
against it? I am trying to evaluate the best way to go.

 

[Thomas A. Rowe]

See inline below...

FYI: I have never used PHP or MySQL.
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

Thanks Thomas, sorry I got it wrong but I knew you had knowledge about PHP though.

I am working on creating a database with MySql and PHP. I abandoned FP because I could log into
the hosting site from a couple locations and use free FTP tool and not be dependent upon FP being
installed on PCs. How easy it is to create printed reports from a MySQL database. I began to
wonder if I should have stayed with Microsoft products. If I had created database with Access,
then are reports easy to generate?

To generate reports via scripting you are limited to the command available in the lanaguage and your
knowledge/resources for either PHP or ASP, however to use either locally requires that you have a
web server installed so that you can access the PHP/ASP scripts and MS SQL or MySQL Database Server
via http.

With Access, you could always download the database and work with it directly in MS Access or export
the data to Excel.

So I could have used the PHP to create Access database without depending on FrontPage? Then with
Access, the other Microsoft applications could be used against it? I am trying to evaluate the
best way to go.

I don't think you can use PHP to create an MS Access database. With ASP / ASP.net you can create a
MS Access database.

So far I have been able to create any functionality in ASP/VBscript that can be similarily create in
PHP, that I have need for my web projects.

 

[Susan]

Sorry, I obviously confused you with someone else. Thanks for the
information though.

 

[Andrew Murray]

News Group member Veign is the one MVP with the PHP knowledge, and
frequently recommends PHP solutions to questions asked here (and mostly on
the Expression Web Group).