yan hassell
asked on
reverse engineer .sql from php files
I'm looking for a way to recreate a MySQL db based on the PHP files. Basically an old client wants to resurrect an old web app and he only has the PHP files.
is there some app/script that can run through PHP files and extract any update/insert/select queries and generate a .sql to be used to create tables?
any other suggestions on how to bring this back to life?
is there some app/script that can run through PHP files and extract any update/insert/select queries and generate a .sql to be used to create tables?
any other suggestions on how to bring this back to life?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
its not built with a framework. just a bunch of php files. The server it was hosted on has long been decommissioned so I dont have any access to backups unfortunately.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for all the help guys. Im going to leave this open another day or so and then try to figure out how to spread the points ;)
lol, I did resurect the dead a few times and was quite happy with that. my personal feeling is old apps are usually properly written or simple enough that it does not matter. i'd never suggest using whichever framework unless i have a good reason to, and the information provided is way too little for that to apply... my belief is frameworks usually add complexity and are often less short-lived than the corresponding app so unless you're building something really huge, or short-lived, or structured in a way you feel you might as well take over the framework's development if needed, or... stay away from them...
ASKER