Hi Girish,
> I am working on a project for a university, i am doing it in PHP4 >
& MYSQL.
> And i am cosely to finish the project. Now the client is telling
> that they want the database as ORACLE (NOT MYSQL). I had wrote a
> class file for interacting with the database and i am using that
> class file for database activities.
>
> How can i change the whole project to PHP4 & ORACLE. Is it a big
> issue? Or i just need to change the database class file.
Basically you should replace the class file for one that interacts with
Oracle.
However, you will also need to check all database queries, I suppose
you pass those as parameters to the class when wanting to obtain some
result.
No experience with Oracle, but for instance MySQL and PostgreSQL, apart
from ome bigger differences like in the way functions work and how for
instance the primary key is returned after an insert, have some small
differences when writing the queries, in a.o. substring handling,
concatenation, partial selects ("limit start, rows" versus "limit rows,
offset"), etc.
Thus you will need to check all the places in your scripts where sql is
generated as well. But nothing undoable. Last year I needed to change a
working project from MySQL to PostgreSQL and when starting with a
working project it is quite straightforward.
Marc
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/php-list/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
