Hello, As a php developer i have been asked to convert a .asp/.mdb based website to a php/mysql website. I have never develop with .asp so i need your advice. All static .asp files can be convert with no problems. But i see a folder called data with a .mdb file in it. I guess this is the Microsoft access database file, can i import this into a mysql database? Is there an access equivalent as phpmyadmin? What are common pitfalls when converting .asp to php??
Hello Check the Below URL this may help u : http://www.bullzip.com/products/a2m/info.php It is a convertor program for Access to Mysql
Converting from ASP-Access to PHP-MySQL should be straight forward, unless there are proprietary calls in the ASP code or the odd JetSQL code. For example, if the ASP calls and instantiates Microsoft-specific components or the database is using stored queries or embedded functions. Another tip, if the Access migration is a problem then look at using ODBC and PHP. $db = ADONewConnection('access'); $dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=d:\inetpub\data\northwind.mdb;Uid=Admin;Pwd=;"; $db->Connect($dsn); Good luck!