January24
If you need to configure your xampp installation (on winXP) to connect to the oracle
- first you need to download oracle basic instant client for windows
- After unzipping the instant client on a selected directory (i.e. c:/instantclient_11_1) you need to copy all dlls from this directory to “xampp/apache/bin/”
- Add instant client directory to windows system variable’s path : follow Start -> Control Panel -> System -> Advanced -> Environment Variables and edit PATH in the System variables list
- now open up php.ini from “xampp/php” and remove semicolon from this line “;extension=php_oci8.dll”
all you have to do is restarting apache and you’re all set
here is a nice document with more general detail about installing php and the oracle instant client for linux and windows
December22
As of php5.2 you can use APC to create progress bar for your file upload
here is a nice document from IBM:
http://www.ibm.com/developerworks/library/os-php-v525/index.html
and if you are using php on windows environment you can download php_apc.dll from here:
http://downloads.php.net/pierre/
September18
You begin a business on the web, nobody knows in future what is your data growth rate, so think that your idea on the web is successful and you want to expand it but limitation on your database will end your growth and then you are at the end of road. mysql is not for enterprise and critical systems.
if you think that mysql is free so, oracle released express edtion that is free of charge and if your business has expanded you can go to other oracle edition and buy it if your business is successful so you have enough money to pay for standard or enterprise edtion, you must think to unlimited growth, data is mony and more data needs better repository and manager.
If your data is your money no doubt to deliver it to a bank that is more secure and with guard and other tools that save it 100%. oracle can do it for you.
September18
My immediate answer without discuss about technical prespective is we d’nt know in the future what is most popular os . oracle can install on any os but sqlserver is only for windows , think if in future linux or other os is the only choice what happend to your business , it is the end of road, terrible!
September18
web publishing by using suitable platform is not so difficult.
we suggest tree tier designing: data tier, business role tier, interface tier
on data tier we have table and other objects that is relational design on second tier we define business roles in packages by pl/sql (oracle native procedural language) , java or c language and at third tier is php ,xhtml for presentation, so not any sql is in front end layer and you have very thin client layer, you d’nt need to know anything on the backend (database and packages) you only call package by oci8 and focus on publishing.
this mthod is secure , minimum time effort for developing and best performance.
