Link to home
Start Free TrialLog in
Avatar of yan hassell
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?
SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of yan hassell
yan hassell

ASKER

thats my last option.  was hoping to find something more automated.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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...