converting ASP code to php

macdoctor

We are trying to figure out how to convert an access database to php code, including its queries and macros to php coding. Waht are the different ways of doing it? If there are any and which are the simplest an easiest.

mtimdog

What database are you going to use with php? If using mysql, I'd suggest a converter for the tables similar to this (if using this, change \g to semi-colon). Then, use your queries in your PHP pages to query the database.

VBA isn't quite the same as ASP, if you're having trouble moving your logic over, you could try asp2php converter.

macdoctor

We will be using mysql. "When you say use your queries in your PHP pages to query the database," are those php queries be created automatically from ther access queries and macros, or they need to be created manually?

Thanks!

mtimdog

Created manually, basically open the query in Access, view it in SQL mode, copy the SQL, and put that in your php code to query for the results.

Merve

Isn't there a program called ASP2PHP?

mtimdog

Yes, I even gave a link to it.

piersk

Ok, macdoctor: It sounds like you're getting confused between ASP, PHP and Access.

Access is different from ASP. The queries stored in Access, although accessible through ASP cannot (AFAIAA) be accessed through PHP.

ASP can very simply be "translated" into PHP. Access can't.

mtimdog

Substitute vba for access and I somewhat agree with Piersk. VBA is a "subset" of VB. ASP is vbscript(vbscript used for the most part I think). Vbscript is a subset of VB. using the asp2php program, some of the things probably will transfer over, and others will get all f-ed up.

I think the easiest way to do it would be to re-write it in pseudo-code. Then learn how to do it in PHP and implement.