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.

    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.

      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!

        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.

          Isn't there a program called ASP2PHP?

            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.

              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.

                Write a Reply...