sf_guy Posted November 3, 2012 Share Posted November 3, 2012 Ugh, I was just told to convert a bunch of PHP mySQL apps I didn't write to run under Oracle. I'm fairly new to PHP and know nothing about Oracle (but am trying to read up as much as I can) Can any of this be accomplished via search and replace, i.e. replacing the mysqli-> calls with Oracle calls, or is it totally different and I'll have to go line by line. Also, Oracle doesn't seem to offer any kind of auto-numbering (or does it?) so a lot of the tables with primary keys based on unique, ascending numbers are going to have to be changed. If someone could post the equivalent of a mysqli "SELECT" and "UPDATE" for Oracle it would be HUGELY appreciated! Quote Link to comment https://forums.phpfreaks.com/topic/270259-converting-to-oracle-from-mysql/ Share on other sites More sharing options...
PFMaBiSmAd Posted November 3, 2012 Share Posted November 3, 2012 I would recommend writing a database class to serve as a wrapper/interface. You would then search and replace the existing query/fetch/num_rows/affected_rows/error calls with the replacement class methods. I would then test using mysql(i) statements in your class to insure you didn't break anything. Then all you would need to do is concentrate on making the class methods produce the equivalent results using Oracle command/queries. Quote Link to comment https://forums.phpfreaks.com/topic/270259-converting-to-oracle-from-mysql/#findComment-1389991 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.